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_module_name IN VARCHAR2,

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_module_name IN VARCHAR2,
197: p_module_version IN VARCHAR2 ) IS
198: --

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_module_name IN VARCHAR2,
197: p_module_version IN VARCHAR2 ) IS
198: --
199: l_icr_rec ar_interim_cash_receipts%ROWTYPE;

Line 199: l_icr_rec ar_interim_cash_receipts%ROWTYPE;

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

Line 359: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

355: | |
356: +===========================================================================*/
357: PROCEDURE validate_args_update_row(
358: p_row_id IN VARCHAR2,
359: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
360: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
361: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
362: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
363: p_pay_from_customer IN

Line 360: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

356: +===========================================================================*/
357: PROCEDURE validate_args_update_row(
358: p_row_id IN VARCHAR2,
359: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
360: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
361: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
362: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
363: p_pay_from_customer IN
364: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 361: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

357: PROCEDURE validate_args_update_row(
358: p_row_id IN VARCHAR2,
359: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
360: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
361: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
362: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
363: p_pay_from_customer IN
364: ar_interim_cash_receipts.pay_from_customer%TYPE,
365: p_site_use_id IN

Line 362: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

358: p_row_id IN VARCHAR2,
359: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
360: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
361: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
362: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
363: p_pay_from_customer IN
364: ar_interim_cash_receipts.pay_from_customer%TYPE,
365: p_site_use_id IN
366: ar_interim_cash_receipts.site_use_id%TYPE,

Line 364: ar_interim_cash_receipts.pay_from_customer%TYPE,

360: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
361: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
362: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
363: p_pay_from_customer IN
364: ar_interim_cash_receipts.pay_from_customer%TYPE,
365: p_site_use_id IN
366: ar_interim_cash_receipts.site_use_id%TYPE,
367: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
368: p_payment_schedule_id IN

Line 366: ar_interim_cash_receipts.site_use_id%TYPE,

362: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
363: p_pay_from_customer IN
364: ar_interim_cash_receipts.pay_from_customer%TYPE,
365: p_site_use_id IN
366: ar_interim_cash_receipts.site_use_id%TYPE,
367: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
368: p_payment_schedule_id IN
369: ar_payment_schedules.payment_schedule_id%TYPE,
370: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 367: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

363: p_pay_from_customer IN
364: ar_interim_cash_receipts.pay_from_customer%TYPE,
365: p_site_use_id IN
366: ar_interim_cash_receipts.site_use_id%TYPE,
367: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
368: p_payment_schedule_id IN
369: ar_payment_schedules.payment_schedule_id%TYPE,
370: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
371: p_receipt_method_id IN

Line 370: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

366: ar_interim_cash_receipts.site_use_id%TYPE,
367: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
368: p_payment_schedule_id IN
369: ar_payment_schedules.payment_schedule_id%TYPE,
370: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
371: p_receipt_method_id IN
372: ar_interim_cash_receipts.receipt_method_id%TYPE,
373: p_remittance_bank_account_id IN
374: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

Line 372: ar_interim_cash_receipts.receipt_method_id%TYPE,

368: p_payment_schedule_id IN
369: ar_payment_schedules.payment_schedule_id%TYPE,
370: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
371: p_receipt_method_id IN
372: ar_interim_cash_receipts.receipt_method_id%TYPE,
373: p_remittance_bank_account_id IN
374: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
375: BEGIN
376: IF PG_DEBUG in ('Y', 'C') THEN

Line 374: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

370: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
371: p_receipt_method_id IN
372: ar_interim_cash_receipts.receipt_method_id%TYPE,
373: p_remittance_bank_account_id IN
374: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
375: BEGIN
376: IF PG_DEBUG in ('Y', 'C') THEN
377: arp_util.debug( 'arp_rw_icr_pkg.validate_args_update_row()+' );
378: END IF;

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

449: | procedures. |
450: +===========================================================================*/
451: PROCEDURE insert_row(
452: p_row_id IN OUT NOCOPY VARCHAR2,
453: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
454: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
455: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
456: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 454: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

450: +===========================================================================*/
451: PROCEDURE insert_row(
452: p_row_id IN OUT NOCOPY VARCHAR2,
453: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
454: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
455: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
456: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
458: p_amount_applied IN

Line 455: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

451: PROCEDURE insert_row(
452: p_row_id IN OUT NOCOPY VARCHAR2,
453: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
454: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
455: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
456: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
458: p_amount_applied IN
459: ar_interim_cash_receipts.amount_applied%TYPE,

Line 456: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

452: p_row_id IN OUT NOCOPY VARCHAR2,
453: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
454: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
455: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
456: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
458: p_amount_applied IN
459: ar_interim_cash_receipts.amount_applied%TYPE,
460: p_trans_to_receipt_rate IN

Line 457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

453: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
454: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
455: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
456: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
458: p_amount_applied IN
459: ar_interim_cash_receipts.amount_applied%TYPE,
460: p_trans_to_receipt_rate IN
461: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

Line 459: ar_interim_cash_receipts.amount_applied%TYPE,

455: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
456: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
458: p_amount_applied IN
459: ar_interim_cash_receipts.amount_applied%TYPE,
460: p_trans_to_receipt_rate IN
461: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
462: p_factor_discount_amount
463: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 461: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

457: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
458: p_amount_applied IN
459: ar_interim_cash_receipts.amount_applied%TYPE,
460: p_trans_to_receipt_rate IN
461: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
462: p_factor_discount_amount
463: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
464: p_receipt_method_id IN
465: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 463: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

459: ar_interim_cash_receipts.amount_applied%TYPE,
460: p_trans_to_receipt_rate IN
461: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
462: p_factor_discount_amount
463: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
464: p_receipt_method_id IN
465: ar_interim_cash_receipts.receipt_method_id%TYPE,
466: p_remittance_bank_account_id IN
467: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 465: ar_interim_cash_receipts.receipt_method_id%TYPE,

461: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
462: p_factor_discount_amount
463: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
464: p_receipt_method_id IN
465: ar_interim_cash_receipts.receipt_method_id%TYPE,
466: p_remittance_bank_account_id IN
467: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
468: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
469: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 467: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

463: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
464: p_receipt_method_id IN
465: ar_interim_cash_receipts.receipt_method_id%TYPE,
466: p_remittance_bank_account_id IN
467: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
468: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
469: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
470: p_payment_schedule_id IN
471: ar_payment_schedules.payment_schedule_id%TYPE,

Line 468: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

464: p_receipt_method_id IN
465: ar_interim_cash_receipts.receipt_method_id%TYPE,
466: p_remittance_bank_account_id IN
467: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
468: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
469: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
470: p_payment_schedule_id IN
471: ar_payment_schedules.payment_schedule_id%TYPE,
472: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

Line 469: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

465: ar_interim_cash_receipts.receipt_method_id%TYPE,
466: p_remittance_bank_account_id IN
467: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
468: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
469: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
470: p_payment_schedule_id IN
471: ar_payment_schedules.payment_schedule_id%TYPE,
472: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
473: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

Line 472: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

468: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
469: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
470: p_payment_schedule_id IN
471: ar_payment_schedules.payment_schedule_id%TYPE,
472: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
473: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
474: p_exchange_rate_type IN
475: ar_interim_cash_receipts.exchange_rate_type%TYPE,
476: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 473: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

469: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
470: p_payment_schedule_id IN
471: ar_payment_schedules.payment_schedule_id%TYPE,
472: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
473: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
474: p_exchange_rate_type IN
475: ar_interim_cash_receipts.exchange_rate_type%TYPE,
476: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
477: p_anticipated_clearing_date IN

Line 475: ar_interim_cash_receipts.exchange_rate_type%TYPE,

471: ar_payment_schedules.payment_schedule_id%TYPE,
472: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
473: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
474: p_exchange_rate_type IN
475: ar_interim_cash_receipts.exchange_rate_type%TYPE,
476: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
477: p_anticipated_clearing_date IN
478: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
479: p_pay_from_customer IN

Line 476: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

472: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
473: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
474: p_exchange_rate_type IN
475: ar_interim_cash_receipts.exchange_rate_type%TYPE,
476: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
477: p_anticipated_clearing_date IN
478: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
479: p_pay_from_customer IN
480: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 478: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

474: p_exchange_rate_type IN
475: ar_interim_cash_receipts.exchange_rate_type%TYPE,
476: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
477: p_anticipated_clearing_date IN
478: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
479: p_pay_from_customer IN
480: ar_interim_cash_receipts.pay_from_customer%TYPE,
481: p_customer_bank_account_id IN
482: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

Line 480: ar_interim_cash_receipts.pay_from_customer%TYPE,

476: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
477: p_anticipated_clearing_date IN
478: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
479: p_pay_from_customer IN
480: ar_interim_cash_receipts.pay_from_customer%TYPE,
481: p_customer_bank_account_id IN
482: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
483: p_customer_bank_branch_id IN
484: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 482: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

478: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
479: p_pay_from_customer IN
480: ar_interim_cash_receipts.pay_from_customer%TYPE,
481: p_customer_bank_account_id IN
482: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
483: p_customer_bank_branch_id IN
484: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
485: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
486: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

Line 484: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

480: ar_interim_cash_receipts.pay_from_customer%TYPE,
481: p_customer_bank_account_id IN
482: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
483: p_customer_bank_branch_id IN
484: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
485: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
486: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
487: p_ussgl_transaction_code IN
488: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

Line 485: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,

481: p_customer_bank_account_id IN
482: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
483: p_customer_bank_branch_id IN
484: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
485: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
486: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
487: p_ussgl_transaction_code IN
488: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
489: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 486: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

482: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
483: p_customer_bank_branch_id IN
484: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
485: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
486: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
487: p_ussgl_transaction_code IN
488: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
489: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
490: p_doc_sequence_value IN

Line 488: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

484: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
485: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
486: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
487: p_ussgl_transaction_code IN
488: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
489: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
490: p_doc_sequence_value IN
491: ar_interim_cash_receipts.doc_sequence_value%TYPE,
492: p_attribute_category IN

Line 489: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

485: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
486: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
487: p_ussgl_transaction_code IN
488: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
489: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
490: p_doc_sequence_value IN
491: ar_interim_cash_receipts.doc_sequence_value%TYPE,
492: p_attribute_category IN
493: ar_interim_cash_receipts.attribute_category%TYPE,

Line 491: ar_interim_cash_receipts.doc_sequence_value%TYPE,

487: p_ussgl_transaction_code IN
488: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
489: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
490: p_doc_sequence_value IN
491: ar_interim_cash_receipts.doc_sequence_value%TYPE,
492: p_attribute_category IN
493: ar_interim_cash_receipts.attribute_category%TYPE,
494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

Line 493: ar_interim_cash_receipts.attribute_category%TYPE,

489: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
490: p_doc_sequence_value IN
491: ar_interim_cash_receipts.doc_sequence_value%TYPE,
492: p_attribute_category IN
493: ar_interim_cash_receipts.attribute_category%TYPE,
494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

Line 494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,

490: p_doc_sequence_value IN
491: ar_interim_cash_receipts.doc_sequence_value%TYPE,
492: p_attribute_category IN
493: ar_interim_cash_receipts.attribute_category%TYPE,
494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

Line 495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

491: ar_interim_cash_receipts.doc_sequence_value%TYPE,
492: p_attribute_category IN
493: ar_interim_cash_receipts.attribute_category%TYPE,
494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

Line 496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,

492: p_attribute_category IN
493: ar_interim_cash_receipts.attribute_category%TYPE,
494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

Line 497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

493: ar_interim_cash_receipts.attribute_category%TYPE,
494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

Line 498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

494: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

Line 499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

495: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

Line 500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

496: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

Line 501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

497: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

Line 502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

498: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

Line 503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

499: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

Line 504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

500: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

Line 505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

501: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
509: p_application_notes IN

Line 506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

502: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
509: p_application_notes IN
510: ar_interim_cash_receipts.application_notes%TYPE,

Line 507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

503: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
509: p_application_notes IN
510: ar_interim_cash_receipts.application_notes%TYPE,
511: p_application_ref_type IN

Line 508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

504: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
505: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
509: p_application_notes IN
510: ar_interim_cash_receipts.application_notes%TYPE,
511: p_application_ref_type IN
512: ar_interim_cash_receipts.application_ref_type%TYPE,

Line 510: ar_interim_cash_receipts.application_notes%TYPE,

506: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
507: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
509: p_application_notes IN
510: ar_interim_cash_receipts.application_notes%TYPE,
511: p_application_ref_type IN
512: ar_interim_cash_receipts.application_ref_type%TYPE,
513: p_customer_reference IN
514: ar_interim_cash_receipts.customer_reference%TYPE,

Line 512: ar_interim_cash_receipts.application_ref_type%TYPE,

508: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
509: p_application_notes IN
510: ar_interim_cash_receipts.application_notes%TYPE,
511: p_application_ref_type IN
512: ar_interim_cash_receipts.application_ref_type%TYPE,
513: p_customer_reference IN
514: ar_interim_cash_receipts.customer_reference%TYPE,
515: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
516: p_module_name IN VARCHAR2,

Line 514: ar_interim_cash_receipts.customer_reference%TYPE,

510: ar_interim_cash_receipts.application_notes%TYPE,
511: p_application_ref_type IN
512: ar_interim_cash_receipts.application_ref_type%TYPE,
513: p_customer_reference IN
514: ar_interim_cash_receipts.customer_reference%TYPE,
515: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
516: p_module_name IN VARCHAR2,
517: p_module_version IN VARCHAR2 ) IS
518: --

Line 515: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

511: p_application_ref_type IN
512: ar_interim_cash_receipts.application_ref_type%TYPE,
513: p_customer_reference IN
514: ar_interim_cash_receipts.customer_reference%TYPE,
515: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
516: p_module_name IN VARCHAR2,
517: p_module_version IN VARCHAR2 ) IS
518: --
519: l_row_id VARCHAR2(30);

Line 520: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;

516: p_module_name IN VARCHAR2,
517: p_module_version IN VARCHAR2 ) IS
518: --
519: l_row_id VARCHAR2(30);
520: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
521: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
522: --
523: BEGIN
524: IF PG_DEBUG in ('Y', 'C') THEN

Line 521: l_icr_rec ar_interim_cash_receipts%ROWTYPE;

517: p_module_version IN VARCHAR2 ) IS
518: --
519: l_row_id VARCHAR2(30);
520: l_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE;
521: l_icr_rec ar_interim_cash_receipts%ROWTYPE;
522: --
523: BEGIN
524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_util.debug( 'arp_rw_icr_pkg.insert_row()+' );

Line 700: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

696: | |
697: +===========================================================================*/
698: PROCEDURE validate_args_insert_row(
699: p_row_id IN VARCHAR2,
700: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
701: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
702: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 701: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

697: +===========================================================================*/
698: PROCEDURE validate_args_insert_row(
699: p_row_id IN VARCHAR2,
700: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
701: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
702: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

Line 702: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

698: PROCEDURE validate_args_insert_row(
699: p_row_id IN VARCHAR2,
700: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
701: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
702: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
706: p_pay_from_customer IN

Line 703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,

699: p_row_id IN VARCHAR2,
700: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
701: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
702: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
706: p_pay_from_customer IN
707: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

700: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
701: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
702: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
706: p_pay_from_customer IN
707: ar_interim_cash_receipts.pay_from_customer%TYPE,
708: p_site_use_id IN

Line 705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

701: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
702: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
706: p_pay_from_customer IN
707: ar_interim_cash_receipts.pay_from_customer%TYPE,
708: p_site_use_id IN
709: ar_interim_cash_receipts.site_use_id%TYPE,

Line 707: ar_interim_cash_receipts.pay_from_customer%TYPE,

703: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
704: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
706: p_pay_from_customer IN
707: ar_interim_cash_receipts.pay_from_customer%TYPE,
708: p_site_use_id IN
709: ar_interim_cash_receipts.site_use_id%TYPE,
710: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
711: p_payment_schedule_id IN

Line 709: ar_interim_cash_receipts.site_use_id%TYPE,

705: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
706: p_pay_from_customer IN
707: ar_interim_cash_receipts.pay_from_customer%TYPE,
708: p_site_use_id IN
709: ar_interim_cash_receipts.site_use_id%TYPE,
710: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
711: p_payment_schedule_id IN
712: ar_payment_schedules.payment_schedule_id%TYPE,
713: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

Line 710: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

706: p_pay_from_customer IN
707: ar_interim_cash_receipts.pay_from_customer%TYPE,
708: p_site_use_id IN
709: ar_interim_cash_receipts.site_use_id%TYPE,
710: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
711: p_payment_schedule_id IN
712: ar_payment_schedules.payment_schedule_id%TYPE,
713: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
714: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 713: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

709: ar_interim_cash_receipts.site_use_id%TYPE,
710: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
711: p_payment_schedule_id IN
712: ar_payment_schedules.payment_schedule_id%TYPE,
713: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
714: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
715: p_receipt_method_id IN
716: ar_interim_cash_receipts.receipt_method_id%TYPE,
717: p_remittance_bank_account_id IN

Line 714: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

710: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
711: p_payment_schedule_id IN
712: ar_payment_schedules.payment_schedule_id%TYPE,
713: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
714: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
715: p_receipt_method_id IN
716: ar_interim_cash_receipts.receipt_method_id%TYPE,
717: p_remittance_bank_account_id IN
718: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

Line 716: ar_interim_cash_receipts.receipt_method_id%TYPE,

712: ar_payment_schedules.payment_schedule_id%TYPE,
713: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
714: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
715: p_receipt_method_id IN
716: ar_interim_cash_receipts.receipt_method_id%TYPE,
717: p_remittance_bank_account_id IN
718: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
719: BEGIN
720: IF PG_DEBUG in ('Y', 'C') THEN

Line 718: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS

714: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
715: p_receipt_method_id IN
716: ar_interim_cash_receipts.receipt_method_id%TYPE,
717: p_remittance_bank_account_id IN
718: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE ) IS
719: BEGIN
720: IF PG_DEBUG in ('Y', 'C') THEN
721: arp_util.debug( 'arp_rw_icr_pkg.validate_args_insert_row()+' );
722: END IF;

Line 787: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

783: | in p_site_use_id validation. |
784: | |
785: +===========================================================================*/
786: PROCEDURE validate_special_type(
787: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
788: p_pay_from_customer IN
789: ar_interim_cash_receipts.pay_from_customer%TYPE,
790: p_site_use_id IN
791: ar_interim_cash_receipts.site_use_id%TYPE,

Line 789: ar_interim_cash_receipts.pay_from_customer%TYPE,

785: +===========================================================================*/
786: PROCEDURE validate_special_type(
787: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
788: p_pay_from_customer IN
789: ar_interim_cash_receipts.pay_from_customer%TYPE,
790: p_site_use_id IN
791: ar_interim_cash_receipts.site_use_id%TYPE,
792: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
793: p_payment_schedule_id IN

Line 791: ar_interim_cash_receipts.site_use_id%TYPE,

787: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
788: p_pay_from_customer IN
789: ar_interim_cash_receipts.pay_from_customer%TYPE,
790: p_site_use_id IN
791: ar_interim_cash_receipts.site_use_id%TYPE,
792: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
793: p_payment_schedule_id IN
794: ar_payment_schedules.payment_schedule_id%TYPE ) IS
795: BEGIN

Line 792: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

788: p_pay_from_customer IN
789: ar_interim_cash_receipts.pay_from_customer%TYPE,
790: p_site_use_id IN
791: ar_interim_cash_receipts.site_use_id%TYPE,
792: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
793: p_payment_schedule_id IN
794: ar_payment_schedules.payment_schedule_id%TYPE ) IS
795: BEGIN
796: --

Line 854: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

850: | applied from which will hold the amount in |
851: | receipt currency for cross currency apps. |
852: +===========================================================================*/
853: PROCEDURE get_applied_amount_total(
854: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
855: p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
856: p_applied_count_total OUT NOCOPY NUMBER,
857: p_module_name IN VARCHAR2,
858: p_module_version IN VARCHAR2 ) IS

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

851: | receipt currency for cross currency apps. |
852: +===========================================================================*/
853: PROCEDURE get_applied_amount_total(
854: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
855: p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
856: p_applied_count_total OUT NOCOPY NUMBER,
857: p_module_name IN VARCHAR2,
858: p_module_version IN VARCHAR2 ) IS
859: BEGIN

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

910: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
911: | |
912: +===========================================================================*/
913: PROCEDURE val_args_applied_amount_total(
914: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
915: BEGIN
916: IF PG_DEBUG in ('Y', 'C') THEN
917: arp_util.debug( 'arp_rw_icr_pkg.val_args_applied_amount_total()+' );
918: END IF;

Line 968: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

964: | |
965: +===========================================================================*/
966: PROCEDURE check_unique_receipt(
967: p_row_id IN VARCHAR2,
968: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
969: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
970: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
971: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
972: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 969: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

965: +===========================================================================*/
966: PROCEDURE check_unique_receipt(
967: p_row_id IN VARCHAR2,
968: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
969: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
970: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
971: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
972: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
973: p_factor_discount_amount

Line 970: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

966: PROCEDURE check_unique_receipt(
967: p_row_id IN VARCHAR2,
968: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
969: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
970: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
971: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
972: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
973: p_factor_discount_amount
974: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 972: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

968: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
969: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
970: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
971: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
972: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
973: p_factor_discount_amount
974: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
975: p_module_name IN VARCHAR2,
976: p_module_version IN VARCHAR2 ) IS

Line 974: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

970: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
971: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
972: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
973: p_factor_discount_amount
974: IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
975: p_module_name IN VARCHAR2,
976: p_module_version IN VARCHAR2 ) IS
977: l_count NUMBER := 0;
978: BEGIN

Line 1000: FROM ar_interim_cash_receipts icr

996: -- Check ICR table to see if the receipt exists
997: --
998: SELECT COUNT(*)
999: INTO l_count
1000: FROM ar_interim_cash_receipts icr
1001: WHERE ( p_row_id IS NULL
1002: OR icr.rowid <> p_row_id )
1003: AND ( p_cr_id IS NULL
1004: OR icr.cash_receipt_id <> p_cr_id )

Line 1071: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

1067: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 08/08/95 |
1068: | |
1069: +===========================================================================*/
1070: PROCEDURE val_args_check_unique_receipt(
1071: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
1072: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
1073: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1074: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1075: BEGIN

Line 1072: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

1068: | |
1069: +===========================================================================*/
1070: PROCEDURE val_args_check_unique_receipt(
1071: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
1072: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
1073: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1074: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1075: BEGIN
1076: IF PG_DEBUG in ('Y', 'C') THEN

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

1070: PROCEDURE val_args_check_unique_receipt(
1071: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
1072: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
1073: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1074: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE ) IS
1075: BEGIN
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug( 'arp_rw_icr_pkg.val_args_check_unique_receipt()+' );
1078: END IF;

Line 1133: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1129: | MODIFICATION HISTORY - 08/09/95 - Created by Ganesh Vaidee |
1130: | |
1131: +===========================================================================*/
1132: FUNCTION lines_exists(
1133: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1134: p_module_name IN VARCHAR2,
1135: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
1136: l_count NUMBER;
1137: BEGIN

Line 1203: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1199: | MODIFICATION HISTORY - 08/09/95 - Created by Ganesh Vaidee |
1200: | |
1201: +===========================================================================*/
1202: PROCEDURE check_no_lines_exists (
1203: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1204: p_module_name IN VARCHAR2,
1205: p_module_version IN VARCHAR2 ) IS
1206: BEGIN
1207: IF PG_DEBUG in ('Y', 'C') THEN

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

1279: | delete_row - Deletes a row from the QRC_ICR table |
1280: | |
1281: | |
1282: | DESCRIPTION |
1283: | This function deletes a row from AR_INTERIM_CASH_RECEIPTS. |
1284: | |
1285: | |
1286: | SCOPE - PUBLIC |
1287: | |

Line 1308: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1304: | 10-21-96 OSTEINME updated comments |
1305: +===========================================================================*/
1306: PROCEDURE delete_row(
1307: p_row_id IN VARCHAR2,
1308: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1309: p_module_name IN VARCHAR2,
1310: p_module_version IN VARCHAR2 ) IS
1311: BEGIN
1312: IF PG_DEBUG in ('Y', 'C') THEN

Line 1369: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,

1365: | 10-28-96 OSTEINME added new parameter customer_bank_branch_id |
1366: +===========================================================================*/
1367: PROCEDURE lock_row(
1368: p_row_id VARCHAR2,
1369: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1370: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1371: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1372: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

Line 1370: p_special_type ar_interim_cash_receipts.special_type%TYPE,

1366: +===========================================================================*/
1367: PROCEDURE lock_row(
1368: p_row_id VARCHAR2,
1369: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1370: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1371: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1372: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1374: p_factor_discount_amount IN

Line 1371: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,

1367: PROCEDURE lock_row(
1368: p_row_id VARCHAR2,
1369: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1370: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1371: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1372: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1374: p_factor_discount_amount IN
1375: ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 1372: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,

1368: p_row_id VARCHAR2,
1369: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1370: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1371: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1372: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1374: p_factor_discount_amount IN
1375: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1376: p_receipt_method_id

Line 1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

1369: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
1370: p_special_type ar_interim_cash_receipts.special_type%TYPE,
1371: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1372: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1374: p_factor_discount_amount IN
1375: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1376: p_receipt_method_id
1377: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 1375: ar_interim_cash_receipts.factor_discount_amount%TYPE,

1371: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
1372: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1374: p_factor_discount_amount IN
1375: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1376: p_receipt_method_id
1377: ar_interim_cash_receipts.receipt_method_id%TYPE,
1378: p_remittance_bank_account_id
1379: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 1377: ar_interim_cash_receipts.receipt_method_id%TYPE,

1373: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
1374: p_factor_discount_amount IN
1375: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1376: p_receipt_method_id
1377: ar_interim_cash_receipts.receipt_method_id%TYPE,
1378: p_remittance_bank_account_id
1379: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1380: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1381: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 1379: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

1375: ar_interim_cash_receipts.factor_discount_amount%TYPE,
1376: p_receipt_method_id
1377: ar_interim_cash_receipts.receipt_method_id%TYPE,
1378: p_remittance_bank_account_id
1379: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1380: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1381: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1382: p_payment_schedule_id
1383: ar_payment_schedules.payment_schedule_id%TYPE,

Line 1380: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,

1376: p_receipt_method_id
1377: ar_interim_cash_receipts.receipt_method_id%TYPE,
1378: p_remittance_bank_account_id
1379: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1380: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1381: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1382: p_payment_schedule_id
1383: ar_payment_schedules.payment_schedule_id%TYPE,
1384: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

Line 1381: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

1377: ar_interim_cash_receipts.receipt_method_id%TYPE,
1378: p_remittance_bank_account_id
1379: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
1380: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1381: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1382: p_payment_schedule_id
1383: ar_payment_schedules.payment_schedule_id%TYPE,
1384: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1385: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

Line 1384: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

1380: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
1381: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1382: p_payment_schedule_id
1383: ar_payment_schedules.payment_schedule_id%TYPE,
1384: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1385: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1386: p_exchange_rate_type
1387: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1388: p_gl_date IN

Line 1385: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

1381: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
1382: p_payment_schedule_id
1383: ar_payment_schedules.payment_schedule_id%TYPE,
1384: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1385: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1386: p_exchange_rate_type
1387: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1388: p_gl_date IN
1389: ar_interim_cash_receipts.gl_date%TYPE,

Line 1387: ar_interim_cash_receipts.exchange_rate_type%TYPE,

1383: ar_payment_schedules.payment_schedule_id%TYPE,
1384: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
1385: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1386: p_exchange_rate_type
1387: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1388: p_gl_date IN
1389: ar_interim_cash_receipts.gl_date%TYPE,
1390: p_anticipated_clearing_date IN
1391: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

Line 1389: ar_interim_cash_receipts.gl_date%TYPE,

1385: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
1386: p_exchange_rate_type
1387: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1388: p_gl_date IN
1389: ar_interim_cash_receipts.gl_date%TYPE,
1390: p_anticipated_clearing_date IN
1391: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1392: p_pay_from_customer
1393: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 1391: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

1387: ar_interim_cash_receipts.exchange_rate_type%TYPE,
1388: p_gl_date IN
1389: ar_interim_cash_receipts.gl_date%TYPE,
1390: p_anticipated_clearing_date IN
1391: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1392: p_pay_from_customer
1393: ar_interim_cash_receipts.pay_from_customer%TYPE,
1394: p_customer_bank_account_id IN
1395: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

Line 1393: ar_interim_cash_receipts.pay_from_customer%TYPE,

1389: ar_interim_cash_receipts.gl_date%TYPE,
1390: p_anticipated_clearing_date IN
1391: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1392: p_pay_from_customer
1393: ar_interim_cash_receipts.pay_from_customer%TYPE,
1394: p_customer_bank_account_id IN
1395: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1396: p_customer_bank_branch_id IN
1397: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 1395: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

1391: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
1392: p_pay_from_customer
1393: ar_interim_cash_receipts.pay_from_customer%TYPE,
1394: p_customer_bank_account_id IN
1395: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1396: p_customer_bank_branch_id IN
1397: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1398: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1399: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

Line 1397: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

1393: ar_interim_cash_receipts.pay_from_customer%TYPE,
1394: p_customer_bank_account_id IN
1395: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1396: p_customer_bank_branch_id IN
1397: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1398: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1399: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1400: p_ussgl_transaction_code
1401: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

Line 1398: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,

1394: p_customer_bank_account_id IN
1395: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1396: p_customer_bank_branch_id IN
1397: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1398: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1399: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1400: p_ussgl_transaction_code
1401: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1402: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 1399: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

1395: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
1396: p_customer_bank_branch_id IN
1397: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1398: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1399: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1400: p_ussgl_transaction_code
1401: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1402: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1403: p_doc_sequence_value

Line 1401: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

1397: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
1398: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1399: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1400: p_ussgl_transaction_code
1401: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1402: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1403: p_doc_sequence_value
1404: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1405: p_attribute_category

Line 1402: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

1398: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
1399: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
1400: p_ussgl_transaction_code
1401: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1402: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1403: p_doc_sequence_value
1404: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1405: p_attribute_category
1406: ar_interim_cash_receipts.attribute_category%TYPE,

Line 1404: ar_interim_cash_receipts.doc_sequence_value%TYPE,

1400: p_ussgl_transaction_code
1401: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
1402: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1403: p_doc_sequence_value
1404: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1405: p_attribute_category
1406: ar_interim_cash_receipts.attribute_category%TYPE,
1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

Line 1406: ar_interim_cash_receipts.attribute_category%TYPE,

1402: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
1403: p_doc_sequence_value
1404: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1405: p_attribute_category
1406: ar_interim_cash_receipts.attribute_category%TYPE,
1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

Line 1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,

1403: p_doc_sequence_value
1404: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1405: p_attribute_category
1406: ar_interim_cash_receipts.attribute_category%TYPE,
1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

Line 1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

1404: ar_interim_cash_receipts.doc_sequence_value%TYPE,
1405: p_attribute_category
1406: ar_interim_cash_receipts.attribute_category%TYPE,
1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

Line 1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,

1405: p_attribute_category
1406: ar_interim_cash_receipts.attribute_category%TYPE,
1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

Line 1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

1406: ar_interim_cash_receipts.attribute_category%TYPE,
1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

Line 1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

1407: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

Line 1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

1408: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

Line 1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

1409: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

Line 1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

1410: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

Line 1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

1411: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

Line 1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

1412: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1420: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

Line 1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

1413: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1420: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1421: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE

Line 1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

1414: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1420: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1421: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1422: ) IS

Line 1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

1415: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1420: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1421: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1422: ) IS
1423: CURSOR C IS

Line 1420: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

1416: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1420: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1421: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1422: ) IS
1423: CURSOR C IS
1424: SELECT *

Line 1421: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE

1417: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
1418: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
1419: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
1420: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
1421: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1422: ) IS
1423: CURSOR C IS
1424: SELECT *
1425: FROM ar_interim_cash_receipts

Line 1425: FROM ar_interim_cash_receipts

1421: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE
1422: ) IS
1423: CURSOR C IS
1424: SELECT *
1425: FROM ar_interim_cash_receipts
1426: WHERE rowid = p_row_id
1427: FOR UPDATE of CASH_RECEIPT_ID NOWAIT;
1428: Recinfo C%ROWTYPE;
1429: --