DBA Data[Home] [Help]

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 AUTHID CURRENT_USER AS
2: /* $Header: ARERICRS.pls 120.3.12010000.2 2009/02/02 16:47:22 mpsingh 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.12010000.2 2009/02/02 16:47:22 mpsingh 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_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,

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_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
74: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,

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_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
74: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
75: p_module_name IN VARCHAR2,

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_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
74: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
75: p_module_name IN VARCHAR2,
76: p_module_version IN VARCHAR2 );

Line 73: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%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_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
74: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
75: p_module_name IN VARCHAR2,
76: p_module_version IN VARCHAR2 );
77: --

Line 74: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%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_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
74: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
75: p_module_name IN VARCHAR2,
76: p_module_version IN VARCHAR2 );
77: --
78: --

Line 85: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

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

Line 86: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

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

Line 87: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

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

Line 88: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

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

Line 90: ar_interim_cash_receipts.amount_applied%TYPE,

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

Line 92: ar_interim_cash_receipts.trans_to_receipt_rate%TYPE,

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

Line 94: ar_interim_cash_receipts.factor_discount_amount%TYPE,

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

Line 96: ar_interim_cash_receipts.receipt_method_id%TYPE,

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

Line 98: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

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

Line 99: p_batch_id IN ar_interim_cash_receipts.batch_id%TYPE,

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

Line 100: p_customer_trx_id IN ar_interim_cash_receipts.customer_trx_id%TYPE,

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

Line 104: ar_interim_cash_receipts.pay_from_customer%TYPE,

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

Line 106: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

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

Line 108: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

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

Line 109: p_site_use_id IN ar_interim_cash_receipts.site_use_id%TYPE,

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

Line 111: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

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

Line 112: p_doc_sequence_id IN ar_interim_cash_receipts.doc_sequence_id%TYPE,

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

Line 114: ar_interim_cash_receipts.doc_sequence_value%TYPE,

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

Line 116: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

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

Line 118: ar_interim_cash_receipts.attribute_category%TYPE,

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

Line 119: p_attribute1 IN ar_interim_cash_receipts.attribute1%TYPE,

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

Line 120: p_attribute2 IN ar_interim_cash_receipts.attribute2%TYPE,

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

Line 121: p_attribute3 IN ar_interim_cash_receipts.attribute3%TYPE,

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

Line 122: p_attribute4 IN ar_interim_cash_receipts.attribute4%TYPE,

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

Line 123: p_attribute5 IN ar_interim_cash_receipts.attribute5%TYPE,

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

Line 124: p_attribute6 IN ar_interim_cash_receipts.attribute6%TYPE,

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

Line 125: p_attribute7 IN ar_interim_cash_receipts.attribute7%TYPE,

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

Line 126: p_attribute8 IN ar_interim_cash_receipts.attribute8%TYPE,

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

Line 127: p_attribute9 IN ar_interim_cash_receipts.attribute9%TYPE,

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

Line 128: p_attribute10 IN ar_interim_cash_receipts.attribute10%TYPE,

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

Line 129: p_attribute11 IN ar_interim_cash_receipts.attribute11%TYPE,

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

Line 130: p_attribute12 IN ar_interim_cash_receipts.attribute12%TYPE,

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

Line 131: p_attribute13 IN ar_interim_cash_receipts.attribute13%TYPE,

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

Line 132: p_attribute14 IN ar_interim_cash_receipts.attribute14%TYPE,

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

Line 133: p_attribute15 IN ar_interim_cash_receipts.attribute15%TYPE,

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

Line 135: p_exchange_date IN ar_interim_cash_receipts.exchange_date%TYPE,

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

Line 136: p_exchange_rate IN ar_interim_cash_receipts.exchange_rate%TYPE,

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

Line 138: ar_interim_cash_receipts.exchange_rate_type%TYPE,

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

Line 140: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

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

Line 142: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,

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

Line 144: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,

140: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
141: -- enh 2074220
142: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
143: -- Bug 2707190 additions
144: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
145: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
146: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
147: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
148: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,

Line 145: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,

141: -- enh 2074220
142: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
143: -- Bug 2707190 additions
144: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
145: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
146: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
147: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
148: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
149: p_module_name IN VARCHAR2,

Line 146: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,

142: p_application_notes IN ar_interim_cash_receipts.application_notes%TYPE,
143: -- Bug 2707190 additions
144: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
145: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
146: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
147: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
148: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
149: p_module_name IN VARCHAR2,
150: p_module_version IN VARCHAR2 );

Line 147: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,

143: -- Bug 2707190 additions
144: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
145: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
146: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
147: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
148: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
149: p_module_name IN VARCHAR2,
150: p_module_version IN VARCHAR2 );
151: PROCEDURE check_unique_receipt(

Line 148: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,

144: p_application_ref_type IN ar_interim_cash_receipts.application_ref_type%TYPE,
145: p_customer_reference IN ar_interim_cash_receipts.customer_reference%TYPE,
146: p_customer_reason IN ar_interim_cash_receipts.customer_reason%TYPE,
147: p_automatch_set_id IN ar_interim_cash_receipts.automatch_set_id%TYPE,
148: p_autoapply_flag IN ar_interim_cash_receipts.autoapply_flag%TYPE,
149: p_module_name IN VARCHAR2,
150: p_module_version IN VARCHAR2 );
151: PROCEDURE check_unique_receipt(
152: p_row_id IN VARCHAR2,

Line 153: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

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

Line 154: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,

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

Line 155: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,

151: PROCEDURE check_unique_receipt(
152: p_row_id IN VARCHAR2,
153: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
154: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
155: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
156: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
157: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
158: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
159: p_module_name IN VARCHAR2,

Line 157: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,

153: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
154: p_special_type IN ar_interim_cash_receipts.special_type%TYPE,
155: p_receipt_number IN ar_interim_cash_receipts.receipt_number%TYPE,
156: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
157: p_receipt_amount IN ar_interim_cash_receipts.amount%TYPE,
158: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,
159: p_module_name IN VARCHAR2,
160: p_module_version IN VARCHAR2 );
161: --

Line 158: p_factor_discount_amount IN ar_interim_cash_receipts.factor_discount_amount%TYPE,

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

Line 163: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

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

Line 168: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

164: p_module_name IN VARCHAR2,
165: p_module_version IN VARCHAR2 );
166: --
167: FUNCTION lines_exists(
168: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
169: p_module_name IN VARCHAR2,
170: p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
171: --
172: PROCEDURE delete_row(

Line 174: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,

170: p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
171: --
172: PROCEDURE delete_row(
173: p_row_id IN VARCHAR2,
174: p_cr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
175: p_module_name IN VARCHAR2,
176: p_module_version IN VARCHAR2 );
177: --
178: PROCEDURE lock_row(

Line 180: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,

176: p_module_version IN VARCHAR2 );
177: --
178: PROCEDURE lock_row(
179: p_row_id VARCHAR2,
180: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
181: p_special_type ar_interim_cash_receipts.special_type%TYPE,
182: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
183: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

Line 181: p_special_type ar_interim_cash_receipts.special_type%TYPE,

177: --
178: PROCEDURE lock_row(
179: p_row_id VARCHAR2,
180: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
181: p_special_type ar_interim_cash_receipts.special_type%TYPE,
182: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
183: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
185: p_factor_discount_amount IN

Line 182: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,

178: PROCEDURE lock_row(
179: p_row_id VARCHAR2,
180: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
181: p_special_type ar_interim_cash_receipts.special_type%TYPE,
182: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
183: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
185: p_factor_discount_amount IN
186: ar_interim_cash_receipts.factor_discount_amount%TYPE,

Line 183: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,

179: p_row_id VARCHAR2,
180: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
181: p_special_type ar_interim_cash_receipts.special_type%TYPE,
182: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
183: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
185: p_factor_discount_amount IN
186: ar_interim_cash_receipts.factor_discount_amount%TYPE,
187: p_receipt_method_id

Line 184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,

180: p_cr_id ar_interim_cash_receipts.cash_receipt_id%TYPE,
181: p_special_type ar_interim_cash_receipts.special_type%TYPE,
182: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
183: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
185: p_factor_discount_amount IN
186: ar_interim_cash_receipts.factor_discount_amount%TYPE,
187: p_receipt_method_id
188: ar_interim_cash_receipts.receipt_method_id%TYPE,

Line 186: ar_interim_cash_receipts.factor_discount_amount%TYPE,

182: p_receipt_number ar_interim_cash_receipts.receipt_number%TYPE,
183: p_currency_code ar_interim_cash_receipts.currency_code%TYPE,
184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
185: p_factor_discount_amount IN
186: ar_interim_cash_receipts.factor_discount_amount%TYPE,
187: p_receipt_method_id
188: ar_interim_cash_receipts.receipt_method_id%TYPE,
189: p_remittance_bank_account_id
190: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

Line 188: ar_interim_cash_receipts.receipt_method_id%TYPE,

184: p_receipt_amount ar_interim_cash_receipts.amount%TYPE,
185: p_factor_discount_amount IN
186: ar_interim_cash_receipts.factor_discount_amount%TYPE,
187: p_receipt_method_id
188: ar_interim_cash_receipts.receipt_method_id%TYPE,
189: p_remittance_bank_account_id
190: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
191: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
192: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

Line 190: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,

186: ar_interim_cash_receipts.factor_discount_amount%TYPE,
187: p_receipt_method_id
188: ar_interim_cash_receipts.receipt_method_id%TYPE,
189: p_remittance_bank_account_id
190: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
191: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
192: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
193: p_payment_schedule_id
194: ar_payment_schedules.payment_schedule_id%TYPE,

Line 191: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,

187: p_receipt_method_id
188: ar_interim_cash_receipts.receipt_method_id%TYPE,
189: p_remittance_bank_account_id
190: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
191: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
192: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
193: p_payment_schedule_id
194: ar_payment_schedules.payment_schedule_id%TYPE,
195: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

Line 192: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,

188: ar_interim_cash_receipts.receipt_method_id%TYPE,
189: p_remittance_bank_account_id
190: ar_interim_cash_receipts.remit_bank_acct_use_id%TYPE,
191: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
192: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
193: p_payment_schedule_id
194: ar_payment_schedules.payment_schedule_id%TYPE,
195: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
196: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

Line 195: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,

191: p_batch_id ar_interim_cash_receipts.batch_id%TYPE,
192: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
193: p_payment_schedule_id
194: ar_payment_schedules.payment_schedule_id%TYPE,
195: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
196: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
197: p_exchange_rate_type
198: ar_interim_cash_receipts.exchange_rate_type%TYPE,
199: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

Line 196: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,

192: p_customer_trx_id ar_interim_cash_receipts.customer_trx_id%TYPE,
193: p_payment_schedule_id
194: ar_payment_schedules.payment_schedule_id%TYPE,
195: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
196: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
197: p_exchange_rate_type
198: ar_interim_cash_receipts.exchange_rate_type%TYPE,
199: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
200: p_anticipated_clearing_date IN

Line 198: ar_interim_cash_receipts.exchange_rate_type%TYPE,

194: ar_payment_schedules.payment_schedule_id%TYPE,
195: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
196: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
197: p_exchange_rate_type
198: ar_interim_cash_receipts.exchange_rate_type%TYPE,
199: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
200: p_anticipated_clearing_date IN
201: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
202: p_pay_from_customer

Line 199: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,

195: p_exchange_date ar_interim_cash_receipts.exchange_date%TYPE,
196: p_exchange_rate ar_interim_cash_receipts.exchange_rate%TYPE,
197: p_exchange_rate_type
198: ar_interim_cash_receipts.exchange_rate_type%TYPE,
199: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
200: p_anticipated_clearing_date IN
201: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
202: p_pay_from_customer
203: ar_interim_cash_receipts.pay_from_customer%TYPE,

Line 201: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,

197: p_exchange_rate_type
198: ar_interim_cash_receipts.exchange_rate_type%TYPE,
199: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
200: p_anticipated_clearing_date IN
201: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
202: p_pay_from_customer
203: ar_interim_cash_receipts.pay_from_customer%TYPE,
204: p_customer_bank_account_id IN
205: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

Line 203: ar_interim_cash_receipts.pay_from_customer%TYPE,

199: p_gl_date IN ar_interim_cash_receipts.gl_date%TYPE,
200: p_anticipated_clearing_date IN
201: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
202: p_pay_from_customer
203: ar_interim_cash_receipts.pay_from_customer%TYPE,
204: p_customer_bank_account_id IN
205: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
206: p_customer_bank_branch_id IN
207: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

Line 205: ar_interim_cash_receipts.customer_bank_account_id%TYPE,

201: ar_interim_cash_receipts.anticipated_clearing_date%TYPE,
202: p_pay_from_customer
203: ar_interim_cash_receipts.pay_from_customer%TYPE,
204: p_customer_bank_account_id IN
205: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
206: p_customer_bank_branch_id IN
207: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
208: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
209: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

Line 207: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,

203: ar_interim_cash_receipts.pay_from_customer%TYPE,
204: p_customer_bank_account_id IN
205: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
206: p_customer_bank_branch_id IN
207: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
208: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
209: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
210: p_ussgl_transaction_code
211: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

Line 208: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,

204: p_customer_bank_account_id IN
205: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
206: p_customer_bank_branch_id IN
207: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
208: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
209: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
210: p_ussgl_transaction_code
211: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
212: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

Line 209: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,

205: ar_interim_cash_receipts.customer_bank_account_id%TYPE,
206: p_customer_bank_branch_id IN
207: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
208: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
209: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
210: p_ussgl_transaction_code
211: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
212: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
213: p_doc_sequence_value

Line 211: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,

207: ar_interim_cash_receipts.customer_bank_branch_id%TYPE,
208: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
209: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
210: p_ussgl_transaction_code
211: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
212: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
213: p_doc_sequence_value
214: ar_interim_cash_receipts.doc_sequence_value%TYPE,
215: p_attribute_category

Line 212: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,

208: p_receipt_date ar_interim_cash_receipts.receipt_date%TYPE,
209: p_site_use_id ar_interim_cash_receipts.site_use_id%TYPE,
210: p_ussgl_transaction_code
211: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
212: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
213: p_doc_sequence_value
214: ar_interim_cash_receipts.doc_sequence_value%TYPE,
215: p_attribute_category
216: ar_interim_cash_receipts.attribute_category%TYPE,

Line 214: ar_interim_cash_receipts.doc_sequence_value%TYPE,

210: p_ussgl_transaction_code
211: ar_interim_cash_receipts.ussgl_transaction_code%TYPE,
212: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
213: p_doc_sequence_value
214: ar_interim_cash_receipts.doc_sequence_value%TYPE,
215: p_attribute_category
216: ar_interim_cash_receipts.attribute_category%TYPE,
217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

Line 216: ar_interim_cash_receipts.attribute_category%TYPE,

212: p_doc_sequence_id ar_interim_cash_receipts.doc_sequence_id%TYPE,
213: p_doc_sequence_value
214: ar_interim_cash_receipts.doc_sequence_value%TYPE,
215: p_attribute_category
216: ar_interim_cash_receipts.attribute_category%TYPE,
217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

Line 217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,

213: p_doc_sequence_value
214: ar_interim_cash_receipts.doc_sequence_value%TYPE,
215: p_attribute_category
216: ar_interim_cash_receipts.attribute_category%TYPE,
217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

Line 218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,

214: ar_interim_cash_receipts.doc_sequence_value%TYPE,
215: p_attribute_category
216: ar_interim_cash_receipts.attribute_category%TYPE,
217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

Line 219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,

215: p_attribute_category
216: ar_interim_cash_receipts.attribute_category%TYPE,
217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

Line 220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,

216: ar_interim_cash_receipts.attribute_category%TYPE,
217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

Line 221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,

217: p_attribute1 ar_interim_cash_receipts.attribute1%TYPE,
218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

Line 222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,

218: p_attribute2 ar_interim_cash_receipts.attribute2%TYPE,
219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

Line 223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,

219: p_attribute3 ar_interim_cash_receipts.attribute3%TYPE,
220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

Line 224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,

220: p_attribute4 ar_interim_cash_receipts.attribute4%TYPE,
221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

Line 225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,

221: p_attribute5 ar_interim_cash_receipts.attribute5%TYPE,
222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

Line 226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,

222: p_attribute6 ar_interim_cash_receipts.attribute6%TYPE,
223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
230: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

Line 227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,

223: p_attribute7 ar_interim_cash_receipts.attribute7%TYPE,
224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
230: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
231: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);

Line 228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,

224: p_attribute8 ar_interim_cash_receipts.attribute8%TYPE,
225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
230: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
231: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
232: END ARP_RW_ICR_PKG;

Line 229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,

225: p_attribute9 ar_interim_cash_receipts.attribute9%TYPE,
226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
230: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
231: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
232: END ARP_RW_ICR_PKG;

Line 230: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,

226: p_attribute10 ar_interim_cash_receipts.attribute10%TYPE,
227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
230: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
231: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
232: END ARP_RW_ICR_PKG;

Line 231: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);

227: p_attribute11 ar_interim_cash_receipts.attribute11%TYPE,
228: p_attribute12 ar_interim_cash_receipts.attribute12%TYPE,
229: p_attribute13 ar_interim_cash_receipts.attribute13%TYPE,
230: p_attribute14 ar_interim_cash_receipts.attribute14%TYPE,
231: p_attribute15 ar_interim_cash_receipts.attribute15%TYPE);
232: END ARP_RW_ICR_PKG;