eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 805: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;

801: l_ret_status VARCHAR2(1) := 'E';
802: l_msg_count NUMBER;
803: l_msg_data VARCHAR2(2000);
804:
805: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
806: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
807: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
808: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
809:

Line 806: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;

802: l_msg_count NUMBER;
803: l_msg_data VARCHAR2(2000);
804:
805: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
806: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
807: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
808: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
809:
810:

Line 807: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;

803: l_msg_data VARCHAR2(2000);
804:
805: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
806: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
807: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
808: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
809:
810:
811: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;

Line 808: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;

804:
805: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
806: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
807: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
808: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
809:
810:
811: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;
812: l_int_bank_account_id NUMBER;

Line 847: FROM ap_inv_selection_criteria_all

843: l_payment_profile_id,
844: l_int_bank_account_id,
845: l_payment_document_id,
846: l_create_instrs_flag
847: FROM ap_inv_selection_criteria_all
848: WHERE checkrun_id = p_checkrun_id;
849: --
850: OPEN curr_arr_cursor;
851: FETCH curr_arr_cursor

Line 906: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;

902: l_ret_status VARCHAR2(1) := 'E';
903: l_msg_count NUMBER;
904: l_msg_data VARCHAR2(2000);
905:
906: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
907: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
908: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
909: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
910:

Line 907: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;

903: l_msg_count NUMBER;
904: l_msg_data VARCHAR2(2000);
905:
906: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
907: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
908: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
909: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
910:
911: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;

Line 908: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;

904: l_msg_data VARCHAR2(2000);
905:
906: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
907: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
908: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
909: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
910:
911: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;
912: l_int_bank_account_id NUMBER;

Line 909: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;

905:
906: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
907: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
908: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
909: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
910:
911: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;
912: l_int_bank_account_id NUMBER;
913: l_int_bank_account_arr IBY_FD_USER_API_PUB.Int_Bank_Acc_Tab_Type;

Line 1024: FROM ap_inv_selection_criteria_all

1020: IF p_psr_id is NULL THEN
1021: --
1022: SELECT request_id, status
1023: INTO l_request_id, l_status
1024: FROM ap_inv_selection_criteria_all
1025: WHERE checkrun_id = p_checkrun_id;
1026:
1027: -- 11i Payment batches have request_id as NULL, disable the cancel icon
1028: IF l_request_id is NULL THEN