115: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
116:
117: PROCEDURE lock_compare_cover(
118: p_customer_trx_line_id IN
119: ra_customer_trx_lines.customer_trx_line_id%type,
120: p_customer_trx_id IN
121: ra_customer_trx_lines.customer_trx_id%type,
122: p_line_number IN
123: ra_customer_trx_lines.line_number%type,
117: PROCEDURE lock_compare_cover(
118: p_customer_trx_line_id IN
119: ra_customer_trx_lines.customer_trx_line_id%type,
120: p_customer_trx_id IN
121: ra_customer_trx_lines.customer_trx_id%type,
122: p_line_number IN
123: ra_customer_trx_lines.line_number%type,
124: p_line_type IN
125: ra_customer_trx_lines.line_type%type,
119: ra_customer_trx_lines.customer_trx_line_id%type,
120: p_customer_trx_id IN
121: ra_customer_trx_lines.customer_trx_id%type,
122: p_line_number IN
123: ra_customer_trx_lines.line_number%type,
124: p_line_type IN
125: ra_customer_trx_lines.line_type%type,
126: p_quantity_credited IN
127: ra_customer_trx_lines.quantity_credited%type,
121: ra_customer_trx_lines.customer_trx_id%type,
122: p_line_number IN
123: ra_customer_trx_lines.line_number%type,
124: p_line_type IN
125: ra_customer_trx_lines.line_type%type,
126: p_quantity_credited IN
127: ra_customer_trx_lines.quantity_credited%type,
128: p_quantity_invoiced IN
129: ra_customer_trx_lines.quantity_invoiced%type,
123: ra_customer_trx_lines.line_number%type,
124: p_line_type IN
125: ra_customer_trx_lines.line_type%type,
126: p_quantity_credited IN
127: ra_customer_trx_lines.quantity_credited%type,
128: p_quantity_invoiced IN
129: ra_customer_trx_lines.quantity_invoiced%type,
130: p_quantity_ordered IN
131: ra_customer_trx_lines.quantity_ordered%type,
125: ra_customer_trx_lines.line_type%type,
126: p_quantity_credited IN
127: ra_customer_trx_lines.quantity_credited%type,
128: p_quantity_invoiced IN
129: ra_customer_trx_lines.quantity_invoiced%type,
130: p_quantity_ordered IN
131: ra_customer_trx_lines.quantity_ordered%type,
132: p_gross_unit_selling_price IN
133: ra_customer_trx_lines.unit_selling_price%type,
127: ra_customer_trx_lines.quantity_credited%type,
128: p_quantity_invoiced IN
129: ra_customer_trx_lines.quantity_invoiced%type,
130: p_quantity_ordered IN
131: ra_customer_trx_lines.quantity_ordered%type,
132: p_gross_unit_selling_price IN
133: ra_customer_trx_lines.unit_selling_price%type,
134: p_unit_standard_price IN
135: ra_customer_trx_lines.unit_standard_price%type,
129: ra_customer_trx_lines.quantity_invoiced%type,
130: p_quantity_ordered IN
131: ra_customer_trx_lines.quantity_ordered%type,
132: p_gross_unit_selling_price IN
133: ra_customer_trx_lines.unit_selling_price%type,
134: p_unit_standard_price IN
135: ra_customer_trx_lines.unit_standard_price%type,
136: p_gross_extended_amount IN
137: ra_customer_trx_lines.extended_amount%type,
131: ra_customer_trx_lines.quantity_ordered%type,
132: p_gross_unit_selling_price IN
133: ra_customer_trx_lines.unit_selling_price%type,
134: p_unit_standard_price IN
135: ra_customer_trx_lines.unit_standard_price%type,
136: p_gross_extended_amount IN
137: ra_customer_trx_lines.extended_amount%type,
138: p_memo_line_id IN
139: ra_customer_trx_lines.memo_line_id%type,
133: ra_customer_trx_lines.unit_selling_price%type,
134: p_unit_standard_price IN
135: ra_customer_trx_lines.unit_standard_price%type,
136: p_gross_extended_amount IN
137: ra_customer_trx_lines.extended_amount%type,
138: p_memo_line_id IN
139: ra_customer_trx_lines.memo_line_id%type,
140: p_inventory_item_id IN
141: ra_customer_trx_lines.inventory_item_id%type,
135: ra_customer_trx_lines.unit_standard_price%type,
136: p_gross_extended_amount IN
137: ra_customer_trx_lines.extended_amount%type,
138: p_memo_line_id IN
139: ra_customer_trx_lines.memo_line_id%type,
140: p_inventory_item_id IN
141: ra_customer_trx_lines.inventory_item_id%type,
142: p_item_exception_rate_id IN
143: ra_customer_trx_lines.item_exception_rate_id%type,
137: ra_customer_trx_lines.extended_amount%type,
138: p_memo_line_id IN
139: ra_customer_trx_lines.memo_line_id%type,
140: p_inventory_item_id IN
141: ra_customer_trx_lines.inventory_item_id%type,
142: p_item_exception_rate_id IN
143: ra_customer_trx_lines.item_exception_rate_id%type,
144: p_description IN
145: ra_customer_trx_lines.description%type,
139: ra_customer_trx_lines.memo_line_id%type,
140: p_inventory_item_id IN
141: ra_customer_trx_lines.inventory_item_id%type,
142: p_item_exception_rate_id IN
143: ra_customer_trx_lines.item_exception_rate_id%type,
144: p_description IN
145: ra_customer_trx_lines.description%type,
146: p_item_context IN
147: ra_customer_trx_lines.item_context%type,
141: ra_customer_trx_lines.inventory_item_id%type,
142: p_item_exception_rate_id IN
143: ra_customer_trx_lines.item_exception_rate_id%type,
144: p_description IN
145: ra_customer_trx_lines.description%type,
146: p_item_context IN
147: ra_customer_trx_lines.item_context%type,
148: p_initial_customer_trx_line_id IN
149: ra_customer_trx_lines.initial_customer_trx_line_id%type,
143: ra_customer_trx_lines.item_exception_rate_id%type,
144: p_description IN
145: ra_customer_trx_lines.description%type,
146: p_item_context IN
147: ra_customer_trx_lines.item_context%type,
148: p_initial_customer_trx_line_id IN
149: ra_customer_trx_lines.initial_customer_trx_line_id%type,
150: p_link_to_cust_trx_line_id IN
151: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
145: ra_customer_trx_lines.description%type,
146: p_item_context IN
147: ra_customer_trx_lines.item_context%type,
148: p_initial_customer_trx_line_id IN
149: ra_customer_trx_lines.initial_customer_trx_line_id%type,
150: p_link_to_cust_trx_line_id IN
151: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
152: p_previous_customer_trx_id IN
153: ra_customer_trx_lines.previous_customer_trx_id%type,
147: ra_customer_trx_lines.item_context%type,
148: p_initial_customer_trx_line_id IN
149: ra_customer_trx_lines.initial_customer_trx_line_id%type,
150: p_link_to_cust_trx_line_id IN
151: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
152: p_previous_customer_trx_id IN
153: ra_customer_trx_lines.previous_customer_trx_id%type,
154: p_prev_customer_trx_line_id IN
155: ra_customer_trx_lines.previous_customer_trx_line_id%type,
149: ra_customer_trx_lines.initial_customer_trx_line_id%type,
150: p_link_to_cust_trx_line_id IN
151: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
152: p_previous_customer_trx_id IN
153: ra_customer_trx_lines.previous_customer_trx_id%type,
154: p_prev_customer_trx_line_id IN
155: ra_customer_trx_lines.previous_customer_trx_line_id%type,
156: p_accounting_rule_duration IN
157: ra_customer_trx_lines.accounting_rule_duration%type,
151: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
152: p_previous_customer_trx_id IN
153: ra_customer_trx_lines.previous_customer_trx_id%type,
154: p_prev_customer_trx_line_id IN
155: ra_customer_trx_lines.previous_customer_trx_line_id%type,
156: p_accounting_rule_duration IN
157: ra_customer_trx_lines.accounting_rule_duration%type,
158: p_accounting_rule_id IN
159: ra_customer_trx_lines.accounting_rule_id%type,
153: ra_customer_trx_lines.previous_customer_trx_id%type,
154: p_prev_customer_trx_line_id IN
155: ra_customer_trx_lines.previous_customer_trx_line_id%type,
156: p_accounting_rule_duration IN
157: ra_customer_trx_lines.accounting_rule_duration%type,
158: p_accounting_rule_id IN
159: ra_customer_trx_lines.accounting_rule_id%type,
160: p_rule_start_date IN
161: ra_customer_trx_lines.rule_start_date%type,
155: ra_customer_trx_lines.previous_customer_trx_line_id%type,
156: p_accounting_rule_duration IN
157: ra_customer_trx_lines.accounting_rule_duration%type,
158: p_accounting_rule_id IN
159: ra_customer_trx_lines.accounting_rule_id%type,
160: p_rule_start_date IN
161: ra_customer_trx_lines.rule_start_date%type,
162: p_autorule_complete_flag IN
163: ra_customer_trx_lines.autorule_complete_flag%type,
157: ra_customer_trx_lines.accounting_rule_duration%type,
158: p_accounting_rule_id IN
159: ra_customer_trx_lines.accounting_rule_id%type,
160: p_rule_start_date IN
161: ra_customer_trx_lines.rule_start_date%type,
162: p_autorule_complete_flag IN
163: ra_customer_trx_lines.autorule_complete_flag%type,
164: p_autorule_duration_processed IN
165: ra_customer_trx_lines.autorule_duration_processed%type,
159: ra_customer_trx_lines.accounting_rule_id%type,
160: p_rule_start_date IN
161: ra_customer_trx_lines.rule_start_date%type,
162: p_autorule_complete_flag IN
163: ra_customer_trx_lines.autorule_complete_flag%type,
164: p_autorule_duration_processed IN
165: ra_customer_trx_lines.autorule_duration_processed%type,
166: p_reason_code IN
167: ra_customer_trx_lines.reason_code%type,
161: ra_customer_trx_lines.rule_start_date%type,
162: p_autorule_complete_flag IN
163: ra_customer_trx_lines.autorule_complete_flag%type,
164: p_autorule_duration_processed IN
165: ra_customer_trx_lines.autorule_duration_processed%type,
166: p_reason_code IN
167: ra_customer_trx_lines.reason_code%type,
168: p_last_period_to_credit IN
169: ra_customer_trx_lines.last_period_to_credit%type,
163: ra_customer_trx_lines.autorule_complete_flag%type,
164: p_autorule_duration_processed IN
165: ra_customer_trx_lines.autorule_duration_processed%type,
166: p_reason_code IN
167: ra_customer_trx_lines.reason_code%type,
168: p_last_period_to_credit IN
169: ra_customer_trx_lines.last_period_to_credit%type,
170: p_sales_order IN
171: ra_customer_trx_lines.sales_order%type,
165: ra_customer_trx_lines.autorule_duration_processed%type,
166: p_reason_code IN
167: ra_customer_trx_lines.reason_code%type,
168: p_last_period_to_credit IN
169: ra_customer_trx_lines.last_period_to_credit%type,
170: p_sales_order IN
171: ra_customer_trx_lines.sales_order%type,
172: p_sales_order_date IN
173: ra_customer_trx_lines.sales_order_date%type,
167: ra_customer_trx_lines.reason_code%type,
168: p_last_period_to_credit IN
169: ra_customer_trx_lines.last_period_to_credit%type,
170: p_sales_order IN
171: ra_customer_trx_lines.sales_order%type,
172: p_sales_order_date IN
173: ra_customer_trx_lines.sales_order_date%type,
174: p_sales_order_line IN
175: ra_customer_trx_lines.sales_order_line%type,
169: ra_customer_trx_lines.last_period_to_credit%type,
170: p_sales_order IN
171: ra_customer_trx_lines.sales_order%type,
172: p_sales_order_date IN
173: ra_customer_trx_lines.sales_order_date%type,
174: p_sales_order_line IN
175: ra_customer_trx_lines.sales_order_line%type,
176: p_sales_order_revision IN
177: ra_customer_trx_lines.sales_order_revision%type,
171: ra_customer_trx_lines.sales_order%type,
172: p_sales_order_date IN
173: ra_customer_trx_lines.sales_order_date%type,
174: p_sales_order_line IN
175: ra_customer_trx_lines.sales_order_line%type,
176: p_sales_order_revision IN
177: ra_customer_trx_lines.sales_order_revision%type,
178: p_sales_order_source IN
179: ra_customer_trx_lines.sales_order_source%type,
173: ra_customer_trx_lines.sales_order_date%type,
174: p_sales_order_line IN
175: ra_customer_trx_lines.sales_order_line%type,
176: p_sales_order_revision IN
177: ra_customer_trx_lines.sales_order_revision%type,
178: p_sales_order_source IN
179: ra_customer_trx_lines.sales_order_source%type,
180: p_vat_tax_id IN
181: ra_customer_trx_lines.vat_tax_id%type,
175: ra_customer_trx_lines.sales_order_line%type,
176: p_sales_order_revision IN
177: ra_customer_trx_lines.sales_order_revision%type,
178: p_sales_order_source IN
179: ra_customer_trx_lines.sales_order_source%type,
180: p_vat_tax_id IN
181: ra_customer_trx_lines.vat_tax_id%type,
182: p_tax_exempt_flag IN
183: ra_customer_trx_lines.tax_exempt_flag%type,
177: ra_customer_trx_lines.sales_order_revision%type,
178: p_sales_order_source IN
179: ra_customer_trx_lines.sales_order_source%type,
180: p_vat_tax_id IN
181: ra_customer_trx_lines.vat_tax_id%type,
182: p_tax_exempt_flag IN
183: ra_customer_trx_lines.tax_exempt_flag%type,
184: p_sales_tax_id IN
185: ra_customer_trx_lines.sales_tax_id%type,
179: ra_customer_trx_lines.sales_order_source%type,
180: p_vat_tax_id IN
181: ra_customer_trx_lines.vat_tax_id%type,
182: p_tax_exempt_flag IN
183: ra_customer_trx_lines.tax_exempt_flag%type,
184: p_sales_tax_id IN
185: ra_customer_trx_lines.sales_tax_id%type,
186: p_location_segment_id IN
187: ra_customer_trx_lines.location_segment_id%type,
181: ra_customer_trx_lines.vat_tax_id%type,
182: p_tax_exempt_flag IN
183: ra_customer_trx_lines.tax_exempt_flag%type,
184: p_sales_tax_id IN
185: ra_customer_trx_lines.sales_tax_id%type,
186: p_location_segment_id IN
187: ra_customer_trx_lines.location_segment_id%type,
188: p_tax_exempt_number IN
189: ra_customer_trx_lines.tax_exempt_number%type,
183: ra_customer_trx_lines.tax_exempt_flag%type,
184: p_sales_tax_id IN
185: ra_customer_trx_lines.sales_tax_id%type,
186: p_location_segment_id IN
187: ra_customer_trx_lines.location_segment_id%type,
188: p_tax_exempt_number IN
189: ra_customer_trx_lines.tax_exempt_number%type,
190: p_tax_exempt_reason_code IN
191: ra_customer_trx_lines.tax_exempt_reason_code%type,
185: ra_customer_trx_lines.sales_tax_id%type,
186: p_location_segment_id IN
187: ra_customer_trx_lines.location_segment_id%type,
188: p_tax_exempt_number IN
189: ra_customer_trx_lines.tax_exempt_number%type,
190: p_tax_exempt_reason_code IN
191: ra_customer_trx_lines.tax_exempt_reason_code%type,
192: p_tax_vendor_return_code IN
193: ra_customer_trx_lines.tax_vendor_return_code%type,
187: ra_customer_trx_lines.location_segment_id%type,
188: p_tax_exempt_number IN
189: ra_customer_trx_lines.tax_exempt_number%type,
190: p_tax_exempt_reason_code IN
191: ra_customer_trx_lines.tax_exempt_reason_code%type,
192: p_tax_vendor_return_code IN
193: ra_customer_trx_lines.tax_vendor_return_code%type,
194: p_taxable_flag IN
195: ra_customer_trx_lines.taxable_flag%type,
189: ra_customer_trx_lines.tax_exempt_number%type,
190: p_tax_exempt_reason_code IN
191: ra_customer_trx_lines.tax_exempt_reason_code%type,
192: p_tax_vendor_return_code IN
193: ra_customer_trx_lines.tax_vendor_return_code%type,
194: p_taxable_flag IN
195: ra_customer_trx_lines.taxable_flag%type,
196: p_tax_exemption_id IN
197: ra_customer_trx_lines.tax_exemption_id%type,
191: ra_customer_trx_lines.tax_exempt_reason_code%type,
192: p_tax_vendor_return_code IN
193: ra_customer_trx_lines.tax_vendor_return_code%type,
194: p_taxable_flag IN
195: ra_customer_trx_lines.taxable_flag%type,
196: p_tax_exemption_id IN
197: ra_customer_trx_lines.tax_exemption_id%type,
198: p_tax_precedence IN
199: ra_customer_trx_lines.tax_precedence%type,
193: ra_customer_trx_lines.tax_vendor_return_code%type,
194: p_taxable_flag IN
195: ra_customer_trx_lines.taxable_flag%type,
196: p_tax_exemption_id IN
197: ra_customer_trx_lines.tax_exemption_id%type,
198: p_tax_precedence IN
199: ra_customer_trx_lines.tax_precedence%type,
200: p_tax_rate IN
201: ra_customer_trx_lines.tax_rate%type,
195: ra_customer_trx_lines.taxable_flag%type,
196: p_tax_exemption_id IN
197: ra_customer_trx_lines.tax_exemption_id%type,
198: p_tax_precedence IN
199: ra_customer_trx_lines.tax_precedence%type,
200: p_tax_rate IN
201: ra_customer_trx_lines.tax_rate%type,
202: p_uom_code IN
203: ra_customer_trx_lines.uom_code%type,
197: ra_customer_trx_lines.tax_exemption_id%type,
198: p_tax_precedence IN
199: ra_customer_trx_lines.tax_precedence%type,
200: p_tax_rate IN
201: ra_customer_trx_lines.tax_rate%type,
202: p_uom_code IN
203: ra_customer_trx_lines.uom_code%type,
204: p_autotax IN
205: ra_customer_trx_lines.autotax%type,
199: ra_customer_trx_lines.tax_precedence%type,
200: p_tax_rate IN
201: ra_customer_trx_lines.tax_rate%type,
202: p_uom_code IN
203: ra_customer_trx_lines.uom_code%type,
204: p_autotax IN
205: ra_customer_trx_lines.autotax%type,
206: p_movement_id IN
207: ra_customer_trx_lines.movement_id%type,
201: ra_customer_trx_lines.tax_rate%type,
202: p_uom_code IN
203: ra_customer_trx_lines.uom_code%type,
204: p_autotax IN
205: ra_customer_trx_lines.autotax%type,
206: p_movement_id IN
207: ra_customer_trx_lines.movement_id%type,
208: p_default_ussgl_trx_code IN
209: ra_customer_trx_lines.default_ussgl_transaction_code%type,
203: ra_customer_trx_lines.uom_code%type,
204: p_autotax IN
205: ra_customer_trx_lines.autotax%type,
206: p_movement_id IN
207: ra_customer_trx_lines.movement_id%type,
208: p_default_ussgl_trx_code IN
209: ra_customer_trx_lines.default_ussgl_transaction_code%type,
210: p_default_ussgl_trx_code_cntxt IN
211: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
205: ra_customer_trx_lines.autotax%type,
206: p_movement_id IN
207: ra_customer_trx_lines.movement_id%type,
208: p_default_ussgl_trx_code IN
209: ra_customer_trx_lines.default_ussgl_transaction_code%type,
210: p_default_ussgl_trx_code_cntxt IN
211: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
212: p_interface_line_context IN
213: ra_customer_trx_lines.interface_line_context%type,
207: ra_customer_trx_lines.movement_id%type,
208: p_default_ussgl_trx_code IN
209: ra_customer_trx_lines.default_ussgl_transaction_code%type,
210: p_default_ussgl_trx_code_cntxt IN
211: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
212: p_interface_line_context IN
213: ra_customer_trx_lines.interface_line_context%type,
214: p_interface_line_attribute1 IN
215: ra_customer_trx_lines.interface_line_attribute1%type,
209: ra_customer_trx_lines.default_ussgl_transaction_code%type,
210: p_default_ussgl_trx_code_cntxt IN
211: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
212: p_interface_line_context IN
213: ra_customer_trx_lines.interface_line_context%type,
214: p_interface_line_attribute1 IN
215: ra_customer_trx_lines.interface_line_attribute1%type,
216: p_interface_line_attribute2 IN
217: ra_customer_trx_lines.interface_line_attribute2%type,
211: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
212: p_interface_line_context IN
213: ra_customer_trx_lines.interface_line_context%type,
214: p_interface_line_attribute1 IN
215: ra_customer_trx_lines.interface_line_attribute1%type,
216: p_interface_line_attribute2 IN
217: ra_customer_trx_lines.interface_line_attribute2%type,
218: p_interface_line_attribute3 IN
219: ra_customer_trx_lines.interface_line_attribute3%type,
213: ra_customer_trx_lines.interface_line_context%type,
214: p_interface_line_attribute1 IN
215: ra_customer_trx_lines.interface_line_attribute1%type,
216: p_interface_line_attribute2 IN
217: ra_customer_trx_lines.interface_line_attribute2%type,
218: p_interface_line_attribute3 IN
219: ra_customer_trx_lines.interface_line_attribute3%type,
220: p_interface_line_attribute4 IN
221: ra_customer_trx_lines.interface_line_attribute4%type,
215: ra_customer_trx_lines.interface_line_attribute1%type,
216: p_interface_line_attribute2 IN
217: ra_customer_trx_lines.interface_line_attribute2%type,
218: p_interface_line_attribute3 IN
219: ra_customer_trx_lines.interface_line_attribute3%type,
220: p_interface_line_attribute4 IN
221: ra_customer_trx_lines.interface_line_attribute4%type,
222: p_interface_line_attribute5 IN
223: ra_customer_trx_lines.interface_line_attribute5%type,
217: ra_customer_trx_lines.interface_line_attribute2%type,
218: p_interface_line_attribute3 IN
219: ra_customer_trx_lines.interface_line_attribute3%type,
220: p_interface_line_attribute4 IN
221: ra_customer_trx_lines.interface_line_attribute4%type,
222: p_interface_line_attribute5 IN
223: ra_customer_trx_lines.interface_line_attribute5%type,
224: p_interface_line_attribute6 IN
225: ra_customer_trx_lines.interface_line_attribute6%type,
219: ra_customer_trx_lines.interface_line_attribute3%type,
220: p_interface_line_attribute4 IN
221: ra_customer_trx_lines.interface_line_attribute4%type,
222: p_interface_line_attribute5 IN
223: ra_customer_trx_lines.interface_line_attribute5%type,
224: p_interface_line_attribute6 IN
225: ra_customer_trx_lines.interface_line_attribute6%type,
226: p_interface_line_attribute7 IN
227: ra_customer_trx_lines.interface_line_attribute7%type,
221: ra_customer_trx_lines.interface_line_attribute4%type,
222: p_interface_line_attribute5 IN
223: ra_customer_trx_lines.interface_line_attribute5%type,
224: p_interface_line_attribute6 IN
225: ra_customer_trx_lines.interface_line_attribute6%type,
226: p_interface_line_attribute7 IN
227: ra_customer_trx_lines.interface_line_attribute7%type,
228: p_interface_line_attribute8 IN
229: ra_customer_trx_lines.interface_line_attribute8%type,
223: ra_customer_trx_lines.interface_line_attribute5%type,
224: p_interface_line_attribute6 IN
225: ra_customer_trx_lines.interface_line_attribute6%type,
226: p_interface_line_attribute7 IN
227: ra_customer_trx_lines.interface_line_attribute7%type,
228: p_interface_line_attribute8 IN
229: ra_customer_trx_lines.interface_line_attribute8%type,
230: p_interface_line_attribute9 IN
231: ra_customer_trx_lines.interface_line_attribute9%type,
225: ra_customer_trx_lines.interface_line_attribute6%type,
226: p_interface_line_attribute7 IN
227: ra_customer_trx_lines.interface_line_attribute7%type,
228: p_interface_line_attribute8 IN
229: ra_customer_trx_lines.interface_line_attribute8%type,
230: p_interface_line_attribute9 IN
231: ra_customer_trx_lines.interface_line_attribute9%type,
232: p_interface_line_attribute10 IN
233: ra_customer_trx_lines.interface_line_attribute10%type,
227: ra_customer_trx_lines.interface_line_attribute7%type,
228: p_interface_line_attribute8 IN
229: ra_customer_trx_lines.interface_line_attribute8%type,
230: p_interface_line_attribute9 IN
231: ra_customer_trx_lines.interface_line_attribute9%type,
232: p_interface_line_attribute10 IN
233: ra_customer_trx_lines.interface_line_attribute10%type,
234: p_interface_line_attribute11 IN
235: ra_customer_trx_lines.interface_line_attribute11%type,
229: ra_customer_trx_lines.interface_line_attribute8%type,
230: p_interface_line_attribute9 IN
231: ra_customer_trx_lines.interface_line_attribute9%type,
232: p_interface_line_attribute10 IN
233: ra_customer_trx_lines.interface_line_attribute10%type,
234: p_interface_line_attribute11 IN
235: ra_customer_trx_lines.interface_line_attribute11%type,
236: p_interface_line_attribute12 IN
237: ra_customer_trx_lines.interface_line_attribute12%type,
231: ra_customer_trx_lines.interface_line_attribute9%type,
232: p_interface_line_attribute10 IN
233: ra_customer_trx_lines.interface_line_attribute10%type,
234: p_interface_line_attribute11 IN
235: ra_customer_trx_lines.interface_line_attribute11%type,
236: p_interface_line_attribute12 IN
237: ra_customer_trx_lines.interface_line_attribute12%type,
238: p_interface_line_attribute13 IN
239: ra_customer_trx_lines.interface_line_attribute13%type,
233: ra_customer_trx_lines.interface_line_attribute10%type,
234: p_interface_line_attribute11 IN
235: ra_customer_trx_lines.interface_line_attribute11%type,
236: p_interface_line_attribute12 IN
237: ra_customer_trx_lines.interface_line_attribute12%type,
238: p_interface_line_attribute13 IN
239: ra_customer_trx_lines.interface_line_attribute13%type,
240: p_interface_line_attribute14 IN
241: ra_customer_trx_lines.interface_line_attribute14%type,
235: ra_customer_trx_lines.interface_line_attribute11%type,
236: p_interface_line_attribute12 IN
237: ra_customer_trx_lines.interface_line_attribute12%type,
238: p_interface_line_attribute13 IN
239: ra_customer_trx_lines.interface_line_attribute13%type,
240: p_interface_line_attribute14 IN
241: ra_customer_trx_lines.interface_line_attribute14%type,
242: p_interface_line_attribute15 IN
243: ra_customer_trx_lines.interface_line_attribute15%type,
237: ra_customer_trx_lines.interface_line_attribute12%type,
238: p_interface_line_attribute13 IN
239: ra_customer_trx_lines.interface_line_attribute13%type,
240: p_interface_line_attribute14 IN
241: ra_customer_trx_lines.interface_line_attribute14%type,
242: p_interface_line_attribute15 IN
243: ra_customer_trx_lines.interface_line_attribute15%type,
244: p_attribute_category IN
245: ra_customer_trx_lines.attribute_category%type,
239: ra_customer_trx_lines.interface_line_attribute13%type,
240: p_interface_line_attribute14 IN
241: ra_customer_trx_lines.interface_line_attribute14%type,
242: p_interface_line_attribute15 IN
243: ra_customer_trx_lines.interface_line_attribute15%type,
244: p_attribute_category IN
245: ra_customer_trx_lines.attribute_category%type,
246: p_attribute1 IN
247: ra_customer_trx_lines.attribute1%type,
241: ra_customer_trx_lines.interface_line_attribute14%type,
242: p_interface_line_attribute15 IN
243: ra_customer_trx_lines.interface_line_attribute15%type,
244: p_attribute_category IN
245: ra_customer_trx_lines.attribute_category%type,
246: p_attribute1 IN
247: ra_customer_trx_lines.attribute1%type,
248: p_attribute2 IN
249: ra_customer_trx_lines.attribute2%type,
243: ra_customer_trx_lines.interface_line_attribute15%type,
244: p_attribute_category IN
245: ra_customer_trx_lines.attribute_category%type,
246: p_attribute1 IN
247: ra_customer_trx_lines.attribute1%type,
248: p_attribute2 IN
249: ra_customer_trx_lines.attribute2%type,
250: p_attribute3 IN
251: ra_customer_trx_lines.attribute3%type,
245: ra_customer_trx_lines.attribute_category%type,
246: p_attribute1 IN
247: ra_customer_trx_lines.attribute1%type,
248: p_attribute2 IN
249: ra_customer_trx_lines.attribute2%type,
250: p_attribute3 IN
251: ra_customer_trx_lines.attribute3%type,
252: p_attribute4 IN
253: ra_customer_trx_lines.attribute4%type,
247: ra_customer_trx_lines.attribute1%type,
248: p_attribute2 IN
249: ra_customer_trx_lines.attribute2%type,
250: p_attribute3 IN
251: ra_customer_trx_lines.attribute3%type,
252: p_attribute4 IN
253: ra_customer_trx_lines.attribute4%type,
254: p_attribute5 IN
255: ra_customer_trx_lines.attribute5%type,
249: ra_customer_trx_lines.attribute2%type,
250: p_attribute3 IN
251: ra_customer_trx_lines.attribute3%type,
252: p_attribute4 IN
253: ra_customer_trx_lines.attribute4%type,
254: p_attribute5 IN
255: ra_customer_trx_lines.attribute5%type,
256: p_attribute6 IN
257: ra_customer_trx_lines.attribute6%type,
251: ra_customer_trx_lines.attribute3%type,
252: p_attribute4 IN
253: ra_customer_trx_lines.attribute4%type,
254: p_attribute5 IN
255: ra_customer_trx_lines.attribute5%type,
256: p_attribute6 IN
257: ra_customer_trx_lines.attribute6%type,
258: p_attribute7 IN
259: ra_customer_trx_lines.attribute7%type,
253: ra_customer_trx_lines.attribute4%type,
254: p_attribute5 IN
255: ra_customer_trx_lines.attribute5%type,
256: p_attribute6 IN
257: ra_customer_trx_lines.attribute6%type,
258: p_attribute7 IN
259: ra_customer_trx_lines.attribute7%type,
260: p_attribute8 IN
261: ra_customer_trx_lines.attribute8%type,
255: ra_customer_trx_lines.attribute5%type,
256: p_attribute6 IN
257: ra_customer_trx_lines.attribute6%type,
258: p_attribute7 IN
259: ra_customer_trx_lines.attribute7%type,
260: p_attribute8 IN
261: ra_customer_trx_lines.attribute8%type,
262: p_attribute9 IN
263: ra_customer_trx_lines.attribute9%type,
257: ra_customer_trx_lines.attribute6%type,
258: p_attribute7 IN
259: ra_customer_trx_lines.attribute7%type,
260: p_attribute8 IN
261: ra_customer_trx_lines.attribute8%type,
262: p_attribute9 IN
263: ra_customer_trx_lines.attribute9%type,
264: p_attribute10 IN
265: ra_customer_trx_lines.attribute10%type,
259: ra_customer_trx_lines.attribute7%type,
260: p_attribute8 IN
261: ra_customer_trx_lines.attribute8%type,
262: p_attribute9 IN
263: ra_customer_trx_lines.attribute9%type,
264: p_attribute10 IN
265: ra_customer_trx_lines.attribute10%type,
266: p_attribute11 IN
267: ra_customer_trx_lines.attribute11%type,
261: ra_customer_trx_lines.attribute8%type,
262: p_attribute9 IN
263: ra_customer_trx_lines.attribute9%type,
264: p_attribute10 IN
265: ra_customer_trx_lines.attribute10%type,
266: p_attribute11 IN
267: ra_customer_trx_lines.attribute11%type,
268: p_attribute12 IN
269: ra_customer_trx_lines.attribute12%type,
263: ra_customer_trx_lines.attribute9%type,
264: p_attribute10 IN
265: ra_customer_trx_lines.attribute10%type,
266: p_attribute11 IN
267: ra_customer_trx_lines.attribute11%type,
268: p_attribute12 IN
269: ra_customer_trx_lines.attribute12%type,
270: p_attribute13 IN
271: ra_customer_trx_lines.attribute13%type,
265: ra_customer_trx_lines.attribute10%type,
266: p_attribute11 IN
267: ra_customer_trx_lines.attribute11%type,
268: p_attribute12 IN
269: ra_customer_trx_lines.attribute12%type,
270: p_attribute13 IN
271: ra_customer_trx_lines.attribute13%type,
272: p_attribute14 IN
273: ra_customer_trx_lines.attribute14%type,
267: ra_customer_trx_lines.attribute11%type,
268: p_attribute12 IN
269: ra_customer_trx_lines.attribute12%type,
270: p_attribute13 IN
271: ra_customer_trx_lines.attribute13%type,
272: p_attribute14 IN
273: ra_customer_trx_lines.attribute14%type,
274: p_attribute15 IN
275: ra_customer_trx_lines.attribute15%type,
269: ra_customer_trx_lines.attribute12%type,
270: p_attribute13 IN
271: ra_customer_trx_lines.attribute13%type,
272: p_attribute14 IN
273: ra_customer_trx_lines.attribute14%type,
274: p_attribute15 IN
275: ra_customer_trx_lines.attribute15%type,
276: p_unit_selling_price IN
277: ra_customer_trx_lines.unit_selling_price%type,
271: ra_customer_trx_lines.attribute13%type,
272: p_attribute14 IN
273: ra_customer_trx_lines.attribute14%type,
274: p_attribute15 IN
275: ra_customer_trx_lines.attribute15%type,
276: p_unit_selling_price IN
277: ra_customer_trx_lines.unit_selling_price%type,
278: p_extended_amount IN
279: ra_customer_trx_lines.extended_amount%type,
273: ra_customer_trx_lines.attribute14%type,
274: p_attribute15 IN
275: ra_customer_trx_lines.attribute15%type,
276: p_unit_selling_price IN
277: ra_customer_trx_lines.unit_selling_price%type,
278: p_extended_amount IN
279: ra_customer_trx_lines.extended_amount%type,
280: p_amount_includes_tax_flag IN
281: ra_customer_trx_lines.amount_includes_tax_flag%type,
275: ra_customer_trx_lines.attribute15%type,
276: p_unit_selling_price IN
277: ra_customer_trx_lines.unit_selling_price%type,
278: p_extended_amount IN
279: ra_customer_trx_lines.extended_amount%type,
280: p_amount_includes_tax_flag IN
281: ra_customer_trx_lines.amount_includes_tax_flag%type,
282: p_global_attribute_category IN
283: ra_customer_trx_lines.global_attribute_category%type,
277: ra_customer_trx_lines.unit_selling_price%type,
278: p_extended_amount IN
279: ra_customer_trx_lines.extended_amount%type,
280: p_amount_includes_tax_flag IN
281: ra_customer_trx_lines.amount_includes_tax_flag%type,
282: p_global_attribute_category IN
283: ra_customer_trx_lines.global_attribute_category%type,
284: p_global_attribute1 IN
285: ra_customer_trx_lines.global_attribute1%type,
279: ra_customer_trx_lines.extended_amount%type,
280: p_amount_includes_tax_flag IN
281: ra_customer_trx_lines.amount_includes_tax_flag%type,
282: p_global_attribute_category IN
283: ra_customer_trx_lines.global_attribute_category%type,
284: p_global_attribute1 IN
285: ra_customer_trx_lines.global_attribute1%type,
286: p_global_attribute2 IN
287: ra_customer_trx_lines.global_attribute2%type,
281: ra_customer_trx_lines.amount_includes_tax_flag%type,
282: p_global_attribute_category IN
283: ra_customer_trx_lines.global_attribute_category%type,
284: p_global_attribute1 IN
285: ra_customer_trx_lines.global_attribute1%type,
286: p_global_attribute2 IN
287: ra_customer_trx_lines.global_attribute2%type,
288: p_global_attribute3 IN
289: ra_customer_trx_lines.global_attribute3%type,
283: ra_customer_trx_lines.global_attribute_category%type,
284: p_global_attribute1 IN
285: ra_customer_trx_lines.global_attribute1%type,
286: p_global_attribute2 IN
287: ra_customer_trx_lines.global_attribute2%type,
288: p_global_attribute3 IN
289: ra_customer_trx_lines.global_attribute3%type,
290: p_global_attribute4 IN
291: ra_customer_trx_lines.global_attribute4%type,
285: ra_customer_trx_lines.global_attribute1%type,
286: p_global_attribute2 IN
287: ra_customer_trx_lines.global_attribute2%type,
288: p_global_attribute3 IN
289: ra_customer_trx_lines.global_attribute3%type,
290: p_global_attribute4 IN
291: ra_customer_trx_lines.global_attribute4%type,
292: p_global_attribute5 IN
293: ra_customer_trx_lines.global_attribute5%type,
287: ra_customer_trx_lines.global_attribute2%type,
288: p_global_attribute3 IN
289: ra_customer_trx_lines.global_attribute3%type,
290: p_global_attribute4 IN
291: ra_customer_trx_lines.global_attribute4%type,
292: p_global_attribute5 IN
293: ra_customer_trx_lines.global_attribute5%type,
294: p_global_attribute6 IN
295: ra_customer_trx_lines.global_attribute6%type,
289: ra_customer_trx_lines.global_attribute3%type,
290: p_global_attribute4 IN
291: ra_customer_trx_lines.global_attribute4%type,
292: p_global_attribute5 IN
293: ra_customer_trx_lines.global_attribute5%type,
294: p_global_attribute6 IN
295: ra_customer_trx_lines.global_attribute6%type,
296: p_global_attribute7 IN
297: ra_customer_trx_lines.global_attribute7%type,
291: ra_customer_trx_lines.global_attribute4%type,
292: p_global_attribute5 IN
293: ra_customer_trx_lines.global_attribute5%type,
294: p_global_attribute6 IN
295: ra_customer_trx_lines.global_attribute6%type,
296: p_global_attribute7 IN
297: ra_customer_trx_lines.global_attribute7%type,
298: p_global_attribute8 IN
299: ra_customer_trx_lines.global_attribute8%type,
293: ra_customer_trx_lines.global_attribute5%type,
294: p_global_attribute6 IN
295: ra_customer_trx_lines.global_attribute6%type,
296: p_global_attribute7 IN
297: ra_customer_trx_lines.global_attribute7%type,
298: p_global_attribute8 IN
299: ra_customer_trx_lines.global_attribute8%type,
300: p_global_attribute9 IN
301: ra_customer_trx_lines.global_attribute9%type,
295: ra_customer_trx_lines.global_attribute6%type,
296: p_global_attribute7 IN
297: ra_customer_trx_lines.global_attribute7%type,
298: p_global_attribute8 IN
299: ra_customer_trx_lines.global_attribute8%type,
300: p_global_attribute9 IN
301: ra_customer_trx_lines.global_attribute9%type,
302: p_global_attribute10 IN
303: ra_customer_trx_lines.global_attribute10%type,
297: ra_customer_trx_lines.global_attribute7%type,
298: p_global_attribute8 IN
299: ra_customer_trx_lines.global_attribute8%type,
300: p_global_attribute9 IN
301: ra_customer_trx_lines.global_attribute9%type,
302: p_global_attribute10 IN
303: ra_customer_trx_lines.global_attribute10%type,
304: p_global_attribute11 IN
305: ra_customer_trx_lines.global_attribute11%type,
299: ra_customer_trx_lines.global_attribute8%type,
300: p_global_attribute9 IN
301: ra_customer_trx_lines.global_attribute9%type,
302: p_global_attribute10 IN
303: ra_customer_trx_lines.global_attribute10%type,
304: p_global_attribute11 IN
305: ra_customer_trx_lines.global_attribute11%type,
306: p_global_attribute12 IN
307: ra_customer_trx_lines.global_attribute12%type,
301: ra_customer_trx_lines.global_attribute9%type,
302: p_global_attribute10 IN
303: ra_customer_trx_lines.global_attribute10%type,
304: p_global_attribute11 IN
305: ra_customer_trx_lines.global_attribute11%type,
306: p_global_attribute12 IN
307: ra_customer_trx_lines.global_attribute12%type,
308: p_global_attribute13 IN
309: ra_customer_trx_lines.global_attribute13%type,
303: ra_customer_trx_lines.global_attribute10%type,
304: p_global_attribute11 IN
305: ra_customer_trx_lines.global_attribute11%type,
306: p_global_attribute12 IN
307: ra_customer_trx_lines.global_attribute12%type,
308: p_global_attribute13 IN
309: ra_customer_trx_lines.global_attribute13%type,
310: p_global_attribute14 IN
311: ra_customer_trx_lines.global_attribute14%type,
305: ra_customer_trx_lines.global_attribute11%type,
306: p_global_attribute12 IN
307: ra_customer_trx_lines.global_attribute12%type,
308: p_global_attribute13 IN
309: ra_customer_trx_lines.global_attribute13%type,
310: p_global_attribute14 IN
311: ra_customer_trx_lines.global_attribute14%type,
312: p_global_attribute15 IN
313: ra_customer_trx_lines.global_attribute15%type,
307: ra_customer_trx_lines.global_attribute12%type,
308: p_global_attribute13 IN
309: ra_customer_trx_lines.global_attribute13%type,
310: p_global_attribute14 IN
311: ra_customer_trx_lines.global_attribute14%type,
312: p_global_attribute15 IN
313: ra_customer_trx_lines.global_attribute15%type,
314: p_global_attribute16 IN
315: ra_customer_trx_lines.global_attribute16%type,
309: ra_customer_trx_lines.global_attribute13%type,
310: p_global_attribute14 IN
311: ra_customer_trx_lines.global_attribute14%type,
312: p_global_attribute15 IN
313: ra_customer_trx_lines.global_attribute15%type,
314: p_global_attribute16 IN
315: ra_customer_trx_lines.global_attribute16%type,
316: p_global_attribute17 IN
317: ra_customer_trx_lines.global_attribute17%type,
311: ra_customer_trx_lines.global_attribute14%type,
312: p_global_attribute15 IN
313: ra_customer_trx_lines.global_attribute15%type,
314: p_global_attribute16 IN
315: ra_customer_trx_lines.global_attribute16%type,
316: p_global_attribute17 IN
317: ra_customer_trx_lines.global_attribute17%type,
318: p_global_attribute18 IN
319: ra_customer_trx_lines.global_attribute18%type,
313: ra_customer_trx_lines.global_attribute15%type,
314: p_global_attribute16 IN
315: ra_customer_trx_lines.global_attribute16%type,
316: p_global_attribute17 IN
317: ra_customer_trx_lines.global_attribute17%type,
318: p_global_attribute18 IN
319: ra_customer_trx_lines.global_attribute18%type,
320: p_global_attribute19 IN
321: ra_customer_trx_lines.global_attribute19%type,
315: ra_customer_trx_lines.global_attribute16%type,
316: p_global_attribute17 IN
317: ra_customer_trx_lines.global_attribute17%type,
318: p_global_attribute18 IN
319: ra_customer_trx_lines.global_attribute18%type,
320: p_global_attribute19 IN
321: ra_customer_trx_lines.global_attribute19%type,
322: p_global_attribute20 IN
323: ra_customer_trx_lines.global_attribute20%type,
317: ra_customer_trx_lines.global_attribute17%type,
318: p_global_attribute18 IN
319: ra_customer_trx_lines.global_attribute18%type,
320: p_global_attribute19 IN
321: ra_customer_trx_lines.global_attribute19%type,
322: p_global_attribute20 IN
323: ra_customer_trx_lines.global_attribute20%type,
324: p_warehouse_id IN
325: ra_customer_trx_lines.warehouse_id%type ,
319: ra_customer_trx_lines.global_attribute18%type,
320: p_global_attribute19 IN
321: ra_customer_trx_lines.global_attribute19%type,
322: p_global_attribute20 IN
323: ra_customer_trx_lines.global_attribute20%type,
324: p_warehouse_id IN
325: ra_customer_trx_lines.warehouse_id%type ,
326: p_rule_end_date IN
327: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL)
321: ra_customer_trx_lines.global_attribute19%type,
322: p_global_attribute20 IN
323: ra_customer_trx_lines.global_attribute20%type,
324: p_warehouse_id IN
325: ra_customer_trx_lines.warehouse_id%type ,
326: p_rule_end_date IN
327: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL)
328:
329: IS
323: ra_customer_trx_lines.global_attribute20%type,
324: p_warehouse_id IN
325: ra_customer_trx_lines.warehouse_id%type ,
326: p_rule_end_date IN
327: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL)
328:
329: IS
330:
331: l_line_rec ra_customer_trx_lines%rowtype;
327: ra_customer_trx_lines.rule_end_date%type DEFAULT NULL)
328:
329: IS
330:
331: l_line_rec ra_customer_trx_lines%rowtype;
332:
333: BEGIN
334:
335: IF PG_DEBUG in ('Y', 'C') THEN