Query to Get List Of Approver for IExpense Transaction using API
Dynamic Approver List for AME
DECLARE
p_application_id NUMBER;
p_transaction_type VARCHAR2 (200);
p_transaction_id VARCHAR2 (200);
p_apprs_view_type VARCHAR2 (200);
p_coa_insertions_flag VARCHAR2 (200);
p_ame_approvers_list ame_approver_record2_table_ss ;---apps.ame_dynamic_approval_pkg.ame_approver_record2_table_ss;
p_ame_order_type_list ame_insertion_record2_table_ss:= ame_insertion_record2_table_ss(); --apps.ame_dynamic_approval_pkg.ame_insertion_record2_table_ss;
p_all_approvers_count VARCHAR2 (200);
p_warning_msg_name VARCHAR2 (200);
p_error_msg_text VARCHAR2 (200);
BEGIN
p_application_id := 200;
p_transaction_type := 'APEXP';
p_transaction_id := 99878;
p_apprs_view_type := 'Active';
p_coa_insertions_flag := NULL;
-- P_AME_APPROVERS_LIST := NULL; Modify the code to initialize this parameter
-- P_AME_ORDER_TYPE_LIST := NULL; Modify the code to initialize this parameter
p_all_approvers_count := NULL;
p_warning_msg_name := NULL;
p_error_msg_text := NULL;
p_ame_approvers_list := ame_approver_record2_table_ss();
apps.ame_dynamic_approval_pkg.get_ame_apprs_and_ins_list
(p_application_id,
p_transaction_type,
p_transaction_id,
p_apprs_view_type,
p_coa_insertions_flag,
p_ame_approvers_list,
p_ame_order_type_list,
p_all_approvers_count,
p_warning_msg_name,
p_error_msg_text
);
DBMS_OUTPUT.put_line ( 'Alam:-'
|| p_all_approvers_count
|| ','
|| p_warning_msg_name
|| ','
|| p_error_msg_text
);
IF(p_ame_approvers_list.count() ) > 0 THEN
FOR i IN 1..p_ame_approvers_list.count() LOOP
dbms_output.put_line(' approver_order_number =>'|| p_ame_approvers_list(i).approver_order_number
||' **** display_name =>'||p_ame_approvers_list(i).display_name
--' **** Approver Category =>'||p_ame_approvers_list(i).approver_category
--' **** approval_status =>' ||p_ame_approvers_list(i).approval_status
--' **** source =>'||p_ame_approvers_list(i).source
);
END LOOP;
ELSE
dbms_output.put_line(' No Approver Found');
END IF;
END;
-- COMMIT;
END;
