171: ra_cust_trx_line_gl_dist.amount%type,
172: p_amount2 IN
173: ra_cust_trx_line_gl_dist.amount%type,
174: p_customer_trx_id IN
175: ra_customer_trx_lines.customer_trx_id%type,
176: p_line_number IN
177: ra_customer_trx_lines.line_number%type,
178: p_line_type IN
179: ra_customer_trx_lines.line_type%type,
173: ra_cust_trx_line_gl_dist.amount%type,
174: p_customer_trx_id IN
175: ra_customer_trx_lines.customer_trx_id%type,
176: p_line_number IN
177: ra_customer_trx_lines.line_number%type,
178: p_line_type IN
179: ra_customer_trx_lines.line_type%type,
180: p_quantity_credited IN
181: ra_customer_trx_lines.quantity_credited%type,
175: ra_customer_trx_lines.customer_trx_id%type,
176: p_line_number IN
177: ra_customer_trx_lines.line_number%type,
178: p_line_type IN
179: ra_customer_trx_lines.line_type%type,
180: p_quantity_credited IN
181: ra_customer_trx_lines.quantity_credited%type,
182: p_quantity_invoiced IN
183: ra_customer_trx_lines.quantity_invoiced%type,
177: ra_customer_trx_lines.line_number%type,
178: p_line_type IN
179: ra_customer_trx_lines.line_type%type,
180: p_quantity_credited IN
181: ra_customer_trx_lines.quantity_credited%type,
182: p_quantity_invoiced IN
183: ra_customer_trx_lines.quantity_invoiced%type,
184: p_quantity_ordered IN
185: ra_customer_trx_lines.quantity_ordered%type,
179: ra_customer_trx_lines.line_type%type,
180: p_quantity_credited IN
181: ra_customer_trx_lines.quantity_credited%type,
182: p_quantity_invoiced IN
183: ra_customer_trx_lines.quantity_invoiced%type,
184: p_quantity_ordered IN
185: ra_customer_trx_lines.quantity_ordered%type,
186: p_unit_selling_price IN
187: ra_customer_trx_lines.unit_selling_price%type,
181: ra_customer_trx_lines.quantity_credited%type,
182: p_quantity_invoiced IN
183: ra_customer_trx_lines.quantity_invoiced%type,
184: p_quantity_ordered IN
185: ra_customer_trx_lines.quantity_ordered%type,
186: p_unit_selling_price IN
187: ra_customer_trx_lines.unit_selling_price%type,
188: p_unit_standard_price IN
189: ra_customer_trx_lines.unit_standard_price%type,
183: ra_customer_trx_lines.quantity_invoiced%type,
184: p_quantity_ordered IN
185: ra_customer_trx_lines.quantity_ordered%type,
186: p_unit_selling_price IN
187: ra_customer_trx_lines.unit_selling_price%type,
188: p_unit_standard_price IN
189: ra_customer_trx_lines.unit_standard_price%type,
190: p_revenue_amount IN
191: ra_customer_trx_lines.revenue_amount%type,
185: ra_customer_trx_lines.quantity_ordered%type,
186: p_unit_selling_price IN
187: ra_customer_trx_lines.unit_selling_price%type,
188: p_unit_standard_price IN
189: ra_customer_trx_lines.unit_standard_price%type,
190: p_revenue_amount IN
191: ra_customer_trx_lines.revenue_amount%type,
192: p_extended_amount IN
193: ra_customer_trx_lines.extended_amount%type,
187: ra_customer_trx_lines.unit_selling_price%type,
188: p_unit_standard_price IN
189: ra_customer_trx_lines.unit_standard_price%type,
190: p_revenue_amount IN
191: ra_customer_trx_lines.revenue_amount%type,
192: p_extended_amount IN
193: ra_customer_trx_lines.extended_amount%type,
194: p_memo_line_id IN
195: ra_customer_trx_lines.memo_line_id%type,
189: ra_customer_trx_lines.unit_standard_price%type,
190: p_revenue_amount IN
191: ra_customer_trx_lines.revenue_amount%type,
192: p_extended_amount IN
193: ra_customer_trx_lines.extended_amount%type,
194: p_memo_line_id IN
195: ra_customer_trx_lines.memo_line_id%type,
196: p_inventory_item_id IN
197: ra_customer_trx_lines.inventory_item_id%type,
191: ra_customer_trx_lines.revenue_amount%type,
192: p_extended_amount IN
193: ra_customer_trx_lines.extended_amount%type,
194: p_memo_line_id IN
195: ra_customer_trx_lines.memo_line_id%type,
196: p_inventory_item_id IN
197: ra_customer_trx_lines.inventory_item_id%type,
198: p_item_exception_rate_id IN
199: ra_customer_trx_lines.item_exception_rate_id%type,
193: ra_customer_trx_lines.extended_amount%type,
194: p_memo_line_id IN
195: ra_customer_trx_lines.memo_line_id%type,
196: p_inventory_item_id IN
197: ra_customer_trx_lines.inventory_item_id%type,
198: p_item_exception_rate_id IN
199: ra_customer_trx_lines.item_exception_rate_id%type,
200: p_description IN
201: ra_customer_trx_lines.description%type,
195: ra_customer_trx_lines.memo_line_id%type,
196: p_inventory_item_id IN
197: ra_customer_trx_lines.inventory_item_id%type,
198: p_item_exception_rate_id IN
199: ra_customer_trx_lines.item_exception_rate_id%type,
200: p_description IN
201: ra_customer_trx_lines.description%type,
202: p_item_context IN
203: ra_customer_trx_lines.item_context%type,
197: ra_customer_trx_lines.inventory_item_id%type,
198: p_item_exception_rate_id IN
199: ra_customer_trx_lines.item_exception_rate_id%type,
200: p_description IN
201: ra_customer_trx_lines.description%type,
202: p_item_context IN
203: ra_customer_trx_lines.item_context%type,
204: p_initial_customer_trx_line_id IN
205: ra_customer_trx_lines.initial_customer_trx_line_id%type,
199: ra_customer_trx_lines.item_exception_rate_id%type,
200: p_description IN
201: ra_customer_trx_lines.description%type,
202: p_item_context IN
203: ra_customer_trx_lines.item_context%type,
204: p_initial_customer_trx_line_id IN
205: ra_customer_trx_lines.initial_customer_trx_line_id%type,
206: p_link_to_cust_trx_line_id IN
207: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
201: ra_customer_trx_lines.description%type,
202: p_item_context IN
203: ra_customer_trx_lines.item_context%type,
204: p_initial_customer_trx_line_id IN
205: ra_customer_trx_lines.initial_customer_trx_line_id%type,
206: p_link_to_cust_trx_line_id IN
207: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
208: p_previous_customer_trx_id IN
209: ra_customer_trx_lines.previous_customer_trx_id%type,
203: ra_customer_trx_lines.item_context%type,
204: p_initial_customer_trx_line_id IN
205: ra_customer_trx_lines.initial_customer_trx_line_id%type,
206: p_link_to_cust_trx_line_id IN
207: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
208: p_previous_customer_trx_id IN
209: ra_customer_trx_lines.previous_customer_trx_id%type,
210: p_prev_customer_trx_line_id IN
211: ra_customer_trx_lines.previous_customer_trx_line_id%type,
205: ra_customer_trx_lines.initial_customer_trx_line_id%type,
206: p_link_to_cust_trx_line_id IN
207: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
208: p_previous_customer_trx_id IN
209: ra_customer_trx_lines.previous_customer_trx_id%type,
210: p_prev_customer_trx_line_id IN
211: ra_customer_trx_lines.previous_customer_trx_line_id%type,
212: p_accounting_rule_duration IN OUT NOCOPY
213: ra_customer_trx_lines.accounting_rule_duration%type,
207: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
208: p_previous_customer_trx_id IN
209: ra_customer_trx_lines.previous_customer_trx_id%type,
210: p_prev_customer_trx_line_id IN
211: ra_customer_trx_lines.previous_customer_trx_line_id%type,
212: p_accounting_rule_duration IN OUT NOCOPY
213: ra_customer_trx_lines.accounting_rule_duration%type,
214: p_accounting_rule_id IN
215: ra_customer_trx_lines.accounting_rule_id%type,
209: ra_customer_trx_lines.previous_customer_trx_id%type,
210: p_prev_customer_trx_line_id IN
211: ra_customer_trx_lines.previous_customer_trx_line_id%type,
212: p_accounting_rule_duration IN OUT NOCOPY
213: ra_customer_trx_lines.accounting_rule_duration%type,
214: p_accounting_rule_id IN
215: ra_customer_trx_lines.accounting_rule_id%type,
216: p_rule_start_date IN OUT NOCOPY
217: ra_customer_trx_lines.rule_start_date%type,
211: ra_customer_trx_lines.previous_customer_trx_line_id%type,
212: p_accounting_rule_duration IN OUT NOCOPY
213: ra_customer_trx_lines.accounting_rule_duration%type,
214: p_accounting_rule_id IN
215: ra_customer_trx_lines.accounting_rule_id%type,
216: p_rule_start_date IN OUT NOCOPY
217: ra_customer_trx_lines.rule_start_date%type,
218: p_autorule_complete_flag IN
219: ra_customer_trx_lines.autorule_complete_flag%type,
213: ra_customer_trx_lines.accounting_rule_duration%type,
214: p_accounting_rule_id IN
215: ra_customer_trx_lines.accounting_rule_id%type,
216: p_rule_start_date IN OUT NOCOPY
217: ra_customer_trx_lines.rule_start_date%type,
218: p_autorule_complete_flag IN
219: ra_customer_trx_lines.autorule_complete_flag%type,
220: p_autorule_duration_processed IN
221: ra_customer_trx_lines.autorule_duration_processed%type,
215: ra_customer_trx_lines.accounting_rule_id%type,
216: p_rule_start_date IN OUT NOCOPY
217: ra_customer_trx_lines.rule_start_date%type,
218: p_autorule_complete_flag IN
219: ra_customer_trx_lines.autorule_complete_flag%type,
220: p_autorule_duration_processed IN
221: ra_customer_trx_lines.autorule_duration_processed%type,
222: p_reason_code IN
223: ra_customer_trx_lines.reason_code%type,
217: ra_customer_trx_lines.rule_start_date%type,
218: p_autorule_complete_flag IN
219: ra_customer_trx_lines.autorule_complete_flag%type,
220: p_autorule_duration_processed IN
221: ra_customer_trx_lines.autorule_duration_processed%type,
222: p_reason_code IN
223: ra_customer_trx_lines.reason_code%type,
224: p_last_period_to_credit IN
225: ra_customer_trx_lines.last_period_to_credit%type,
219: ra_customer_trx_lines.autorule_complete_flag%type,
220: p_autorule_duration_processed IN
221: ra_customer_trx_lines.autorule_duration_processed%type,
222: p_reason_code IN
223: ra_customer_trx_lines.reason_code%type,
224: p_last_period_to_credit IN
225: ra_customer_trx_lines.last_period_to_credit%type,
226: p_sales_order IN
227: ra_customer_trx_lines.sales_order%type,
221: ra_customer_trx_lines.autorule_duration_processed%type,
222: p_reason_code IN
223: ra_customer_trx_lines.reason_code%type,
224: p_last_period_to_credit IN
225: ra_customer_trx_lines.last_period_to_credit%type,
226: p_sales_order IN
227: ra_customer_trx_lines.sales_order%type,
228: p_sales_order_date IN
229: ra_customer_trx_lines.sales_order_date%type,
223: ra_customer_trx_lines.reason_code%type,
224: p_last_period_to_credit IN
225: ra_customer_trx_lines.last_period_to_credit%type,
226: p_sales_order IN
227: ra_customer_trx_lines.sales_order%type,
228: p_sales_order_date IN
229: ra_customer_trx_lines.sales_order_date%type,
230: p_sales_order_line IN
231: ra_customer_trx_lines.sales_order_line%type,
225: ra_customer_trx_lines.last_period_to_credit%type,
226: p_sales_order IN
227: ra_customer_trx_lines.sales_order%type,
228: p_sales_order_date IN
229: ra_customer_trx_lines.sales_order_date%type,
230: p_sales_order_line IN
231: ra_customer_trx_lines.sales_order_line%type,
232: p_sales_order_revision IN
233: ra_customer_trx_lines.sales_order_revision%type,
227: ra_customer_trx_lines.sales_order%type,
228: p_sales_order_date IN
229: ra_customer_trx_lines.sales_order_date%type,
230: p_sales_order_line IN
231: ra_customer_trx_lines.sales_order_line%type,
232: p_sales_order_revision IN
233: ra_customer_trx_lines.sales_order_revision%type,
234: p_sales_order_source IN
235: ra_customer_trx_lines.sales_order_source%type,
229: ra_customer_trx_lines.sales_order_date%type,
230: p_sales_order_line IN
231: ra_customer_trx_lines.sales_order_line%type,
232: p_sales_order_revision IN
233: ra_customer_trx_lines.sales_order_revision%type,
234: p_sales_order_source IN
235: ra_customer_trx_lines.sales_order_source%type,
236: p_vat_tax_id IN
237: ra_customer_trx_lines.vat_tax_id%type,
231: ra_customer_trx_lines.sales_order_line%type,
232: p_sales_order_revision IN
233: ra_customer_trx_lines.sales_order_revision%type,
234: p_sales_order_source IN
235: ra_customer_trx_lines.sales_order_source%type,
236: p_vat_tax_id IN
237: ra_customer_trx_lines.vat_tax_id%type,
238: p_tax_exempt_flag IN
239: ra_customer_trx_lines.tax_exempt_flag%type,
233: ra_customer_trx_lines.sales_order_revision%type,
234: p_sales_order_source IN
235: ra_customer_trx_lines.sales_order_source%type,
236: p_vat_tax_id IN
237: ra_customer_trx_lines.vat_tax_id%type,
238: p_tax_exempt_flag IN
239: ra_customer_trx_lines.tax_exempt_flag%type,
240: p_sales_tax_id IN
241: ra_customer_trx_lines.sales_tax_id%type,
235: ra_customer_trx_lines.sales_order_source%type,
236: p_vat_tax_id IN
237: ra_customer_trx_lines.vat_tax_id%type,
238: p_tax_exempt_flag IN
239: ra_customer_trx_lines.tax_exempt_flag%type,
240: p_sales_tax_id IN
241: ra_customer_trx_lines.sales_tax_id%type,
242: p_location_segment_id IN
243: ra_customer_trx_lines.location_segment_id%type,
237: ra_customer_trx_lines.vat_tax_id%type,
238: p_tax_exempt_flag IN
239: ra_customer_trx_lines.tax_exempt_flag%type,
240: p_sales_tax_id IN
241: ra_customer_trx_lines.sales_tax_id%type,
242: p_location_segment_id IN
243: ra_customer_trx_lines.location_segment_id%type,
244: p_tax_exempt_number IN
245: ra_customer_trx_lines.tax_exempt_number%type,
239: ra_customer_trx_lines.tax_exempt_flag%type,
240: p_sales_tax_id IN
241: ra_customer_trx_lines.sales_tax_id%type,
242: p_location_segment_id IN
243: ra_customer_trx_lines.location_segment_id%type,
244: p_tax_exempt_number IN
245: ra_customer_trx_lines.tax_exempt_number%type,
246: p_tax_exempt_reason_code IN
247: ra_customer_trx_lines.tax_exempt_reason_code%type,
241: ra_customer_trx_lines.sales_tax_id%type,
242: p_location_segment_id IN
243: ra_customer_trx_lines.location_segment_id%type,
244: p_tax_exempt_number IN
245: ra_customer_trx_lines.tax_exempt_number%type,
246: p_tax_exempt_reason_code IN
247: ra_customer_trx_lines.tax_exempt_reason_code%type,
248: p_tax_vendor_return_code IN
249: ra_customer_trx_lines.tax_vendor_return_code%type,
243: ra_customer_trx_lines.location_segment_id%type,
244: p_tax_exempt_number IN
245: ra_customer_trx_lines.tax_exempt_number%type,
246: p_tax_exempt_reason_code IN
247: ra_customer_trx_lines.tax_exempt_reason_code%type,
248: p_tax_vendor_return_code IN
249: ra_customer_trx_lines.tax_vendor_return_code%type,
250: p_taxable_flag IN
251: ra_customer_trx_lines.taxable_flag%type,
245: ra_customer_trx_lines.tax_exempt_number%type,
246: p_tax_exempt_reason_code IN
247: ra_customer_trx_lines.tax_exempt_reason_code%type,
248: p_tax_vendor_return_code IN
249: ra_customer_trx_lines.tax_vendor_return_code%type,
250: p_taxable_flag IN
251: ra_customer_trx_lines.taxable_flag%type,
252: p_tax_exemption_id IN
253: ra_customer_trx_lines.tax_exemption_id%type,
247: ra_customer_trx_lines.tax_exempt_reason_code%type,
248: p_tax_vendor_return_code IN
249: ra_customer_trx_lines.tax_vendor_return_code%type,
250: p_taxable_flag IN
251: ra_customer_trx_lines.taxable_flag%type,
252: p_tax_exemption_id IN
253: ra_customer_trx_lines.tax_exemption_id%type,
254: p_tax_precedence IN
255: ra_customer_trx_lines.tax_precedence%type,
249: ra_customer_trx_lines.tax_vendor_return_code%type,
250: p_taxable_flag IN
251: ra_customer_trx_lines.taxable_flag%type,
252: p_tax_exemption_id IN
253: ra_customer_trx_lines.tax_exemption_id%type,
254: p_tax_precedence IN
255: ra_customer_trx_lines.tax_precedence%type,
256: p_tax_rate IN
257: ra_customer_trx_lines.tax_rate%type,
251: ra_customer_trx_lines.taxable_flag%type,
252: p_tax_exemption_id IN
253: ra_customer_trx_lines.tax_exemption_id%type,
254: p_tax_precedence IN
255: ra_customer_trx_lines.tax_precedence%type,
256: p_tax_rate IN
257: ra_customer_trx_lines.tax_rate%type,
258: p_uom_code IN
259: ra_customer_trx_lines.uom_code%type,
253: ra_customer_trx_lines.tax_exemption_id%type,
254: p_tax_precedence IN
255: ra_customer_trx_lines.tax_precedence%type,
256: p_tax_rate IN
257: ra_customer_trx_lines.tax_rate%type,
258: p_uom_code IN
259: ra_customer_trx_lines.uom_code%type,
260: p_autotax IN
261: ra_customer_trx_lines.autotax%type,
255: ra_customer_trx_lines.tax_precedence%type,
256: p_tax_rate IN
257: ra_customer_trx_lines.tax_rate%type,
258: p_uom_code IN
259: ra_customer_trx_lines.uom_code%type,
260: p_autotax IN
261: ra_customer_trx_lines.autotax%type,
262: p_movement_id IN
263: ra_customer_trx_lines.movement_id%type,
257: ra_customer_trx_lines.tax_rate%type,
258: p_uom_code IN
259: ra_customer_trx_lines.uom_code%type,
260: p_autotax IN
261: ra_customer_trx_lines.autotax%type,
262: p_movement_id IN
263: ra_customer_trx_lines.movement_id%type,
264: p_default_ussgl_trx_code IN
265: ra_customer_trx_lines.default_ussgl_transaction_code%type,
259: ra_customer_trx_lines.uom_code%type,
260: p_autotax IN
261: ra_customer_trx_lines.autotax%type,
262: p_movement_id IN
263: ra_customer_trx_lines.movement_id%type,
264: p_default_ussgl_trx_code IN
265: ra_customer_trx_lines.default_ussgl_transaction_code%type,
266: p_default_ussgl_trx_code_cntxt IN
267: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
261: ra_customer_trx_lines.autotax%type,
262: p_movement_id IN
263: ra_customer_trx_lines.movement_id%type,
264: p_default_ussgl_trx_code IN
265: ra_customer_trx_lines.default_ussgl_transaction_code%type,
266: p_default_ussgl_trx_code_cntxt IN
267: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
268: p_interface_line_context IN
269: ra_customer_trx_lines.interface_line_context%type,
263: ra_customer_trx_lines.movement_id%type,
264: p_default_ussgl_trx_code IN
265: ra_customer_trx_lines.default_ussgl_transaction_code%type,
266: p_default_ussgl_trx_code_cntxt IN
267: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
268: p_interface_line_context IN
269: ra_customer_trx_lines.interface_line_context%type,
270: p_interface_line_attribute1 IN
271: ra_customer_trx_lines.interface_line_attribute1%type,
265: ra_customer_trx_lines.default_ussgl_transaction_code%type,
266: p_default_ussgl_trx_code_cntxt IN
267: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
268: p_interface_line_context IN
269: ra_customer_trx_lines.interface_line_context%type,
270: p_interface_line_attribute1 IN
271: ra_customer_trx_lines.interface_line_attribute1%type,
272: p_interface_line_attribute2 IN
273: ra_customer_trx_lines.interface_line_attribute2%type,
267: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
268: p_interface_line_context IN
269: ra_customer_trx_lines.interface_line_context%type,
270: p_interface_line_attribute1 IN
271: ra_customer_trx_lines.interface_line_attribute1%type,
272: p_interface_line_attribute2 IN
273: ra_customer_trx_lines.interface_line_attribute2%type,
274: p_interface_line_attribute3 IN
275: ra_customer_trx_lines.interface_line_attribute3%type,
269: ra_customer_trx_lines.interface_line_context%type,
270: p_interface_line_attribute1 IN
271: ra_customer_trx_lines.interface_line_attribute1%type,
272: p_interface_line_attribute2 IN
273: ra_customer_trx_lines.interface_line_attribute2%type,
274: p_interface_line_attribute3 IN
275: ra_customer_trx_lines.interface_line_attribute3%type,
276: p_interface_line_attribute4 IN
277: ra_customer_trx_lines.interface_line_attribute4%type,
271: ra_customer_trx_lines.interface_line_attribute1%type,
272: p_interface_line_attribute2 IN
273: ra_customer_trx_lines.interface_line_attribute2%type,
274: p_interface_line_attribute3 IN
275: ra_customer_trx_lines.interface_line_attribute3%type,
276: p_interface_line_attribute4 IN
277: ra_customer_trx_lines.interface_line_attribute4%type,
278: p_interface_line_attribute5 IN
279: ra_customer_trx_lines.interface_line_attribute5%type,
273: ra_customer_trx_lines.interface_line_attribute2%type,
274: p_interface_line_attribute3 IN
275: ra_customer_trx_lines.interface_line_attribute3%type,
276: p_interface_line_attribute4 IN
277: ra_customer_trx_lines.interface_line_attribute4%type,
278: p_interface_line_attribute5 IN
279: ra_customer_trx_lines.interface_line_attribute5%type,
280: p_interface_line_attribute6 IN
281: ra_customer_trx_lines.interface_line_attribute6%type,
275: ra_customer_trx_lines.interface_line_attribute3%type,
276: p_interface_line_attribute4 IN
277: ra_customer_trx_lines.interface_line_attribute4%type,
278: p_interface_line_attribute5 IN
279: ra_customer_trx_lines.interface_line_attribute5%type,
280: p_interface_line_attribute6 IN
281: ra_customer_trx_lines.interface_line_attribute6%type,
282: p_interface_line_attribute7 IN
283: ra_customer_trx_lines.interface_line_attribute7%type,
277: ra_customer_trx_lines.interface_line_attribute4%type,
278: p_interface_line_attribute5 IN
279: ra_customer_trx_lines.interface_line_attribute5%type,
280: p_interface_line_attribute6 IN
281: ra_customer_trx_lines.interface_line_attribute6%type,
282: p_interface_line_attribute7 IN
283: ra_customer_trx_lines.interface_line_attribute7%type,
284: p_interface_line_attribute8 IN
285: ra_customer_trx_lines.interface_line_attribute8%type,
279: ra_customer_trx_lines.interface_line_attribute5%type,
280: p_interface_line_attribute6 IN
281: ra_customer_trx_lines.interface_line_attribute6%type,
282: p_interface_line_attribute7 IN
283: ra_customer_trx_lines.interface_line_attribute7%type,
284: p_interface_line_attribute8 IN
285: ra_customer_trx_lines.interface_line_attribute8%type,
286: p_interface_line_attribute9 IN
287: ra_customer_trx_lines.interface_line_attribute9%type,
281: ra_customer_trx_lines.interface_line_attribute6%type,
282: p_interface_line_attribute7 IN
283: ra_customer_trx_lines.interface_line_attribute7%type,
284: p_interface_line_attribute8 IN
285: ra_customer_trx_lines.interface_line_attribute8%type,
286: p_interface_line_attribute9 IN
287: ra_customer_trx_lines.interface_line_attribute9%type,
288: p_interface_line_attribute10 IN
289: ra_customer_trx_lines.interface_line_attribute10%type,
283: ra_customer_trx_lines.interface_line_attribute7%type,
284: p_interface_line_attribute8 IN
285: ra_customer_trx_lines.interface_line_attribute8%type,
286: p_interface_line_attribute9 IN
287: ra_customer_trx_lines.interface_line_attribute9%type,
288: p_interface_line_attribute10 IN
289: ra_customer_trx_lines.interface_line_attribute10%type,
290: p_interface_line_attribute11 IN
291: ra_customer_trx_lines.interface_line_attribute11%type,
285: ra_customer_trx_lines.interface_line_attribute8%type,
286: p_interface_line_attribute9 IN
287: ra_customer_trx_lines.interface_line_attribute9%type,
288: p_interface_line_attribute10 IN
289: ra_customer_trx_lines.interface_line_attribute10%type,
290: p_interface_line_attribute11 IN
291: ra_customer_trx_lines.interface_line_attribute11%type,
292: p_interface_line_attribute12 IN
293: ra_customer_trx_lines.interface_line_attribute12%type,
287: ra_customer_trx_lines.interface_line_attribute9%type,
288: p_interface_line_attribute10 IN
289: ra_customer_trx_lines.interface_line_attribute10%type,
290: p_interface_line_attribute11 IN
291: ra_customer_trx_lines.interface_line_attribute11%type,
292: p_interface_line_attribute12 IN
293: ra_customer_trx_lines.interface_line_attribute12%type,
294: p_interface_line_attribute13 IN
295: ra_customer_trx_lines.interface_line_attribute13%type,
289: ra_customer_trx_lines.interface_line_attribute10%type,
290: p_interface_line_attribute11 IN
291: ra_customer_trx_lines.interface_line_attribute11%type,
292: p_interface_line_attribute12 IN
293: ra_customer_trx_lines.interface_line_attribute12%type,
294: p_interface_line_attribute13 IN
295: ra_customer_trx_lines.interface_line_attribute13%type,
296: p_interface_line_attribute14 IN
297: ra_customer_trx_lines.interface_line_attribute14%type,
291: ra_customer_trx_lines.interface_line_attribute11%type,
292: p_interface_line_attribute12 IN
293: ra_customer_trx_lines.interface_line_attribute12%type,
294: p_interface_line_attribute13 IN
295: ra_customer_trx_lines.interface_line_attribute13%type,
296: p_interface_line_attribute14 IN
297: ra_customer_trx_lines.interface_line_attribute14%type,
298: p_interface_line_attribute15 IN
299: ra_customer_trx_lines.interface_line_attribute15%type,
293: ra_customer_trx_lines.interface_line_attribute12%type,
294: p_interface_line_attribute13 IN
295: ra_customer_trx_lines.interface_line_attribute13%type,
296: p_interface_line_attribute14 IN
297: ra_customer_trx_lines.interface_line_attribute14%type,
298: p_interface_line_attribute15 IN
299: ra_customer_trx_lines.interface_line_attribute15%type,
300: p_attribute_category IN
301: ra_customer_trx_lines.attribute_category%type,
295: ra_customer_trx_lines.interface_line_attribute13%type,
296: p_interface_line_attribute14 IN
297: ra_customer_trx_lines.interface_line_attribute14%type,
298: p_interface_line_attribute15 IN
299: ra_customer_trx_lines.interface_line_attribute15%type,
300: p_attribute_category IN
301: ra_customer_trx_lines.attribute_category%type,
302: p_attribute1 IN
303: ra_customer_trx_lines.attribute1%type,
297: ra_customer_trx_lines.interface_line_attribute14%type,
298: p_interface_line_attribute15 IN
299: ra_customer_trx_lines.interface_line_attribute15%type,
300: p_attribute_category IN
301: ra_customer_trx_lines.attribute_category%type,
302: p_attribute1 IN
303: ra_customer_trx_lines.attribute1%type,
304: p_attribute2 IN
305: ra_customer_trx_lines.attribute2%type,
299: ra_customer_trx_lines.interface_line_attribute15%type,
300: p_attribute_category IN
301: ra_customer_trx_lines.attribute_category%type,
302: p_attribute1 IN
303: ra_customer_trx_lines.attribute1%type,
304: p_attribute2 IN
305: ra_customer_trx_lines.attribute2%type,
306: p_attribute3 IN
307: ra_customer_trx_lines.attribute3%type,
301: ra_customer_trx_lines.attribute_category%type,
302: p_attribute1 IN
303: ra_customer_trx_lines.attribute1%type,
304: p_attribute2 IN
305: ra_customer_trx_lines.attribute2%type,
306: p_attribute3 IN
307: ra_customer_trx_lines.attribute3%type,
308: p_attribute4 IN
309: ra_customer_trx_lines.attribute4%type,
303: ra_customer_trx_lines.attribute1%type,
304: p_attribute2 IN
305: ra_customer_trx_lines.attribute2%type,
306: p_attribute3 IN
307: ra_customer_trx_lines.attribute3%type,
308: p_attribute4 IN
309: ra_customer_trx_lines.attribute4%type,
310: p_attribute5 IN
311: ra_customer_trx_lines.attribute5%type,
305: ra_customer_trx_lines.attribute2%type,
306: p_attribute3 IN
307: ra_customer_trx_lines.attribute3%type,
308: p_attribute4 IN
309: ra_customer_trx_lines.attribute4%type,
310: p_attribute5 IN
311: ra_customer_trx_lines.attribute5%type,
312: p_attribute6 IN
313: ra_customer_trx_lines.attribute6%type,
307: ra_customer_trx_lines.attribute3%type,
308: p_attribute4 IN
309: ra_customer_trx_lines.attribute4%type,
310: p_attribute5 IN
311: ra_customer_trx_lines.attribute5%type,
312: p_attribute6 IN
313: ra_customer_trx_lines.attribute6%type,
314: p_attribute7 IN
315: ra_customer_trx_lines.attribute7%type,
309: ra_customer_trx_lines.attribute4%type,
310: p_attribute5 IN
311: ra_customer_trx_lines.attribute5%type,
312: p_attribute6 IN
313: ra_customer_trx_lines.attribute6%type,
314: p_attribute7 IN
315: ra_customer_trx_lines.attribute7%type,
316: p_attribute8 IN
317: ra_customer_trx_lines.attribute8%type,
311: ra_customer_trx_lines.attribute5%type,
312: p_attribute6 IN
313: ra_customer_trx_lines.attribute6%type,
314: p_attribute7 IN
315: ra_customer_trx_lines.attribute7%type,
316: p_attribute8 IN
317: ra_customer_trx_lines.attribute8%type,
318: p_attribute9 IN
319: ra_customer_trx_lines.attribute9%type,
313: ra_customer_trx_lines.attribute6%type,
314: p_attribute7 IN
315: ra_customer_trx_lines.attribute7%type,
316: p_attribute8 IN
317: ra_customer_trx_lines.attribute8%type,
318: p_attribute9 IN
319: ra_customer_trx_lines.attribute9%type,
320: p_attribute10 IN
321: ra_customer_trx_lines.attribute10%type,
315: ra_customer_trx_lines.attribute7%type,
316: p_attribute8 IN
317: ra_customer_trx_lines.attribute8%type,
318: p_attribute9 IN
319: ra_customer_trx_lines.attribute9%type,
320: p_attribute10 IN
321: ra_customer_trx_lines.attribute10%type,
322: p_attribute11 IN
323: ra_customer_trx_lines.attribute11%type,
317: ra_customer_trx_lines.attribute8%type,
318: p_attribute9 IN
319: ra_customer_trx_lines.attribute9%type,
320: p_attribute10 IN
321: ra_customer_trx_lines.attribute10%type,
322: p_attribute11 IN
323: ra_customer_trx_lines.attribute11%type,
324: p_attribute12 IN
325: ra_customer_trx_lines.attribute12%type,
319: ra_customer_trx_lines.attribute9%type,
320: p_attribute10 IN
321: ra_customer_trx_lines.attribute10%type,
322: p_attribute11 IN
323: ra_customer_trx_lines.attribute11%type,
324: p_attribute12 IN
325: ra_customer_trx_lines.attribute12%type,
326: p_attribute13 IN
327: ra_customer_trx_lines.attribute13%type,
321: ra_customer_trx_lines.attribute10%type,
322: p_attribute11 IN
323: ra_customer_trx_lines.attribute11%type,
324: p_attribute12 IN
325: ra_customer_trx_lines.attribute12%type,
326: p_attribute13 IN
327: ra_customer_trx_lines.attribute13%type,
328: p_attribute14 IN
329: ra_customer_trx_lines.attribute14%type,
323: ra_customer_trx_lines.attribute11%type,
324: p_attribute12 IN
325: ra_customer_trx_lines.attribute12%type,
326: p_attribute13 IN
327: ra_customer_trx_lines.attribute13%type,
328: p_attribute14 IN
329: ra_customer_trx_lines.attribute14%type,
330: p_attribute15 IN
331: ra_customer_trx_lines.attribute15%type,
325: ra_customer_trx_lines.attribute12%type,
326: p_attribute13 IN
327: ra_customer_trx_lines.attribute13%type,
328: p_attribute14 IN
329: ra_customer_trx_lines.attribute14%type,
330: p_attribute15 IN
331: ra_customer_trx_lines.attribute15%type,
332: p_customer_trx_line_id OUT NOCOPY
333: ra_customer_trx_lines.customer_trx_line_id%type,
327: ra_customer_trx_lines.attribute13%type,
328: p_attribute14 IN
329: ra_customer_trx_lines.attribute14%type,
330: p_attribute15 IN
331: ra_customer_trx_lines.attribute15%type,
332: p_customer_trx_line_id OUT NOCOPY
333: ra_customer_trx_lines.customer_trx_line_id%type,
334: p_gl_date IN OUT NOCOPY
335: ra_cust_trx_line_gl_dist.gl_date%type,
329: ra_customer_trx_lines.attribute14%type,
330: p_attribute15 IN
331: ra_customer_trx_lines.attribute15%type,
332: p_customer_trx_line_id OUT NOCOPY
333: ra_customer_trx_lines.customer_trx_line_id%type,
334: p_gl_date IN OUT NOCOPY
335: ra_cust_trx_line_gl_dist.gl_date%type,
336: p_trx_date IN OUT NOCOPY
337: ra_customer_trx.trx_date%type,
339: ra_customer_trx.invoice_currency_code%type,
340: p_header_exchange_rate IN
341: ra_customer_trx.exchange_rate%type,
342: p_amount_includes_tax_flag IN
343: ra_customer_trx_lines.amount_includes_tax_flag%type,
344: p_net_extended_amount OUT NOCOPY
345: ra_customer_trx_lines.extended_amount%type,
346: p_net_unit_selling_price OUT NOCOPY
347: ra_customer_trx_lines.unit_selling_price%type,
341: ra_customer_trx.exchange_rate%type,
342: p_amount_includes_tax_flag IN
343: ra_customer_trx_lines.amount_includes_tax_flag%type,
344: p_net_extended_amount OUT NOCOPY
345: ra_customer_trx_lines.extended_amount%type,
346: p_net_unit_selling_price OUT NOCOPY
347: ra_customer_trx_lines.unit_selling_price%type,
348: p_status OUT NOCOPY
349: varchar2 ,
343: ra_customer_trx_lines.amount_includes_tax_flag%type,
344: p_net_extended_amount OUT NOCOPY
345: ra_customer_trx_lines.extended_amount%type,
346: p_net_unit_selling_price OUT NOCOPY
347: ra_customer_trx_lines.unit_selling_price%type,
348: p_status OUT NOCOPY
349: varchar2 ,
350: p_global_attribute_category IN
351: ra_customer_trx_lines.global_attribute_category%type,
347: ra_customer_trx_lines.unit_selling_price%type,
348: p_status OUT NOCOPY
349: varchar2 ,
350: p_global_attribute_category IN
351: ra_customer_trx_lines.global_attribute_category%type,
352: p_global_attribute1 IN
353: ra_customer_trx_lines.global_attribute1%type,
354: p_global_attribute2 IN
355: ra_customer_trx_lines.global_attribute2%type,
349: varchar2 ,
350: p_global_attribute_category IN
351: ra_customer_trx_lines.global_attribute_category%type,
352: p_global_attribute1 IN
353: ra_customer_trx_lines.global_attribute1%type,
354: p_global_attribute2 IN
355: ra_customer_trx_lines.global_attribute2%type,
356: p_global_attribute3 IN
357: ra_customer_trx_lines.global_attribute3%type,
351: ra_customer_trx_lines.global_attribute_category%type,
352: p_global_attribute1 IN
353: ra_customer_trx_lines.global_attribute1%type,
354: p_global_attribute2 IN
355: ra_customer_trx_lines.global_attribute2%type,
356: p_global_attribute3 IN
357: ra_customer_trx_lines.global_attribute3%type,
358: p_global_attribute4 IN
359: ra_customer_trx_lines.global_attribute4%type,
353: ra_customer_trx_lines.global_attribute1%type,
354: p_global_attribute2 IN
355: ra_customer_trx_lines.global_attribute2%type,
356: p_global_attribute3 IN
357: ra_customer_trx_lines.global_attribute3%type,
358: p_global_attribute4 IN
359: ra_customer_trx_lines.global_attribute4%type,
360: p_global_attribute5 IN
361: ra_customer_trx_lines.global_attribute5%type,
355: ra_customer_trx_lines.global_attribute2%type,
356: p_global_attribute3 IN
357: ra_customer_trx_lines.global_attribute3%type,
358: p_global_attribute4 IN
359: ra_customer_trx_lines.global_attribute4%type,
360: p_global_attribute5 IN
361: ra_customer_trx_lines.global_attribute5%type,
362: p_global_attribute6 IN
363: ra_customer_trx_lines.global_attribute6%type,
357: ra_customer_trx_lines.global_attribute3%type,
358: p_global_attribute4 IN
359: ra_customer_trx_lines.global_attribute4%type,
360: p_global_attribute5 IN
361: ra_customer_trx_lines.global_attribute5%type,
362: p_global_attribute6 IN
363: ra_customer_trx_lines.global_attribute6%type,
364: p_global_attribute7 IN
365: ra_customer_trx_lines.global_attribute7%type,
359: ra_customer_trx_lines.global_attribute4%type,
360: p_global_attribute5 IN
361: ra_customer_trx_lines.global_attribute5%type,
362: p_global_attribute6 IN
363: ra_customer_trx_lines.global_attribute6%type,
364: p_global_attribute7 IN
365: ra_customer_trx_lines.global_attribute7%type,
366: p_global_attribute8 IN
367: ra_customer_trx_lines.global_attribute8%type,
361: ra_customer_trx_lines.global_attribute5%type,
362: p_global_attribute6 IN
363: ra_customer_trx_lines.global_attribute6%type,
364: p_global_attribute7 IN
365: ra_customer_trx_lines.global_attribute7%type,
366: p_global_attribute8 IN
367: ra_customer_trx_lines.global_attribute8%type,
368: p_global_attribute9 IN
369: ra_customer_trx_lines.global_attribute9%type,
363: ra_customer_trx_lines.global_attribute6%type,
364: p_global_attribute7 IN
365: ra_customer_trx_lines.global_attribute7%type,
366: p_global_attribute8 IN
367: ra_customer_trx_lines.global_attribute8%type,
368: p_global_attribute9 IN
369: ra_customer_trx_lines.global_attribute9%type,
370: p_global_attribute10 IN
371: ra_customer_trx_lines.global_attribute10%type,
365: ra_customer_trx_lines.global_attribute7%type,
366: p_global_attribute8 IN
367: ra_customer_trx_lines.global_attribute8%type,
368: p_global_attribute9 IN
369: ra_customer_trx_lines.global_attribute9%type,
370: p_global_attribute10 IN
371: ra_customer_trx_lines.global_attribute10%type,
372: p_global_attribute11 IN
373: ra_customer_trx_lines.global_attribute11%type,
367: ra_customer_trx_lines.global_attribute8%type,
368: p_global_attribute9 IN
369: ra_customer_trx_lines.global_attribute9%type,
370: p_global_attribute10 IN
371: ra_customer_trx_lines.global_attribute10%type,
372: p_global_attribute11 IN
373: ra_customer_trx_lines.global_attribute11%type,
374: p_global_attribute12 IN
375: ra_customer_trx_lines.global_attribute12%type,
369: ra_customer_trx_lines.global_attribute9%type,
370: p_global_attribute10 IN
371: ra_customer_trx_lines.global_attribute10%type,
372: p_global_attribute11 IN
373: ra_customer_trx_lines.global_attribute11%type,
374: p_global_attribute12 IN
375: ra_customer_trx_lines.global_attribute12%type,
376: p_global_attribute13 IN
377: ra_customer_trx_lines.global_attribute13%type,
371: ra_customer_trx_lines.global_attribute10%type,
372: p_global_attribute11 IN
373: ra_customer_trx_lines.global_attribute11%type,
374: p_global_attribute12 IN
375: ra_customer_trx_lines.global_attribute12%type,
376: p_global_attribute13 IN
377: ra_customer_trx_lines.global_attribute13%type,
378: p_global_attribute14 IN
379: ra_customer_trx_lines.global_attribute14%type,
373: ra_customer_trx_lines.global_attribute11%type,
374: p_global_attribute12 IN
375: ra_customer_trx_lines.global_attribute12%type,
376: p_global_attribute13 IN
377: ra_customer_trx_lines.global_attribute13%type,
378: p_global_attribute14 IN
379: ra_customer_trx_lines.global_attribute14%type,
380: p_global_attribute15 IN
381: ra_customer_trx_lines.global_attribute15%type,
375: ra_customer_trx_lines.global_attribute12%type,
376: p_global_attribute13 IN
377: ra_customer_trx_lines.global_attribute13%type,
378: p_global_attribute14 IN
379: ra_customer_trx_lines.global_attribute14%type,
380: p_global_attribute15 IN
381: ra_customer_trx_lines.global_attribute15%type,
382: p_global_attribute16 IN
383: ra_customer_trx_lines.global_attribute16%type,
377: ra_customer_trx_lines.global_attribute13%type,
378: p_global_attribute14 IN
379: ra_customer_trx_lines.global_attribute14%type,
380: p_global_attribute15 IN
381: ra_customer_trx_lines.global_attribute15%type,
382: p_global_attribute16 IN
383: ra_customer_trx_lines.global_attribute16%type,
384: p_global_attribute17 IN
385: ra_customer_trx_lines.global_attribute17%type,
379: ra_customer_trx_lines.global_attribute14%type,
380: p_global_attribute15 IN
381: ra_customer_trx_lines.global_attribute15%type,
382: p_global_attribute16 IN
383: ra_customer_trx_lines.global_attribute16%type,
384: p_global_attribute17 IN
385: ra_customer_trx_lines.global_attribute17%type,
386: p_global_attribute18 IN
387: ra_customer_trx_lines.global_attribute18%type,
381: ra_customer_trx_lines.global_attribute15%type,
382: p_global_attribute16 IN
383: ra_customer_trx_lines.global_attribute16%type,
384: p_global_attribute17 IN
385: ra_customer_trx_lines.global_attribute17%type,
386: p_global_attribute18 IN
387: ra_customer_trx_lines.global_attribute18%type,
388: p_global_attribute19 IN
389: ra_customer_trx_lines.global_attribute19%type,
383: ra_customer_trx_lines.global_attribute16%type,
384: p_global_attribute17 IN
385: ra_customer_trx_lines.global_attribute17%type,
386: p_global_attribute18 IN
387: ra_customer_trx_lines.global_attribute18%type,
388: p_global_attribute19 IN
389: ra_customer_trx_lines.global_attribute19%type,
390: p_global_attribute20 IN
391: ra_customer_trx_lines.global_attribute20%type,
385: ra_customer_trx_lines.global_attribute17%type,
386: p_global_attribute18 IN
387: ra_customer_trx_lines.global_attribute18%type,
388: p_global_attribute19 IN
389: ra_customer_trx_lines.global_attribute19%type,
390: p_global_attribute20 IN
391: ra_customer_trx_lines.global_attribute20%type,
392: p_warehouse_id IN
393: ra_customer_trx_lines.warehouse_id%type,
387: ra_customer_trx_lines.global_attribute18%type,
388: p_global_attribute19 IN
389: ra_customer_trx_lines.global_attribute19%type,
390: p_global_attribute20 IN
391: ra_customer_trx_lines.global_attribute20%type,
392: p_warehouse_id IN
393: ra_customer_trx_lines.warehouse_id%type,
394: p_translated_description IN
395: ra_customer_trx_lines.translated_description%type,
389: ra_customer_trx_lines.global_attribute19%type,
390: p_global_attribute20 IN
391: ra_customer_trx_lines.global_attribute20%type,
392: p_warehouse_id IN
393: ra_customer_trx_lines.warehouse_id%type,
394: p_translated_description IN
395: ra_customer_trx_lines.translated_description%type,
396: p_payment_set_id IN ra_customer_trx_lines.payment_set_id%type,
397: p_ship_to_customer_id IN
391: ra_customer_trx_lines.global_attribute20%type,
392: p_warehouse_id IN
393: ra_customer_trx_lines.warehouse_id%type,
394: p_translated_description IN
395: ra_customer_trx_lines.translated_description%type,
396: p_payment_set_id IN ra_customer_trx_lines.payment_set_id%type,
397: p_ship_to_customer_id IN
398: ra_customer_trx_lines.ship_to_customer_id%type DEFAULT NULL,
399: p_ship_to_site_use_id IN
392: p_warehouse_id IN
393: ra_customer_trx_lines.warehouse_id%type,
394: p_translated_description IN
395: ra_customer_trx_lines.translated_description%type,
396: p_payment_set_id IN ra_customer_trx_lines.payment_set_id%type,
397: p_ship_to_customer_id IN
398: ra_customer_trx_lines.ship_to_customer_id%type DEFAULT NULL,
399: p_ship_to_site_use_id IN
400: ra_customer_trx_lines.ship_to_site_use_id%type DEFAULT NULL,
394: p_translated_description IN
395: ra_customer_trx_lines.translated_description%type,
396: p_payment_set_id IN ra_customer_trx_lines.payment_set_id%type,
397: p_ship_to_customer_id IN
398: ra_customer_trx_lines.ship_to_customer_id%type DEFAULT NULL,
399: p_ship_to_site_use_id IN
400: ra_customer_trx_lines.ship_to_site_use_id%type DEFAULT NULL,
401: p_ship_to_contact_id IN
402: ra_customer_trx_lines.ship_to_contact_id%type DEFAULT NULL,
396: p_payment_set_id IN ra_customer_trx_lines.payment_set_id%type,
397: p_ship_to_customer_id IN
398: ra_customer_trx_lines.ship_to_customer_id%type DEFAULT NULL,
399: p_ship_to_site_use_id IN
400: ra_customer_trx_lines.ship_to_site_use_id%type DEFAULT NULL,
401: p_ship_to_contact_id IN
402: ra_customer_trx_lines.ship_to_contact_id%type DEFAULT NULL,
403: p_tax_classification_code IN
404: ra_customer_trx_lines.tax_classification_code%type DEFAULT NULL,
398: ra_customer_trx_lines.ship_to_customer_id%type DEFAULT NULL,
399: p_ship_to_site_use_id IN
400: ra_customer_trx_lines.ship_to_site_use_id%type DEFAULT NULL,
401: p_ship_to_contact_id IN
402: ra_customer_trx_lines.ship_to_contact_id%type DEFAULT NULL,
403: p_tax_classification_code IN
404: ra_customer_trx_lines.tax_classification_code%type DEFAULT NULL,
405: p_rule_end_date IN
406: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL
400: ra_customer_trx_lines.ship_to_site_use_id%type DEFAULT NULL,
401: p_ship_to_contact_id IN
402: ra_customer_trx_lines.ship_to_contact_id%type DEFAULT NULL,
403: p_tax_classification_code IN
404: ra_customer_trx_lines.tax_classification_code%type DEFAULT NULL,
405: p_rule_end_date IN
406: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL
407: )
408: IS
402: ra_customer_trx_lines.ship_to_contact_id%type DEFAULT NULL,
403: p_tax_classification_code IN
404: ra_customer_trx_lines.tax_classification_code%type DEFAULT NULL,
405: p_rule_end_date IN
406: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL
407: )
408: IS
409:
410: l_line_rec ra_customer_trx_lines%rowtype;
406: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL
407: )
408: IS
409:
410: l_line_rec ra_customer_trx_lines%rowtype;
411:
412: /* bug 3567353 */
413: l_error_message VARCHAR2(128) := '';
414: l_dist_count NUMBER;