3: --
4: PROCEDURE insert_row(
5: p_row_id IN OUT NOCOPY VARCHAR2,
6: p_icr_line_id IN OUT NOCOPY
7: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
8: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
9: p_payment_amount IN
10: ar_interim_cash_receipt_lines.payment_amount%TYPE,
11: p_amount_applied_from IN
4: PROCEDURE insert_row(
5: p_row_id IN OUT NOCOPY VARCHAR2,
6: p_icr_line_id IN OUT NOCOPY
7: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
8: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
9: p_payment_amount IN
10: ar_interim_cash_receipt_lines.payment_amount%TYPE,
11: p_amount_applied_from IN
12: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
6: p_icr_line_id IN OUT NOCOPY
7: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
8: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
9: p_payment_amount IN
10: ar_interim_cash_receipt_lines.payment_amount%TYPE,
11: p_amount_applied_from IN
12: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
13: p_trans_to_receipt_rate IN
14: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
8: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
9: p_payment_amount IN
10: ar_interim_cash_receipt_lines.payment_amount%TYPE,
11: p_amount_applied_from IN
12: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
13: p_trans_to_receipt_rate IN
14: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
15: p_payment_schedule_id IN
16: ar_payment_schedules.payment_schedule_id%TYPE,
10: ar_interim_cash_receipt_lines.payment_amount%TYPE,
11: p_amount_applied_from IN
12: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
13: p_trans_to_receipt_rate IN
14: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
15: p_payment_schedule_id IN
16: ar_payment_schedules.payment_schedule_id%TYPE,
17: p_customer_trx_id IN
18: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
14: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
15: p_payment_schedule_id IN
16: ar_payment_schedules.payment_schedule_id%TYPE,
17: p_customer_trx_id IN
18: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
19: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
20: p_sold_to_customer IN
21: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
22: p_discount_taken IN
15: p_payment_schedule_id IN
16: ar_payment_schedules.payment_schedule_id%TYPE,
17: p_customer_trx_id IN
18: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
19: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
20: p_sold_to_customer IN
21: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
22: p_discount_taken IN
23: ar_interim_cash_receipt_lines.discount_taken%TYPE,
17: p_customer_trx_id IN
18: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
19: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
20: p_sold_to_customer IN
21: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
22: p_discount_taken IN
23: ar_interim_cash_receipt_lines.discount_taken%TYPE,
24: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
25: p_ussgl_transaction_code IN
19: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
20: p_sold_to_customer IN
21: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
22: p_discount_taken IN
23: ar_interim_cash_receipt_lines.discount_taken%TYPE,
24: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
25: p_ussgl_transaction_code IN
26: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
27: p_attribute_category IN
20: p_sold_to_customer IN
21: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
22: p_discount_taken IN
23: ar_interim_cash_receipt_lines.discount_taken%TYPE,
24: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
25: p_ussgl_transaction_code IN
26: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
27: p_attribute_category IN
28: ar_interim_cash_receipt_lines.attribute_category%TYPE,
22: p_discount_taken IN
23: ar_interim_cash_receipt_lines.discount_taken%TYPE,
24: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
25: p_ussgl_transaction_code IN
26: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
27: p_attribute_category IN
28: ar_interim_cash_receipt_lines.attribute_category%TYPE,
29: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
24: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
25: p_ussgl_transaction_code IN
26: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
27: p_attribute_category IN
28: ar_interim_cash_receipt_lines.attribute_category%TYPE,
29: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
25: p_ussgl_transaction_code IN
26: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
27: p_attribute_category IN
28: ar_interim_cash_receipt_lines.attribute_category%TYPE,
29: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
26: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
27: p_attribute_category IN
28: ar_interim_cash_receipt_lines.attribute_category%TYPE,
29: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
27: p_attribute_category IN
28: ar_interim_cash_receipt_lines.attribute_category%TYPE,
29: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
28: ar_interim_cash_receipt_lines.attribute_category%TYPE,
29: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
29: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
30: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
31: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
32: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
33: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
34: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
35: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
43: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
36: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
43: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
44: p_global_attribute_category IN
37: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
43: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
44: p_global_attribute_category IN
45: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
38: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
43: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
44: p_global_attribute_category IN
45: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
46: p_global_attribute1 IN
39: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
40: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
43: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
44: p_global_attribute_category IN
45: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
46: p_global_attribute1 IN
47: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
41: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
42: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
43: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
44: p_global_attribute_category IN
45: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
46: p_global_attribute1 IN
47: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
48: p_global_attribute2 IN
49: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
43: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
44: p_global_attribute_category IN
45: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
46: p_global_attribute1 IN
47: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
48: p_global_attribute2 IN
49: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
50: p_global_attribute3 IN
51: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
45: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
46: p_global_attribute1 IN
47: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
48: p_global_attribute2 IN
49: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
50: p_global_attribute3 IN
51: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
52: p_global_attribute4 IN
53: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
47: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
48: p_global_attribute2 IN
49: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
50: p_global_attribute3 IN
51: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
52: p_global_attribute4 IN
53: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
54: p_global_attribute5 IN
55: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
49: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
50: p_global_attribute3 IN
51: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
52: p_global_attribute4 IN
53: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
54: p_global_attribute5 IN
55: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
56: p_global_attribute6 IN
57: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
51: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
52: p_global_attribute4 IN
53: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
54: p_global_attribute5 IN
55: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
56: p_global_attribute6 IN
57: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
58: p_global_attribute7 IN
59: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
53: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
54: p_global_attribute5 IN
55: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
56: p_global_attribute6 IN
57: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
58: p_global_attribute7 IN
59: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
60: p_global_attribute8 IN
61: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
55: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
56: p_global_attribute6 IN
57: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
58: p_global_attribute7 IN
59: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
60: p_global_attribute8 IN
61: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
62: p_global_attribute9 IN
63: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
57: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
58: p_global_attribute7 IN
59: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
60: p_global_attribute8 IN
61: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
62: p_global_attribute9 IN
63: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
64: p_global_attribute10 IN
65: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
59: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
60: p_global_attribute8 IN
61: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
62: p_global_attribute9 IN
63: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
64: p_global_attribute10 IN
65: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
66: p_global_attribute11 IN
67: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
61: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
62: p_global_attribute9 IN
63: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
64: p_global_attribute10 IN
65: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
66: p_global_attribute11 IN
67: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
68: p_global_attribute12 IN
69: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
63: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
64: p_global_attribute10 IN
65: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
66: p_global_attribute11 IN
67: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
68: p_global_attribute12 IN
69: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
70: p_global_attribute13 IN
71: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
65: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
66: p_global_attribute11 IN
67: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
68: p_global_attribute12 IN
69: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
70: p_global_attribute13 IN
71: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
72: p_global_attribute14 IN
73: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
67: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
68: p_global_attribute12 IN
69: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
70: p_global_attribute13 IN
71: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
72: p_global_attribute14 IN
73: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
74: p_global_attribute15 IN
75: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
69: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
70: p_global_attribute13 IN
71: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
72: p_global_attribute14 IN
73: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
74: p_global_attribute15 IN
75: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
76: p_global_attribute16 IN
77: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
71: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
72: p_global_attribute14 IN
73: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
74: p_global_attribute15 IN
75: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
76: p_global_attribute16 IN
77: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
78: p_global_attribute17 IN
79: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
73: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
74: p_global_attribute15 IN
75: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
76: p_global_attribute16 IN
77: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
78: p_global_attribute17 IN
79: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
80: p_global_attribute18 IN
81: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
75: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
76: p_global_attribute16 IN
77: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
78: p_global_attribute17 IN
79: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
80: p_global_attribute18 IN
81: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
82: p_global_attribute19 IN
83: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
77: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
78: p_global_attribute17 IN
79: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
80: p_global_attribute18 IN
81: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
82: p_global_attribute19 IN
83: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
84: p_global_attribute20 IN
85: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
79: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
80: p_global_attribute18 IN
81: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
82: p_global_attribute19 IN
83: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
84: p_global_attribute20 IN
85: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
86: p_application_ref_type IN
87: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
81: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
82: p_global_attribute19 IN
83: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
84: p_global_attribute20 IN
85: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
86: p_application_ref_type IN
87: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
88: p_customer_reference IN
89: ar_interim_cash_receipt_lines.customer_reference%TYPE,
83: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
84: p_global_attribute20 IN
85: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
86: p_application_ref_type IN
87: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
88: p_customer_reference IN
89: ar_interim_cash_receipt_lines.customer_reference%TYPE,
90: p_customer_reason IN
91: ar_interim_cash_receipt_lines.customer_reason%TYPE,
85: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
86: p_application_ref_type IN
87: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
88: p_customer_reference IN
89: ar_interim_cash_receipt_lines.customer_reference%TYPE,
90: p_customer_reason IN
91: ar_interim_cash_receipt_lines.customer_reason%TYPE,
92: p_applied_rec_app_id IN
93: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
87: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
88: p_customer_reference IN
89: ar_interim_cash_receipt_lines.customer_reference%TYPE,
90: p_customer_reason IN
91: ar_interim_cash_receipt_lines.customer_reason%TYPE,
92: p_applied_rec_app_id IN
93: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
94: p_module_name IN VARCHAR2,
95: p_module_version IN VARCHAR2 );
89: ar_interim_cash_receipt_lines.customer_reference%TYPE,
90: p_customer_reason IN
91: ar_interim_cash_receipt_lines.customer_reason%TYPE,
92: p_applied_rec_app_id IN
93: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
94: p_module_name IN VARCHAR2,
95: p_module_version IN VARCHAR2 );
96: --
97: PROCEDURE update_row(
96: --
97: PROCEDURE update_row(
98: p_row_id IN VARCHAR2,
99: p_icr_line_id IN
100: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
101: p_cr_id IN
102: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
103: p_payment_amount IN
104: ar_interim_cash_receipt_lines.payment_amount%TYPE,
98: p_row_id IN VARCHAR2,
99: p_icr_line_id IN
100: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
101: p_cr_id IN
102: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
103: p_payment_amount IN
104: ar_interim_cash_receipt_lines.payment_amount%TYPE,
105: p_amount_applied_from IN
106: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
100: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
101: p_cr_id IN
102: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
103: p_payment_amount IN
104: ar_interim_cash_receipt_lines.payment_amount%TYPE,
105: p_amount_applied_from IN
106: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
107: p_trans_to_receipt_rate IN
108: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
102: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
103: p_payment_amount IN
104: ar_interim_cash_receipt_lines.payment_amount%TYPE,
105: p_amount_applied_from IN
106: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
107: p_trans_to_receipt_rate IN
108: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
109: p_payment_schedule_id IN
110: ar_payment_schedules.payment_schedule_id%TYPE,
104: ar_interim_cash_receipt_lines.payment_amount%TYPE,
105: p_amount_applied_from IN
106: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
107: p_trans_to_receipt_rate IN
108: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
109: p_payment_schedule_id IN
110: ar_payment_schedules.payment_schedule_id%TYPE,
111: p_customer_trx_id IN
112: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
108: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
109: p_payment_schedule_id IN
110: ar_payment_schedules.payment_schedule_id%TYPE,
111: p_customer_trx_id IN
112: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
113: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
114: p_sold_to_customer IN
115: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
116: p_discount_taken IN
109: p_payment_schedule_id IN
110: ar_payment_schedules.payment_schedule_id%TYPE,
111: p_customer_trx_id IN
112: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
113: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
114: p_sold_to_customer IN
115: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
116: p_discount_taken IN
117: ar_interim_cash_receipt_lines.discount_taken%TYPE,
111: p_customer_trx_id IN
112: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
113: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
114: p_sold_to_customer IN
115: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
116: p_discount_taken IN
117: ar_interim_cash_receipt_lines.discount_taken%TYPE,
118: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
119: p_ussgl_transaction_code IN
113: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
114: p_sold_to_customer IN
115: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
116: p_discount_taken IN
117: ar_interim_cash_receipt_lines.discount_taken%TYPE,
118: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
119: p_ussgl_transaction_code IN
120: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
121: p_attribute_category IN
114: p_sold_to_customer IN
115: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
116: p_discount_taken IN
117: ar_interim_cash_receipt_lines.discount_taken%TYPE,
118: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
119: p_ussgl_transaction_code IN
120: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
121: p_attribute_category IN
122: ar_interim_cash_receipt_lines.attribute_category%TYPE,
116: p_discount_taken IN
117: ar_interim_cash_receipt_lines.discount_taken%TYPE,
118: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
119: p_ussgl_transaction_code IN
120: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
121: p_attribute_category IN
122: ar_interim_cash_receipt_lines.attribute_category%TYPE,
123: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
118: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
119: p_ussgl_transaction_code IN
120: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
121: p_attribute_category IN
122: ar_interim_cash_receipt_lines.attribute_category%TYPE,
123: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
119: p_ussgl_transaction_code IN
120: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
121: p_attribute_category IN
122: ar_interim_cash_receipt_lines.attribute_category%TYPE,
123: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
120: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
121: p_attribute_category IN
122: ar_interim_cash_receipt_lines.attribute_category%TYPE,
123: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
121: p_attribute_category IN
122: ar_interim_cash_receipt_lines.attribute_category%TYPE,
123: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
122: ar_interim_cash_receipt_lines.attribute_category%TYPE,
123: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
123: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
124: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
125: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
126: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
127: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
128: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
129: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
137: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
130: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
137: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
138: p_global_attribute_category IN
131: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
137: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
138: p_global_attribute_category IN
139: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
132: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
137: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
138: p_global_attribute_category IN
139: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
140: p_global_attribute1 IN
133: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
134: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
137: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
138: p_global_attribute_category IN
139: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
140: p_global_attribute1 IN
141: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
135: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
136: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
137: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
138: p_global_attribute_category IN
139: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
140: p_global_attribute1 IN
141: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
142: p_global_attribute2 IN
143: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
137: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
138: p_global_attribute_category IN
139: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
140: p_global_attribute1 IN
141: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
142: p_global_attribute2 IN
143: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
144: p_global_attribute3 IN
145: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
139: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
140: p_global_attribute1 IN
141: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
142: p_global_attribute2 IN
143: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
144: p_global_attribute3 IN
145: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
146: p_global_attribute4 IN
147: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
141: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
142: p_global_attribute2 IN
143: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
144: p_global_attribute3 IN
145: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
146: p_global_attribute4 IN
147: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
148: p_global_attribute5 IN
149: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
143: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
144: p_global_attribute3 IN
145: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
146: p_global_attribute4 IN
147: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
148: p_global_attribute5 IN
149: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
150: p_global_attribute6 IN
151: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
145: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
146: p_global_attribute4 IN
147: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
148: p_global_attribute5 IN
149: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
150: p_global_attribute6 IN
151: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
152: p_global_attribute7 IN
153: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
147: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
148: p_global_attribute5 IN
149: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
150: p_global_attribute6 IN
151: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
152: p_global_attribute7 IN
153: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
154: p_global_attribute8 IN
155: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
149: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
150: p_global_attribute6 IN
151: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
152: p_global_attribute7 IN
153: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
154: p_global_attribute8 IN
155: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
156: p_global_attribute9 IN
157: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
151: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
152: p_global_attribute7 IN
153: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
154: p_global_attribute8 IN
155: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
156: p_global_attribute9 IN
157: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
158: p_global_attribute10 IN
159: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
153: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
154: p_global_attribute8 IN
155: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
156: p_global_attribute9 IN
157: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
158: p_global_attribute10 IN
159: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
160: p_global_attribute11 IN
161: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
155: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
156: p_global_attribute9 IN
157: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
158: p_global_attribute10 IN
159: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
160: p_global_attribute11 IN
161: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
162: p_global_attribute12 IN
163: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
157: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
158: p_global_attribute10 IN
159: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
160: p_global_attribute11 IN
161: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
162: p_global_attribute12 IN
163: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
164: p_global_attribute13 IN
165: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
159: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
160: p_global_attribute11 IN
161: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
162: p_global_attribute12 IN
163: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
164: p_global_attribute13 IN
165: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
166: p_global_attribute14 IN
167: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
161: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
162: p_global_attribute12 IN
163: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
164: p_global_attribute13 IN
165: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
166: p_global_attribute14 IN
167: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
168: p_global_attribute15 IN
169: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
163: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
164: p_global_attribute13 IN
165: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
166: p_global_attribute14 IN
167: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
168: p_global_attribute15 IN
169: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
170: p_global_attribute16 IN
171: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
165: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
166: p_global_attribute14 IN
167: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
168: p_global_attribute15 IN
169: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
170: p_global_attribute16 IN
171: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
172: p_global_attribute17 IN
173: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
167: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
168: p_global_attribute15 IN
169: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
170: p_global_attribute16 IN
171: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
172: p_global_attribute17 IN
173: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
174: p_global_attribute18 IN
175: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
169: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
170: p_global_attribute16 IN
171: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
172: p_global_attribute17 IN
173: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
174: p_global_attribute18 IN
175: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
176: p_global_attribute19 IN
177: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
171: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
172: p_global_attribute17 IN
173: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
174: p_global_attribute18 IN
175: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
176: p_global_attribute19 IN
177: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
178: p_global_attribute20 IN
179: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
173: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
174: p_global_attribute18 IN
175: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
176: p_global_attribute19 IN
177: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
178: p_global_attribute20 IN
179: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
180: p_application_ref_type IN
181: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
175: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
176: p_global_attribute19 IN
177: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
178: p_global_attribute20 IN
179: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
180: p_application_ref_type IN
181: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
182: p_customer_reference IN
183: ar_interim_cash_receipt_lines.customer_reference%TYPE,
177: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
178: p_global_attribute20 IN
179: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
180: p_application_ref_type IN
181: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
182: p_customer_reference IN
183: ar_interim_cash_receipt_lines.customer_reference%TYPE,
184: p_customer_reason IN
185: ar_interim_cash_receipt_lines.customer_reason%TYPE,
179: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
180: p_application_ref_type IN
181: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
182: p_customer_reference IN
183: ar_interim_cash_receipt_lines.customer_reference%TYPE,
184: p_customer_reason IN
185: ar_interim_cash_receipt_lines.customer_reason%TYPE,
186: p_applied_rec_app_id IN
187: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
181: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
182: p_customer_reference IN
183: ar_interim_cash_receipt_lines.customer_reference%TYPE,
184: p_customer_reason IN
185: ar_interim_cash_receipt_lines.customer_reason%TYPE,
186: p_applied_rec_app_id IN
187: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
188: p_module_name IN VARCHAR2,
189: p_module_version IN VARCHAR2 );
183: ar_interim_cash_receipt_lines.customer_reference%TYPE,
184: p_customer_reason IN
185: ar_interim_cash_receipt_lines.customer_reason%TYPE,
186: p_applied_rec_app_id IN
187: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
188: p_module_name IN VARCHAR2,
189: p_module_version IN VARCHAR2 );
190: --
191: PROCEDURE delete_row(
191: PROCEDURE delete_row(
192: p_row_id IN VARCHAR2,
193: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
194: p_icr_line_id IN
195: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
196: p_module_name IN VARCHAR2,
197: p_module_version IN VARCHAR2 );
198: --
199: PROCEDURE lock_row(
198: --
199: PROCEDURE lock_row(
200: p_row_id VARCHAR2,
201: p_icr_id
202: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
203: p_icr_line_id
204: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
205: p_payment_amount
206: ar_interim_cash_receipt_lines.payment_amount%TYPE,
200: p_row_id VARCHAR2,
201: p_icr_id
202: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
203: p_icr_line_id
204: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
205: p_payment_amount
206: ar_interim_cash_receipt_lines.payment_amount%TYPE,
207: p_payment_schedule_id
208: ar_payment_schedules.payment_schedule_id%TYPE,
202: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
203: p_icr_line_id
204: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
205: p_payment_amount
206: ar_interim_cash_receipt_lines.payment_amount%TYPE,
207: p_payment_schedule_id
208: ar_payment_schedules.payment_schedule_id%TYPE,
209: p_customer_trx_id
210: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
206: ar_interim_cash_receipt_lines.payment_amount%TYPE,
207: p_payment_schedule_id
208: ar_payment_schedules.payment_schedule_id%TYPE,
209: p_customer_trx_id
210: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
211: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
212: p_sold_to_customer
213: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
214: p_discount_taken
207: p_payment_schedule_id
208: ar_payment_schedules.payment_schedule_id%TYPE,
209: p_customer_trx_id
210: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
211: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
212: p_sold_to_customer
213: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
214: p_discount_taken
215: ar_interim_cash_receipt_lines.discount_taken%TYPE,
209: p_customer_trx_id
210: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
211: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
212: p_sold_to_customer
213: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
214: p_discount_taken
215: ar_interim_cash_receipt_lines.discount_taken%TYPE,
216: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
217: p_ussgl_transaction_code
211: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
212: p_sold_to_customer
213: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
214: p_discount_taken
215: ar_interim_cash_receipt_lines.discount_taken%TYPE,
216: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
217: p_ussgl_transaction_code
218: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
219: p_attribute_category
212: p_sold_to_customer
213: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
214: p_discount_taken
215: ar_interim_cash_receipt_lines.discount_taken%TYPE,
216: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
217: p_ussgl_transaction_code
218: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
219: p_attribute_category
220: ar_interim_cash_receipt_lines.attribute_category%TYPE,
214: p_discount_taken
215: ar_interim_cash_receipt_lines.discount_taken%TYPE,
216: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
217: p_ussgl_transaction_code
218: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
219: p_attribute_category
220: ar_interim_cash_receipt_lines.attribute_category%TYPE,
221: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
216: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
217: p_ussgl_transaction_code
218: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
219: p_attribute_category
220: ar_interim_cash_receipt_lines.attribute_category%TYPE,
221: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
217: p_ussgl_transaction_code
218: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
219: p_attribute_category
220: ar_interim_cash_receipt_lines.attribute_category%TYPE,
221: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
218: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
219: p_attribute_category
220: ar_interim_cash_receipt_lines.attribute_category%TYPE,
221: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
219: p_attribute_category
220: ar_interim_cash_receipt_lines.attribute_category%TYPE,
221: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
220: ar_interim_cash_receipt_lines.attribute_category%TYPE,
221: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
221: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
222: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
223: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
224: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
225: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
226: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
227: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
235: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
228: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
235: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
236: p_global_attribute_category IN
229: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
235: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
236: p_global_attribute_category IN
237: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
230: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
235: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
236: p_global_attribute_category IN
237: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
238: p_global_attribute1 IN
231: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
232: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
235: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
236: p_global_attribute_category IN
237: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
238: p_global_attribute1 IN
239: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
233: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
234: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
235: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
236: p_global_attribute_category IN
237: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
238: p_global_attribute1 IN
239: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
240: p_global_attribute2 IN
241: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
235: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
236: p_global_attribute_category IN
237: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
238: p_global_attribute1 IN
239: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
240: p_global_attribute2 IN
241: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
242: p_global_attribute3 IN
243: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
237: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
238: p_global_attribute1 IN
239: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
240: p_global_attribute2 IN
241: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
242: p_global_attribute3 IN
243: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
244: p_global_attribute4 IN
245: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
239: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
240: p_global_attribute2 IN
241: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
242: p_global_attribute3 IN
243: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
244: p_global_attribute4 IN
245: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
246: p_global_attribute5 IN
247: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
241: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
242: p_global_attribute3 IN
243: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
244: p_global_attribute4 IN
245: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
246: p_global_attribute5 IN
247: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
248: p_global_attribute6 IN
249: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
243: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
244: p_global_attribute4 IN
245: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
246: p_global_attribute5 IN
247: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
248: p_global_attribute6 IN
249: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
250: p_global_attribute7 IN
251: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
245: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
246: p_global_attribute5 IN
247: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
248: p_global_attribute6 IN
249: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
250: p_global_attribute7 IN
251: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
252: p_global_attribute8 IN
253: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
247: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
248: p_global_attribute6 IN
249: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
250: p_global_attribute7 IN
251: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
252: p_global_attribute8 IN
253: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
254: p_global_attribute9 IN
255: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
249: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
250: p_global_attribute7 IN
251: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
252: p_global_attribute8 IN
253: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
254: p_global_attribute9 IN
255: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
256: p_global_attribute10 IN
257: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
251: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
252: p_global_attribute8 IN
253: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
254: p_global_attribute9 IN
255: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
256: p_global_attribute10 IN
257: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
258: p_global_attribute11 IN
259: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
253: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
254: p_global_attribute9 IN
255: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
256: p_global_attribute10 IN
257: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
258: p_global_attribute11 IN
259: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
260: p_global_attribute12 IN
261: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
255: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
256: p_global_attribute10 IN
257: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
258: p_global_attribute11 IN
259: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
260: p_global_attribute12 IN
261: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
262: p_global_attribute13 IN
263: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
257: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
258: p_global_attribute11 IN
259: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
260: p_global_attribute12 IN
261: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
262: p_global_attribute13 IN
263: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
264: p_global_attribute14 IN
265: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
259: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
260: p_global_attribute12 IN
261: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
262: p_global_attribute13 IN
263: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
264: p_global_attribute14 IN
265: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
266: p_global_attribute15 IN
267: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
261: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
262: p_global_attribute13 IN
263: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
264: p_global_attribute14 IN
265: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
266: p_global_attribute15 IN
267: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
268: p_global_attribute16 IN
269: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
263: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
264: p_global_attribute14 IN
265: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
266: p_global_attribute15 IN
267: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
268: p_global_attribute16 IN
269: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
270: p_global_attribute17 IN
271: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
265: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
266: p_global_attribute15 IN
267: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
268: p_global_attribute16 IN
269: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
270: p_global_attribute17 IN
271: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
272: p_global_attribute18 IN
273: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
267: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
268: p_global_attribute16 IN
269: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
270: p_global_attribute17 IN
271: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
272: p_global_attribute18 IN
273: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
274: p_global_attribute19 IN
275: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
269: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
270: p_global_attribute17 IN
271: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
272: p_global_attribute18 IN
273: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
274: p_global_attribute19 IN
275: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
276: p_global_attribute20 IN
277: ar_interim_cash_receipt_lines.global_attribute20%TYPE
271: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
272: p_global_attribute18 IN
273: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
274: p_global_attribute19 IN
275: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
276: p_global_attribute20 IN
277: ar_interim_cash_receipt_lines.global_attribute20%TYPE
278: );
279: --
273: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
274: p_global_attribute19 IN
275: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
276: p_global_attribute20 IN
277: ar_interim_cash_receipt_lines.global_attribute20%TYPE
278: );
279: --
280: END ARP_RW_ICR_LINES_PKG;