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 39: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

35: p_auto_print_program_id IN AR_BATCHES.auto_print_program_id%TYPE,
36: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
37: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
38: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
39: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
40: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 40: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

36: p_auto_trans_program_id IN AR_BATCHES.auto_trans_program_id%TYPE,
37: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
38: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
39: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
40: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

37: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
38: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
39: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
40: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
45: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

38: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
39: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
40: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
45: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
46: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

39: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
40: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
45: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
46: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
47: p_unsigned_flag IN varchar2,

Line 44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

40: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
45: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
46: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
47: p_unsigned_flag IN varchar2,
48: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 45: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

41: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
45: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
46: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
47: p_unsigned_flag IN varchar2,
48: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
49: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 46: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

42: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
43: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
44: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
45: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
46: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
47: p_unsigned_flag IN varchar2,
48: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
49: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
50: p_include_unpaid_flag IN varchar2,

Line 51: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

47: p_unsigned_flag IN varchar2,
48: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
49: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
50: p_include_unpaid_flag IN varchar2,
51: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
52: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
53: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
54: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
55: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 81: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

77: x_msg_data OUT NOCOPY VARCHAR2 ,
78: p_batch_id IN AR_BATCHES.batch_id%TYPE,
79: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
80: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
81: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
82: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 82: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

78: p_batch_id IN AR_BATCHES.batch_id%TYPE,
79: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
80: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
81: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
82: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

79: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
80: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
81: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
82: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
87: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

80: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
81: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
82: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
87: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
88: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

81: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
82: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
87: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
88: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
89: p_unsigned_flag IN varchar2,

Line 86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

82: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
87: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
88: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
89: p_unsigned_flag IN varchar2,
90: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 87: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

83: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
87: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
88: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
89: p_unsigned_flag IN varchar2,
90: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
91: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 88: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

84: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
85: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
86: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
87: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
88: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
89: p_unsigned_flag IN varchar2,
90: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
91: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
92: p_include_unpaid_flag IN varchar2,

Line 93: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

89: p_unsigned_flag IN varchar2,
90: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
91: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
92: p_include_unpaid_flag IN varchar2,
93: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
94: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
95: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
96: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
97: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 119: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

115: p_batch_date IN AR_BATCHES.batch_date%TYPE,
116: p_gl_date IN AR_BATCHES.gl_date%TYPE,
117: p_currency_code IN AR_BATCHES.currency_code%TYPE,
118: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
119: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
120: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
121: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
123: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 120: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

116: p_gl_date IN AR_BATCHES.gl_date%TYPE,
117: p_currency_code IN AR_BATCHES.currency_code%TYPE,
118: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
119: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
120: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
121: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
123: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
124: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 121: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

117: p_currency_code IN AR_BATCHES.currency_code%TYPE,
118: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
119: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
120: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
121: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
123: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
124: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
125: p_unsigned_flag IN varchar2,

Line 122: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

118: p_remittance_bank_account_id IN AR_BATCHES.remit_bank_acct_use_id%TYPE,
119: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
120: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
121: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
123: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
124: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
125: p_unsigned_flag IN varchar2,
126: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 123: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

119: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
120: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
121: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
123: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
124: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
125: p_unsigned_flag IN varchar2,
126: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
127: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 124: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

120: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
121: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
122: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
123: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
124: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
125: p_unsigned_flag IN varchar2,
126: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
127: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
128: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

Line 128: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

124: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
125: p_unsigned_flag IN varchar2,
126: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
127: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
128: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
129: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
130: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
131: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
132: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE);

Line 143: p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,

139: x_return_status OUT NOCOPY varchar2,
140: x_msg_count OUT NOCOPY number,
141: x_msg_data OUT NOCOPY varchar2,
142: p_batch_id IN AR_BATCHES.batch_id%TYPE,
143: p_ps_id IN AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
144: p_action_flag IN varchar2,
145: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
146: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE);
147:

Line 149: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

145: p_control_count OUT NOCOPY AR_BATCHES.control_count%TYPE,
146: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE);
147:
148: PROCEDURE construct_select_br_for_remit (
149: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
150: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
151: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
152: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
153: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 150: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

146: p_control_amount OUT NOCOPY AR_BATCHES.control_amount%TYPE);
147:
148: PROCEDURE construct_select_br_for_remit (
149: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
150: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
151: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
152: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
153: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
154: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

Line 169: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

165:
166: PROCEDURE validate_br_search_criteria(
167: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
168: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
169: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
170: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 170: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

166: PROCEDURE validate_br_search_criteria(
167: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
168: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
169: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
170: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

167: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
168: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
169: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
170: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
175: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

168: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
169: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
170: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
175: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
176: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

169: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
170: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
175: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
176: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
177: p_unsigned_flag IN varchar2,

Line 174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

170: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
175: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
176: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
177: p_unsigned_flag IN varchar2,
178: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 175: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

171: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
175: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
176: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
177: p_unsigned_flag IN varchar2,
178: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
179: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 176: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

172: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
173: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
174: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
175: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
176: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
177: p_unsigned_flag IN varchar2,
178: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
179: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
180: p_include_unpaid_flag IN varchar2,

Line 181: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

177: p_unsigned_flag IN varchar2,
178: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
179: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
180: p_include_unpaid_flag IN varchar2,
181: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
182: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
183: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
184: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
185: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 213: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

209: p_batch_id IN AR_BATCHES.batch_id%TYPE,
210: p_physical_bill IN varchar2,
211: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
212: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
213: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
214: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 214: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,

210: p_physical_bill IN varchar2,
211: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
212: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
213: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
214: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

Line 215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

211: p_remit_total_low IN AR_BATCHES.control_amount%TYPE,
212: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
213: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
214: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
219: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,

212: p_remit_total_high IN AR_BATCHES.control_amount%TYPE,
213: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
214: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
219: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
220: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

Line 217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

213: p_maturity_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
214: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
219: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
220: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
221: p_unsigned_flag IN varchar2,

Line 218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,

214: p_maturity_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
219: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
220: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
221: p_unsigned_flag IN varchar2,
222: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,

Line 219: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

215: p_br_number_low IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
219: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
220: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
221: p_unsigned_flag IN varchar2,
222: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
223: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,

Line 220: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,

216: p_br_number_high IN AR_PAYMENT_SCHEDULES.trx_number%TYPE,
217: p_br_amount_low IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
218: p_br_amount_high IN AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE,
219: p_transaction_type1_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
220: p_transaction_type2_id IN AR_PAYMENT_SCHEDULES.cust_trx_type_id%TYPE,
221: p_unsigned_flag IN varchar2,
222: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
223: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
224: p_include_unpaid_flag IN varchar2,

Line 225: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,

221: p_unsigned_flag IN varchar2,
222: p_signed_flag IN RA_CUST_TRX_TYPES.signed_flag%TYPE,
223: p_drawee_issued_flag IN RA_CUST_TRX_TYPES.drawee_issued_flag%TYPE,
224: p_include_unpaid_flag IN varchar2,
225: p_drawee_id IN AR_PAYMENT_SCHEDULES.customer_id%TYPE,
226: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,
227: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,
228: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
229: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,