165: varchar2,
166: p_form_version IN
167: number,
168: p_customer_trx_line_id IN
169: ra_customer_trx_lines.customer_trx_line_id%type,
170: p_complete_flag IN
171: ra_customer_trx.complete_flag%type,
172: p_recalculate_tax_flag IN
173: boolean,
167: number,
168: p_customer_trx_line_id IN
169: ra_customer_trx_lines.customer_trx_line_id%type,
170: p_complete_flag IN
171: ra_customer_trx.complete_flag%type,
172: p_recalculate_tax_flag IN
173: boolean,
174: p_trx_amount IN
175: number,
173: boolean,
174: p_trx_amount IN
175: number,
176: p_exchange_rate IN
177: ra_customer_trx.exchange_rate%type,
178: p_gl_date IN OUT NOCOPY
179: ra_cust_trx_line_gl_dist.gl_date%type,
180: p_trx_date IN OUT NOCOPY
181: ra_customer_trx.trx_date%type,
177: ra_customer_trx.exchange_rate%type,
178: p_gl_date IN OUT NOCOPY
179: ra_cust_trx_line_gl_dist.gl_date%type,
180: p_trx_date IN OUT NOCOPY
181: ra_customer_trx.trx_date%type,
182: p_customer_trx_id IN
183: ra_customer_trx_lines.customer_trx_id%type,
184: p_line_number IN
185: ra_customer_trx_lines.line_number%type,
179: ra_cust_trx_line_gl_dist.gl_date%type,
180: p_trx_date IN OUT NOCOPY
181: ra_customer_trx.trx_date%type,
182: p_customer_trx_id IN
183: ra_customer_trx_lines.customer_trx_id%type,
184: p_line_number IN
185: ra_customer_trx_lines.line_number%type,
186: p_line_type IN
187: ra_customer_trx_lines.line_type%type,
181: ra_customer_trx.trx_date%type,
182: p_customer_trx_id IN
183: ra_customer_trx_lines.customer_trx_id%type,
184: p_line_number IN
185: ra_customer_trx_lines.line_number%type,
186: p_line_type IN
187: ra_customer_trx_lines.line_type%type,
188: p_quantity_credited IN
189: ra_customer_trx_lines.quantity_credited%type,
183: ra_customer_trx_lines.customer_trx_id%type,
184: p_line_number IN
185: ra_customer_trx_lines.line_number%type,
186: p_line_type IN
187: ra_customer_trx_lines.line_type%type,
188: p_quantity_credited IN
189: ra_customer_trx_lines.quantity_credited%type,
190: p_quantity_invoiced IN
191: ra_customer_trx_lines.quantity_invoiced%type,
185: ra_customer_trx_lines.line_number%type,
186: p_line_type IN
187: ra_customer_trx_lines.line_type%type,
188: p_quantity_credited IN
189: ra_customer_trx_lines.quantity_credited%type,
190: p_quantity_invoiced IN
191: ra_customer_trx_lines.quantity_invoiced%type,
192: p_quantity_ordered IN
193: ra_customer_trx_lines.quantity_ordered%type,
187: ra_customer_trx_lines.line_type%type,
188: p_quantity_credited IN
189: ra_customer_trx_lines.quantity_credited%type,
190: p_quantity_invoiced IN
191: ra_customer_trx_lines.quantity_invoiced%type,
192: p_quantity_ordered IN
193: ra_customer_trx_lines.quantity_ordered%type,
194: p_unit_selling_price IN
195: ra_customer_trx_lines.unit_selling_price%type,
189: ra_customer_trx_lines.quantity_credited%type,
190: p_quantity_invoiced IN
191: ra_customer_trx_lines.quantity_invoiced%type,
192: p_quantity_ordered IN
193: ra_customer_trx_lines.quantity_ordered%type,
194: p_unit_selling_price IN
195: ra_customer_trx_lines.unit_selling_price%type,
196: p_unit_standard_price IN
197: ra_customer_trx_lines.unit_standard_price%type,
191: ra_customer_trx_lines.quantity_invoiced%type,
192: p_quantity_ordered IN
193: ra_customer_trx_lines.quantity_ordered%type,
194: p_unit_selling_price IN
195: ra_customer_trx_lines.unit_selling_price%type,
196: p_unit_standard_price IN
197: ra_customer_trx_lines.unit_standard_price%type,
198: p_revenue_amount IN
199: ra_customer_trx_lines.revenue_amount%type,
193: ra_customer_trx_lines.quantity_ordered%type,
194: p_unit_selling_price IN
195: ra_customer_trx_lines.unit_selling_price%type,
196: p_unit_standard_price IN
197: ra_customer_trx_lines.unit_standard_price%type,
198: p_revenue_amount IN
199: ra_customer_trx_lines.revenue_amount%type,
200: p_extended_amount IN
201: ra_customer_trx_lines.extended_amount%type,
195: ra_customer_trx_lines.unit_selling_price%type,
196: p_unit_standard_price IN
197: ra_customer_trx_lines.unit_standard_price%type,
198: p_revenue_amount IN
199: ra_customer_trx_lines.revenue_amount%type,
200: p_extended_amount IN
201: ra_customer_trx_lines.extended_amount%type,
202: p_memo_line_id IN
203: ra_customer_trx_lines.memo_line_id%type,
197: ra_customer_trx_lines.unit_standard_price%type,
198: p_revenue_amount IN
199: ra_customer_trx_lines.revenue_amount%type,
200: p_extended_amount IN
201: ra_customer_trx_lines.extended_amount%type,
202: p_memo_line_id IN
203: ra_customer_trx_lines.memo_line_id%type,
204: p_inventory_item_id IN
205: ra_customer_trx_lines.inventory_item_id%type,
199: ra_customer_trx_lines.revenue_amount%type,
200: p_extended_amount IN
201: ra_customer_trx_lines.extended_amount%type,
202: p_memo_line_id IN
203: ra_customer_trx_lines.memo_line_id%type,
204: p_inventory_item_id IN
205: ra_customer_trx_lines.inventory_item_id%type,
206: p_item_exception_rate_id IN
207: ra_customer_trx_lines.item_exception_rate_id%type,
201: ra_customer_trx_lines.extended_amount%type,
202: p_memo_line_id IN
203: ra_customer_trx_lines.memo_line_id%type,
204: p_inventory_item_id IN
205: ra_customer_trx_lines.inventory_item_id%type,
206: p_item_exception_rate_id IN
207: ra_customer_trx_lines.item_exception_rate_id%type,
208: p_description IN
209: ra_customer_trx_lines.description%type,
203: ra_customer_trx_lines.memo_line_id%type,
204: p_inventory_item_id IN
205: ra_customer_trx_lines.inventory_item_id%type,
206: p_item_exception_rate_id IN
207: ra_customer_trx_lines.item_exception_rate_id%type,
208: p_description IN
209: ra_customer_trx_lines.description%type,
210: p_item_context IN
211: ra_customer_trx_lines.item_context%type,
205: ra_customer_trx_lines.inventory_item_id%type,
206: p_item_exception_rate_id IN
207: ra_customer_trx_lines.item_exception_rate_id%type,
208: p_description IN
209: ra_customer_trx_lines.description%type,
210: p_item_context IN
211: ra_customer_trx_lines.item_context%type,
212: p_initial_customer_trx_line_id IN
213: ra_customer_trx_lines.initial_customer_trx_line_id%type,
207: ra_customer_trx_lines.item_exception_rate_id%type,
208: p_description IN
209: ra_customer_trx_lines.description%type,
210: p_item_context IN
211: ra_customer_trx_lines.item_context%type,
212: p_initial_customer_trx_line_id IN
213: ra_customer_trx_lines.initial_customer_trx_line_id%type,
214: p_link_to_cust_trx_line_id IN
215: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
209: ra_customer_trx_lines.description%type,
210: p_item_context IN
211: ra_customer_trx_lines.item_context%type,
212: p_initial_customer_trx_line_id IN
213: ra_customer_trx_lines.initial_customer_trx_line_id%type,
214: p_link_to_cust_trx_line_id IN
215: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
216: p_previous_customer_trx_id IN
217: ra_customer_trx_lines.previous_customer_trx_id%type,
211: ra_customer_trx_lines.item_context%type,
212: p_initial_customer_trx_line_id IN
213: ra_customer_trx_lines.initial_customer_trx_line_id%type,
214: p_link_to_cust_trx_line_id IN
215: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
216: p_previous_customer_trx_id IN
217: ra_customer_trx_lines.previous_customer_trx_id%type,
218: p_prev_customer_trx_line_id IN
219: ra_customer_trx_lines.previous_customer_trx_line_id%type,
213: ra_customer_trx_lines.initial_customer_trx_line_id%type,
214: p_link_to_cust_trx_line_id IN
215: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
216: p_previous_customer_trx_id IN
217: ra_customer_trx_lines.previous_customer_trx_id%type,
218: p_prev_customer_trx_line_id IN
219: ra_customer_trx_lines.previous_customer_trx_line_id%type,
220: p_accounting_rule_duration IN
221: ra_customer_trx_lines.accounting_rule_duration%type,
215: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
216: p_previous_customer_trx_id IN
217: ra_customer_trx_lines.previous_customer_trx_id%type,
218: p_prev_customer_trx_line_id IN
219: ra_customer_trx_lines.previous_customer_trx_line_id%type,
220: p_accounting_rule_duration IN
221: ra_customer_trx_lines.accounting_rule_duration%type,
222: p_accounting_rule_id IN
223: ra_customer_trx_lines.accounting_rule_id%type,
217: ra_customer_trx_lines.previous_customer_trx_id%type,
218: p_prev_customer_trx_line_id IN
219: ra_customer_trx_lines.previous_customer_trx_line_id%type,
220: p_accounting_rule_duration IN
221: ra_customer_trx_lines.accounting_rule_duration%type,
222: p_accounting_rule_id IN
223: ra_customer_trx_lines.accounting_rule_id%type,
224: p_rule_start_date IN
225: ra_customer_trx_lines.rule_start_date%type,
219: ra_customer_trx_lines.previous_customer_trx_line_id%type,
220: p_accounting_rule_duration IN
221: ra_customer_trx_lines.accounting_rule_duration%type,
222: p_accounting_rule_id IN
223: ra_customer_trx_lines.accounting_rule_id%type,
224: p_rule_start_date IN
225: ra_customer_trx_lines.rule_start_date%type,
226: p_autorule_complete_flag IN
227: ra_customer_trx_lines.autorule_complete_flag%type,
221: ra_customer_trx_lines.accounting_rule_duration%type,
222: p_accounting_rule_id IN
223: ra_customer_trx_lines.accounting_rule_id%type,
224: p_rule_start_date IN
225: ra_customer_trx_lines.rule_start_date%type,
226: p_autorule_complete_flag IN
227: ra_customer_trx_lines.autorule_complete_flag%type,
228: p_autorule_duration_processed IN
229: ra_customer_trx_lines.autorule_duration_processed%type,
223: ra_customer_trx_lines.accounting_rule_id%type,
224: p_rule_start_date IN
225: ra_customer_trx_lines.rule_start_date%type,
226: p_autorule_complete_flag IN
227: ra_customer_trx_lines.autorule_complete_flag%type,
228: p_autorule_duration_processed IN
229: ra_customer_trx_lines.autorule_duration_processed%type,
230: p_reason_code IN
231: ra_customer_trx_lines.reason_code%type,
225: ra_customer_trx_lines.rule_start_date%type,
226: p_autorule_complete_flag IN
227: ra_customer_trx_lines.autorule_complete_flag%type,
228: p_autorule_duration_processed IN
229: ra_customer_trx_lines.autorule_duration_processed%type,
230: p_reason_code IN
231: ra_customer_trx_lines.reason_code%type,
232: p_last_period_to_credit IN
233: ra_customer_trx_lines.last_period_to_credit%type,
227: ra_customer_trx_lines.autorule_complete_flag%type,
228: p_autorule_duration_processed IN
229: ra_customer_trx_lines.autorule_duration_processed%type,
230: p_reason_code IN
231: ra_customer_trx_lines.reason_code%type,
232: p_last_period_to_credit IN
233: ra_customer_trx_lines.last_period_to_credit%type,
234: p_sales_order IN
235: ra_customer_trx_lines.sales_order%type,
229: ra_customer_trx_lines.autorule_duration_processed%type,
230: p_reason_code IN
231: ra_customer_trx_lines.reason_code%type,
232: p_last_period_to_credit IN
233: ra_customer_trx_lines.last_period_to_credit%type,
234: p_sales_order IN
235: ra_customer_trx_lines.sales_order%type,
236: p_sales_order_date IN
237: ra_customer_trx_lines.sales_order_date%type,
231: ra_customer_trx_lines.reason_code%type,
232: p_last_period_to_credit IN
233: ra_customer_trx_lines.last_period_to_credit%type,
234: p_sales_order IN
235: ra_customer_trx_lines.sales_order%type,
236: p_sales_order_date IN
237: ra_customer_trx_lines.sales_order_date%type,
238: p_sales_order_line IN
239: ra_customer_trx_lines.sales_order_line%type,
233: ra_customer_trx_lines.last_period_to_credit%type,
234: p_sales_order IN
235: ra_customer_trx_lines.sales_order%type,
236: p_sales_order_date IN
237: ra_customer_trx_lines.sales_order_date%type,
238: p_sales_order_line IN
239: ra_customer_trx_lines.sales_order_line%type,
240: p_sales_order_revision IN
241: ra_customer_trx_lines.sales_order_revision%type,
235: ra_customer_trx_lines.sales_order%type,
236: p_sales_order_date IN
237: ra_customer_trx_lines.sales_order_date%type,
238: p_sales_order_line IN
239: ra_customer_trx_lines.sales_order_line%type,
240: p_sales_order_revision IN
241: ra_customer_trx_lines.sales_order_revision%type,
242: p_sales_order_source IN
243: ra_customer_trx_lines.sales_order_source%type,
237: ra_customer_trx_lines.sales_order_date%type,
238: p_sales_order_line IN
239: ra_customer_trx_lines.sales_order_line%type,
240: p_sales_order_revision IN
241: ra_customer_trx_lines.sales_order_revision%type,
242: p_sales_order_source IN
243: ra_customer_trx_lines.sales_order_source%type,
244: p_vat_tax_id IN
245: ra_customer_trx_lines.vat_tax_id%type,
239: ra_customer_trx_lines.sales_order_line%type,
240: p_sales_order_revision IN
241: ra_customer_trx_lines.sales_order_revision%type,
242: p_sales_order_source IN
243: ra_customer_trx_lines.sales_order_source%type,
244: p_vat_tax_id IN
245: ra_customer_trx_lines.vat_tax_id%type,
246: p_tax_exempt_flag IN
247: ra_customer_trx_lines.tax_exempt_flag%type,
241: ra_customer_trx_lines.sales_order_revision%type,
242: p_sales_order_source IN
243: ra_customer_trx_lines.sales_order_source%type,
244: p_vat_tax_id IN
245: ra_customer_trx_lines.vat_tax_id%type,
246: p_tax_exempt_flag IN
247: ra_customer_trx_lines.tax_exempt_flag%type,
248: p_sales_tax_id IN
249: ra_customer_trx_lines.sales_tax_id%type,
243: ra_customer_trx_lines.sales_order_source%type,
244: p_vat_tax_id IN
245: ra_customer_trx_lines.vat_tax_id%type,
246: p_tax_exempt_flag IN
247: ra_customer_trx_lines.tax_exempt_flag%type,
248: p_sales_tax_id IN
249: ra_customer_trx_lines.sales_tax_id%type,
250: p_location_segment_id IN
251: ra_customer_trx_lines.location_segment_id%type,
245: ra_customer_trx_lines.vat_tax_id%type,
246: p_tax_exempt_flag IN
247: ra_customer_trx_lines.tax_exempt_flag%type,
248: p_sales_tax_id IN
249: ra_customer_trx_lines.sales_tax_id%type,
250: p_location_segment_id IN
251: ra_customer_trx_lines.location_segment_id%type,
252: p_tax_exempt_number IN
253: ra_customer_trx_lines.tax_exempt_number%type,
247: ra_customer_trx_lines.tax_exempt_flag%type,
248: p_sales_tax_id IN
249: ra_customer_trx_lines.sales_tax_id%type,
250: p_location_segment_id IN
251: ra_customer_trx_lines.location_segment_id%type,
252: p_tax_exempt_number IN
253: ra_customer_trx_lines.tax_exempt_number%type,
254: p_tax_exempt_reason_code IN
255: ra_customer_trx_lines.tax_exempt_reason_code%type,
249: ra_customer_trx_lines.sales_tax_id%type,
250: p_location_segment_id IN
251: ra_customer_trx_lines.location_segment_id%type,
252: p_tax_exempt_number IN
253: ra_customer_trx_lines.tax_exempt_number%type,
254: p_tax_exempt_reason_code IN
255: ra_customer_trx_lines.tax_exempt_reason_code%type,
256: p_tax_vendor_return_code IN
257: ra_customer_trx_lines.tax_vendor_return_code%type,
251: ra_customer_trx_lines.location_segment_id%type,
252: p_tax_exempt_number IN
253: ra_customer_trx_lines.tax_exempt_number%type,
254: p_tax_exempt_reason_code IN
255: ra_customer_trx_lines.tax_exempt_reason_code%type,
256: p_tax_vendor_return_code IN
257: ra_customer_trx_lines.tax_vendor_return_code%type,
258: p_taxable_flag IN
259: ra_customer_trx_lines.taxable_flag%type,
253: ra_customer_trx_lines.tax_exempt_number%type,
254: p_tax_exempt_reason_code IN
255: ra_customer_trx_lines.tax_exempt_reason_code%type,
256: p_tax_vendor_return_code IN
257: ra_customer_trx_lines.tax_vendor_return_code%type,
258: p_taxable_flag IN
259: ra_customer_trx_lines.taxable_flag%type,
260: p_tax_exemption_id IN
261: ra_customer_trx_lines.tax_exemption_id%type,
255: ra_customer_trx_lines.tax_exempt_reason_code%type,
256: p_tax_vendor_return_code IN
257: ra_customer_trx_lines.tax_vendor_return_code%type,
258: p_taxable_flag IN
259: ra_customer_trx_lines.taxable_flag%type,
260: p_tax_exemption_id IN
261: ra_customer_trx_lines.tax_exemption_id%type,
262: p_tax_precedence IN
263: ra_customer_trx_lines.tax_precedence%type,
257: ra_customer_trx_lines.tax_vendor_return_code%type,
258: p_taxable_flag IN
259: ra_customer_trx_lines.taxable_flag%type,
260: p_tax_exemption_id IN
261: ra_customer_trx_lines.tax_exemption_id%type,
262: p_tax_precedence IN
263: ra_customer_trx_lines.tax_precedence%type,
264: p_tax_rate IN
265: ra_customer_trx_lines.tax_rate%type,
259: ra_customer_trx_lines.taxable_flag%type,
260: p_tax_exemption_id IN
261: ra_customer_trx_lines.tax_exemption_id%type,
262: p_tax_precedence IN
263: ra_customer_trx_lines.tax_precedence%type,
264: p_tax_rate IN
265: ra_customer_trx_lines.tax_rate%type,
266: p_uom_code IN
267: ra_customer_trx_lines.uom_code%type,
261: ra_customer_trx_lines.tax_exemption_id%type,
262: p_tax_precedence IN
263: ra_customer_trx_lines.tax_precedence%type,
264: p_tax_rate IN
265: ra_customer_trx_lines.tax_rate%type,
266: p_uom_code IN
267: ra_customer_trx_lines.uom_code%type,
268: p_autotax IN
269: ra_customer_trx_lines.autotax%type,
263: ra_customer_trx_lines.tax_precedence%type,
264: p_tax_rate IN
265: ra_customer_trx_lines.tax_rate%type,
266: p_uom_code IN
267: ra_customer_trx_lines.uom_code%type,
268: p_autotax IN
269: ra_customer_trx_lines.autotax%type,
270: p_movement_id IN
271: ra_customer_trx_lines.movement_id%type,
265: ra_customer_trx_lines.tax_rate%type,
266: p_uom_code IN
267: ra_customer_trx_lines.uom_code%type,
268: p_autotax IN
269: ra_customer_trx_lines.autotax%type,
270: p_movement_id IN
271: ra_customer_trx_lines.movement_id%type,
272: p_default_ussgl_trx_code IN
273: ra_customer_trx_lines.default_ussgl_transaction_code%type,
267: ra_customer_trx_lines.uom_code%type,
268: p_autotax IN
269: ra_customer_trx_lines.autotax%type,
270: p_movement_id IN
271: ra_customer_trx_lines.movement_id%type,
272: p_default_ussgl_trx_code IN
273: ra_customer_trx_lines.default_ussgl_transaction_code%type,
274: p_default_ussgl_trx_code_cntxt IN
275: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
269: ra_customer_trx_lines.autotax%type,
270: p_movement_id IN
271: ra_customer_trx_lines.movement_id%type,
272: p_default_ussgl_trx_code IN
273: ra_customer_trx_lines.default_ussgl_transaction_code%type,
274: p_default_ussgl_trx_code_cntxt IN
275: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
276: p_interface_line_context IN
277: ra_customer_trx_lines.interface_line_context%type,
271: ra_customer_trx_lines.movement_id%type,
272: p_default_ussgl_trx_code IN
273: ra_customer_trx_lines.default_ussgl_transaction_code%type,
274: p_default_ussgl_trx_code_cntxt IN
275: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
276: p_interface_line_context IN
277: ra_customer_trx_lines.interface_line_context%type,
278: p_interface_line_attribute1 IN
279: ra_customer_trx_lines.interface_line_attribute1%type,
273: ra_customer_trx_lines.default_ussgl_transaction_code%type,
274: p_default_ussgl_trx_code_cntxt IN
275: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
276: p_interface_line_context IN
277: ra_customer_trx_lines.interface_line_context%type,
278: p_interface_line_attribute1 IN
279: ra_customer_trx_lines.interface_line_attribute1%type,
280: p_interface_line_attribute2 IN
281: ra_customer_trx_lines.interface_line_attribute2%type,
275: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
276: p_interface_line_context IN
277: ra_customer_trx_lines.interface_line_context%type,
278: p_interface_line_attribute1 IN
279: ra_customer_trx_lines.interface_line_attribute1%type,
280: p_interface_line_attribute2 IN
281: ra_customer_trx_lines.interface_line_attribute2%type,
282: p_interface_line_attribute3 IN
283: ra_customer_trx_lines.interface_line_attribute3%type,
277: ra_customer_trx_lines.interface_line_context%type,
278: p_interface_line_attribute1 IN
279: ra_customer_trx_lines.interface_line_attribute1%type,
280: p_interface_line_attribute2 IN
281: ra_customer_trx_lines.interface_line_attribute2%type,
282: p_interface_line_attribute3 IN
283: ra_customer_trx_lines.interface_line_attribute3%type,
284: p_interface_line_attribute4 IN
285: ra_customer_trx_lines.interface_line_attribute4%type,
279: ra_customer_trx_lines.interface_line_attribute1%type,
280: p_interface_line_attribute2 IN
281: ra_customer_trx_lines.interface_line_attribute2%type,
282: p_interface_line_attribute3 IN
283: ra_customer_trx_lines.interface_line_attribute3%type,
284: p_interface_line_attribute4 IN
285: ra_customer_trx_lines.interface_line_attribute4%type,
286: p_interface_line_attribute5 IN
287: ra_customer_trx_lines.interface_line_attribute5%type,
281: ra_customer_trx_lines.interface_line_attribute2%type,
282: p_interface_line_attribute3 IN
283: ra_customer_trx_lines.interface_line_attribute3%type,
284: p_interface_line_attribute4 IN
285: ra_customer_trx_lines.interface_line_attribute4%type,
286: p_interface_line_attribute5 IN
287: ra_customer_trx_lines.interface_line_attribute5%type,
288: p_interface_line_attribute6 IN
289: ra_customer_trx_lines.interface_line_attribute6%type,
283: ra_customer_trx_lines.interface_line_attribute3%type,
284: p_interface_line_attribute4 IN
285: ra_customer_trx_lines.interface_line_attribute4%type,
286: p_interface_line_attribute5 IN
287: ra_customer_trx_lines.interface_line_attribute5%type,
288: p_interface_line_attribute6 IN
289: ra_customer_trx_lines.interface_line_attribute6%type,
290: p_interface_line_attribute7 IN
291: ra_customer_trx_lines.interface_line_attribute7%type,
285: ra_customer_trx_lines.interface_line_attribute4%type,
286: p_interface_line_attribute5 IN
287: ra_customer_trx_lines.interface_line_attribute5%type,
288: p_interface_line_attribute6 IN
289: ra_customer_trx_lines.interface_line_attribute6%type,
290: p_interface_line_attribute7 IN
291: ra_customer_trx_lines.interface_line_attribute7%type,
292: p_interface_line_attribute8 IN
293: ra_customer_trx_lines.interface_line_attribute8%type,
287: ra_customer_trx_lines.interface_line_attribute5%type,
288: p_interface_line_attribute6 IN
289: ra_customer_trx_lines.interface_line_attribute6%type,
290: p_interface_line_attribute7 IN
291: ra_customer_trx_lines.interface_line_attribute7%type,
292: p_interface_line_attribute8 IN
293: ra_customer_trx_lines.interface_line_attribute8%type,
294: p_interface_line_attribute9 IN
295: ra_customer_trx_lines.interface_line_attribute9%type,
289: ra_customer_trx_lines.interface_line_attribute6%type,
290: p_interface_line_attribute7 IN
291: ra_customer_trx_lines.interface_line_attribute7%type,
292: p_interface_line_attribute8 IN
293: ra_customer_trx_lines.interface_line_attribute8%type,
294: p_interface_line_attribute9 IN
295: ra_customer_trx_lines.interface_line_attribute9%type,
296: p_interface_line_attribute10 IN
297: ra_customer_trx_lines.interface_line_attribute10%type,
291: ra_customer_trx_lines.interface_line_attribute7%type,
292: p_interface_line_attribute8 IN
293: ra_customer_trx_lines.interface_line_attribute8%type,
294: p_interface_line_attribute9 IN
295: ra_customer_trx_lines.interface_line_attribute9%type,
296: p_interface_line_attribute10 IN
297: ra_customer_trx_lines.interface_line_attribute10%type,
298: p_interface_line_attribute11 IN
299: ra_customer_trx_lines.interface_line_attribute11%type,
293: ra_customer_trx_lines.interface_line_attribute8%type,
294: p_interface_line_attribute9 IN
295: ra_customer_trx_lines.interface_line_attribute9%type,
296: p_interface_line_attribute10 IN
297: ra_customer_trx_lines.interface_line_attribute10%type,
298: p_interface_line_attribute11 IN
299: ra_customer_trx_lines.interface_line_attribute11%type,
300: p_interface_line_attribute12 IN
301: ra_customer_trx_lines.interface_line_attribute12%type,
295: ra_customer_trx_lines.interface_line_attribute9%type,
296: p_interface_line_attribute10 IN
297: ra_customer_trx_lines.interface_line_attribute10%type,
298: p_interface_line_attribute11 IN
299: ra_customer_trx_lines.interface_line_attribute11%type,
300: p_interface_line_attribute12 IN
301: ra_customer_trx_lines.interface_line_attribute12%type,
302: p_interface_line_attribute13 IN
303: ra_customer_trx_lines.interface_line_attribute13%type,
297: ra_customer_trx_lines.interface_line_attribute10%type,
298: p_interface_line_attribute11 IN
299: ra_customer_trx_lines.interface_line_attribute11%type,
300: p_interface_line_attribute12 IN
301: ra_customer_trx_lines.interface_line_attribute12%type,
302: p_interface_line_attribute13 IN
303: ra_customer_trx_lines.interface_line_attribute13%type,
304: p_interface_line_attribute14 IN
305: ra_customer_trx_lines.interface_line_attribute14%type,
299: ra_customer_trx_lines.interface_line_attribute11%type,
300: p_interface_line_attribute12 IN
301: ra_customer_trx_lines.interface_line_attribute12%type,
302: p_interface_line_attribute13 IN
303: ra_customer_trx_lines.interface_line_attribute13%type,
304: p_interface_line_attribute14 IN
305: ra_customer_trx_lines.interface_line_attribute14%type,
306: p_interface_line_attribute15 IN
307: ra_customer_trx_lines.interface_line_attribute15%type,
301: ra_customer_trx_lines.interface_line_attribute12%type,
302: p_interface_line_attribute13 IN
303: ra_customer_trx_lines.interface_line_attribute13%type,
304: p_interface_line_attribute14 IN
305: ra_customer_trx_lines.interface_line_attribute14%type,
306: p_interface_line_attribute15 IN
307: ra_customer_trx_lines.interface_line_attribute15%type,
308: p_attribute_category IN
309: ra_customer_trx_lines.attribute_category%type,
303: ra_customer_trx_lines.interface_line_attribute13%type,
304: p_interface_line_attribute14 IN
305: ra_customer_trx_lines.interface_line_attribute14%type,
306: p_interface_line_attribute15 IN
307: ra_customer_trx_lines.interface_line_attribute15%type,
308: p_attribute_category IN
309: ra_customer_trx_lines.attribute_category%type,
310: p_attribute1 IN
311: ra_customer_trx_lines.attribute1%type,
305: ra_customer_trx_lines.interface_line_attribute14%type,
306: p_interface_line_attribute15 IN
307: ra_customer_trx_lines.interface_line_attribute15%type,
308: p_attribute_category IN
309: ra_customer_trx_lines.attribute_category%type,
310: p_attribute1 IN
311: ra_customer_trx_lines.attribute1%type,
312: p_attribute2 IN
313: ra_customer_trx_lines.attribute2%type,
307: ra_customer_trx_lines.interface_line_attribute15%type,
308: p_attribute_category IN
309: ra_customer_trx_lines.attribute_category%type,
310: p_attribute1 IN
311: ra_customer_trx_lines.attribute1%type,
312: p_attribute2 IN
313: ra_customer_trx_lines.attribute2%type,
314: p_attribute3 IN
315: ra_customer_trx_lines.attribute3%type,
309: ra_customer_trx_lines.attribute_category%type,
310: p_attribute1 IN
311: ra_customer_trx_lines.attribute1%type,
312: p_attribute2 IN
313: ra_customer_trx_lines.attribute2%type,
314: p_attribute3 IN
315: ra_customer_trx_lines.attribute3%type,
316: p_attribute4 IN
317: ra_customer_trx_lines.attribute4%type,
311: ra_customer_trx_lines.attribute1%type,
312: p_attribute2 IN
313: ra_customer_trx_lines.attribute2%type,
314: p_attribute3 IN
315: ra_customer_trx_lines.attribute3%type,
316: p_attribute4 IN
317: ra_customer_trx_lines.attribute4%type,
318: p_attribute5 IN
319: ra_customer_trx_lines.attribute5%type,
313: ra_customer_trx_lines.attribute2%type,
314: p_attribute3 IN
315: ra_customer_trx_lines.attribute3%type,
316: p_attribute4 IN
317: ra_customer_trx_lines.attribute4%type,
318: p_attribute5 IN
319: ra_customer_trx_lines.attribute5%type,
320: p_attribute6 IN
321: ra_customer_trx_lines.attribute6%type,
315: ra_customer_trx_lines.attribute3%type,
316: p_attribute4 IN
317: ra_customer_trx_lines.attribute4%type,
318: p_attribute5 IN
319: ra_customer_trx_lines.attribute5%type,
320: p_attribute6 IN
321: ra_customer_trx_lines.attribute6%type,
322: p_attribute7 IN
323: ra_customer_trx_lines.attribute7%type,
317: ra_customer_trx_lines.attribute4%type,
318: p_attribute5 IN
319: ra_customer_trx_lines.attribute5%type,
320: p_attribute6 IN
321: ra_customer_trx_lines.attribute6%type,
322: p_attribute7 IN
323: ra_customer_trx_lines.attribute7%type,
324: p_attribute8 IN
325: ra_customer_trx_lines.attribute8%type,
319: ra_customer_trx_lines.attribute5%type,
320: p_attribute6 IN
321: ra_customer_trx_lines.attribute6%type,
322: p_attribute7 IN
323: ra_customer_trx_lines.attribute7%type,
324: p_attribute8 IN
325: ra_customer_trx_lines.attribute8%type,
326: p_attribute9 IN
327: ra_customer_trx_lines.attribute9%type,
321: ra_customer_trx_lines.attribute6%type,
322: p_attribute7 IN
323: ra_customer_trx_lines.attribute7%type,
324: p_attribute8 IN
325: ra_customer_trx_lines.attribute8%type,
326: p_attribute9 IN
327: ra_customer_trx_lines.attribute9%type,
328: p_attribute10 IN
329: ra_customer_trx_lines.attribute10%type,
323: ra_customer_trx_lines.attribute7%type,
324: p_attribute8 IN
325: ra_customer_trx_lines.attribute8%type,
326: p_attribute9 IN
327: ra_customer_trx_lines.attribute9%type,
328: p_attribute10 IN
329: ra_customer_trx_lines.attribute10%type,
330: p_attribute11 IN
331: ra_customer_trx_lines.attribute11%type,
325: ra_customer_trx_lines.attribute8%type,
326: p_attribute9 IN
327: ra_customer_trx_lines.attribute9%type,
328: p_attribute10 IN
329: ra_customer_trx_lines.attribute10%type,
330: p_attribute11 IN
331: ra_customer_trx_lines.attribute11%type,
332: p_attribute12 IN
333: ra_customer_trx_lines.attribute12%type,
327: ra_customer_trx_lines.attribute9%type,
328: p_attribute10 IN
329: ra_customer_trx_lines.attribute10%type,
330: p_attribute11 IN
331: ra_customer_trx_lines.attribute11%type,
332: p_attribute12 IN
333: ra_customer_trx_lines.attribute12%type,
334: p_attribute13 IN
335: ra_customer_trx_lines.attribute13%type,
329: ra_customer_trx_lines.attribute10%type,
330: p_attribute11 IN
331: ra_customer_trx_lines.attribute11%type,
332: p_attribute12 IN
333: ra_customer_trx_lines.attribute12%type,
334: p_attribute13 IN
335: ra_customer_trx_lines.attribute13%type,
336: p_attribute14 IN
337: ra_customer_trx_lines.attribute14%type,
331: ra_customer_trx_lines.attribute11%type,
332: p_attribute12 IN
333: ra_customer_trx_lines.attribute12%type,
334: p_attribute13 IN
335: ra_customer_trx_lines.attribute13%type,
336: p_attribute14 IN
337: ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN
339: ra_customer_trx_lines.attribute15%type,
333: ra_customer_trx_lines.attribute12%type,
334: p_attribute13 IN
335: ra_customer_trx_lines.attribute13%type,
336: p_attribute14 IN
337: ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN
339: ra_customer_trx_lines.attribute15%type,
340: p_header_currency_code IN
341: ra_customer_trx.invoice_currency_code%type,
335: ra_customer_trx_lines.attribute13%type,
336: p_attribute14 IN
337: ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN
339: ra_customer_trx_lines.attribute15%type,
340: p_header_currency_code IN
341: ra_customer_trx.invoice_currency_code%type,
342: p_gross_extended_amount IN
343: ra_customer_trx_lines.gross_extended_amount%type,
337: ra_customer_trx_lines.attribute14%type,
338: p_attribute15 IN
339: ra_customer_trx_lines.attribute15%type,
340: p_header_currency_code IN
341: ra_customer_trx.invoice_currency_code%type,
342: p_gross_extended_amount IN
343: ra_customer_trx_lines.gross_extended_amount%type,
344: p_gross_unit_selling_price IN
345: ra_customer_trx_lines.gross_unit_selling_price%type,
339: ra_customer_trx_lines.attribute15%type,
340: p_header_currency_code IN
341: ra_customer_trx.invoice_currency_code%type,
342: p_gross_extended_amount IN
343: ra_customer_trx_lines.gross_extended_amount%type,
344: p_gross_unit_selling_price IN
345: ra_customer_trx_lines.gross_unit_selling_price%type,
346: p_amount_includes_tax_flag IN
347: ra_customer_trx_lines.amount_includes_tax_flag%type,
341: ra_customer_trx.invoice_currency_code%type,
342: p_gross_extended_amount IN
343: ra_customer_trx_lines.gross_extended_amount%type,
344: p_gross_unit_selling_price IN
345: ra_customer_trx_lines.gross_unit_selling_price%type,
346: p_amount_includes_tax_flag IN
347: ra_customer_trx_lines.amount_includes_tax_flag%type,
348: p_status OUT NOCOPY
349: varchar2,
343: ra_customer_trx_lines.gross_extended_amount%type,
344: p_gross_unit_selling_price IN
345: ra_customer_trx_lines.gross_unit_selling_price%type,
346: p_amount_includes_tax_flag IN
347: ra_customer_trx_lines.amount_includes_tax_flag%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.amount_includes_tax_flag%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_payment_set_id IN
393: ra_customer_trx_lines.payment_set_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_payment_set_id IN
393: ra_customer_trx_lines.payment_set_id%type )
394: IS
395:
389: ra_customer_trx_lines.global_attribute19%type,
390: p_global_attribute20 IN
391: ra_customer_trx_lines.global_attribute20%type,
392: p_payment_set_id IN
393: ra_customer_trx_lines.payment_set_id%type )
394: IS
395:
396: l_line_rec ra_customer_trx_lines%rowtype;
397:
392: p_payment_set_id IN
393: ra_customer_trx_lines.payment_set_id%type )
394: IS
395:
396: l_line_rec ra_customer_trx_lines%rowtype;
397:
398: /* bug 3567353 */
399: l_error_message VARCHAR2(128) := '';
400: l_dist_count NUMBER;