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_RW_ICR_PKG dependencies on AR_INTERIM_CASH_RECEIPTS

Line 8: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:
6: PROCEDURE validate_args_insert_row(
7: p_row_id IN VARCHAR2,
8: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
9: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
10: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 9: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

5:
6: PROCEDURE validate_args_insert_row(
7: p_row_id IN VARCHAR2,
8: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
9: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
10: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

Line 10: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

6: PROCEDURE validate_args_insert_row(
7: p_row_id IN VARCHAR2,
8: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
9: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
10: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
14: p_pay_from_customer IN

Line 11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,

7: p_row_id IN VARCHAR2,
8: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
9: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
10: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
14: p_pay_from_customer IN
15: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

8: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
9: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
10: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
14: p_pay_from_customer IN
15: ar_interim_cash_receipts.pay_from_customer%TYPE,
16: p_site_use_id IN

Line 13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

9: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
10: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
14: p_pay_from_customer IN
15: ar_interim_cash_receipts.pay_from_customer%TYPE,
16: p_site_use_id IN
17: ar_interim_cash_receipts.site_use_id%TYPE,

Line 15: ar_interim_cash_receipts.pay_from_customer%TYPE,

11: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
12: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
14: p_pay_from_customer IN
15: ar_interim_cash_receipts.pay_from_customer%TYPE,
16: p_site_use_id IN
17: ar_interim_cash_receipts.site_use_id%TYPE,
18: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
19: p_payment_schedule_id IN

Line 17: ar_interim_cash_receipts.site_use_id%TYPE,

13: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
14: p_pay_from_customer IN
15: ar_interim_cash_receipts.pay_from_customer%TYPE,
16: p_site_use_id IN
17: ar_interim_cash_receipts.site_use_id%TYPE,
18: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
19: p_payment_schedule_id IN
20: ar_payment_schedules.payment_schedule_id%TYPE,
21: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

Line 18: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

14: p_pay_from_customer IN
15: ar_interim_cash_receipts.pay_from_customer%TYPE,
16: p_site_use_id IN
17: ar_interim_cash_receipts.site_use_id%TYPE,
18: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
19: p_payment_schedule_id IN
20: ar_payment_schedules.payment_schedule_id%TYPE,
21: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
22: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 21: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

17: ar_interim_cash_receipts.site_use_id%TYPE,
18: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
19: p_payment_schedule_id IN
20: ar_payment_schedules.payment_schedule_id%TYPE,
21: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
22: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
23: p_receipt_method_id IN
24: ar_interim_cash_receipts.receipt_method_id%TYPE,
25: p_remittance_bank_account_id IN

Line 22: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

18: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
19: p_payment_schedule_id IN
20: ar_payment_schedules.payment_schedule_id%TYPE,
21: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
22: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
23: p_receipt_method_id IN
24: ar_interim_cash_receipts.receipt_method_id%TYPE,
25: p_remittance_bank_account_id IN
26: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );

Line 24: ar_interim_cash_receipts.receipt_method_id%TYPE,

20: ar_payment_schedules.payment_schedule_id%TYPE,
21: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
22: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
23: p_receipt_method_id IN
24: ar_interim_cash_receipts.receipt_method_id%TYPE,
25: p_remittance_bank_account_id IN
26: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
27: --
28: PROCEDURE validate_args_update_row(

Line 26: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );

22: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
23: p_receipt_method_id IN
24: ar_interim_cash_receipts.receipt_method_id%TYPE,
25: p_remittance_bank_account_id IN
26: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
27: --
28: PROCEDURE validate_args_update_row(
29: p_row_id IN VARCHAR2,
30: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

Line 30: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

26: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
27: --
28: PROCEDURE validate_args_update_row(
29: p_row_id IN VARCHAR2,
30: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
31: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
32: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
33: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
34: p_pay_from_customer IN

Line 31: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

27: --
28: PROCEDURE validate_args_update_row(
29: p_row_id IN VARCHAR2,
30: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
31: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
32: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
33: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
34: p_pay_from_customer IN
35: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 32: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

28: PROCEDURE validate_args_update_row(
29: p_row_id IN VARCHAR2,
30: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
31: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
32: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
33: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
34: p_pay_from_customer IN
35: ar_interim_cash_receipts.pay_from_customer%TYPE,
36: p_site_use_id IN

Line 33: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

29: p_row_id IN VARCHAR2,
30: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
31: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
32: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
33: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
34: p_pay_from_customer IN
35: ar_interim_cash_receipts.pay_from_customer%TYPE,
36: p_site_use_id IN
37: ar_interim_cash_receipts.site_use_id%TYPE,

Line 35: ar_interim_cash_receipts.pay_from_customer%TYPE,

31: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
32: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
33: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
34: p_pay_from_customer IN
35: ar_interim_cash_receipts.pay_from_customer%TYPE,
36: p_site_use_id IN
37: ar_interim_cash_receipts.site_use_id%TYPE,
38: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
39: p_payment_schedule_id IN

Line 37: ar_interim_cash_receipts.site_use_id%TYPE,

33: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
34: p_pay_from_customer IN
35: ar_interim_cash_receipts.pay_from_customer%TYPE,
36: p_site_use_id IN
37: ar_interim_cash_receipts.site_use_id%TYPE,
38: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
39: p_payment_schedule_id IN
40: ar_payment_schedules.payment_schedule_id%TYPE,
41: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 38: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

34: p_pay_from_customer IN
35: ar_interim_cash_receipts.pay_from_customer%TYPE,
36: p_site_use_id IN
37: ar_interim_cash_receipts.site_use_id%TYPE,
38: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
39: p_payment_schedule_id IN
40: ar_payment_schedules.payment_schedule_id%TYPE,
41: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
42: p_receipt_method_id IN

Line 41: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

37: ar_interim_cash_receipts.site_use_id%TYPE,
38: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
39: p_payment_schedule_id IN
40: ar_payment_schedules.payment_schedule_id%TYPE,
41: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
42: p_receipt_method_id IN
43: ar_interim_cash_receipts.receipt_method_id%TYPE,
44: p_remittance_bank_account_id IN
45: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );

Line 43: ar_interim_cash_receipts.receipt_method_id%TYPE,

39: p_payment_schedule_id IN
40: ar_payment_schedules.payment_schedule_id%TYPE,
41: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
42: p_receipt_method_id IN
43: ar_interim_cash_receipts.receipt_method_id%TYPE,
44: p_remittance_bank_account_id IN
45: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
46: --
47: PROCEDURE validate_special_type(

Line 45: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );

41: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
42: p_receipt_method_id IN
43: ar_interim_cash_receipts.receipt_method_id%TYPE,
44: p_remittance_bank_account_id IN
45: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
46: --
47: PROCEDURE validate_special_type(
48: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
49: p_pay_from_customer IN

Line 48: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

44: p_remittance_bank_account_id IN
45: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE );
46: --
47: PROCEDURE validate_special_type(
48: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
49: p_pay_from_customer IN
50: ar_interim_cash_receipts.pay_from_customer%TYPE,
51: p_site_use_id IN
52: ar_interim_cash_receipts.site_use_id%TYPE,

Line 50: ar_interim_cash_receipts.pay_from_customer%TYPE,

46: --
47: PROCEDURE validate_special_type(
48: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
49: p_pay_from_customer IN
50: ar_interim_cash_receipts.pay_from_customer%TYPE,
51: p_site_use_id IN
52: ar_interim_cash_receipts.site_use_id%TYPE,
53: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
54: p_payment_schedule_id IN

Line 52: ar_interim_cash_receipts.site_use_id%TYPE,

48: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
49: p_pay_from_customer IN
50: ar_interim_cash_receipts.pay_from_customer%TYPE,
51: p_site_use_id IN
52: ar_interim_cash_receipts.site_use_id%TYPE,
53: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
54: p_payment_schedule_id IN
55: ar_payment_schedules.payment_schedule_id%TYPE );
56: --

Line 53: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

49: p_pay_from_customer IN
50: ar_interim_cash_receipts.pay_from_customer%TYPE,
51: p_site_use_id IN
52: ar_interim_cash_receipts.site_use_id%TYPE,
53: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
54: p_payment_schedule_id IN
55: ar_payment_schedules.payment_schedule_id%TYPE );
56: --
57: PROCEDURE val_args_applied_amount_total(

Line 58: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE );

54: p_payment_schedule_id IN
55: ar_payment_schedules.payment_schedule_id%TYPE );
56: --
57: PROCEDURE val_args_applied_amount_total(
58: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE );
59: PROCEDURE val_args_check_unique_receipt(
60: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
61: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
62: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

Line 60: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

56: --
57: PROCEDURE val_args_applied_amount_total(
58: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE );
59: PROCEDURE val_args_check_unique_receipt(
60: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
61: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
62: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
63: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE );
64: --

Line 61: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

57: PROCEDURE val_args_applied_amount_total(
58: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE );
59: PROCEDURE val_args_check_unique_receipt(
60: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
61: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
62: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
63: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE );
64: --
65: PROCEDURE update_bank_account_uses(

Line 63: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE );

59: PROCEDURE val_args_check_unique_receipt(
60: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
61: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
62: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
63: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE );
64: --
65: PROCEDURE update_bank_account_uses(
66: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
67: p_bank_account_id IN ar_batches.remit_bank_acct_use_id%TYPE );

Line 132: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

128: --
129:
130: PROCEDURE update_row(
131: p_row_id IN VARCHAR2,
132: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
133: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
134: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
135: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
136: p_amount_applied IN

Line 133: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

129:
130: PROCEDURE update_row(
131: p_row_id IN VARCHAR2,
132: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
133: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
134: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
135: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
136: p_amount_applied IN
137: ar_interim_cash_receipts.amount_applied%TYPE,

Line 134: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

130: PROCEDURE update_row(
131: p_row_id IN VARCHAR2,
132: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
133: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
134: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
135: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
136: p_amount_applied IN
137: ar_interim_cash_receipts.amount_applied%TYPE,
138: p_trans_to_receipt_rate IN

Line 135: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

131: p_row_id IN VARCHAR2,
132: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
133: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
134: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
135: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
136: p_amount_applied IN
137: ar_interim_cash_receipts.amount_applied%TYPE,
138: p_trans_to_receipt_rate IN
139: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

Line 137: ar_interim_cash_receipts.amount_applied%TYPE,

133: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
134: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
135: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
136: p_amount_applied IN
137: ar_interim_cash_receipts.amount_applied%TYPE,
138: p_trans_to_receipt_rate IN
139: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
140: p_factor_discount_amount IN
141: ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 139: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

135: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
136: p_amount_applied IN
137: ar_interim_cash_receipts.amount_applied%TYPE,
138: p_trans_to_receipt_rate IN
139: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
140: p_factor_discount_amount IN
141: ar_interim_cash_receipts.factor_discount_amount%TYPE,
142: p_receipt_method_id IN
143: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 141: ar_interim_cash_receipts.factor_discount_amount%TYPE,

137: ar_interim_cash_receipts.amount_applied%TYPE,
138: p_trans_to_receipt_rate IN
139: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
140: p_factor_discount_amount IN
141: ar_interim_cash_receipts.factor_discount_amount%TYPE,
142: p_receipt_method_id IN
143: ar_interim_cash_receipts.receipt_method_id%TYPE,
144: p_remittance_bank_account_id IN
145: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 143: ar_interim_cash_receipts.receipt_method_id%TYPE,

139: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
140: p_factor_discount_amount IN
141: ar_interim_cash_receipts.factor_discount_amount%TYPE,
142: p_receipt_method_id IN
143: ar_interim_cash_receipts.receipt_method_id%TYPE,
144: p_remittance_bank_account_id IN
145: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
146: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
147: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 145: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

141: ar_interim_cash_receipts.factor_discount_amount%TYPE,
142: p_receipt_method_id IN
143: ar_interim_cash_receipts.receipt_method_id%TYPE,
144: p_remittance_bank_account_id IN
145: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
146: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
147: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
148: p_payment_schedule_id IN
149: ar_payment_schedules.payment_schedule_id%TYPE,

Line 146: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

142: p_receipt_method_id IN
143: ar_interim_cash_receipts.receipt_method_id%TYPE,
144: p_remittance_bank_account_id IN
145: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
146: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
147: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
148: p_payment_schedule_id IN
149: ar_payment_schedules.payment_schedule_id%TYPE,
150: p_pay_from_customer IN

Line 147: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

143: ar_interim_cash_receipts.receipt_method_id%TYPE,
144: p_remittance_bank_account_id IN
145: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
146: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
147: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
148: p_payment_schedule_id IN
149: ar_payment_schedules.payment_schedule_id%TYPE,
150: p_pay_from_customer IN
151: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 151: ar_interim_cash_receipts.pay_from_customer%TYPE,

147: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
148: p_payment_schedule_id IN
149: ar_payment_schedules.payment_schedule_id%TYPE,
150: p_pay_from_customer IN
151: ar_interim_cash_receipts.pay_from_customer%TYPE,
152: p_customer_bank_account_id IN
153: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
154: p_customer_bank_branch_id IN
155: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 153: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

149: ar_payment_schedules.payment_schedule_id%TYPE,
150: p_pay_from_customer IN
151: ar_interim_cash_receipts.pay_from_customer%TYPE,
152: p_customer_bank_account_id IN
153: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
154: p_customer_bank_branch_id IN
155: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
156: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
157: p_ussgl_transaction_code IN

Line 155: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

151: ar_interim_cash_receipts.pay_from_customer%TYPE,
152: p_customer_bank_account_id IN
153: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
154: p_customer_bank_branch_id IN
155: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
156: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
157: p_ussgl_transaction_code IN
158: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
159: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 156: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

152: p_customer_bank_account_id IN
153: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
154: p_customer_bank_branch_id IN
155: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
156: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
157: p_ussgl_transaction_code IN
158: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
159: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
160: p_doc_sequence_value IN

Line 158: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

154: p_customer_bank_branch_id IN
155: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
156: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
157: p_ussgl_transaction_code IN
158: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
159: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
160: p_doc_sequence_value IN
161: ar_interim_cash_receipts.doc_sequence_value%TYPE,
162: p_anticipated_clearing_date IN

Line 159: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

155: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
156: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
157: p_ussgl_transaction_code IN
158: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
159: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
160: p_doc_sequence_value IN
161: ar_interim_cash_receipts.doc_sequence_value%TYPE,
162: p_anticipated_clearing_date IN
163: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

Line 161: ar_interim_cash_receipts.doc_sequence_value%TYPE,

157: p_ussgl_transaction_code IN
158: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
159: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
160: p_doc_sequence_value IN
161: ar_interim_cash_receipts.doc_sequence_value%TYPE,
162: p_anticipated_clearing_date IN
163: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
164: p_attribute_category IN
165: ar_interim_cash_receipts.attribute_category%TYPE,

Line 163: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

159: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
160: p_doc_sequence_value IN
161: ar_interim_cash_receipts.doc_sequence_value%TYPE,
162: p_anticipated_clearing_date IN
163: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
164: p_attribute_category IN
165: ar_interim_cash_receipts.attribute_category%TYPE,
166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

Line 165: ar_interim_cash_receipts.attribute_category%TYPE,

161: ar_interim_cash_receipts.doc_sequence_value%TYPE,
162: p_anticipated_clearing_date IN
163: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
164: p_attribute_category IN
165: ar_interim_cash_receipts.attribute_category%TYPE,
166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

Line 166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,

162: p_anticipated_clearing_date IN
163: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
164: p_attribute_category IN
165: ar_interim_cash_receipts.attribute_category%TYPE,
166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

Line 167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

163: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
164: p_attribute_category IN
165: ar_interim_cash_receipts.attribute_category%TYPE,
166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

Line 168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,

164: p_attribute_category IN
165: ar_interim_cash_receipts.attribute_category%TYPE,
166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

Line 169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

165: ar_interim_cash_receipts.attribute_category%TYPE,
166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

Line 170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

166: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

Line 171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

167: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

Line 172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

168: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

Line 173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

169: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

Line 174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

170: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

Line 175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

171: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

Line 176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

172: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

Line 177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

173: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
181: -- Bug fix: 597519 12/18/97

Line 178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

174: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
181: -- Bug fix: 597519 12/18/97
182: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

Line 179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

175: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
181: -- Bug fix: 597519 12/18/97
182: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
183: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

Line 180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

176: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
177: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
181: -- Bug fix: 597519 12/18/97
182: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
183: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
184: p_exchange_rate_type IN

Line 182: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

178: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
181: -- Bug fix: 597519 12/18/97
182: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
183: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
184: p_exchange_rate_type IN
185: ar_interim_cash_receipts.exchange_rate_type%TYPE,
186: -- Bug fix: 750400 12/24/98

Line 183: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

179: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
180: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
181: -- Bug fix: 597519 12/18/97
182: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
183: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
184: p_exchange_rate_type IN
185: ar_interim_cash_receipts.exchange_rate_type%TYPE,
186: -- Bug fix: 750400 12/24/98
187: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 185: ar_interim_cash_receipts.exchange_rate_type%TYPE,

181: -- Bug fix: 597519 12/18/97
182: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
183: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
184: p_exchange_rate_type IN
185: ar_interim_cash_receipts.exchange_rate_type%TYPE,
186: -- Bug fix: 750400 12/24/98
187: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
188: -- enh 2074220
189: p_application_notes IN

Line 187: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

183: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
184: p_exchange_rate_type IN
185: ar_interim_cash_receipts.exchange_rate_type%TYPE,
186: -- Bug fix: 750400 12/24/98
187: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
188: -- enh 2074220
189: p_application_notes IN
190: ar_interim_cash_receipts.application_notes%TYPE,
191: p_application_ref_type IN

Line 190: ar_interim_cash_receipts.application_notes%TYPE,

186: -- Bug fix: 750400 12/24/98
187: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
188: -- enh 2074220
189: p_application_notes IN
190: ar_interim_cash_receipts.application_notes%TYPE,
191: p_application_ref_type IN
192: ar_interim_cash_receipts.application_ref_type%TYPE,
193: p_customer_reference IN
194: ar_interim_cash_receipts.customer_reference%TYPE,

Line 192: ar_interim_cash_receipts.application_ref_type%TYPE,

188: -- enh 2074220
189: p_application_notes IN
190: ar_interim_cash_receipts.application_notes%TYPE,
191: p_application_ref_type IN
192: ar_interim_cash_receipts.application_ref_type%TYPE,
193: p_customer_reference IN
194: ar_interim_cash_receipts.customer_reference%TYPE,
195: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
196: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,

Line 194: ar_interim_cash_receipts.customer_reference%TYPE,

190: ar_interim_cash_receipts.application_notes%TYPE,
191: p_application_ref_type IN
192: ar_interim_cash_receipts.application_ref_type%TYPE,
193: p_customer_reference IN
194: ar_interim_cash_receipts.customer_reference%TYPE,
195: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
196: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
197: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
198: p_module_name IN VARCHAR2,

Line 195: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

191: p_application_ref_type IN
192: ar_interim_cash_receipts.application_ref_type%TYPE,
193: p_customer_reference IN
194: ar_interim_cash_receipts.customer_reference%TYPE,
195: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
196: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
197: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
198: p_module_name IN VARCHAR2,
199: p_module_version IN VARCHAR2 ) IS

Line 196: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,

192: ar_interim_cash_receipts.application_ref_type%TYPE,
193: p_customer_reference IN
194: ar_interim_cash_receipts.customer_reference%TYPE,
195: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
196: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
197: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
198: p_module_name IN VARCHAR2,
199: p_module_version IN VARCHAR2 ) IS
200: --

Line 197: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,

193: p_customer_reference IN
194: ar_interim_cash_receipts.customer_reference%TYPE,
195: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
196: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
197: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
198: p_module_name IN VARCHAR2,
199: p_module_version IN VARCHAR2 ) IS
200: --
201: l_icr_rec ar_interim_cash_receipts%ROWTYPE;

Line 201: l_icr_rec ar_interim_cash_receipts%ROWTYPE;

197: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
198: p_module_name IN VARCHAR2,
199: p_module_version IN VARCHAR2 ) IS
200: --
201: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
202: BEGIN
203: IF PG_DEBUG in ('Y', 'C') THEN
204: arp_util.debug( 'arp_rw_icr_pkg.update_row()+' );
205: arp_util.debug( 'Special Type : '||p_special_type );

Line 365: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

361: | |
362: +===========================================================================*/
363: PROCEDURE validate_args_update_row(
364: p_row_id IN VARCHAR2,
365: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
366: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
367: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
368: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
369: p_pay_from_customer IN

Line 366: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

362: +===========================================================================*/
363: PROCEDURE validate_args_update_row(
364: p_row_id IN VARCHAR2,
365: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
366: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
367: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
368: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
369: p_pay_from_customer IN
370: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 367: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

363: PROCEDURE validate_args_update_row(
364: p_row_id IN VARCHAR2,
365: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
366: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
367: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
368: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
369: p_pay_from_customer IN
370: ar_interim_cash_receipts.pay_from_customer%TYPE,
371: p_site_use_id IN

Line 368: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

364: p_row_id IN VARCHAR2,
365: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
366: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
367: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
368: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
369: p_pay_from_customer IN
370: ar_interim_cash_receipts.pay_from_customer%TYPE,
371: p_site_use_id IN
372: ar_interim_cash_receipts.site_use_id%TYPE,

Line 370: ar_interim_cash_receipts.pay_from_customer%TYPE,

366: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
367: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
368: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
369: p_pay_from_customer IN
370: ar_interim_cash_receipts.pay_from_customer%TYPE,
371: p_site_use_id IN
372: ar_interim_cash_receipts.site_use_id%TYPE,
373: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
374: p_payment_schedule_id IN

Line 372: ar_interim_cash_receipts.site_use_id%TYPE,

368: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
369: p_pay_from_customer IN
370: ar_interim_cash_receipts.pay_from_customer%TYPE,
371: p_site_use_id IN
372: ar_interim_cash_receipts.site_use_id%TYPE,
373: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
374: p_payment_schedule_id IN
375: ar_payment_schedules.payment_schedule_id%TYPE,
376: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 373: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

369: p_pay_from_customer IN
370: ar_interim_cash_receipts.pay_from_customer%TYPE,
371: p_site_use_id IN
372: ar_interim_cash_receipts.site_use_id%TYPE,
373: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
374: p_payment_schedule_id IN
375: ar_payment_schedules.payment_schedule_id%TYPE,
376: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
377: p_receipt_method_id IN

Line 376: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

372: ar_interim_cash_receipts.site_use_id%TYPE,
373: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
374: p_payment_schedule_id IN
375: ar_payment_schedules.payment_schedule_id%TYPE,
376: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
377: p_receipt_method_id IN
378: ar_interim_cash_receipts.receipt_method_id%TYPE,
379: p_remittance_bank_account_id IN
380: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

Line 378: ar_interim_cash_receipts.receipt_method_id%TYPE,

374: p_payment_schedule_id IN
375: ar_payment_schedules.payment_schedule_id%TYPE,
376: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
377: p_receipt_method_id IN
378: ar_interim_cash_receipts.receipt_method_id%TYPE,
379: p_remittance_bank_account_id IN
380: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
381: BEGIN
382: IF PG_DEBUG in ('Y', 'C') THEN

Line 380: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

376: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
377: p_receipt_method_id IN
378: ar_interim_cash_receipts.receipt_method_id%TYPE,
379: p_remittance_bank_account_id IN
380: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
381: BEGIN
382: IF PG_DEBUG in ('Y', 'C') THEN
383: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );
384: END IF;

Line 459: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,

455: | procedures. |
456: +===========================================================================*/
457: PROCEDURE insert_row(
458: p_row_id IN OUT NOCOPY VARCHAR2,
459: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
460: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
461: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
462: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 460: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

456: +===========================================================================*/
457: PROCEDURE insert_row(
458: p_row_id IN OUT NOCOPY VARCHAR2,
459: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
460: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
461: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
462: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
464: p_amount_applied IN

Line 461: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

457: PROCEDURE insert_row(
458: p_row_id IN OUT NOCOPY VARCHAR2,
459: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
460: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
461: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
462: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
464: p_amount_applied IN
465: ar_interim_cash_receipts.amount_applied%TYPE,

Line 462: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

458: p_row_id IN OUT NOCOPY VARCHAR2,
459: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
460: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
461: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
462: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
464: p_amount_applied IN
465: ar_interim_cash_receipts.amount_applied%TYPE,
466: p_trans_to_receipt_rate IN

Line 463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

459: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
460: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
461: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
462: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
464: p_amount_applied IN
465: ar_interim_cash_receipts.amount_applied%TYPE,
466: p_trans_to_receipt_rate IN
467: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

Line 465: ar_interim_cash_receipts.amount_applied%TYPE,

461: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
462: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
464: p_amount_applied IN
465: ar_interim_cash_receipts.amount_applied%TYPE,
466: p_trans_to_receipt_rate IN
467: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
468: p_factor_discount_amount
469: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 467: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

463: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
464: p_amount_applied IN
465: ar_interim_cash_receipts.amount_applied%TYPE,
466: p_trans_to_receipt_rate IN
467: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
468: p_factor_discount_amount
469: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
470: p_receipt_method_id IN
471: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 469: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

465: ar_interim_cash_receipts.amount_applied%TYPE,
466: p_trans_to_receipt_rate IN
467: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
468: p_factor_discount_amount
469: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
470: p_receipt_method_id IN
471: ar_interim_cash_receipts.receipt_method_id%TYPE,
472: p_remittance_bank_account_id IN
473: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 471: ar_interim_cash_receipts.receipt_method_id%TYPE,

467: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
468: p_factor_discount_amount
469: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
470: p_receipt_method_id IN
471: ar_interim_cash_receipts.receipt_method_id%TYPE,
472: p_remittance_bank_account_id IN
473: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
474: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
475: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 473: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

469: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
470: p_receipt_method_id IN
471: ar_interim_cash_receipts.receipt_method_id%TYPE,
472: p_remittance_bank_account_id IN
473: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
474: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
475: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
476: p_payment_schedule_id IN
477: ar_payment_schedules.payment_schedule_id%TYPE,

Line 474: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

470: p_receipt_method_id IN
471: ar_interim_cash_receipts.receipt_method_id%TYPE,
472: p_remittance_bank_account_id IN
473: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
474: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
475: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
476: p_payment_schedule_id IN
477: ar_payment_schedules.payment_schedule_id%TYPE,
478: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

Line 475: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

471: ar_interim_cash_receipts.receipt_method_id%TYPE,
472: p_remittance_bank_account_id IN
473: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
474: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
475: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
476: p_payment_schedule_id IN
477: ar_payment_schedules.payment_schedule_id%TYPE,
478: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
479: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

Line 478: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

474: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
475: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
476: p_payment_schedule_id IN
477: ar_payment_schedules.payment_schedule_id%TYPE,
478: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
479: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
480: p_exchange_rate_type IN
481: ar_interim_cash_receipts.exchange_rate_type%TYPE,
482: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 479: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

475: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
476: p_payment_schedule_id IN
477: ar_payment_schedules.payment_schedule_id%TYPE,
478: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
479: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
480: p_exchange_rate_type IN
481: ar_interim_cash_receipts.exchange_rate_type%TYPE,
482: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
483: p_anticipated_clearing_date IN

Line 481: ar_interim_cash_receipts.exchange_rate_type%TYPE,

477: ar_payment_schedules.payment_schedule_id%TYPE,
478: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
479: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
480: p_exchange_rate_type IN
481: ar_interim_cash_receipts.exchange_rate_type%TYPE,
482: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
483: p_anticipated_clearing_date IN
484: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
485: p_pay_from_customer IN

Line 482: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

478: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
479: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
480: p_exchange_rate_type IN
481: ar_interim_cash_receipts.exchange_rate_type%TYPE,
482: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
483: p_anticipated_clearing_date IN
484: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
485: p_pay_from_customer IN
486: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 484: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

480: p_exchange_rate_type IN
481: ar_interim_cash_receipts.exchange_rate_type%TYPE,
482: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
483: p_anticipated_clearing_date IN
484: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
485: p_pay_from_customer IN
486: ar_interim_cash_receipts.pay_from_customer%TYPE,
487: p_customer_bank_account_id IN
488: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

Line 486: ar_interim_cash_receipts.pay_from_customer%TYPE,

482: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
483: p_anticipated_clearing_date IN
484: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
485: p_pay_from_customer IN
486: ar_interim_cash_receipts.pay_from_customer%TYPE,
487: p_customer_bank_account_id IN
488: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
489: p_customer_bank_branch_id IN
490: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 488: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

484: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
485: p_pay_from_customer IN
486: ar_interim_cash_receipts.pay_from_customer%TYPE,
487: p_customer_bank_account_id IN
488: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
489: p_customer_bank_branch_id IN
490: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
491: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
492: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

Line 490: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

486: ar_interim_cash_receipts.pay_from_customer%TYPE,
487: p_customer_bank_account_id IN
488: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
489: p_customer_bank_branch_id IN
490: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
491: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
492: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
493: p_ussgl_transaction_code IN
494: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

Line 491: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,

487: p_customer_bank_account_id IN
488: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
489: p_customer_bank_branch_id IN
490: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
491: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
492: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
493: p_ussgl_transaction_code IN
494: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
495: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 492: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

488: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
489: p_customer_bank_branch_id IN
490: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
491: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
492: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
493: p_ussgl_transaction_code IN
494: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
495: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
496: p_doc_sequence_value IN

Line 494: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

490: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
491: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
492: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
493: p_ussgl_transaction_code IN
494: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
495: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
496: p_doc_sequence_value IN
497: ar_interim_cash_receipts.doc_sequence_value%TYPE,
498: p_attribute_category IN

Line 495: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

491: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
492: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
493: p_ussgl_transaction_code IN
494: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
495: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
496: p_doc_sequence_value IN
497: ar_interim_cash_receipts.doc_sequence_value%TYPE,
498: p_attribute_category IN
499: ar_interim_cash_receipts.attribute_category%TYPE,

Line 497: ar_interim_cash_receipts.doc_sequence_value%TYPE,

493: p_ussgl_transaction_code IN
494: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
495: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
496: p_doc_sequence_value IN
497: ar_interim_cash_receipts.doc_sequence_value%TYPE,
498: p_attribute_category IN
499: ar_interim_cash_receipts.attribute_category%TYPE,
500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

Line 499: ar_interim_cash_receipts.attribute_category%TYPE,

495: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
496: p_doc_sequence_value IN
497: ar_interim_cash_receipts.doc_sequence_value%TYPE,
498: p_attribute_category IN
499: ar_interim_cash_receipts.attribute_category%TYPE,
500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

Line 500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,

496: p_doc_sequence_value IN
497: ar_interim_cash_receipts.doc_sequence_value%TYPE,
498: p_attribute_category IN
499: ar_interim_cash_receipts.attribute_category%TYPE,
500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

Line 501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

497: ar_interim_cash_receipts.doc_sequence_value%TYPE,
498: p_attribute_category IN
499: ar_interim_cash_receipts.attribute_category%TYPE,
500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

Line 502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,

498: p_attribute_category IN
499: ar_interim_cash_receipts.attribute_category%TYPE,
500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

Line 503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

499: ar_interim_cash_receipts.attribute_category%TYPE,
500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

Line 504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

500: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

Line 505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

501: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

Line 506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

502: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

Line 507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

503: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

Line 508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

504: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

Line 509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

505: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

Line 510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

506: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

Line 511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

507: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
515: p_application_notes IN

Line 512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

508: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
515: p_application_notes IN
516: ar_interim_cash_receipts.application_notes%TYPE,

Line 513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

509: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
515: p_application_notes IN
516: ar_interim_cash_receipts.application_notes%TYPE,
517: p_application_ref_type IN

Line 514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

510: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
511: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
515: p_application_notes IN
516: ar_interim_cash_receipts.application_notes%TYPE,
517: p_application_ref_type IN
518: ar_interim_cash_receipts.application_ref_type%TYPE,

Line 516: ar_interim_cash_receipts.application_notes%TYPE,

512: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
513: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
515: p_application_notes IN
516: ar_interim_cash_receipts.application_notes%TYPE,
517: p_application_ref_type IN
518: ar_interim_cash_receipts.application_ref_type%TYPE,
519: p_customer_reference IN
520: ar_interim_cash_receipts.customer_reference%TYPE,

Line 518: ar_interim_cash_receipts.application_ref_type%TYPE,

514: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
515: p_application_notes IN
516: ar_interim_cash_receipts.application_notes%TYPE,
517: p_application_ref_type IN
518: ar_interim_cash_receipts.application_ref_type%TYPE,
519: p_customer_reference IN
520: ar_interim_cash_receipts.customer_reference%TYPE,
521: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
522: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,

Line 520: ar_interim_cash_receipts.customer_reference%TYPE,

516: ar_interim_cash_receipts.application_notes%TYPE,
517: p_application_ref_type IN
518: ar_interim_cash_receipts.application_ref_type%TYPE,
519: p_customer_reference IN
520: ar_interim_cash_receipts.customer_reference%TYPE,
521: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
522: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
523: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
524: p_module_name IN VARCHAR2,

Line 521: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

517: p_application_ref_type IN
518: ar_interim_cash_receipts.application_ref_type%TYPE,
519: p_customer_reference IN
520: ar_interim_cash_receipts.customer_reference%TYPE,
521: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
522: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
523: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
524: p_module_name IN VARCHAR2,
525: p_module_version IN VARCHAR2 ) IS

Line 522: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,

518: ar_interim_cash_receipts.application_ref_type%TYPE,
519: p_customer_reference IN
520: ar_interim_cash_receipts.customer_reference%TYPE,
521: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
522: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
523: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
524: p_module_name IN VARCHAR2,
525: p_module_version IN VARCHAR2 ) IS
526: --

Line 523: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,

519: p_customer_reference IN
520: ar_interim_cash_receipts.customer_reference%TYPE,
521: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
522: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
523: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
524: p_module_name IN VARCHAR2,
525: p_module_version IN VARCHAR2 ) IS
526: --
527: l_row_id VARCHAR2(30);

Line 528: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

524: p_module_name IN VARCHAR2,
525: p_module_version IN VARCHAR2 ) IS
526: --
527: l_row_id VARCHAR2(30);
528: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
529: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
530: --
531: BEGIN
532: IF PG_DEBUG in ('Y', 'C') THEN

Line 529: l_icr_rec ar_interim_cash_receipts%ROWTYPE;

525: p_module_version IN VARCHAR2 ) IS
526: --
527: l_row_id VARCHAR2(30);
528: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
529: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
530: --
531: BEGIN
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );

Line 712: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

708: | |
709: +===========================================================================*/
710: PROCEDURE validate_args_insert_row(
711: p_row_id IN VARCHAR2,
712: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
713: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
714: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 713: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

709: +===========================================================================*/
710: PROCEDURE validate_args_insert_row(
711: p_row_id IN VARCHAR2,
712: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
713: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
714: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

Line 714: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

710: PROCEDURE validate_args_insert_row(
711: p_row_id IN VARCHAR2,
712: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
713: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
714: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
718: p_pay_from_customer IN

Line 715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,

711: p_row_id IN VARCHAR2,
712: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
713: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
714: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
718: p_pay_from_customer IN
719: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

712: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
713: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
714: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
718: p_pay_from_customer IN
719: ar_interim_cash_receipts.pay_from_customer%TYPE,
720: p_site_use_id IN

Line 717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

713: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
714: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
718: p_pay_from_customer IN
719: ar_interim_cash_receipts.pay_from_customer%TYPE,
720: p_site_use_id IN
721: ar_interim_cash_receipts.site_use_id%TYPE,

Line 719: ar_interim_cash_receipts.pay_from_customer%TYPE,

715: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
716: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
718: p_pay_from_customer IN
719: ar_interim_cash_receipts.pay_from_customer%TYPE,
720: p_site_use_id IN
721: ar_interim_cash_receipts.site_use_id%TYPE,
722: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
723: p_payment_schedule_id IN

Line 721: ar_interim_cash_receipts.site_use_id%TYPE,

717: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
718: p_pay_from_customer IN
719: ar_interim_cash_receipts.pay_from_customer%TYPE,
720: p_site_use_id IN
721: ar_interim_cash_receipts.site_use_id%TYPE,
722: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
723: p_payment_schedule_id IN
724: ar_payment_schedules.payment_schedule_id%TYPE,
725: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

Line 722: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

718: p_pay_from_customer IN
719: ar_interim_cash_receipts.pay_from_customer%TYPE,
720: p_site_use_id IN
721: ar_interim_cash_receipts.site_use_id%TYPE,
722: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
723: p_payment_schedule_id IN
724: ar_payment_schedules.payment_schedule_id%TYPE,
725: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
726: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 725: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

721: ar_interim_cash_receipts.site_use_id%TYPE,
722: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
723: p_payment_schedule_id IN
724: ar_payment_schedules.payment_schedule_id%TYPE,
725: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
726: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
727: p_receipt_method_id IN
728: ar_interim_cash_receipts.receipt_method_id%TYPE,
729: p_remittance_bank_account_id IN

Line 726: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

722: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
723: p_payment_schedule_id IN
724: ar_payment_schedules.payment_schedule_id%TYPE,
725: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
726: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
727: p_receipt_method_id IN
728: ar_interim_cash_receipts.receipt_method_id%TYPE,
729: p_remittance_bank_account_id IN
730: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

Line 728: ar_interim_cash_receipts.receipt_method_id%TYPE,

724: ar_payment_schedules.payment_schedule_id%TYPE,
725: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
726: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
727: p_receipt_method_id IN
728: ar_interim_cash_receipts.receipt_method_id%TYPE,
729: p_remittance_bank_account_id IN
730: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN

Line 730: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

726: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
727: p_receipt_method_id IN
728: ar_interim_cash_receipts.receipt_method_id%TYPE,
729: p_remittance_bank_account_id IN
730: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );
734: END IF;

Line 799: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

795: | in p_site_use_id validation. |
796: | |
797: +===========================================================================*/
798: PROCEDURE validate_special_type(
799: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
800: p_pay_from_customer IN
801: ar_interim_cash_receipts.pay_from_customer%TYPE,
802: p_site_use_id IN
803: ar_interim_cash_receipts.site_use_id%TYPE,

Line 801: ar_interim_cash_receipts.pay_from_customer%TYPE,

797: +===========================================================================*/
798: PROCEDURE validate_special_type(
799: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
800: p_pay_from_customer IN
801: ar_interim_cash_receipts.pay_from_customer%TYPE,
802: p_site_use_id IN
803: ar_interim_cash_receipts.site_use_id%TYPE,
804: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
805: p_payment_schedule_id IN

Line 803: ar_interim_cash_receipts.site_use_id%TYPE,

799: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
800: p_pay_from_customer IN
801: ar_interim_cash_receipts.pay_from_customer%TYPE,
802: p_site_use_id IN
803: ar_interim_cash_receipts.site_use_id%TYPE,
804: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
805: p_payment_schedule_id IN
806: ar_payment_schedules.payment_schedule_id%TYPE ) IS
807: BEGIN

Line 804: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

800: p_pay_from_customer IN
801: ar_interim_cash_receipts.pay_from_customer%TYPE,
802: p_site_use_id IN
803: ar_interim_cash_receipts.site_use_id%TYPE,
804: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
805: p_payment_schedule_id IN
806: ar_payment_schedules.payment_schedule_id%TYPE ) IS
807: BEGIN
808: --

Line 866: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

862: | applied from which will hold the amount in |
863: | receipt currency for cross currency apps. |
864: +===========================================================================*/
865: PROCEDURE get_applied_amount_total(
866: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
867: p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
868: p_applied_count_total OUT NOCOPY NUMBER,
869: p_module_name IN VARCHAR2,
870: p_module_version IN VARCHAR2 ) IS

Line 867: p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,

863: | receipt currency for cross currency apps. |
864: +===========================================================================*/
865: PROCEDURE get_applied_amount_total(
866: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
867: p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
868: p_applied_count_total OUT NOCOPY NUMBER,
869: p_module_name IN VARCHAR2,
870: p_module_version IN VARCHAR2 ) IS
871: BEGIN

Line 926: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS

922: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
923: | |
924: +===========================================================================*/
925: PROCEDURE val_args_applied_amount_total(
926: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
927: BEGIN
928: IF PG_DEBUG in ('Y', 'C') THEN
929: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );
930: END IF;

Line 980: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

976: | |
977: +===========================================================================*/
978: PROCEDURE check_unique_receipt(
979: p_row_id IN VARCHAR2,
980: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
981: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
982: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
983: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
984: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 981: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

977: +===========================================================================*/
978: PROCEDURE check_unique_receipt(
979: p_row_id IN VARCHAR2,
980: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
981: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
982: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
983: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
984: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
985: p_factor_discount_amount

Line 982: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

978: PROCEDURE check_unique_receipt(
979: p_row_id IN VARCHAR2,
980: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
981: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
982: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
983: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
984: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
985: p_factor_discount_amount
986: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 984: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

980: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
981: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
982: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
983: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
984: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
985: p_factor_discount_amount
986: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
987: p_module_name IN VARCHAR2,
988: p_module_version IN VARCHAR2 ) IS

Line 986: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

982: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
983: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
984: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
985: p_factor_discount_amount
986: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
987: p_module_name IN VARCHAR2,
988: p_module_version IN VARCHAR2 ) IS
989: l_count NUMBER := 0;
990: BEGIN

Line 1012: FROM ar_interim_cash_receipts icr

1008: -- Check ICR table to see if the receipt exists
1009: --
1010: SELECT COUNT(*)
1011: INTO l_count
1012: FROM ar_interim_cash_receipts icr
1013: WHERE ( p_row_id IS NULL
1014: OR icr.rowid <> p_row_id )
1015: AND ( p_cr_id IS NULL
1016: OR icr.cash_receipt_id <> p_cr_id )

Line 1083: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

1079: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
1080: | |
1081: +===========================================================================*/
1082: PROCEDURE val_args_check_unique_receipt(
1083: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
1084: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
1085: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1086: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1087: BEGIN

Line 1084: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

1080: | |
1081: +===========================================================================*/
1082: PROCEDURE val_args_check_unique_receipt(
1083: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
1084: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
1085: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1086: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1087: BEGIN
1088: IF PG_DEBUG in ('Y', 'C') THEN

Line 1086: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS

1082: PROCEDURE val_args_check_unique_receipt(
1083: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
1084: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
1085: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1086: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1087: BEGIN
1088: IF PG_DEBUG in ('Y', 'C') THEN
1089: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );
1090: END IF;

Line 1145: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1141: | MODIFICATION HISTORY - 08/09/95 - Created by Ganesh Vaidee |
1142: | |
1143: +===========================================================================*/
1144: FUNCTION lines_exists(
1145: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1146: p_module_name IN VARCHAR2,
1147: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
1148: l_count NUMBER;
1149: BEGIN

Line 1215: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1211: | MODIFICATION HISTORY - 08/09/95 - Created by Ganesh Vaidee |
1212: | |
1213: +===========================================================================*/
1214: PROCEDURE check_no_lines_exists (
1215: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1216: p_module_name IN VARCHAR2,
1217: p_module_version IN VARCHAR2 ) IS
1218: BEGIN
1219: IF PG_DEBUG in ('Y', 'C') THEN

Line 1295: | This function deletes a row from AR_INTERIM_CASH_RECEIPTS. |

1291: | delete_row - Deletes a row from the QRC_ICR table |
1292: | |
1293: | |
1294: | DESCRIPTION |
1295: | This function deletes a row from AR_INTERIM_CASH_RECEIPTS. |
1296: | |
1297: | |
1298: | SCOPE - PUBLIC |
1299: | |

Line 1320: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1316: | 10-21-96 OSTEINME updated comments |
1317: +===========================================================================*/
1318: PROCEDURE delete_row(
1319: p_row_id IN VARCHAR2,
1320: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1321: p_module_name IN VARCHAR2,
1322: p_module_version IN VARCHAR2 ) IS
1323: BEGIN
1324: IF PG_DEBUG in ('Y', 'C') THEN

Line 1381: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,

1377: | 10-28-96 OSTEINME added new parameter customer_bank_branch_id |
1378: +===========================================================================*/
1379: PROCEDURE lock_row(
1380: p_row_id VARCHAR2,
1381: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1382: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1383: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1384: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

Line 1382: p_special_type ar_interim_cash_receipts.special_type%TYPE,

1378: +===========================================================================*/
1379: PROCEDURE lock_row(
1380: p_row_id VARCHAR2,
1381: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1382: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1383: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1384: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1386: p_factor_discount_amount IN

Line 1383: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,

1379: PROCEDURE lock_row(
1380: p_row_id VARCHAR2,
1381: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1382: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1383: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1384: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1386: p_factor_discount_amount IN
1387: ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 1384: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,

1380: p_row_id VARCHAR2,
1381: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1382: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1383: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1384: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1386: p_factor_discount_amount IN
1387: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1388: p_receipt_method_id

Line 1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

1381: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1382: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1383: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1384: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1386: p_factor_discount_amount IN
1387: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1388: p_receipt_method_id
1389: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 1387: ar_interim_cash_receipts.factor_discount_amount%TYPE,

1383: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1384: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1386: p_factor_discount_amount IN
1387: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1388: p_receipt_method_id
1389: ar_interim_cash_receipts.receipt_method_id%TYPE,
1390: p_remittance_bank_account_id
1391: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 1389: ar_interim_cash_receipts.receipt_method_id%TYPE,

1385: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1386: p_factor_discount_amount IN
1387: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1388: p_receipt_method_id
1389: ar_interim_cash_receipts.receipt_method_id%TYPE,
1390: p_remittance_bank_account_id
1391: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1392: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1393: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 1391: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

1387: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1388: p_receipt_method_id
1389: ar_interim_cash_receipts.receipt_method_id%TYPE,
1390: p_remittance_bank_account_id
1391: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1392: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1393: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1394: p_payment_schedule_id
1395: ar_payment_schedules.payment_schedule_id%TYPE,

Line 1392: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,

1388: p_receipt_method_id
1389: ar_interim_cash_receipts.receipt_method_id%TYPE,
1390: p_remittance_bank_account_id
1391: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1392: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1393: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1394: p_payment_schedule_id
1395: ar_payment_schedules.payment_schedule_id%TYPE,
1396: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

Line 1393: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

1389: ar_interim_cash_receipts.receipt_method_id%TYPE,
1390: p_remittance_bank_account_id
1391: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1392: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1393: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1394: p_payment_schedule_id
1395: ar_payment_schedules.payment_schedule_id%TYPE,
1396: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1397: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

Line 1396: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

1392: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1393: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1394: p_payment_schedule_id
1395: ar_payment_schedules.payment_schedule_id%TYPE,
1396: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1397: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1398: p_exchange_rate_type
1399: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1400: p_gl_date IN

Line 1397: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

1393: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1394: p_payment_schedule_id
1395: ar_payment_schedules.payment_schedule_id%TYPE,
1396: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1397: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1398: p_exchange_rate_type
1399: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1400: p_gl_date IN
1401: ar_interim_cash_receipts.gl_date%TYPE,

Line 1399: ar_interim_cash_receipts.exchange_rate_type%TYPE,

1395: ar_payment_schedules.payment_schedule_id%TYPE,
1396: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1397: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1398: p_exchange_rate_type
1399: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1400: p_gl_date IN
1401: ar_interim_cash_receipts.gl_date%TYPE,
1402: p_anticipated_clearing_date IN
1403: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

Line 1401: ar_interim_cash_receipts.gl_date%TYPE,

1397: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1398: p_exchange_rate_type
1399: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1400: p_gl_date IN
1401: ar_interim_cash_receipts.gl_date%TYPE,
1402: p_anticipated_clearing_date IN
1403: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1404: p_pay_from_customer
1405: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 1403: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

1399: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1400: p_gl_date IN
1401: ar_interim_cash_receipts.gl_date%TYPE,
1402: p_anticipated_clearing_date IN
1403: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1404: p_pay_from_customer
1405: ar_interim_cash_receipts.pay_from_customer%TYPE,
1406: p_customer_bank_account_id IN
1407: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

Line 1405: ar_interim_cash_receipts.pay_from_customer%TYPE,

1401: ar_interim_cash_receipts.gl_date%TYPE,
1402: p_anticipated_clearing_date IN
1403: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1404: p_pay_from_customer
1405: ar_interim_cash_receipts.pay_from_customer%TYPE,
1406: p_customer_bank_account_id IN
1407: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1408: p_customer_bank_branch_id IN
1409: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 1407: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

1403: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1404: p_pay_from_customer
1405: ar_interim_cash_receipts.pay_from_customer%TYPE,
1406: p_customer_bank_account_id IN
1407: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1408: p_customer_bank_branch_id IN
1409: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1410: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1411: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

Line 1409: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

1405: ar_interim_cash_receipts.pay_from_customer%TYPE,
1406: p_customer_bank_account_id IN
1407: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1408: p_customer_bank_branch_id IN
1409: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1410: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1411: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1412: p_ussgl_transaction_code
1413: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

Line 1410: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,

1406: p_customer_bank_account_id IN
1407: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1408: p_customer_bank_branch_id IN
1409: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1410: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1411: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1412: p_ussgl_transaction_code
1413: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1414: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 1411: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

1407: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1408: p_customer_bank_branch_id IN
1409: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1410: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1411: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1412: p_ussgl_transaction_code
1413: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1414: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1415: p_doc_sequence_value

Line 1413: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

1409: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1410: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1411: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1412: p_ussgl_transaction_code
1413: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1414: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1415: p_doc_sequence_value
1416: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1417: p_attribute_category

Line 1414: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

1410: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1411: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1412: p_ussgl_transaction_code
1413: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1414: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1415: p_doc_sequence_value
1416: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1417: p_attribute_category
1418: ar_interim_cash_receipts.attribute_category%TYPE,

Line 1416: ar_interim_cash_receipts.doc_sequence_value%TYPE,

1412: p_ussgl_transaction_code
1413: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1414: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1415: p_doc_sequence_value
1416: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1417: p_attribute_category
1418: ar_interim_cash_receipts.attribute_category%TYPE,
1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

Line 1418: ar_interim_cash_receipts.attribute_category%TYPE,

1414: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1415: p_doc_sequence_value
1416: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1417: p_attribute_category
1418: ar_interim_cash_receipts.attribute_category%TYPE,
1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

Line 1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,

1415: p_doc_sequence_value
1416: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1417: p_attribute_category
1418: ar_interim_cash_receipts.attribute_category%TYPE,
1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

Line 1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

1416: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1417: p_attribute_category
1418: ar_interim_cash_receipts.attribute_category%TYPE,
1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

Line 1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,

1417: p_attribute_category
1418: ar_interim_cash_receipts.attribute_category%TYPE,
1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

Line 1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

1418: ar_interim_cash_receipts.attribute_category%TYPE,
1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

Line 1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

1419: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

Line 1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

1420: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

Line 1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

1421: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

Line 1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

1422: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

Line 1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

1423: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

Line 1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

1424: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1432: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

Line 1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

1425: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1432: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1433: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE

Line 1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

1426: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1432: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1433: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1434: ) IS

Line 1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

1427: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1432: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1433: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1434: ) IS
1435: CURSOR C IS

Line 1432: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

1428: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1432: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1433: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1434: ) IS
1435: CURSOR C IS
1436: SELECT *

Line 1433: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE

1429: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1430: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1431: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1432: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1433: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1434: ) IS
1435: CURSOR C IS
1436: SELECT *
1437: FROM ar_interim_cash_receipts

Line 1437: FROM ar_interim_cash_receipts

1433: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1434: ) IS
1435: CURSOR C IS
1436: SELECT *
1437: FROM ar_interim_cash_receipts
1438: WHERE rowid = p_row_id
1439: FOR UPDATE of CASH_RECEIPT_ID NOWAIT;
1440: Recinfo C%ROWTYPE;
1441: --