5:
6: PROCEDURE validate_args_insert_row(
7: p_row_id IN VARCHAR2,
8: p_icr_line_id IN
9: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
10: p_cash_receipt_id IN
11: ar_interim_cash_receipts.cash_receipt_id%TYPE,
12: p_payment_schedule_id IN
13: ar_payment_schedules.payment_schedule_id%TYPE,
11: ar_interim_cash_receipts.cash_receipt_id%TYPE,
12: p_payment_schedule_id IN
13: ar_payment_schedules.payment_schedule_id%TYPE,
14: p_customer_trx_id IN
15: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
16: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
17: p_sold_to_customer IN
18: ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
19: --
12: p_payment_schedule_id IN
13: ar_payment_schedules.payment_schedule_id%TYPE,
14: p_customer_trx_id IN
15: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
16: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
17: p_sold_to_customer IN
18: ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
19: --
20: PROCEDURE validate_args_update_row(
14: p_customer_trx_id IN
15: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
16: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
17: p_sold_to_customer IN
18: ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
19: --
20: PROCEDURE validate_args_update_row(
21: p_row_id IN VARCHAR2,
22: p_icr_line_id IN
19: --
20: PROCEDURE validate_args_update_row(
21: p_row_id IN VARCHAR2,
22: p_icr_line_id IN
23: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
24: p_payment_schedule_id IN
25: ar_payment_schedules.payment_schedule_id%TYPE,
26: p_customer_trx_id IN
27: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
23: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
24: p_payment_schedule_id IN
25: ar_payment_schedules.payment_schedule_id%TYPE,
26: p_customer_trx_id IN
27: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
28: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
29: p_sold_to_customer IN
30: ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
31: --
24: p_payment_schedule_id IN
25: ar_payment_schedules.payment_schedule_id%TYPE,
26: p_customer_trx_id IN
27: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
28: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
29: p_sold_to_customer IN
30: ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
31: --
32: PROCEDURE validate_args_delete_row(
26: p_customer_trx_id IN
27: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
28: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
29: p_sold_to_customer IN
30: ar_interim_cash_receipt_lines.sold_to_customer%TYPE );
31: --
32: PROCEDURE validate_args_delete_row(
33: p_row_id IN VARCHAR2,
34: p_icr_line_id IN
31: --
32: PROCEDURE validate_args_delete_row(
33: p_row_id IN VARCHAR2,
34: p_icr_line_id IN
35: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );
36: /*===========================================================================+
37: | PROCEDURE |
38: | update_row - Update a row in the AR_ICR table after checking for|
39: | uniqueness |
81: +===========================================================================*/
82: PROCEDURE update_row(
83: p_row_id IN VARCHAR2,
84: p_icr_line_id IN
85: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
86: p_cr_id IN
87: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
88: p_payment_amount IN
89: ar_interim_cash_receipt_lines.payment_amount%TYPE,
83: p_row_id IN VARCHAR2,
84: p_icr_line_id IN
85: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
86: p_cr_id IN
87: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
88: p_payment_amount IN
89: ar_interim_cash_receipt_lines.payment_amount%TYPE,
90: p_amount_applied_from IN
91: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
85: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
86: p_cr_id IN
87: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
88: p_payment_amount IN
89: ar_interim_cash_receipt_lines.payment_amount%TYPE,
90: p_amount_applied_from IN
91: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
92: p_trans_to_receipt_rate IN
93: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
87: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
88: p_payment_amount IN
89: ar_interim_cash_receipt_lines.payment_amount%TYPE,
90: p_amount_applied_from IN
91: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
92: p_trans_to_receipt_rate IN
93: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
94: p_payment_schedule_id IN
95: ar_payment_schedules.payment_schedule_id%TYPE,
89: ar_interim_cash_receipt_lines.payment_amount%TYPE,
90: p_amount_applied_from IN
91: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
92: p_trans_to_receipt_rate IN
93: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
94: p_payment_schedule_id IN
95: ar_payment_schedules.payment_schedule_id%TYPE,
96: p_customer_trx_id IN
97: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
93: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
94: p_payment_schedule_id IN
95: ar_payment_schedules.payment_schedule_id%TYPE,
96: p_customer_trx_id IN
97: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
98: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
99: p_sold_to_customer IN
100: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
101: p_discount_taken IN
94: p_payment_schedule_id IN
95: ar_payment_schedules.payment_schedule_id%TYPE,
96: p_customer_trx_id IN
97: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
98: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
99: p_sold_to_customer IN
100: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
101: p_discount_taken IN
102: ar_interim_cash_receipt_lines.discount_taken%TYPE,
96: p_customer_trx_id IN
97: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
98: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
99: p_sold_to_customer IN
100: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
101: p_discount_taken IN
102: ar_interim_cash_receipt_lines.discount_taken%TYPE,
103: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
104: p_ussgl_transaction_code IN
98: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
99: p_sold_to_customer IN
100: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
101: p_discount_taken IN
102: ar_interim_cash_receipt_lines.discount_taken%TYPE,
103: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
104: p_ussgl_transaction_code IN
105: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
106: p_attribute_category IN
99: p_sold_to_customer IN
100: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
101: p_discount_taken IN
102: ar_interim_cash_receipt_lines.discount_taken%TYPE,
103: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
104: p_ussgl_transaction_code IN
105: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
106: p_attribute_category IN
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,
101: p_discount_taken IN
102: ar_interim_cash_receipt_lines.discount_taken%TYPE,
103: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
104: p_ussgl_transaction_code IN
105: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
106: p_attribute_category IN
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,
108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
103: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
104: p_ussgl_transaction_code IN
105: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
106: p_attribute_category IN
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,
108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
104: p_ussgl_transaction_code IN
105: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
106: p_attribute_category IN
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,
108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
105: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
106: p_attribute_category IN
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,
108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
106: p_attribute_category IN
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,
108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,
108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
123: p_global_attribute_category IN
116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
123: p_global_attribute_category IN
124: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
123: p_global_attribute_category IN
124: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
125: p_global_attribute1 IN
118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
123: p_global_attribute_category IN
124: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
125: p_global_attribute1 IN
126: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
123: p_global_attribute_category IN
124: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
125: p_global_attribute1 IN
126: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
127: p_global_attribute2 IN
128: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
123: p_global_attribute_category IN
124: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
125: p_global_attribute1 IN
126: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
127: p_global_attribute2 IN
128: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
129: p_global_attribute3 IN
130: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
124: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
125: p_global_attribute1 IN
126: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
127: p_global_attribute2 IN
128: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
129: p_global_attribute3 IN
130: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
131: p_global_attribute4 IN
132: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
126: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
127: p_global_attribute2 IN
128: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
129: p_global_attribute3 IN
130: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
131: p_global_attribute4 IN
132: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
133: p_global_attribute5 IN
134: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
128: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
129: p_global_attribute3 IN
130: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
131: p_global_attribute4 IN
132: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
133: p_global_attribute5 IN
134: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
135: p_global_attribute6 IN
136: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
130: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
131: p_global_attribute4 IN
132: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
133: p_global_attribute5 IN
134: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
135: p_global_attribute6 IN
136: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
137: p_global_attribute7 IN
138: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
132: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
133: p_global_attribute5 IN
134: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
135: p_global_attribute6 IN
136: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
137: p_global_attribute7 IN
138: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
139: p_global_attribute8 IN
140: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
134: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
135: p_global_attribute6 IN
136: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
137: p_global_attribute7 IN
138: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
139: p_global_attribute8 IN
140: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
141: p_global_attribute9 IN
142: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
136: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
137: p_global_attribute7 IN
138: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
139: p_global_attribute8 IN
140: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
141: p_global_attribute9 IN
142: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
143: p_global_attribute10 IN
144: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
138: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
139: p_global_attribute8 IN
140: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
141: p_global_attribute9 IN
142: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
143: p_global_attribute10 IN
144: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
145: p_global_attribute11 IN
146: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
140: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
141: p_global_attribute9 IN
142: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
143: p_global_attribute10 IN
144: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
145: p_global_attribute11 IN
146: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
147: p_global_attribute12 IN
148: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
142: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
143: p_global_attribute10 IN
144: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
145: p_global_attribute11 IN
146: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
147: p_global_attribute12 IN
148: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
149: p_global_attribute13 IN
150: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
144: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
145: p_global_attribute11 IN
146: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
147: p_global_attribute12 IN
148: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
149: p_global_attribute13 IN
150: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
151: p_global_attribute14 IN
152: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
146: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
147: p_global_attribute12 IN
148: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
149: p_global_attribute13 IN
150: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
151: p_global_attribute14 IN
152: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
153: p_global_attribute15 IN
154: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
148: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
149: p_global_attribute13 IN
150: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
151: p_global_attribute14 IN
152: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
153: p_global_attribute15 IN
154: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
155: p_global_attribute16 IN
156: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
150: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
151: p_global_attribute14 IN
152: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
153: p_global_attribute15 IN
154: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
155: p_global_attribute16 IN
156: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
157: p_global_attribute17 IN
158: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
152: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
153: p_global_attribute15 IN
154: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
155: p_global_attribute16 IN
156: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
157: p_global_attribute17 IN
158: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
159: p_global_attribute18 IN
160: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
154: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
155: p_global_attribute16 IN
156: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
157: p_global_attribute17 IN
158: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
159: p_global_attribute18 IN
160: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
161: p_global_attribute19 IN
162: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
156: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
157: p_global_attribute17 IN
158: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
159: p_global_attribute18 IN
160: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
161: p_global_attribute19 IN
162: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
163: p_global_attribute20 IN
164: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
158: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
159: p_global_attribute18 IN
160: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
161: p_global_attribute19 IN
162: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
163: p_global_attribute20 IN
164: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
165: p_application_ref_type IN
166: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
160: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
161: p_global_attribute19 IN
162: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
163: p_global_attribute20 IN
164: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
165: p_application_ref_type IN
166: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
167: p_customer_reference IN
168: ar_interim_cash_receipt_lines.customer_reference%TYPE,
162: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
163: p_global_attribute20 IN
164: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
165: p_application_ref_type IN
166: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
167: p_customer_reference IN
168: ar_interim_cash_receipt_lines.customer_reference%TYPE,
169: p_customer_reason IN
170: ar_interim_cash_receipt_lines.customer_reason%TYPE,
164: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
165: p_application_ref_type IN
166: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
167: p_customer_reference IN
168: ar_interim_cash_receipt_lines.customer_reference%TYPE,
169: p_customer_reason IN
170: ar_interim_cash_receipt_lines.customer_reason%TYPE,
171: p_applied_rec_app_id IN
172: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
166: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
167: p_customer_reference IN
168: ar_interim_cash_receipt_lines.customer_reference%TYPE,
169: p_customer_reason IN
170: ar_interim_cash_receipt_lines.customer_reason%TYPE,
171: p_applied_rec_app_id IN
172: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
173: p_module_name IN VARCHAR2,
174: p_module_version IN VARCHAR2 ) IS
168: ar_interim_cash_receipt_lines.customer_reference%TYPE,
169: p_customer_reason IN
170: ar_interim_cash_receipt_lines.customer_reason%TYPE,
171: p_applied_rec_app_id IN
172: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
173: p_module_name IN VARCHAR2,
174: p_module_version IN VARCHAR2 ) IS
175: --
176: l_icr_lines_rec ar_interim_cash_receipt_lines%ROWTYPE;
172: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
173: p_module_name IN VARCHAR2,
174: p_module_version IN VARCHAR2 ) IS
175: --
176: l_icr_lines_rec ar_interim_cash_receipt_lines%ROWTYPE;
177: BEGIN
178: IF PG_DEBUG in ('Y', 'C') THEN
179: arp_util.debug('arp_rw_icr_line_pkg.update_row()+' );
180: arp_util.debug('Row Id : '||p_row_id );
310: +===========================================================================*/
311: PROCEDURE validate_args_update_row(
312: p_row_id IN VARCHAR2,
313: p_icr_line_id IN
314: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
315: p_payment_schedule_id IN
316: ar_payment_schedules.payment_schedule_id%TYPE,
317: p_customer_trx_id IN
318: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
314: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
315: p_payment_schedule_id IN
316: ar_payment_schedules.payment_schedule_id%TYPE,
317: p_customer_trx_id IN
318: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
319: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
320: p_sold_to_customer IN
321: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
322: BEGIN
315: p_payment_schedule_id IN
316: ar_payment_schedules.payment_schedule_id%TYPE,
317: p_customer_trx_id IN
318: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
319: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
320: p_sold_to_customer IN
321: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
322: BEGIN
323: IF PG_DEBUG in ('Y', 'C') THEN
317: p_customer_trx_id IN
318: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
319: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
320: p_sold_to_customer IN
321: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
322: BEGIN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_util.debug('arp_rw_icr_line_pkg.validate_args_update_row()+' );
325: END IF;
382: +===========================================================================*/
383: PROCEDURE insert_row(
384: p_row_id IN OUT NOCOPY VARCHAR2,
385: p_icr_line_id IN OUT NOCOPY
386: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
387: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
388: p_payment_amount IN
389: ar_interim_cash_receipt_lines.payment_amount%TYPE,
390: p_amount_applied_from IN
383: PROCEDURE insert_row(
384: p_row_id IN OUT NOCOPY VARCHAR2,
385: p_icr_line_id IN OUT NOCOPY
386: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
387: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
388: p_payment_amount IN
389: ar_interim_cash_receipt_lines.payment_amount%TYPE,
390: p_amount_applied_from IN
391: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
385: p_icr_line_id IN OUT NOCOPY
386: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
387: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
388: p_payment_amount IN
389: ar_interim_cash_receipt_lines.payment_amount%TYPE,
390: p_amount_applied_from IN
391: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
392: p_trans_to_receipt_rate IN
393: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
387: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
388: p_payment_amount IN
389: ar_interim_cash_receipt_lines.payment_amount%TYPE,
390: p_amount_applied_from IN
391: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
392: p_trans_to_receipt_rate IN
393: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
394: p_payment_schedule_id IN
395: ar_payment_schedules.payment_schedule_id%TYPE,
389: ar_interim_cash_receipt_lines.payment_amount%TYPE,
390: p_amount_applied_from IN
391: ar_interim_cash_receipt_lines.amount_applied_from%TYPE,
392: p_trans_to_receipt_rate IN
393: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
394: p_payment_schedule_id IN
395: ar_payment_schedules.payment_schedule_id%TYPE,
396: p_customer_trx_id IN
397: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
393: ar_interim_cash_receipt_lines.trans_to_receipt_rate%TYPE,
394: p_payment_schedule_id IN
395: ar_payment_schedules.payment_schedule_id%TYPE,
396: p_customer_trx_id IN
397: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
398: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
399: p_sold_to_customer IN
400: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
401: p_discount_taken IN
394: p_payment_schedule_id IN
395: ar_payment_schedules.payment_schedule_id%TYPE,
396: p_customer_trx_id IN
397: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
398: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
399: p_sold_to_customer IN
400: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
401: p_discount_taken IN
402: ar_interim_cash_receipt_lines.discount_taken%TYPE,
396: p_customer_trx_id IN
397: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
398: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
399: p_sold_to_customer IN
400: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
401: p_discount_taken IN
402: ar_interim_cash_receipt_lines.discount_taken%TYPE,
403: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
404: p_ussgl_transaction_code IN
398: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
399: p_sold_to_customer IN
400: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
401: p_discount_taken IN
402: ar_interim_cash_receipt_lines.discount_taken%TYPE,
403: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
404: p_ussgl_transaction_code IN
405: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
406: p_attribute_category IN
399: p_sold_to_customer IN
400: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
401: p_discount_taken IN
402: ar_interim_cash_receipt_lines.discount_taken%TYPE,
403: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
404: p_ussgl_transaction_code IN
405: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
406: p_attribute_category IN
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,
401: p_discount_taken IN
402: ar_interim_cash_receipt_lines.discount_taken%TYPE,
403: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
404: p_ussgl_transaction_code IN
405: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
406: p_attribute_category IN
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,
408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
403: p_due_date IN ar_interim_cash_receipt_lines.due_date%TYPE,
404: p_ussgl_transaction_code IN
405: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
406: p_attribute_category IN
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,
408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
404: p_ussgl_transaction_code IN
405: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
406: p_attribute_category IN
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,
408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
405: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
406: p_attribute_category IN
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,
408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
406: p_attribute_category IN
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,
408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,
408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%TYPE,
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
423: p_global_attribute_category IN
416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
423: p_global_attribute_category IN
424: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%TYPE,
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
423: p_global_attribute_category IN
424: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
425: p_global_attribute1 IN
418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%TYPE,
419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
423: p_global_attribute_category IN
424: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
425: p_global_attribute1 IN
426: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%TYPE,
421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%TYPE,
422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
423: p_global_attribute_category IN
424: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
425: p_global_attribute1 IN
426: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
427: p_global_attribute2 IN
428: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%TYPE,
423: p_global_attribute_category IN
424: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
425: p_global_attribute1 IN
426: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
427: p_global_attribute2 IN
428: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
429: p_global_attribute3 IN
430: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
424: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
425: p_global_attribute1 IN
426: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
427: p_global_attribute2 IN
428: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
429: p_global_attribute3 IN
430: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
431: p_global_attribute4 IN
432: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
426: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
427: p_global_attribute2 IN
428: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
429: p_global_attribute3 IN
430: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
431: p_global_attribute4 IN
432: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
433: p_global_attribute5 IN
434: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
428: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
429: p_global_attribute3 IN
430: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
431: p_global_attribute4 IN
432: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
433: p_global_attribute5 IN
434: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
435: p_global_attribute6 IN
436: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
430: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
431: p_global_attribute4 IN
432: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
433: p_global_attribute5 IN
434: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
435: p_global_attribute6 IN
436: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
437: p_global_attribute7 IN
438: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
432: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
433: p_global_attribute5 IN
434: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
435: p_global_attribute6 IN
436: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
437: p_global_attribute7 IN
438: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
439: p_global_attribute8 IN
440: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
434: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
435: p_global_attribute6 IN
436: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
437: p_global_attribute7 IN
438: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
439: p_global_attribute8 IN
440: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
441: p_global_attribute9 IN
442: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
436: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
437: p_global_attribute7 IN
438: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
439: p_global_attribute8 IN
440: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
441: p_global_attribute9 IN
442: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
443: p_global_attribute10 IN
444: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
438: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
439: p_global_attribute8 IN
440: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
441: p_global_attribute9 IN
442: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
443: p_global_attribute10 IN
444: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
445: p_global_attribute11 IN
446: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
440: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
441: p_global_attribute9 IN
442: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
443: p_global_attribute10 IN
444: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
445: p_global_attribute11 IN
446: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
447: p_global_attribute12 IN
448: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
442: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
443: p_global_attribute10 IN
444: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
445: p_global_attribute11 IN
446: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
447: p_global_attribute12 IN
448: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
449: p_global_attribute13 IN
450: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
444: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
445: p_global_attribute11 IN
446: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
447: p_global_attribute12 IN
448: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
449: p_global_attribute13 IN
450: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
451: p_global_attribute14 IN
452: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
446: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
447: p_global_attribute12 IN
448: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
449: p_global_attribute13 IN
450: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
451: p_global_attribute14 IN
452: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
453: p_global_attribute15 IN
454: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
448: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
449: p_global_attribute13 IN
450: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
451: p_global_attribute14 IN
452: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
453: p_global_attribute15 IN
454: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
455: p_global_attribute16 IN
456: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
450: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
451: p_global_attribute14 IN
452: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
453: p_global_attribute15 IN
454: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
455: p_global_attribute16 IN
456: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
457: p_global_attribute17 IN
458: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
452: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
453: p_global_attribute15 IN
454: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
455: p_global_attribute16 IN
456: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
457: p_global_attribute17 IN
458: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
459: p_global_attribute18 IN
460: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
454: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
455: p_global_attribute16 IN
456: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
457: p_global_attribute17 IN
458: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
459: p_global_attribute18 IN
460: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
461: p_global_attribute19 IN
462: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
456: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
457: p_global_attribute17 IN
458: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
459: p_global_attribute18 IN
460: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
461: p_global_attribute19 IN
462: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
463: p_global_attribute20 IN
464: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
458: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
459: p_global_attribute18 IN
460: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
461: p_global_attribute19 IN
462: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
463: p_global_attribute20 IN
464: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
465: p_application_ref_type IN
466: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
460: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
461: p_global_attribute19 IN
462: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
463: p_global_attribute20 IN
464: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
465: p_application_ref_type IN
466: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
467: p_customer_reference IN
468: ar_interim_cash_receipt_lines.customer_reference%TYPE,
462: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
463: p_global_attribute20 IN
464: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
465: p_application_ref_type IN
466: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
467: p_customer_reference IN
468: ar_interim_cash_receipt_lines.customer_reference%TYPE,
469: p_customer_reason IN
470: ar_interim_cash_receipt_lines.customer_reason%TYPE,
464: ar_interim_cash_receipt_lines.global_attribute20%TYPE,
465: p_application_ref_type IN
466: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
467: p_customer_reference IN
468: ar_interim_cash_receipt_lines.customer_reference%TYPE,
469: p_customer_reason IN
470: ar_interim_cash_receipt_lines.customer_reason%TYPE,
471: p_applied_rec_app_id IN
472: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
466: ar_interim_cash_receipt_lines.application_ref_type%TYPE,
467: p_customer_reference IN
468: ar_interim_cash_receipt_lines.customer_reference%TYPE,
469: p_customer_reason IN
470: ar_interim_cash_receipt_lines.customer_reason%TYPE,
471: p_applied_rec_app_id IN
472: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
473: p_module_name IN VARCHAR2,
474: p_module_version IN VARCHAR2 ) IS
468: ar_interim_cash_receipt_lines.customer_reference%TYPE,
469: p_customer_reason IN
470: ar_interim_cash_receipt_lines.customer_reason%TYPE,
471: p_applied_rec_app_id IN
472: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,
473: p_module_name IN VARCHAR2,
474: p_module_version IN VARCHAR2 ) IS
475: --
476: l_row_id VARCHAR2(30);
473: p_module_name IN VARCHAR2,
474: p_module_version IN VARCHAR2 ) IS
475: --
476: l_row_id VARCHAR2(30);
477: l_icr_line_id ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE;
478: l_icr_lines_rec ar_interim_cash_receipt_lines%ROWTYPE;
479: --
480: BEGIN
481: IF PG_DEBUG in ('Y', 'C') THEN
474: p_module_version IN VARCHAR2 ) IS
475: --
476: l_row_id VARCHAR2(30);
477: l_icr_line_id ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE;
478: l_icr_lines_rec ar_interim_cash_receipt_lines%ROWTYPE;
479: --
480: BEGIN
481: IF PG_DEBUG in ('Y', 'C') THEN
482: arp_util.debug('arp_rw_icr_line_pkg.insert_row()+' );
611: +===========================================================================*/
612: PROCEDURE validate_args_insert_row(
613: p_row_id IN VARCHAR2,
614: p_icr_line_id IN
615: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
616: p_cash_receipt_id IN
617: ar_interim_cash_receipts.cash_receipt_id%TYPE,
618: p_payment_schedule_id IN
619: ar_payment_schedules.payment_schedule_id%TYPE,
617: ar_interim_cash_receipts.cash_receipt_id%TYPE,
618: p_payment_schedule_id IN
619: ar_payment_schedules.payment_schedule_id%TYPE,
620: p_customer_trx_id IN
621: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
622: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
623: p_sold_to_customer IN
624: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
625: BEGIN
618: p_payment_schedule_id IN
619: ar_payment_schedules.payment_schedule_id%TYPE,
620: p_customer_trx_id IN
621: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
622: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
623: p_sold_to_customer IN
624: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
625: BEGIN
626: IF PG_DEBUG in ('Y', 'C') THEN
620: p_customer_trx_id IN
621: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
622: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%TYPE,
623: p_sold_to_customer IN
624: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS
625: BEGIN
626: IF PG_DEBUG in ('Y', 'C') THEN
627: arp_util.debug( 'arp_rw_icr_lines_pkg.validate_args_insert_row()+' );
628: END IF;
678: PROCEDURE delete_row(
679: p_row_id IN VARCHAR2,
680: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
681: p_icr_line_id IN
682: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
683: p_module_name IN VARCHAR2,
684: p_module_version IN VARCHAR2 ) IS
685: BEGIN
686: IF PG_DEBUG in ('Y', 'C') THEN
736: +===========================================================================*/
737: PROCEDURE validate_args_delete_row(
738: p_row_id IN VARCHAR2,
739: p_icr_line_id IN
740: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE ) IS
741: BEGIN
742: IF PG_DEBUG in ('Y', 'C') THEN
743: arp_util.debug( 'arp_rw_icr_lines_pkg.validate_args_delete_row()+' );
744: END IF;
788: +===========================================================================*/
789: PROCEDURE lock_row(
790: p_row_id VARCHAR2,
791: p_icr_id
792: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
793: p_icr_line_id
794: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
795: p_payment_amount
796: ar_interim_cash_receipt_lines.payment_amount%TYPE,
790: p_row_id VARCHAR2,
791: p_icr_id
792: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
793: p_icr_line_id
794: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
795: p_payment_amount
796: ar_interim_cash_receipt_lines.payment_amount%TYPE,
797: p_payment_schedule_id
798: ar_payment_schedules.payment_schedule_id%TYPE,
792: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,
793: p_icr_line_id
794: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
795: p_payment_amount
796: ar_interim_cash_receipt_lines.payment_amount%TYPE,
797: p_payment_schedule_id
798: ar_payment_schedules.payment_schedule_id%TYPE,
799: p_customer_trx_id
800: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
796: ar_interim_cash_receipt_lines.payment_amount%TYPE,
797: p_payment_schedule_id
798: ar_payment_schedules.payment_schedule_id%TYPE,
799: p_customer_trx_id
800: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
801: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
802: p_sold_to_customer
803: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
804: p_discount_taken
797: p_payment_schedule_id
798: ar_payment_schedules.payment_schedule_id%TYPE,
799: p_customer_trx_id
800: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
801: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
802: p_sold_to_customer
803: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
804: p_discount_taken
805: ar_interim_cash_receipt_lines.discount_taken%TYPE,
799: p_customer_trx_id
800: ar_interim_cash_receipt_lines.customer_trx_id%TYPE,
801: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
802: p_sold_to_customer
803: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
804: p_discount_taken
805: ar_interim_cash_receipt_lines.discount_taken%TYPE,
806: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
807: p_ussgl_transaction_code
801: p_batch_id ar_interim_cash_receipt_lines.batch_id%TYPE,
802: p_sold_to_customer
803: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
804: p_discount_taken
805: ar_interim_cash_receipt_lines.discount_taken%TYPE,
806: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
807: p_ussgl_transaction_code
808: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
809: p_attribute_category
802: p_sold_to_customer
803: ar_interim_cash_receipt_lines.sold_to_customer%TYPE,
804: p_discount_taken
805: ar_interim_cash_receipt_lines.discount_taken%TYPE,
806: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
807: p_ussgl_transaction_code
808: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
809: p_attribute_category
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,
804: p_discount_taken
805: ar_interim_cash_receipt_lines.discount_taken%TYPE,
806: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
807: p_ussgl_transaction_code
808: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
809: p_attribute_category
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,
811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
806: p_due_date ar_interim_cash_receipt_lines.due_date%TYPE,
807: p_ussgl_transaction_code
808: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
809: p_attribute_category
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,
811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
807: p_ussgl_transaction_code
808: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
809: p_attribute_category
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,
811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
808: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
809: p_attribute_category
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,
811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
809: p_attribute_category
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,
811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,
811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%TYPE,
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
826: p_global_attribute_category IN
819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
826: p_global_attribute_category IN
827: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%TYPE,
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
826: p_global_attribute_category IN
827: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
828: p_global_attribute1 IN
821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%TYPE,
822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
826: p_global_attribute_category IN
827: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
828: p_global_attribute1 IN
829: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%TYPE,
824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%TYPE,
825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
826: p_global_attribute_category IN
827: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
828: p_global_attribute1 IN
829: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
830: p_global_attribute2 IN
831: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%TYPE,
826: p_global_attribute_category IN
827: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
828: p_global_attribute1 IN
829: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
830: p_global_attribute2 IN
831: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
832: p_global_attribute3 IN
833: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
827: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,
828: p_global_attribute1 IN
829: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
830: p_global_attribute2 IN
831: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
832: p_global_attribute3 IN
833: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
834: p_global_attribute4 IN
835: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
829: ar_interim_cash_receipt_lines.global_attribute1%TYPE,
830: p_global_attribute2 IN
831: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
832: p_global_attribute3 IN
833: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
834: p_global_attribute4 IN
835: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
836: p_global_attribute5 IN
837: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
831: ar_interim_cash_receipt_lines.global_attribute2%TYPE,
832: p_global_attribute3 IN
833: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
834: p_global_attribute4 IN
835: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
836: p_global_attribute5 IN
837: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
838: p_global_attribute6 IN
839: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
833: ar_interim_cash_receipt_lines.global_attribute3%TYPE,
834: p_global_attribute4 IN
835: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
836: p_global_attribute5 IN
837: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
838: p_global_attribute6 IN
839: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
840: p_global_attribute7 IN
841: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
835: ar_interim_cash_receipt_lines.global_attribute4%TYPE,
836: p_global_attribute5 IN
837: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
838: p_global_attribute6 IN
839: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
840: p_global_attribute7 IN
841: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
842: p_global_attribute8 IN
843: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
837: ar_interim_cash_receipt_lines.global_attribute5%TYPE,
838: p_global_attribute6 IN
839: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
840: p_global_attribute7 IN
841: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
842: p_global_attribute8 IN
843: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
844: p_global_attribute9 IN
845: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
839: ar_interim_cash_receipt_lines.global_attribute6%TYPE,
840: p_global_attribute7 IN
841: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
842: p_global_attribute8 IN
843: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
844: p_global_attribute9 IN
845: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
846: p_global_attribute10 IN
847: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
841: ar_interim_cash_receipt_lines.global_attribute7%TYPE,
842: p_global_attribute8 IN
843: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
844: p_global_attribute9 IN
845: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
846: p_global_attribute10 IN
847: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
848: p_global_attribute11 IN
849: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
843: ar_interim_cash_receipt_lines.global_attribute8%TYPE,
844: p_global_attribute9 IN
845: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
846: p_global_attribute10 IN
847: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
848: p_global_attribute11 IN
849: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
850: p_global_attribute12 IN
851: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
845: ar_interim_cash_receipt_lines.global_attribute9%TYPE,
846: p_global_attribute10 IN
847: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
848: p_global_attribute11 IN
849: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
850: p_global_attribute12 IN
851: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
852: p_global_attribute13 IN
853: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
847: ar_interim_cash_receipt_lines.global_attribute10%TYPE,
848: p_global_attribute11 IN
849: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
850: p_global_attribute12 IN
851: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
852: p_global_attribute13 IN
853: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
854: p_global_attribute14 IN
855: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
849: ar_interim_cash_receipt_lines.global_attribute11%TYPE,
850: p_global_attribute12 IN
851: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
852: p_global_attribute13 IN
853: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
854: p_global_attribute14 IN
855: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
856: p_global_attribute15 IN
857: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
851: ar_interim_cash_receipt_lines.global_attribute12%TYPE,
852: p_global_attribute13 IN
853: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
854: p_global_attribute14 IN
855: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
856: p_global_attribute15 IN
857: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
858: p_global_attribute16 IN
859: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
853: ar_interim_cash_receipt_lines.global_attribute13%TYPE,
854: p_global_attribute14 IN
855: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
856: p_global_attribute15 IN
857: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
858: p_global_attribute16 IN
859: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
860: p_global_attribute17 IN
861: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
855: ar_interim_cash_receipt_lines.global_attribute14%TYPE,
856: p_global_attribute15 IN
857: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
858: p_global_attribute16 IN
859: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
860: p_global_attribute17 IN
861: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
862: p_global_attribute18 IN
863: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
857: ar_interim_cash_receipt_lines.global_attribute15%TYPE,
858: p_global_attribute16 IN
859: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
860: p_global_attribute17 IN
861: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
862: p_global_attribute18 IN
863: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
864: p_global_attribute19 IN
865: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
859: ar_interim_cash_receipt_lines.global_attribute16%TYPE,
860: p_global_attribute17 IN
861: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
862: p_global_attribute18 IN
863: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
864: p_global_attribute19 IN
865: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
866: p_global_attribute20 IN
867: ar_interim_cash_receipt_lines.global_attribute20%TYPE ) IS
861: ar_interim_cash_receipt_lines.global_attribute17%TYPE,
862: p_global_attribute18 IN
863: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
864: p_global_attribute19 IN
865: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
866: p_global_attribute20 IN
867: ar_interim_cash_receipt_lines.global_attribute20%TYPE ) IS
868: CURSOR C IS
869: SELECT *
863: ar_interim_cash_receipt_lines.global_attribute18%TYPE,
864: p_global_attribute19 IN
865: ar_interim_cash_receipt_lines.global_attribute19%TYPE,
866: p_global_attribute20 IN
867: ar_interim_cash_receipt_lines.global_attribute20%TYPE ) IS
868: CURSOR C IS
869: SELECT *
870: FROM ar_interim_cash_receipt_lines
871: WHERE rowid = p_row_id
866: p_global_attribute20 IN
867: ar_interim_cash_receipt_lines.global_attribute20%TYPE ) IS
868: CURSOR C IS
869: SELECT *
870: FROM ar_interim_cash_receipt_lines
871: WHERE rowid = p_row_id
872: FOR UPDATE of CASH_RECEIPT_ID NOWAIT;
873: Recinfo C%ROWTYPE;
874: --