DBA Data[Home] [Help]

APPS.ARP_PROCESS_BR_REMIT dependencies on HZ_CUST_ACCOUNTS

Line 52: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

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,
56: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 53: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%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,
56: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
57: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

Line 54: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
56: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
57: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
58: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 55: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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,
56: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
57: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
58: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
59: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

Line 56: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
56: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
57: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
58: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
59: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
60: p_br_sort_criteria IN varchar2,

Line 94: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

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,
98: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 95: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%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,
98: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
99: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

Line 96: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
98: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
99: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
100: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 97: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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,
98: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
99: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
100: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
101: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

Line 98: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
98: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
99: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
100: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
101: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
102: p_br_sort_criteria IN varchar2,

Line 129: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%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);
133:

Line 130: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%TYPE,

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);
133:
134: PROCEDURE add_or_rm_br_to_remit (

Line 151: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
155: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 152: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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,
155: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
156: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

Line 153: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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,
155: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
156: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
157: p_unsigned_flag IN varchar2,

Line 182: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

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,
186: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 183: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%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,
186: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
187: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

Line 184: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
186: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
187: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
188: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 185: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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,
186: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
187: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
188: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
189: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

Line 186: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
186: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
187: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
188: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
189: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
190: p_br_sort_criteria IN varchar2,

Line 226: p_drawee_number_low IN HZ_CUST_ACCOUNTS.account_number%TYPE,

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,
230: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

Line 227: p_drawee_number_high IN HZ_CUST_ACCOUNTS.account_number%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,
230: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
231: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,

Line 228: p_drawee_class1_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
230: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
231: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
232: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,

Line 229: p_drawee_class2_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,

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,
230: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
231: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
232: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
233: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,

Line 230: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%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,
230: p_drawee_class3_code IN HZ_CUST_ACCOUNTS.customer_class_code%TYPE,
231: p_drawee_bank_name IN ce_bank_branches_v.bank_name%TYPE,
232: p_drawee_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
233: p_drawee_branch_city IN ce_bank_branches_v.city%TYPE,
234: p_br_sort_criteria IN varchar2,