83: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
84: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
84: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
85: p_include_unpaid_flag IN varchar2,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
93: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
93: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
94: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
87: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
88: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
89: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
90: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
91: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
92: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
93: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
94: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
95: p_br_sort_criteria IN varchar2,
381: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
382: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
382: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
383: p_include_unpaid_flag IN varchar2,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
391: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
391: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
392: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
385: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
386: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
387: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
388: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
389: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
390: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
391: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
392: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
393: p_br_sort_criteria IN varchar2,
562: +===========================================================================*/
563: PROCEDURE construct_select_br_for_remit (
564: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
565: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
566: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
567: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
568: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
563: PROCEDURE construct_select_br_for_remit (
564: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
565: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
566: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
567: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
568: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
564: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
565: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
566: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
567: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
568: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
569: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
570: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
571: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
572: p_unsigned_flag IN varchar2,
733:
734: p_select_detail := 'SELECT PS.* ' ||
735: 'FROM AR_PAYMENT_SCHEDULES PS, ' ||
736: 'AR_TRANSACTION_HISTORY HS, ' ||
737: 'HZ_CUST_ACCOUNTS CUST, ' ||
738: 'HZ_PARTIES PARTY, ' ||
739: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
740: 'RA_CUSTOMER_TRX TRX, ' ||
741: 'AP_BANK_ACCOUNTS ACC, ' ||
800: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
801: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
802: p_include_unpaid_flag IN varchar2,
803: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
804: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
805: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
806: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
801: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
802: p_include_unpaid_flag IN varchar2,
803: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
804: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
805: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
806: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
809: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
802: p_include_unpaid_flag IN varchar2,
803: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
804: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
805: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
806: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
809: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
810: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
803: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
804: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
805: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
806: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
809: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
810: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
811: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
804: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
805: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
806: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
807: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
808: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
809: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
810: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
811: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
812: p_br_sort_criteria IN varchar2,
1025: p_unsigned_flag IN varchar2,
1026: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1027: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1028: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1029: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1030: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1031: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1032: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1033:
1026: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1027: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1028: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1029: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1030: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1031: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1032: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1033:
1034: CUR_BR CUR_TYP;
1359: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
1360: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1361: p_include_unpaid_flag IN varchar2,
1362: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1363: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1364: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1365: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1360: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
1361: p_include_unpaid_flag IN varchar2,
1362: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1363: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1364: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1365: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1368: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1361: p_include_unpaid_flag IN varchar2,
1362: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1363: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1364: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1365: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1368: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1369: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1362: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
1363: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1364: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1365: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1368: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1369: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1370: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1363: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1364: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
1365: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1366: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1367: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
1368: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
1369: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1370: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
1371: p_br_sort_criteria IN varchar2,