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 584: , ap_inv_selection_criteria_all aisca

580:
581: SELECT count(*)
582: INTO l_count3
583: FROM iby_pay_service_requests ipsr
584: , ap_inv_selection_criteria_all aisca
585: WHERE aisca.checkrun_id = p_checkrun_id
586: AND aisca.checkrun_name = ipsr.call_app_pay_service_req_code;
587:
588: SELECT count(*)

Line 591: , ap_inv_selection_criteria_all aisca

587:
588: SELECT count(*)
589: INTO l_count4
590: FROM iby_pay_request_sec_v ipsr
591: , ap_inv_selection_criteria_all aisca
592: WHERE aisca.checkrun_id = p_checkrun_id
593: AND aisca.checkrun_name = ipsr.call_app_pay_service_req_code;
594:
595: -- current user doesn't has access to all the selected docs

Line 889: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;

885: l_ret_status VARCHAR2(1) := 'E';
886: l_msg_count NUMBER;
887: l_msg_data VARCHAR2(2000);
888:
889: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
890: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
891: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
892: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
893:

Line 890: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;

886: l_msg_count NUMBER;
887: l_msg_data VARCHAR2(2000);
888:
889: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
890: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
891: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
892: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
893:
894:

Line 891: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;

887: l_msg_data VARCHAR2(2000);
888:
889: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
890: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
891: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
892: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
893:
894:
895: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;

Line 892: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;

888:
889: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
890: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
891: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
892: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
893:
894:
895: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;
896: l_int_bank_account_id NUMBER;

Line 931: FROM ap_inv_selection_criteria_all

927: l_payment_profile_id,
928: l_int_bank_account_id,
929: l_payment_document_id,
930: l_create_instrs_flag
931: FROM ap_inv_selection_criteria_all
932: WHERE checkrun_id = p_checkrun_id;
933: --
934: OPEN curr_arr_cursor;
935: FETCH curr_arr_cursor

Line 990: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;

986: l_ret_status VARCHAR2(1) := 'E';
987: l_msg_count NUMBER;
988: l_msg_data VARCHAR2(2000);
989:
990: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
991: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
992: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
993: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
994:

Line 991: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;

987: l_msg_count NUMBER;
988: l_msg_data VARCHAR2(2000);
989:
990: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
991: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
992: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
993: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
994:
995: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;

Line 992: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;

988: l_msg_data VARCHAR2(2000);
989:
990: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
991: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
992: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
993: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
994:
995: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;
996: l_int_bank_account_id NUMBER;

Line 993: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;

989:
990: l_payment_method_code ap_inv_selection_criteria_all.payment_method_code%TYPE;
991: l_payment_profile_id ap_inv_selection_criteria_all.payment_profile_id%TYPE;
992: l_payment_document_id ap_inv_selection_criteria_all.payment_document_id%TYPE;
993: l_create_instrs_flag ap_inv_selection_criteria_all.create_instrs_flag%TYPE;
994:
995: l_le_arr IBY_FD_USER_API_PUB.Legal_Entity_Tab_Type;
996: l_int_bank_account_id NUMBER;
997: l_int_bank_account_arr IBY_FD_USER_API_PUB.Int_Bank_Acc_Tab_Type;

Line 1119: FROM ap_inv_selection_criteria_all

1115:
1116: /*
1117: SELECT request_id, status
1118: INTO l_request_id, l_status
1119: FROM ap_inv_selection_criteria_all
1120: WHERE checkrun_id = p_checkrun_id;
1121: */
1122:
1123:

Line 1157: /* Bug 11063950 : Populating request_id from ap_inv_selection_criteria_all instead of iby_pay_service_requests */

1153: */
1154: RETURN 'YES';
1155: ELSE --IBY
1156:
1157: /* Bug 11063950 : Populating request_id from ap_inv_selection_criteria_all instead of iby_pay_service_requests */
1158:
1159: /* Commenting out for Bug 11063950 */
1160: /* SELECT request_id,
1161: payment_service_request_status

Line 1168: FROM ap_inv_selection_criteria_all

1164: WHERE payment_service_request_id = p_psr_id; */
1165:
1166: SELECT request_id
1167: INTO l_request_id
1168: FROM ap_inv_selection_criteria_all
1169: WHERE checkrun_id = p_checkrun_id;
1170:
1171: /* Bug 9074848 PPR/PI Termination Enhancement
1172: Commented below check for terminated Payment Service Request.

Line 1196: FROM ap_inv_selection_criteria_all

1192: Check if straight-through processing is used.
1193: */
1194: SELECT Nvl(create_instrs_flag,'N')
1195: INTO l_straight_through_flag
1196: FROM ap_inv_selection_criteria_all
1197: WHERE checkrun_id = p_checkrun_id;
1198:
1199: /* Bug 9074848 PPR/PI Termination Enhancement
1200: Throw error message if straight through processing is not used.