EBS : AP : Query to Get List Of Approver for IExpense Transaction using API : Oracle Apps

 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;