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.ARP_PROCESS_BR_REMIT dependencies on AR_PAYMENT_SCHEDULES

Line 74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

70: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

71: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

72: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

73: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

74: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
82: p_unsigned_flag IN varchar2,

Line 79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

75: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
82: p_unsigned_flag IN varchar2,
83: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

76: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
82: p_unsigned_flag IN varchar2,
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,

Line 81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

77: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
78: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
79: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
80: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
81: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
82: p_unsigned_flag IN varchar2,
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,

Line 86: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

82: p_unsigned_flag IN varchar2,
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,

Line 110: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;

106: l_api_name CONSTANT varchar2(30) := 'create_remit_batch';
107: l_api_version CONSTANT number := 1.0;
108:
109: CUR_BR CUR_TYP;
110: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
111:
112: l_batch_rec AR_BATCHES%ROWTYPE;
113: l_batch_id AR_BATCHES.batch_id%TYPE;
114: l_batch_name AR_BATCHES.name%TYPE;

Line 372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

368: x_msg_data OUT NOCOPY VARCHAR2 ,
369: p_batch_id IN AR_BATCHES.batch_id%TYPE,
370: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

369: p_batch_id IN AR_BATCHES.batch_id%TYPE,
370: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

370: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

371: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

372: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
380: p_unsigned_flag IN varchar2,

Line 377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

373: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
380: p_unsigned_flag IN varchar2,
381: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

374: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
380: p_unsigned_flag 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,

Line 379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

375: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
376: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
377: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
378: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
379: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
380: p_unsigned_flag 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,

Line 384: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

380: p_unsigned_flag 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,

Line 485: -- The selected BR are assigned to the remittance by updating the reserved columns in the table AR_PAYMENT_SCHEDULES

481: p_drawee_sort_criteria,
482: p_drawee_order,
483: l_select_detail);
484:
485: -- The selected BR are assigned to the remittance by updating the reserved columns in the table AR_PAYMENT_SCHEDULES
486: -- until the parameter remittance maximum amount is reached (If it is filled of course).
487: ARP_PROCESS_BR_REMIT.assign_br_to_remit(
488: l_select_detail,
489: l_batch_rec.batch_id,

Line 564: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

560: | MODIFICATION HISTORY - Created by Mireille Flahaut - 20/04/2000 |
561: | |
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,

Line 565: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

561: | |
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,

Line 590: l_ps_class AR_PAYMENT_SCHEDULES.CLASS%TYPE := 'BR';

586: l_flag_yes varchar2(1) := 'Y';
587: l_flag_no varchar2(1) := 'N';
588:
589: l_ps_status_opened AR_BATCHES.status%TYPE := 'OP';
590: l_ps_class AR_PAYMENT_SCHEDULES.CLASS%TYPE := 'BR';
591:
592: l_pending_remittance AR_TRANSACTION_HISTORY.status%TYPE := 'PENDING_REMITTANCE';
593: l_unpaid AR_TRANSACTION_HISTORY.status%TYPE := 'UNPAID';
594:

Line 735: 'FROM AR_PAYMENT_SCHEDULES PS, ' ||

731: the wildcard character. This was giving ORA-00932
732: Inconsitent Datatypes errors in 10g. */
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, ' ||

Line 791: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

787: +===========================================================================*/
788: PROCEDURE validate_br_search_criteria(
789: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
790: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
791: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
792: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 792: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

788: PROCEDURE validate_br_search_criteria(
789: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
790: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
791: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
792: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

789: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
790: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
791: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
792: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
797: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

790: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
791: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
792: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
797: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
798: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

791: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
792: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
797: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
798: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
799: p_unsigned_flag IN varchar2,

Line 796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

792: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
797: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
798: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
799: p_unsigned_flag IN varchar2,
800: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 797: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

793: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
797: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
798: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
799: p_unsigned_flag IN varchar2,
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,

Line 798: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

794: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
795: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
796: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
797: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
798: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
799: p_unsigned_flag IN varchar2,
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,

Line 803: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

799: p_unsigned_flag IN varchar2,
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,

Line 1019: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1015: p_batch_date IN AR_BATCHES.batch_date%TYPE,
1016: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1017: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1018: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1019: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1020: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1021: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1022: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1023: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 1020: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1016: p_gl_date IN AR_BATCHES.gl_date%TYPE,
1017: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1018: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1019: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1020: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1021: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1022: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1023: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1024: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 1021: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

1017: p_currency_code IN AR_BATCHES.currency_code%TYPE,
1018: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1019: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1020: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1021: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1022: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1023: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1024: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1025: p_unsigned_flag IN varchar2,

Line 1022: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

1018: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
1019: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1020: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1021: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1022: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1023: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1024: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1025: p_unsigned_flag IN varchar2,
1026: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 1023: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

1019: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1020: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1021: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1022: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1023: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1024: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
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,

Line 1024: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

1020: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1021: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1022: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1023: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1024: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
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,

Line 1028: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

1024: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
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

Line 1035: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;

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;
1035: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1036:
1037: TOTAL_COUNT AR_BATCHES.control_count%TYPE;
1038: TOTAL_AMOUNT AR_BATCHES.control_amount%TYPE;
1039:

Line 1161: p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

1157: x_return_status OUT NOCOPY VARCHAR2 ,
1158: x_msg_count OUT NOCOPY NUMBER ,
1159: x_msg_data OUT NOCOPY VARCHAR2 ,
1160: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1161: p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
1162: p_action_flag IN varchar2,
1163: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
1164: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE) IS
1165:

Line 1174: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;

1170:
1171: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1172:
1173: l_batch_rec AR_BATCHES%ROWTYPE;
1174: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1175:
1176: l_control_count AR_BATCHES.control_count%TYPE;
1177: l_control_amount AR_BATCHES.control_amount%TYPE;
1178: l_br_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 1178: l_br_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

1174: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1175:
1176: l_control_count AR_BATCHES.control_count%TYPE;
1177: l_control_amount AR_BATCHES.control_amount%TYPE;
1178: l_br_amount AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
1179:
1180: BEGIN
1181:
1182: IF PG_DEBUG in ('Y', 'C') THEN

Line 1350: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1346: p_batch_id IN AR_BATCHES.batch_id%TYPE,
1347: p_physical_bill IN varchar2,
1348: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
1349: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1350: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1351: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 1351: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

1347: p_physical_bill IN varchar2,
1348: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
1349: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1350: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1351: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

1348: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
1349: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1350: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1351: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1356: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

1349: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
1350: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1351: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1356: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1357: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

1350: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1351: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1356: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1357: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1358: p_unsigned_flag IN varchar2,

Line 1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

1351: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1356: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1357: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1358: p_unsigned_flag IN varchar2,
1359: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 1356: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

1352: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1356: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1357: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1358: p_unsigned_flag IN varchar2,
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,

Line 1357: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

1353: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
1354: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1355: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
1356: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1357: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
1358: p_unsigned_flag IN varchar2,
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,

Line 1362: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

1358: p_unsigned_flag IN varchar2,
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,