DBA Data[Home] [Help]

APPS.ARP_RW_ICR_LINES_PKG dependencies on AR_INTERIM_CASH_RECEIPT_LINES

Line 9: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,

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,

Line 15: ar_interim_cash_receipt_lines.customer_trx_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: --

Line 16: p_batch_id IN ar_interim_cash_receipt_lines.batch_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: --
20: PROCEDURE validate_args_update_row(

Line 18: ar_interim_cash_receipt_lines.sold_to_customer%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(
21: p_row_id IN VARCHAR2,
22: p_icr_line_id IN

Line 23: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,

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,

Line 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: --

Line 28: p_batch_id IN ar_interim_cash_receipt_lines.batch_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: --
32: PROCEDURE validate_args_delete_row(

Line 30: ar_interim_cash_receipt_lines.sold_to_customer%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(
33: p_row_id IN VARCHAR2,
34: p_icr_line_id IN

Line 35: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE );

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 |

Line 85: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,

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,

Line 87: ar_interim_cash_receipt_lines.cash_receipt_id%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,

Line 89: ar_interim_cash_receipt_lines.payment_amount%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,

Line 91: ar_interim_cash_receipt_lines.amount_applied_from%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,

Line 93: ar_interim_cash_receipt_lines.trans_to_receipt_rate%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,

Line 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

Line 98: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%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
102: ar_interim_cash_receipt_lines.discount_taken%TYPE,

Line 100: ar_interim_cash_receipt_lines.sold_to_customer%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

Line 102: ar_interim_cash_receipt_lines.discount_taken%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
105: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
106: p_attribute_category IN

Line 103: p_due_date IN ar_interim_cash_receipt_lines.due_date%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
107: ar_interim_cash_receipt_lines.attribute_category%TYPE,

Line 105: ar_interim_cash_receipt_lines.ussgl_transaction_code%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,

Line 107: ar_interim_cash_receipt_lines.attribute_category%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,

Line 108: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%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,

Line 109: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%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,

Line 110: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%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,

Line 111: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%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,

Line 112: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%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,

Line 113: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%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,

Line 114: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%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,

Line 115: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%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,

Line 116: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%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,

Line 117: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%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,

Line 118: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%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,

Line 119: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%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

Line 120: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%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
124: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,

Line 121: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%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

Line 122: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%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
126: ar_interim_cash_receipt_lines.global_attribute1%TYPE,

Line 124: ar_interim_cash_receipt_lines.global_attribute_category%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,

Line 126: ar_interim_cash_receipt_lines.global_attribute1%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,

Line 128: ar_interim_cash_receipt_lines.global_attribute2%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,

Line 130: ar_interim_cash_receipt_lines.global_attribute3%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,

Line 132: ar_interim_cash_receipt_lines.global_attribute4%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,

Line 134: ar_interim_cash_receipt_lines.global_attribute5%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,

Line 136: ar_interim_cash_receipt_lines.global_attribute6%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,

Line 138: ar_interim_cash_receipt_lines.global_attribute7%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,

Line 140: ar_interim_cash_receipt_lines.global_attribute8%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,

Line 142: ar_interim_cash_receipt_lines.global_attribute9%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,

Line 144: ar_interim_cash_receipt_lines.global_attribute10%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,

Line 146: ar_interim_cash_receipt_lines.global_attribute11%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,

Line 148: ar_interim_cash_receipt_lines.global_attribute12%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,

Line 150: ar_interim_cash_receipt_lines.global_attribute13%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,

Line 152: ar_interim_cash_receipt_lines.global_attribute14%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,

Line 154: ar_interim_cash_receipt_lines.global_attribute15%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,

Line 156: ar_interim_cash_receipt_lines.global_attribute16%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,

Line 158: ar_interim_cash_receipt_lines.global_attribute17%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,

Line 160: ar_interim_cash_receipt_lines.global_attribute18%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,

Line 162: ar_interim_cash_receipt_lines.global_attribute19%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,

Line 164: ar_interim_cash_receipt_lines.global_attribute20%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,

Line 166: ar_interim_cash_receipt_lines.application_ref_type%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,

Line 168: ar_interim_cash_receipt_lines.customer_reference%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,

Line 170: ar_interim_cash_receipt_lines.customer_reason%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

Line 172: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,

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;

Line 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 );

Line 314: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,

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,

Line 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

Line 319: p_batch_id IN ar_interim_cash_receipt_lines.batch_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
323: IF PG_DEBUG in ('Y', 'C') THEN

Line 321: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS

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;

Line 386: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,

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

Line 387: p_cr_id IN ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,

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,

Line 389: ar_interim_cash_receipt_lines.payment_amount%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,

Line 391: ar_interim_cash_receipt_lines.amount_applied_from%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,

Line 393: ar_interim_cash_receipt_lines.trans_to_receipt_rate%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,

Line 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

Line 398: p_batch_id IN ar_interim_cash_receipt_lines.batch_id%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
402: ar_interim_cash_receipt_lines.discount_taken%TYPE,

Line 400: ar_interim_cash_receipt_lines.sold_to_customer%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

Line 402: ar_interim_cash_receipt_lines.discount_taken%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
405: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
406: p_attribute_category IN

Line 403: p_due_date IN ar_interim_cash_receipt_lines.due_date%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
407: ar_interim_cash_receipt_lines.attribute_category%TYPE,

Line 405: ar_interim_cash_receipt_lines.ussgl_transaction_code%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,

Line 407: ar_interim_cash_receipt_lines.attribute_category%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,

Line 408: p_attribute1 IN ar_interim_cash_receipt_lines.attribute1%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,

Line 409: p_attribute2 IN ar_interim_cash_receipt_lines.attribute2%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,

Line 410: p_attribute3 IN ar_interim_cash_receipt_lines.attribute3%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,

Line 411: p_attribute4 IN ar_interim_cash_receipt_lines.attribute4%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,

Line 412: p_attribute5 IN ar_interim_cash_receipt_lines.attribute5%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,

Line 413: p_attribute6 IN ar_interim_cash_receipt_lines.attribute6%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,

Line 414: p_attribute7 IN ar_interim_cash_receipt_lines.attribute7%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,

Line 415: p_attribute8 IN ar_interim_cash_receipt_lines.attribute8%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,

Line 416: p_attribute9 IN ar_interim_cash_receipt_lines.attribute9%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,

Line 417: p_attribute10 IN ar_interim_cash_receipt_lines.attribute10%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,

Line 418: p_attribute11 IN ar_interim_cash_receipt_lines.attribute11%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,

Line 419: p_attribute12 IN ar_interim_cash_receipt_lines.attribute12%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

Line 420: p_attribute13 IN ar_interim_cash_receipt_lines.attribute13%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
424: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,

Line 421: p_attribute14 IN ar_interim_cash_receipt_lines.attribute14%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

Line 422: p_attribute15 IN ar_interim_cash_receipt_lines.attribute15%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
426: ar_interim_cash_receipt_lines.global_attribute1%TYPE,

Line 424: ar_interim_cash_receipt_lines.global_attribute_category%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,

Line 426: ar_interim_cash_receipt_lines.global_attribute1%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,

Line 428: ar_interim_cash_receipt_lines.global_attribute2%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,

Line 430: ar_interim_cash_receipt_lines.global_attribute3%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,

Line 432: ar_interim_cash_receipt_lines.global_attribute4%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,

Line 434: ar_interim_cash_receipt_lines.global_attribute5%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,

Line 436: ar_interim_cash_receipt_lines.global_attribute6%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,

Line 438: ar_interim_cash_receipt_lines.global_attribute7%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,

Line 440: ar_interim_cash_receipt_lines.global_attribute8%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,

Line 442: ar_interim_cash_receipt_lines.global_attribute9%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,

Line 444: ar_interim_cash_receipt_lines.global_attribute10%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,

Line 446: ar_interim_cash_receipt_lines.global_attribute11%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,

Line 448: ar_interim_cash_receipt_lines.global_attribute12%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,

Line 450: ar_interim_cash_receipt_lines.global_attribute13%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,

Line 452: ar_interim_cash_receipt_lines.global_attribute14%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,

Line 454: ar_interim_cash_receipt_lines.global_attribute15%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,

Line 456: ar_interim_cash_receipt_lines.global_attribute16%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,

Line 458: ar_interim_cash_receipt_lines.global_attribute17%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,

Line 460: ar_interim_cash_receipt_lines.global_attribute18%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,

Line 462: ar_interim_cash_receipt_lines.global_attribute19%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,

Line 464: ar_interim_cash_receipt_lines.global_attribute20%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,

Line 466: ar_interim_cash_receipt_lines.application_ref_type%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,

Line 468: ar_interim_cash_receipt_lines.customer_reference%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,

Line 470: ar_interim_cash_receipt_lines.customer_reason%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

Line 472: ar_interim_cash_receipt_lines.applied_rec_app_id%TYPE,

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);

Line 477: l_icr_line_id ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE;

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

Line 478: l_icr_lines_rec ar_interim_cash_receipt_lines%ROWTYPE;

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()+' );

Line 615: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,

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,

Line 621: ar_interim_cash_receipt_lines.customer_trx_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

Line 622: p_batch_id IN ar_interim_cash_receipt_lines.batch_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
626: IF PG_DEBUG in ('Y', 'C') THEN

Line 624: ar_interim_cash_receipt_lines.sold_to_customer%TYPE ) IS

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;

Line 682: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,

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

Line 740: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE ) IS

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;

Line 792: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE,

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,

Line 794: ar_interim_cash_receipt_lines.cash_receipt_line_id%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,

Line 796: ar_interim_cash_receipt_lines.payment_amount%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,

Line 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

Line 801: p_batch_id ar_interim_cash_receipt_lines.batch_id%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
805: ar_interim_cash_receipt_lines.discount_taken%TYPE,

Line 803: ar_interim_cash_receipt_lines.sold_to_customer%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

Line 805: ar_interim_cash_receipt_lines.discount_taken%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
808: ar_interim_cash_receipt_lines.ussgl_transaction_code%TYPE,
809: p_attribute_category

Line 806: p_due_date ar_interim_cash_receipt_lines.due_date%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
810: ar_interim_cash_receipt_lines.attribute_category%TYPE,

Line 808: ar_interim_cash_receipt_lines.ussgl_transaction_code%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,

Line 810: ar_interim_cash_receipt_lines.attribute_category%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,

Line 811: p_attribute1 ar_interim_cash_receipt_lines.attribute1%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,

Line 812: p_attribute2 ar_interim_cash_receipt_lines.attribute2%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,

Line 813: p_attribute3 ar_interim_cash_receipt_lines.attribute3%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,

Line 814: p_attribute4 ar_interim_cash_receipt_lines.attribute4%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,

Line 815: p_attribute5 ar_interim_cash_receipt_lines.attribute5%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,

Line 816: p_attribute6 ar_interim_cash_receipt_lines.attribute6%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,

Line 817: p_attribute7 ar_interim_cash_receipt_lines.attribute7%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,

Line 818: p_attribute8 ar_interim_cash_receipt_lines.attribute8%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,

Line 819: p_attribute9 ar_interim_cash_receipt_lines.attribute9%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,

Line 820: p_attribute10 ar_interim_cash_receipt_lines.attribute10%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,

Line 821: p_attribute11 ar_interim_cash_receipt_lines.attribute11%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,

Line 822: p_attribute12 ar_interim_cash_receipt_lines.attribute12%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

Line 823: p_attribute13 ar_interim_cash_receipt_lines.attribute13%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
827: ar_interim_cash_receipt_lines.global_attribute_category%TYPE,

Line 824: p_attribute14 ar_interim_cash_receipt_lines.attribute14%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

Line 825: p_attribute15 ar_interim_cash_receipt_lines.attribute15%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
829: ar_interim_cash_receipt_lines.global_attribute1%TYPE,

Line 827: ar_interim_cash_receipt_lines.global_attribute_category%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,

Line 829: ar_interim_cash_receipt_lines.global_attribute1%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,

Line 831: ar_interim_cash_receipt_lines.global_attribute2%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,

Line 833: ar_interim_cash_receipt_lines.global_attribute3%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,

Line 835: ar_interim_cash_receipt_lines.global_attribute4%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,

Line 837: ar_interim_cash_receipt_lines.global_attribute5%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,

Line 839: ar_interim_cash_receipt_lines.global_attribute6%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,

Line 841: ar_interim_cash_receipt_lines.global_attribute7%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,

Line 843: ar_interim_cash_receipt_lines.global_attribute8%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,

Line 845: ar_interim_cash_receipt_lines.global_attribute9%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,

Line 847: ar_interim_cash_receipt_lines.global_attribute10%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,

Line 849: ar_interim_cash_receipt_lines.global_attribute11%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,

Line 851: ar_interim_cash_receipt_lines.global_attribute12%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,

Line 853: ar_interim_cash_receipt_lines.global_attribute13%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,

Line 855: ar_interim_cash_receipt_lines.global_attribute14%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,

Line 857: ar_interim_cash_receipt_lines.global_attribute15%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,

Line 859: ar_interim_cash_receipt_lines.global_attribute16%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,

Line 861: ar_interim_cash_receipt_lines.global_attribute17%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,

Line 863: ar_interim_cash_receipt_lines.global_attribute18%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

Line 865: ar_interim_cash_receipt_lines.global_attribute19%TYPE,

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 *

Line 867: ar_interim_cash_receipt_lines.global_attribute20%TYPE ) IS

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

Line 870: FROM ar_interim_cash_receipt_lines

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: --