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 5: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

1: PACKAGE ARP_RW_ICR_PKG AS
2: /* $Header: ARERICRS.pls 120.3 2003/10/23 23:12:46 orashid ship $ */
3: --
4: PROCEDURE get_applied_amount_total(
5: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
6: p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
7: p_applied_count_total OUT NOCOPY NUMBER,
8: p_module_name IN VARCHAR2,
9: p_module_version IN VARCHAR2 );

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

2: /* $Header: ARERICRS.pls 120.3 2003/10/23 23:12:46 orashid ship $ */
3: --
4: PROCEDURE get_applied_amount_total(
5: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
6: p_applied_amount_total OUT NOCOPY ar_interim_cash_receipts.amount%TYPE,
7: p_applied_count_total OUT NOCOPY NUMBER,
8: p_module_name IN VARCHAR2,
9: p_module_version IN VARCHAR2 );
10: --

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

9: p_module_version IN VARCHAR2 );
10: --
11: PROCEDURE insert_row(
12: p_row_id IN OUT NOCOPY VARCHAR2,
13: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
15: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
16: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 14: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

10: --
11: PROCEDURE insert_row(
12: p_row_id IN OUT NOCOPY VARCHAR2,
13: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
15: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
16: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
18: p_amount_applied IN

Line 15: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

11: PROCEDURE insert_row(
12: p_row_id IN OUT NOCOPY VARCHAR2,
13: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
15: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
16: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
18: p_amount_applied IN
19: ar_interim_cash_receipts.amount_applied%TYPE,

Line 16: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,

12: p_row_id IN OUT NOCOPY VARCHAR2,
13: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
15: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
16: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
18: p_amount_applied IN
19: ar_interim_cash_receipts.amount_applied%TYPE,
20: p_trans_to_receipt_rate IN

Line 17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

13: p_cr_id IN OUT NOCOPY ar_interim_cash_receipts.cash_receipt_id%TYPE,
14: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
15: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
16: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
18: p_amount_applied IN
19: ar_interim_cash_receipts.amount_applied%TYPE,
20: p_trans_to_receipt_rate IN
21: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

Line 19: ar_interim_cash_receipts.amount_applied%TYPE,

15: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
16: p_currency_code IN ar_interim_cash_receipts.currency_code%TYPE,
17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
18: p_amount_applied IN
19: ar_interim_cash_receipts.amount_applied%TYPE,
20: p_trans_to_receipt_rate IN
21: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
22: p_factor_discount_amount IN
23: ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 21: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

17: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
18: p_amount_applied IN
19: ar_interim_cash_receipts.amount_applied%TYPE,
20: p_trans_to_receipt_rate IN
21: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
22: p_factor_discount_amount IN
23: ar_interim_cash_receipts.factor_discount_amount%TYPE,
24: p_receipt_method_id IN
25: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 23: ar_interim_cash_receipts.factor_discount_amount%TYPE,

19: ar_interim_cash_receipts.amount_applied%TYPE,
20: p_trans_to_receipt_rate IN
21: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
22: p_factor_discount_amount IN
23: ar_interim_cash_receipts.factor_discount_amount%TYPE,
24: p_receipt_method_id IN
25: ar_interim_cash_receipts.receipt_method_id%TYPE,
26: p_remittance_bank_account_id IN
27: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 25: ar_interim_cash_receipts.receipt_method_id%TYPE,

21: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
22: p_factor_discount_amount IN
23: ar_interim_cash_receipts.factor_discount_amount%TYPE,
24: p_receipt_method_id IN
25: ar_interim_cash_receipts.receipt_method_id%TYPE,
26: p_remittance_bank_account_id IN
27: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
28: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
29: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 27: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

23: ar_interim_cash_receipts.factor_discount_amount%TYPE,
24: p_receipt_method_id IN
25: ar_interim_cash_receipts.receipt_method_id%TYPE,
26: p_remittance_bank_account_id IN
27: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
28: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
29: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
30: p_payment_schedule_id IN
31: ar_payment_schedules.payment_schedule_id%TYPE,

Line 28: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

24: p_receipt_method_id IN
25: ar_interim_cash_receipts.receipt_method_id%TYPE,
26: p_remittance_bank_account_id IN
27: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
28: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
29: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
30: p_payment_schedule_id IN
31: ar_payment_schedules.payment_schedule_id%TYPE,
32: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

Line 29: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

25: ar_interim_cash_receipts.receipt_method_id%TYPE,
26: p_remittance_bank_account_id IN
27: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
28: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
29: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
30: p_payment_schedule_id IN
31: ar_payment_schedules.payment_schedule_id%TYPE,
32: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
33: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

Line 32: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

28: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
29: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
30: p_payment_schedule_id IN
31: ar_payment_schedules.payment_schedule_id%TYPE,
32: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
33: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
34: p_exchange_rate_type IN
35: ar_interim_cash_receipts.exchange_rate_type%TYPE,
36: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 33: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

29: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
30: p_payment_schedule_id IN
31: ar_payment_schedules.payment_schedule_id%TYPE,
32: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
33: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
34: p_exchange_rate_type IN
35: ar_interim_cash_receipts.exchange_rate_type%TYPE,
36: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
37: p_anticipated_clearing_date IN

Line 35: ar_interim_cash_receipts.exchange_rate_type%TYPE,

31: ar_payment_schedules.payment_schedule_id%TYPE,
32: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
33: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
34: p_exchange_rate_type IN
35: ar_interim_cash_receipts.exchange_rate_type%TYPE,
36: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
37: p_anticipated_clearing_date IN
38: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
39: p_pay_from_customer IN

Line 36: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

32: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
33: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
34: p_exchange_rate_type IN
35: ar_interim_cash_receipts.exchange_rate_type%TYPE,
36: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
37: p_anticipated_clearing_date IN
38: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
39: p_pay_from_customer IN
40: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 38: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

34: p_exchange_rate_type IN
35: ar_interim_cash_receipts.exchange_rate_type%TYPE,
36: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
37: p_anticipated_clearing_date IN
38: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
39: p_pay_from_customer IN
40: ar_interim_cash_receipts.pay_from_customer%TYPE,
41: p_customer_bank_account_id IN
42: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

Line 40: ar_interim_cash_receipts.pay_from_customer%TYPE,

36: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
37: p_anticipated_clearing_date IN
38: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
39: p_pay_from_customer IN
40: ar_interim_cash_receipts.pay_from_customer%TYPE,
41: p_customer_bank_account_id IN
42: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
43: p_customer_bank_branch_id IN
44: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 42: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

38: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
39: p_pay_from_customer IN
40: ar_interim_cash_receipts.pay_from_customer%TYPE,
41: p_customer_bank_account_id IN
42: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
43: p_customer_bank_branch_id IN
44: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
45: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
46: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

Line 44: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

40: ar_interim_cash_receipts.pay_from_customer%TYPE,
41: p_customer_bank_account_id IN
42: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
43: p_customer_bank_branch_id IN
44: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
45: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
46: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
47: p_ussgl_transaction_code IN
48: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

Line 45: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,

41: p_customer_bank_account_id IN
42: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
43: p_customer_bank_branch_id IN
44: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
45: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
46: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
47: p_ussgl_transaction_code IN
48: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
49: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 46: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

42: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
43: p_customer_bank_branch_id IN
44: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
45: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
46: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
47: p_ussgl_transaction_code IN
48: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
49: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
50: p_doc_sequence_value IN

Line 48: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

44: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
45: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
46: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
47: p_ussgl_transaction_code IN
48: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
49: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
50: p_doc_sequence_value IN
51: ar_interim_cash_receipts.doc_sequence_value%TYPE,
52: p_attribute_category IN

Line 49: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

45: p_receipt_date IN ar_interim_cash_receipts.receipt_date%TYPE,
46: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
47: p_ussgl_transaction_code IN
48: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
49: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
50: p_doc_sequence_value IN
51: ar_interim_cash_receipts.doc_sequence_value%TYPE,
52: p_attribute_category IN
53: ar_interim_cash_receipts.attribute_category%TYPE,

Line 51: ar_interim_cash_receipts.doc_sequence_value%TYPE,

47: p_ussgl_transaction_code IN
48: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
49: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
50: p_doc_sequence_value IN
51: ar_interim_cash_receipts.doc_sequence_value%TYPE,
52: p_attribute_category IN
53: ar_interim_cash_receipts.attribute_category%TYPE,
54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

Line 53: ar_interim_cash_receipts.attribute_category%TYPE,

49: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
50: p_doc_sequence_value IN
51: ar_interim_cash_receipts.doc_sequence_value%TYPE,
52: p_attribute_category IN
53: ar_interim_cash_receipts.attribute_category%TYPE,
54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

Line 54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,

50: p_doc_sequence_value IN
51: ar_interim_cash_receipts.doc_sequence_value%TYPE,
52: p_attribute_category IN
53: ar_interim_cash_receipts.attribute_category%TYPE,
54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

Line 55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

51: ar_interim_cash_receipts.doc_sequence_value%TYPE,
52: p_attribute_category IN
53: ar_interim_cash_receipts.attribute_category%TYPE,
54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

Line 56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,

52: p_attribute_category IN
53: ar_interim_cash_receipts.attribute_category%TYPE,
54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

Line 57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

53: ar_interim_cash_receipts.attribute_category%TYPE,
54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

Line 58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

54: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

Line 59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

55: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

Line 60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

56: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

Line 61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

57: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

Line 62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

58: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

Line 63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

59: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

Line 64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

60: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

Line 65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

61: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,

Line 66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

62: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,

Line 67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

63: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
71: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,

Line 68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

64: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
71: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
72: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

Line 69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,

65: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
71: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
72: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
73: p_module_name IN VARCHAR2,

Line 70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,

66: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
71: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
72: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
73: p_module_name IN VARCHAR2,
74: p_module_version IN VARCHAR2 );

Line 71: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,

67: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
71: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
72: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
73: p_module_name IN VARCHAR2,
74: p_module_version IN VARCHAR2 );
75: --

Line 72: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

68: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
69: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
70: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
71: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
72: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
73: p_module_name IN VARCHAR2,
74: p_module_version IN VARCHAR2 );
75: --
76: --

Line 83: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

79: -- Changes: passing parameters exchange date, exchange rate and
80: --
81: PROCEDURE update_row(
82: p_row_id IN VARCHAR2,
83: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
84: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
85: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
86: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
87: p_amount_applied IN

Line 84: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

80: --
81: PROCEDURE update_row(
82: p_row_id IN VARCHAR2,
83: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
84: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
85: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
86: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
87: p_amount_applied IN
88: ar_interim_cash_receipts.amount_applied%TYPE,

Line 85: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

81: PROCEDURE update_row(
82: p_row_id IN VARCHAR2,
83: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
84: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
85: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
86: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
87: p_amount_applied IN
88: ar_interim_cash_receipts.amount_applied%TYPE,
89: p_trans_to_receipt_rate IN

Line 86: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

82: p_row_id IN VARCHAR2,
83: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
84: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
85: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
86: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
87: p_amount_applied IN
88: ar_interim_cash_receipts.amount_applied%TYPE,
89: p_trans_to_receipt_rate IN
90: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

Line 88: ar_interim_cash_receipts.amount_applied%TYPE,

84: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
85: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
86: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
87: p_amount_applied IN
88: ar_interim_cash_receipts.amount_applied%TYPE,
89: p_trans_to_receipt_rate IN
90: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
91: p_factor_discount_amount IN
92: ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 90: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

86: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
87: p_amount_applied IN
88: ar_interim_cash_receipts.amount_applied%TYPE,
89: p_trans_to_receipt_rate IN
90: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
91: p_factor_discount_amount IN
92: ar_interim_cash_receipts.factor_discount_amount%TYPE,
93: p_receipt_method_id IN
94: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 92: ar_interim_cash_receipts.factor_discount_amount%TYPE,

88: ar_interim_cash_receipts.amount_applied%TYPE,
89: p_trans_to_receipt_rate IN
90: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
91: p_factor_discount_amount IN
92: ar_interim_cash_receipts.factor_discount_amount%TYPE,
93: p_receipt_method_id IN
94: ar_interim_cash_receipts.receipt_method_id%TYPE,
95: p_remittance_bank_account_id IN
96: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 94: ar_interim_cash_receipts.receipt_method_id%TYPE,

90: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,
91: p_factor_discount_amount IN
92: ar_interim_cash_receipts.factor_discount_amount%TYPE,
93: p_receipt_method_id IN
94: ar_interim_cash_receipts.receipt_method_id%TYPE,
95: p_remittance_bank_account_id IN
96: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
97: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
98: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 96: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

92: ar_interim_cash_receipts.factor_discount_amount%TYPE,
93: p_receipt_method_id IN
94: ar_interim_cash_receipts.receipt_method_id%TYPE,
95: p_remittance_bank_account_id IN
96: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
97: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
98: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
99: p_payment_schedule_id IN
100: ar_payment_schedules.payment_schedule_id%TYPE,

Line 97: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

93: p_receipt_method_id IN
94: ar_interim_cash_receipts.receipt_method_id%TYPE,
95: p_remittance_bank_account_id IN
96: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
97: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
98: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
99: p_payment_schedule_id IN
100: ar_payment_schedules.payment_schedule_id%TYPE,
101: p_pay_from_customer IN

Line 98: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

94: ar_interim_cash_receipts.receipt_method_id%TYPE,
95: p_remittance_bank_account_id IN
96: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
97: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,
98: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
99: p_payment_schedule_id IN
100: ar_payment_schedules.payment_schedule_id%TYPE,
101: p_pay_from_customer IN
102: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 102: ar_interim_cash_receipts.pay_from_customer%TYPE,

98: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,
99: p_payment_schedule_id IN
100: ar_payment_schedules.payment_schedule_id%TYPE,
101: p_pay_from_customer IN
102: ar_interim_cash_receipts.pay_from_customer%TYPE,
103: p_customer_bank_account_id IN
104: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
105: p_customer_bank_branch_id IN
106: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 104: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

100: ar_payment_schedules.payment_schedule_id%TYPE,
101: p_pay_from_customer IN
102: ar_interim_cash_receipts.pay_from_customer%TYPE,
103: p_customer_bank_account_id IN
104: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
105: p_customer_bank_branch_id IN
106: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
107: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
108: p_ussgl_transaction_code IN

Line 106: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

102: ar_interim_cash_receipts.pay_from_customer%TYPE,
103: p_customer_bank_account_id IN
104: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
105: p_customer_bank_branch_id IN
106: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
107: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
108: p_ussgl_transaction_code IN
109: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
110: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 107: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

103: p_customer_bank_account_id IN
104: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
105: p_customer_bank_branch_id IN
106: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
107: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
108: p_ussgl_transaction_code IN
109: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
110: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
111: p_doc_sequence_value IN

Line 109: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

105: p_customer_bank_branch_id IN
106: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
107: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
108: p_ussgl_transaction_code IN
109: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
110: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
111: p_doc_sequence_value IN
112: ar_interim_cash_receipts.doc_sequence_value%TYPE,
113: p_anticipated_clearing_date IN

Line 110: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

106: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
107: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,
108: p_ussgl_transaction_code IN
109: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
110: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
111: p_doc_sequence_value IN
112: ar_interim_cash_receipts.doc_sequence_value%TYPE,
113: p_anticipated_clearing_date IN
114: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

Line 112: ar_interim_cash_receipts.doc_sequence_value%TYPE,

108: p_ussgl_transaction_code IN
109: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
110: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
111: p_doc_sequence_value IN
112: ar_interim_cash_receipts.doc_sequence_value%TYPE,
113: p_anticipated_clearing_date IN
114: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
115: p_attribute_category IN
116: ar_interim_cash_receipts.attribute_category%TYPE,

Line 114: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

110: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,
111: p_doc_sequence_value IN
112: ar_interim_cash_receipts.doc_sequence_value%TYPE,
113: p_anticipated_clearing_date IN
114: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
115: p_attribute_category IN
116: ar_interim_cash_receipts.attribute_category%TYPE,
117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

Line 116: ar_interim_cash_receipts.attribute_category%TYPE,

112: ar_interim_cash_receipts.doc_sequence_value%TYPE,
113: p_anticipated_clearing_date IN
114: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
115: p_attribute_category IN
116: ar_interim_cash_receipts.attribute_category%TYPE,
117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

Line 117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,

113: p_anticipated_clearing_date IN
114: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
115: p_attribute_category IN
116: ar_interim_cash_receipts.attribute_category%TYPE,
117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

Line 118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

114: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
115: p_attribute_category IN
116: ar_interim_cash_receipts.attribute_category%TYPE,
117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

Line 119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,

115: p_attribute_category IN
116: ar_interim_cash_receipts.attribute_category%TYPE,
117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

Line 120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

116: ar_interim_cash_receipts.attribute_category%TYPE,
117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

Line 121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

117: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,
118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

Line 122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

118: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,
119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

Line 123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

119: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,
120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

Line 124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

120: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,
121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

Line 125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

121: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,
122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

Line 126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

122: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,
123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

Line 127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

123: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,
124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

Line 128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

124: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,
125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
132: -- Bug fix: 597519 12/17/97

Line 129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

125: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,
126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
132: -- Bug fix: 597519 12/17/97
133: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

Line 130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

126: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,
127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
132: -- Bug fix: 597519 12/17/97
133: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
134: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

Line 131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

127: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,
128: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,
129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
132: -- Bug fix: 597519 12/17/97
133: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
134: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
135: p_exchange_rate_type IN

Line 133: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

129: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,
130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
132: -- Bug fix: 597519 12/17/97
133: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
134: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
135: p_exchange_rate_type IN
136: ar_interim_cash_receipts.exchange_rate_type%TYPE,
137: -- Bug fix 750400 12/24/98

Line 134: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

130: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,
131: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,
132: -- Bug fix: 597519 12/17/97
133: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
134: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
135: p_exchange_rate_type IN
136: ar_interim_cash_receipts.exchange_rate_type%TYPE,
137: -- Bug fix 750400 12/24/98
138: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 136: ar_interim_cash_receipts.exchange_rate_type%TYPE,

132: -- Bug fix: 597519 12/17/97
133: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,
134: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
135: p_exchange_rate_type IN
136: ar_interim_cash_receipts.exchange_rate_type%TYPE,
137: -- Bug fix 750400 12/24/98
138: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
139: -- enh 2074220
140: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,

Line 138: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

134: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,
135: p_exchange_rate_type IN
136: ar_interim_cash_receipts.exchange_rate_type%TYPE,
137: -- Bug fix 750400 12/24/98
138: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
139: -- enh 2074220
140: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
141: -- Bug 2707190 additions
142: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,

Line 140: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,

136: ar_interim_cash_receipts.exchange_rate_type%TYPE,
137: -- Bug fix 750400 12/24/98
138: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
139: -- enh 2074220
140: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
141: -- Bug 2707190 additions
142: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
143: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
144: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

Line 142: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,

138: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
139: -- enh 2074220
140: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
141: -- Bug 2707190 additions
142: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
143: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
144: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
145: p_module_name IN VARCHAR2,
146: p_module_version IN VARCHAR2 );

Line 143: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,

139: -- enh 2074220
140: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
141: -- Bug 2707190 additions
142: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
143: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
144: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
145: p_module_name IN VARCHAR2,
146: p_module_version IN VARCHAR2 );
147: PROCEDURE check_unique_receipt(

Line 144: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

140: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
141: -- Bug 2707190 additions
142: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
143: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
144: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
145: p_module_name IN VARCHAR2,
146: p_module_version IN VARCHAR2 );
147: PROCEDURE check_unique_receipt(
148: p_row_id IN VARCHAR2,

Line 149: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

145: p_module_name IN VARCHAR2,
146: p_module_version IN VARCHAR2 );
147: PROCEDURE check_unique_receipt(
148: p_row_id IN VARCHAR2,
149: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
150: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
151: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
152: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
153: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

Line 150: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

146: p_module_version IN VARCHAR2 );
147: PROCEDURE check_unique_receipt(
148: p_row_id IN VARCHAR2,
149: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
150: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
151: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
152: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
153: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
154: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 151: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

147: PROCEDURE check_unique_receipt(
148: p_row_id IN VARCHAR2,
149: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
150: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
151: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
152: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
153: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
154: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
155: p_module_name IN VARCHAR2,

Line 153: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

149: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
150: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
151: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
152: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
153: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
154: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
155: p_module_name IN VARCHAR2,
156: p_module_version IN VARCHAR2 );
157: --

Line 154: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

150: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
151: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
152: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
153: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
154: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
155: p_module_name IN VARCHAR2,
156: p_module_version IN VARCHAR2 );
157: --
158: PROCEDURE check_no_lines_exists(

Line 159: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

155: p_module_name IN VARCHAR2,
156: p_module_version IN VARCHAR2 );
157: --
158: PROCEDURE check_no_lines_exists(
159: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
160: p_module_name IN VARCHAR2,
161: p_module_version IN VARCHAR2 );
162: --
163: FUNCTION lines_exists(

Line 164: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

160: p_module_name IN VARCHAR2,
161: p_module_version IN VARCHAR2 );
162: --
163: FUNCTION lines_exists(
164: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
165: p_module_name IN VARCHAR2,
166: p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
167: --
168: PROCEDURE delete_row(

Line 170: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

166: p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
167: --
168: PROCEDURE delete_row(
169: p_row_id IN VARCHAR2,
170: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
171: p_module_name IN VARCHAR2,
172: p_module_version IN VARCHAR2 );
173: --
174: PROCEDURE lock_row(

Line 176: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,

172: p_module_version IN VARCHAR2 );
173: --
174: PROCEDURE lock_row(
175: p_row_id VARCHAR2,
176: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
177: p_special_type ar_interim_cash_receipts.special_type%TYPE,
178: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
179: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

Line 177: p_special_type ar_interim_cash_receipts.special_type%TYPE,

173: --
174: PROCEDURE lock_row(
175: p_row_id VARCHAR2,
176: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
177: p_special_type ar_interim_cash_receipts.special_type%TYPE,
178: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
179: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
181: p_factor_discount_amount IN

Line 178: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,

174: PROCEDURE lock_row(
175: p_row_id VARCHAR2,
176: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
177: p_special_type ar_interim_cash_receipts.special_type%TYPE,
178: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
179: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
181: p_factor_discount_amount IN
182: ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 179: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,

175: p_row_id VARCHAR2,
176: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
177: p_special_type ar_interim_cash_receipts.special_type%TYPE,
178: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
179: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
181: p_factor_discount_amount IN
182: ar_interim_cash_receipts.factor_discount_amount%TYPE,
183: p_receipt_method_id

Line 180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

176: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
177: p_special_type ar_interim_cash_receipts.special_type%TYPE,
178: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
179: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
181: p_factor_discount_amount IN
182: ar_interim_cash_receipts.factor_discount_amount%TYPE,
183: p_receipt_method_id
184: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 182: ar_interim_cash_receipts.factor_discount_amount%TYPE,

178: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
179: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
181: p_factor_discount_amount IN
182: ar_interim_cash_receipts.factor_discount_amount%TYPE,
183: p_receipt_method_id
184: ar_interim_cash_receipts.receipt_method_id%TYPE,
185: p_remittance_bank_account_id
186: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 184: ar_interim_cash_receipts.receipt_method_id%TYPE,

180: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
181: p_factor_discount_amount IN
182: ar_interim_cash_receipts.factor_discount_amount%TYPE,
183: p_receipt_method_id
184: ar_interim_cash_receipts.receipt_method_id%TYPE,
185: p_remittance_bank_account_id
186: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
187: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
188: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 186: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

182: ar_interim_cash_receipts.factor_discount_amount%TYPE,
183: p_receipt_method_id
184: ar_interim_cash_receipts.receipt_method_id%TYPE,
185: p_remittance_bank_account_id
186: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
187: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
188: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
189: p_payment_schedule_id
190: ar_payment_schedules.payment_schedule_id%TYPE,

Line 187: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,

183: p_receipt_method_id
184: ar_interim_cash_receipts.receipt_method_id%TYPE,
185: p_remittance_bank_account_id
186: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
187: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
188: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
189: p_payment_schedule_id
190: ar_payment_schedules.payment_schedule_id%TYPE,
191: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

Line 188: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

184: ar_interim_cash_receipts.receipt_method_id%TYPE,
185: p_remittance_bank_account_id
186: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
187: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
188: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
189: p_payment_schedule_id
190: ar_payment_schedules.payment_schedule_id%TYPE,
191: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
192: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

Line 191: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

187: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
188: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
189: p_payment_schedule_id
190: ar_payment_schedules.payment_schedule_id%TYPE,
191: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
192: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
193: p_exchange_rate_type
194: ar_interim_cash_receipts.exchange_rate_type%TYPE,
195: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 192: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

188: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
189: p_payment_schedule_id
190: ar_payment_schedules.payment_schedule_id%TYPE,
191: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
192: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
193: p_exchange_rate_type
194: ar_interim_cash_receipts.exchange_rate_type%TYPE,
195: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
196: p_anticipated_clearing_date IN

Line 194: ar_interim_cash_receipts.exchange_rate_type%TYPE,

190: ar_payment_schedules.payment_schedule_id%TYPE,
191: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
192: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
193: p_exchange_rate_type
194: ar_interim_cash_receipts.exchange_rate_type%TYPE,
195: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
196: p_anticipated_clearing_date IN
197: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
198: p_pay_from_customer

Line 195: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

191: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
192: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
193: p_exchange_rate_type
194: ar_interim_cash_receipts.exchange_rate_type%TYPE,
195: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
196: p_anticipated_clearing_date IN
197: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
198: p_pay_from_customer
199: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 197: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

193: p_exchange_rate_type
194: ar_interim_cash_receipts.exchange_rate_type%TYPE,
195: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
196: p_anticipated_clearing_date IN
197: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
198: p_pay_from_customer
199: ar_interim_cash_receipts.pay_from_customer%TYPE,
200: p_customer_bank_account_id IN
201: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

Line 199: ar_interim_cash_receipts.pay_from_customer%TYPE,

195: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
196: p_anticipated_clearing_date IN
197: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
198: p_pay_from_customer
199: ar_interim_cash_receipts.pay_from_customer%TYPE,
200: p_customer_bank_account_id IN
201: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
202: p_customer_bank_branch_id IN
203: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 201: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

197: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
198: p_pay_from_customer
199: ar_interim_cash_receipts.pay_from_customer%TYPE,
200: p_customer_bank_account_id IN
201: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
202: p_customer_bank_branch_id IN
203: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
204: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
205: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

Line 203: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

199: ar_interim_cash_receipts.pay_from_customer%TYPE,
200: p_customer_bank_account_id IN
201: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
202: p_customer_bank_branch_id IN
203: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
204: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
205: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
206: p_ussgl_transaction_code
207: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

Line 204: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,

200: p_customer_bank_account_id IN
201: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
202: p_customer_bank_branch_id IN
203: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
204: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
205: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
206: p_ussgl_transaction_code
207: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
208: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 205: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

201: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
202: p_customer_bank_branch_id IN
203: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
204: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
205: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
206: p_ussgl_transaction_code
207: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
208: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
209: p_doc_sequence_value

Line 207: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

203: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
204: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
205: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
206: p_ussgl_transaction_code
207: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
208: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
209: p_doc_sequence_value
210: ar_interim_cash_receipts.doc_sequence_value%TYPE,
211: p_attribute_category

Line 208: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

204: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
205: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
206: p_ussgl_transaction_code
207: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
208: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
209: p_doc_sequence_value
210: ar_interim_cash_receipts.doc_sequence_value%TYPE,
211: p_attribute_category
212: ar_interim_cash_receipts.attribute_category%TYPE,

Line 210: ar_interim_cash_receipts.doc_sequence_value%TYPE,

206: p_ussgl_transaction_code
207: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
208: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
209: p_doc_sequence_value
210: ar_interim_cash_receipts.doc_sequence_value%TYPE,
211: p_attribute_category
212: ar_interim_cash_receipts.attribute_category%TYPE,
213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

Line 212: ar_interim_cash_receipts.attribute_category%TYPE,

208: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
209: p_doc_sequence_value
210: ar_interim_cash_receipts.doc_sequence_value%TYPE,
211: p_attribute_category
212: ar_interim_cash_receipts.attribute_category%TYPE,
213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

Line 213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,

209: p_doc_sequence_value
210: ar_interim_cash_receipts.doc_sequence_value%TYPE,
211: p_attribute_category
212: ar_interim_cash_receipts.attribute_category%TYPE,
213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

Line 214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

210: ar_interim_cash_receipts.doc_sequence_value%TYPE,
211: p_attribute_category
212: ar_interim_cash_receipts.attribute_category%TYPE,
213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

Line 215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,

211: p_attribute_category
212: ar_interim_cash_receipts.attribute_category%TYPE,
213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

Line 216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

212: ar_interim_cash_receipts.attribute_category%TYPE,
213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

Line 217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

213: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

Line 218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

214: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

Line 219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

215: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

Line 220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

216: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

Line 221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

217: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

Line 222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

218: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
226: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

Line 223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

219: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
226: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
227: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);

Line 224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

220: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
226: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
227: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
228: END ARP_RW_ICR_PKG;

Line 225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

221: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
226: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
227: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
228: END ARP_RW_ICR_PKG;

Line 226: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

222: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
226: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
227: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
228: END ARP_RW_ICR_PKG;

Line 227: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);

223: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
224: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
225: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
226: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
227: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
228: END ARP_RW_ICR_PKG;