6: varchar2,
7: p_form_version IN
8: number,
9: p_customer_trx_line_id IN
10: ra_customer_trx_lines.customer_trx_line_id%type,
11: p_complete_flag IN
12: ra_customer_trx.complete_flag%type,
13: p_recalculate_tax_flag IN
14: boolean,
20: ra_cust_trx_line_gl_dist.gl_date%type,
21: p_trx_date IN OUT NOCOPY
22: ra_customer_trx.trx_date%type,
23: p_customer_trx_id IN
24: ra_customer_trx_lines.customer_trx_id%type,
25: p_line_number IN
26: ra_customer_trx_lines.line_number%type,
27: p_line_type IN
28: ra_customer_trx_lines.line_type%type,
22: ra_customer_trx.trx_date%type,
23: p_customer_trx_id IN
24: ra_customer_trx_lines.customer_trx_id%type,
25: p_line_number IN
26: ra_customer_trx_lines.line_number%type,
27: p_line_type IN
28: ra_customer_trx_lines.line_type%type,
29: p_quantity_credited IN
30: ra_customer_trx_lines.quantity_credited%type,
24: ra_customer_trx_lines.customer_trx_id%type,
25: p_line_number IN
26: ra_customer_trx_lines.line_number%type,
27: p_line_type IN
28: ra_customer_trx_lines.line_type%type,
29: p_quantity_credited IN
30: ra_customer_trx_lines.quantity_credited%type,
31: p_quantity_invoiced IN
32: ra_customer_trx_lines.quantity_invoiced%type,
26: ra_customer_trx_lines.line_number%type,
27: p_line_type IN
28: ra_customer_trx_lines.line_type%type,
29: p_quantity_credited IN
30: ra_customer_trx_lines.quantity_credited%type,
31: p_quantity_invoiced IN
32: ra_customer_trx_lines.quantity_invoiced%type,
33: p_quantity_ordered IN
34: ra_customer_trx_lines.quantity_ordered%type,
28: ra_customer_trx_lines.line_type%type,
29: p_quantity_credited IN
30: ra_customer_trx_lines.quantity_credited%type,
31: p_quantity_invoiced IN
32: ra_customer_trx_lines.quantity_invoiced%type,
33: p_quantity_ordered IN
34: ra_customer_trx_lines.quantity_ordered%type,
35: p_unit_selling_price IN
36: ra_customer_trx_lines.unit_selling_price%type,
30: ra_customer_trx_lines.quantity_credited%type,
31: p_quantity_invoiced IN
32: ra_customer_trx_lines.quantity_invoiced%type,
33: p_quantity_ordered IN
34: ra_customer_trx_lines.quantity_ordered%type,
35: p_unit_selling_price IN
36: ra_customer_trx_lines.unit_selling_price%type,
37: p_unit_standard_price IN
38: ra_customer_trx_lines.unit_standard_price%type,
32: ra_customer_trx_lines.quantity_invoiced%type,
33: p_quantity_ordered IN
34: ra_customer_trx_lines.quantity_ordered%type,
35: p_unit_selling_price IN
36: ra_customer_trx_lines.unit_selling_price%type,
37: p_unit_standard_price IN
38: ra_customer_trx_lines.unit_standard_price%type,
39: p_revenue_amount IN
40: ra_customer_trx_lines.revenue_amount%type,
34: ra_customer_trx_lines.quantity_ordered%type,
35: p_unit_selling_price IN
36: ra_customer_trx_lines.unit_selling_price%type,
37: p_unit_standard_price IN
38: ra_customer_trx_lines.unit_standard_price%type,
39: p_revenue_amount IN
40: ra_customer_trx_lines.revenue_amount%type,
41: p_extended_amount IN
42: ra_customer_trx_lines.extended_amount%type,
36: ra_customer_trx_lines.unit_selling_price%type,
37: p_unit_standard_price IN
38: ra_customer_trx_lines.unit_standard_price%type,
39: p_revenue_amount IN
40: ra_customer_trx_lines.revenue_amount%type,
41: p_extended_amount IN
42: ra_customer_trx_lines.extended_amount%type,
43: p_memo_line_id IN
44: ra_customer_trx_lines.memo_line_id%type,
38: ra_customer_trx_lines.unit_standard_price%type,
39: p_revenue_amount IN
40: ra_customer_trx_lines.revenue_amount%type,
41: p_extended_amount IN
42: ra_customer_trx_lines.extended_amount%type,
43: p_memo_line_id IN
44: ra_customer_trx_lines.memo_line_id%type,
45: p_inventory_item_id IN
46: ra_customer_trx_lines.inventory_item_id%type,
40: ra_customer_trx_lines.revenue_amount%type,
41: p_extended_amount IN
42: ra_customer_trx_lines.extended_amount%type,
43: p_memo_line_id IN
44: ra_customer_trx_lines.memo_line_id%type,
45: p_inventory_item_id IN
46: ra_customer_trx_lines.inventory_item_id%type,
47: p_item_exception_rate_id IN
48: ra_customer_trx_lines.item_exception_rate_id%type,
42: ra_customer_trx_lines.extended_amount%type,
43: p_memo_line_id IN
44: ra_customer_trx_lines.memo_line_id%type,
45: p_inventory_item_id IN
46: ra_customer_trx_lines.inventory_item_id%type,
47: p_item_exception_rate_id IN
48: ra_customer_trx_lines.item_exception_rate_id%type,
49: p_description IN
50: ra_customer_trx_lines.description%type,
44: ra_customer_trx_lines.memo_line_id%type,
45: p_inventory_item_id IN
46: ra_customer_trx_lines.inventory_item_id%type,
47: p_item_exception_rate_id IN
48: ra_customer_trx_lines.item_exception_rate_id%type,
49: p_description IN
50: ra_customer_trx_lines.description%type,
51: p_item_context IN
52: ra_customer_trx_lines.item_context%type,
46: ra_customer_trx_lines.inventory_item_id%type,
47: p_item_exception_rate_id IN
48: ra_customer_trx_lines.item_exception_rate_id%type,
49: p_description IN
50: ra_customer_trx_lines.description%type,
51: p_item_context IN
52: ra_customer_trx_lines.item_context%type,
53: p_initial_customer_trx_line_id IN
54: ra_customer_trx_lines.initial_customer_trx_line_id%type,
48: ra_customer_trx_lines.item_exception_rate_id%type,
49: p_description IN
50: ra_customer_trx_lines.description%type,
51: p_item_context IN
52: ra_customer_trx_lines.item_context%type,
53: p_initial_customer_trx_line_id IN
54: ra_customer_trx_lines.initial_customer_trx_line_id%type,
55: p_link_to_cust_trx_line_id IN
56: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
50: ra_customer_trx_lines.description%type,
51: p_item_context IN
52: ra_customer_trx_lines.item_context%type,
53: p_initial_customer_trx_line_id IN
54: ra_customer_trx_lines.initial_customer_trx_line_id%type,
55: p_link_to_cust_trx_line_id IN
56: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
57: p_previous_customer_trx_id IN
58: ra_customer_trx_lines.previous_customer_trx_id%type,
52: ra_customer_trx_lines.item_context%type,
53: p_initial_customer_trx_line_id IN
54: ra_customer_trx_lines.initial_customer_trx_line_id%type,
55: p_link_to_cust_trx_line_id IN
56: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
57: p_previous_customer_trx_id IN
58: ra_customer_trx_lines.previous_customer_trx_id%type,
59: p_prev_customer_trx_line_id IN
60: ra_customer_trx_lines.previous_customer_trx_line_id%type,
54: ra_customer_trx_lines.initial_customer_trx_line_id%type,
55: p_link_to_cust_trx_line_id IN
56: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
57: p_previous_customer_trx_id IN
58: ra_customer_trx_lines.previous_customer_trx_id%type,
59: p_prev_customer_trx_line_id IN
60: ra_customer_trx_lines.previous_customer_trx_line_id%type,
61: p_accounting_rule_duration IN
62: ra_customer_trx_lines.accounting_rule_duration%type,
56: ra_customer_trx_lines.link_to_cust_trx_line_id%type,
57: p_previous_customer_trx_id IN
58: ra_customer_trx_lines.previous_customer_trx_id%type,
59: p_prev_customer_trx_line_id IN
60: ra_customer_trx_lines.previous_customer_trx_line_id%type,
61: p_accounting_rule_duration IN
62: ra_customer_trx_lines.accounting_rule_duration%type,
63: p_accounting_rule_id IN
64: ra_customer_trx_lines.accounting_rule_id%type,
58: ra_customer_trx_lines.previous_customer_trx_id%type,
59: p_prev_customer_trx_line_id IN
60: ra_customer_trx_lines.previous_customer_trx_line_id%type,
61: p_accounting_rule_duration IN
62: ra_customer_trx_lines.accounting_rule_duration%type,
63: p_accounting_rule_id IN
64: ra_customer_trx_lines.accounting_rule_id%type,
65: p_rule_start_date IN
66: ra_customer_trx_lines.rule_start_date%type,
60: ra_customer_trx_lines.previous_customer_trx_line_id%type,
61: p_accounting_rule_duration IN
62: ra_customer_trx_lines.accounting_rule_duration%type,
63: p_accounting_rule_id IN
64: ra_customer_trx_lines.accounting_rule_id%type,
65: p_rule_start_date IN
66: ra_customer_trx_lines.rule_start_date%type,
67: p_autorule_complete_flag IN
68: ra_customer_trx_lines.autorule_complete_flag%type,
62: ra_customer_trx_lines.accounting_rule_duration%type,
63: p_accounting_rule_id IN
64: ra_customer_trx_lines.accounting_rule_id%type,
65: p_rule_start_date IN
66: ra_customer_trx_lines.rule_start_date%type,
67: p_autorule_complete_flag IN
68: ra_customer_trx_lines.autorule_complete_flag%type,
69: p_autorule_duration_processed IN
70: ra_customer_trx_lines.autorule_duration_processed%type,
64: ra_customer_trx_lines.accounting_rule_id%type,
65: p_rule_start_date IN
66: ra_customer_trx_lines.rule_start_date%type,
67: p_autorule_complete_flag IN
68: ra_customer_trx_lines.autorule_complete_flag%type,
69: p_autorule_duration_processed IN
70: ra_customer_trx_lines.autorule_duration_processed%type,
71: p_reason_code IN
72: ra_customer_trx_lines.reason_code%type,
66: ra_customer_trx_lines.rule_start_date%type,
67: p_autorule_complete_flag IN
68: ra_customer_trx_lines.autorule_complete_flag%type,
69: p_autorule_duration_processed IN
70: ra_customer_trx_lines.autorule_duration_processed%type,
71: p_reason_code IN
72: ra_customer_trx_lines.reason_code%type,
73: p_last_period_to_credit IN
74: ra_customer_trx_lines.last_period_to_credit%type,
68: ra_customer_trx_lines.autorule_complete_flag%type,
69: p_autorule_duration_processed IN
70: ra_customer_trx_lines.autorule_duration_processed%type,
71: p_reason_code IN
72: ra_customer_trx_lines.reason_code%type,
73: p_last_period_to_credit IN
74: ra_customer_trx_lines.last_period_to_credit%type,
75: p_sales_order IN
76: ra_customer_trx_lines.sales_order%type,
70: ra_customer_trx_lines.autorule_duration_processed%type,
71: p_reason_code IN
72: ra_customer_trx_lines.reason_code%type,
73: p_last_period_to_credit IN
74: ra_customer_trx_lines.last_period_to_credit%type,
75: p_sales_order IN
76: ra_customer_trx_lines.sales_order%type,
77: p_sales_order_date IN
78: ra_customer_trx_lines.sales_order_date%type,
72: ra_customer_trx_lines.reason_code%type,
73: p_last_period_to_credit IN
74: ra_customer_trx_lines.last_period_to_credit%type,
75: p_sales_order IN
76: ra_customer_trx_lines.sales_order%type,
77: p_sales_order_date IN
78: ra_customer_trx_lines.sales_order_date%type,
79: p_sales_order_line IN
80: ra_customer_trx_lines.sales_order_line%type,
74: ra_customer_trx_lines.last_period_to_credit%type,
75: p_sales_order IN
76: ra_customer_trx_lines.sales_order%type,
77: p_sales_order_date IN
78: ra_customer_trx_lines.sales_order_date%type,
79: p_sales_order_line IN
80: ra_customer_trx_lines.sales_order_line%type,
81: p_sales_order_revision IN
82: ra_customer_trx_lines.sales_order_revision%type,
76: ra_customer_trx_lines.sales_order%type,
77: p_sales_order_date IN
78: ra_customer_trx_lines.sales_order_date%type,
79: p_sales_order_line IN
80: ra_customer_trx_lines.sales_order_line%type,
81: p_sales_order_revision IN
82: ra_customer_trx_lines.sales_order_revision%type,
83: p_sales_order_source IN
84: ra_customer_trx_lines.sales_order_source%type,
78: ra_customer_trx_lines.sales_order_date%type,
79: p_sales_order_line IN
80: ra_customer_trx_lines.sales_order_line%type,
81: p_sales_order_revision IN
82: ra_customer_trx_lines.sales_order_revision%type,
83: p_sales_order_source IN
84: ra_customer_trx_lines.sales_order_source%type,
85: p_vat_tax_id IN
86: ra_customer_trx_lines.vat_tax_id%type,
80: ra_customer_trx_lines.sales_order_line%type,
81: p_sales_order_revision IN
82: ra_customer_trx_lines.sales_order_revision%type,
83: p_sales_order_source IN
84: ra_customer_trx_lines.sales_order_source%type,
85: p_vat_tax_id IN
86: ra_customer_trx_lines.vat_tax_id%type,
87: p_tax_exempt_flag IN
88: ra_customer_trx_lines.tax_exempt_flag%type,
82: ra_customer_trx_lines.sales_order_revision%type,
83: p_sales_order_source IN
84: ra_customer_trx_lines.sales_order_source%type,
85: p_vat_tax_id IN
86: ra_customer_trx_lines.vat_tax_id%type,
87: p_tax_exempt_flag IN
88: ra_customer_trx_lines.tax_exempt_flag%type,
89: p_sales_tax_id IN
90: ra_customer_trx_lines.sales_tax_id%type,
84: ra_customer_trx_lines.sales_order_source%type,
85: p_vat_tax_id IN
86: ra_customer_trx_lines.vat_tax_id%type,
87: p_tax_exempt_flag IN
88: ra_customer_trx_lines.tax_exempt_flag%type,
89: p_sales_tax_id IN
90: ra_customer_trx_lines.sales_tax_id%type,
91: p_location_segment_id IN
92: ra_customer_trx_lines.location_segment_id%type,
86: ra_customer_trx_lines.vat_tax_id%type,
87: p_tax_exempt_flag IN
88: ra_customer_trx_lines.tax_exempt_flag%type,
89: p_sales_tax_id IN
90: ra_customer_trx_lines.sales_tax_id%type,
91: p_location_segment_id IN
92: ra_customer_trx_lines.location_segment_id%type,
93: p_tax_exempt_number IN
94: ra_customer_trx_lines.tax_exempt_number%type,
88: ra_customer_trx_lines.tax_exempt_flag%type,
89: p_sales_tax_id IN
90: ra_customer_trx_lines.sales_tax_id%type,
91: p_location_segment_id IN
92: ra_customer_trx_lines.location_segment_id%type,
93: p_tax_exempt_number IN
94: ra_customer_trx_lines.tax_exempt_number%type,
95: p_tax_exempt_reason_code IN
96: ra_customer_trx_lines.tax_exempt_reason_code%type,
90: ra_customer_trx_lines.sales_tax_id%type,
91: p_location_segment_id IN
92: ra_customer_trx_lines.location_segment_id%type,
93: p_tax_exempt_number IN
94: ra_customer_trx_lines.tax_exempt_number%type,
95: p_tax_exempt_reason_code IN
96: ra_customer_trx_lines.tax_exempt_reason_code%type,
97: p_tax_vendor_return_code IN
98: ra_customer_trx_lines.tax_vendor_return_code%type,
92: ra_customer_trx_lines.location_segment_id%type,
93: p_tax_exempt_number IN
94: ra_customer_trx_lines.tax_exempt_number%type,
95: p_tax_exempt_reason_code IN
96: ra_customer_trx_lines.tax_exempt_reason_code%type,
97: p_tax_vendor_return_code IN
98: ra_customer_trx_lines.tax_vendor_return_code%type,
99: p_taxable_flag IN
100: ra_customer_trx_lines.taxable_flag%type,
94: ra_customer_trx_lines.tax_exempt_number%type,
95: p_tax_exempt_reason_code IN
96: ra_customer_trx_lines.tax_exempt_reason_code%type,
97: p_tax_vendor_return_code IN
98: ra_customer_trx_lines.tax_vendor_return_code%type,
99: p_taxable_flag IN
100: ra_customer_trx_lines.taxable_flag%type,
101: p_tax_exemption_id IN
102: ra_customer_trx_lines.tax_exemption_id%type,
96: ra_customer_trx_lines.tax_exempt_reason_code%type,
97: p_tax_vendor_return_code IN
98: ra_customer_trx_lines.tax_vendor_return_code%type,
99: p_taxable_flag IN
100: ra_customer_trx_lines.taxable_flag%type,
101: p_tax_exemption_id IN
102: ra_customer_trx_lines.tax_exemption_id%type,
103: p_tax_precedence IN
104: ra_customer_trx_lines.tax_precedence%type,
98: ra_customer_trx_lines.tax_vendor_return_code%type,
99: p_taxable_flag IN
100: ra_customer_trx_lines.taxable_flag%type,
101: p_tax_exemption_id IN
102: ra_customer_trx_lines.tax_exemption_id%type,
103: p_tax_precedence IN
104: ra_customer_trx_lines.tax_precedence%type,
105: p_tax_rate IN
106: ra_customer_trx_lines.tax_rate%type,
100: ra_customer_trx_lines.taxable_flag%type,
101: p_tax_exemption_id IN
102: ra_customer_trx_lines.tax_exemption_id%type,
103: p_tax_precedence IN
104: ra_customer_trx_lines.tax_precedence%type,
105: p_tax_rate IN
106: ra_customer_trx_lines.tax_rate%type,
107: p_uom_code IN
108: ra_customer_trx_lines.uom_code%type,
102: ra_customer_trx_lines.tax_exemption_id%type,
103: p_tax_precedence IN
104: ra_customer_trx_lines.tax_precedence%type,
105: p_tax_rate IN
106: ra_customer_trx_lines.tax_rate%type,
107: p_uom_code IN
108: ra_customer_trx_lines.uom_code%type,
109: p_autotax IN
110: ra_customer_trx_lines.autotax%type,
104: ra_customer_trx_lines.tax_precedence%type,
105: p_tax_rate IN
106: ra_customer_trx_lines.tax_rate%type,
107: p_uom_code IN
108: ra_customer_trx_lines.uom_code%type,
109: p_autotax IN
110: ra_customer_trx_lines.autotax%type,
111: p_movement_id IN
112: ra_customer_trx_lines.movement_id%type,
106: ra_customer_trx_lines.tax_rate%type,
107: p_uom_code IN
108: ra_customer_trx_lines.uom_code%type,
109: p_autotax IN
110: ra_customer_trx_lines.autotax%type,
111: p_movement_id IN
112: ra_customer_trx_lines.movement_id%type,
113: p_default_ussgl_trx_code IN
114: ra_customer_trx_lines.default_ussgl_transaction_code%type,
108: ra_customer_trx_lines.uom_code%type,
109: p_autotax IN
110: ra_customer_trx_lines.autotax%type,
111: p_movement_id IN
112: ra_customer_trx_lines.movement_id%type,
113: p_default_ussgl_trx_code IN
114: ra_customer_trx_lines.default_ussgl_transaction_code%type,
115: p_default_ussgl_trx_code_cntxt IN
116: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
110: ra_customer_trx_lines.autotax%type,
111: p_movement_id IN
112: ra_customer_trx_lines.movement_id%type,
113: p_default_ussgl_trx_code IN
114: ra_customer_trx_lines.default_ussgl_transaction_code%type,
115: p_default_ussgl_trx_code_cntxt IN
116: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
117: p_interface_line_context IN
118: ra_customer_trx_lines.interface_line_context%type,
112: ra_customer_trx_lines.movement_id%type,
113: p_default_ussgl_trx_code IN
114: ra_customer_trx_lines.default_ussgl_transaction_code%type,
115: p_default_ussgl_trx_code_cntxt IN
116: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
117: p_interface_line_context IN
118: ra_customer_trx_lines.interface_line_context%type,
119: p_interface_line_attribute1 IN
120: ra_customer_trx_lines.interface_line_attribute1%type,
114: ra_customer_trx_lines.default_ussgl_transaction_code%type,
115: p_default_ussgl_trx_code_cntxt IN
116: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
117: p_interface_line_context IN
118: ra_customer_trx_lines.interface_line_context%type,
119: p_interface_line_attribute1 IN
120: ra_customer_trx_lines.interface_line_attribute1%type,
121: p_interface_line_attribute2 IN
122: ra_customer_trx_lines.interface_line_attribute2%type,
116: ra_customer_trx_lines.default_ussgl_trx_code_context%type,
117: p_interface_line_context IN
118: ra_customer_trx_lines.interface_line_context%type,
119: p_interface_line_attribute1 IN
120: ra_customer_trx_lines.interface_line_attribute1%type,
121: p_interface_line_attribute2 IN
122: ra_customer_trx_lines.interface_line_attribute2%type,
123: p_interface_line_attribute3 IN
124: ra_customer_trx_lines.interface_line_attribute3%type,
118: ra_customer_trx_lines.interface_line_context%type,
119: p_interface_line_attribute1 IN
120: ra_customer_trx_lines.interface_line_attribute1%type,
121: p_interface_line_attribute2 IN
122: ra_customer_trx_lines.interface_line_attribute2%type,
123: p_interface_line_attribute3 IN
124: ra_customer_trx_lines.interface_line_attribute3%type,
125: p_interface_line_attribute4 IN
126: ra_customer_trx_lines.interface_line_attribute4%type,
120: ra_customer_trx_lines.interface_line_attribute1%type,
121: p_interface_line_attribute2 IN
122: ra_customer_trx_lines.interface_line_attribute2%type,
123: p_interface_line_attribute3 IN
124: ra_customer_trx_lines.interface_line_attribute3%type,
125: p_interface_line_attribute4 IN
126: ra_customer_trx_lines.interface_line_attribute4%type,
127: p_interface_line_attribute5 IN
128: ra_customer_trx_lines.interface_line_attribute5%type,
122: ra_customer_trx_lines.interface_line_attribute2%type,
123: p_interface_line_attribute3 IN
124: ra_customer_trx_lines.interface_line_attribute3%type,
125: p_interface_line_attribute4 IN
126: ra_customer_trx_lines.interface_line_attribute4%type,
127: p_interface_line_attribute5 IN
128: ra_customer_trx_lines.interface_line_attribute5%type,
129: p_interface_line_attribute6 IN
130: ra_customer_trx_lines.interface_line_attribute6%type,
124: ra_customer_trx_lines.interface_line_attribute3%type,
125: p_interface_line_attribute4 IN
126: ra_customer_trx_lines.interface_line_attribute4%type,
127: p_interface_line_attribute5 IN
128: ra_customer_trx_lines.interface_line_attribute5%type,
129: p_interface_line_attribute6 IN
130: ra_customer_trx_lines.interface_line_attribute6%type,
131: p_interface_line_attribute7 IN
132: ra_customer_trx_lines.interface_line_attribute7%type,
126: ra_customer_trx_lines.interface_line_attribute4%type,
127: p_interface_line_attribute5 IN
128: ra_customer_trx_lines.interface_line_attribute5%type,
129: p_interface_line_attribute6 IN
130: ra_customer_trx_lines.interface_line_attribute6%type,
131: p_interface_line_attribute7 IN
132: ra_customer_trx_lines.interface_line_attribute7%type,
133: p_interface_line_attribute8 IN
134: ra_customer_trx_lines.interface_line_attribute8%type,
128: ra_customer_trx_lines.interface_line_attribute5%type,
129: p_interface_line_attribute6 IN
130: ra_customer_trx_lines.interface_line_attribute6%type,
131: p_interface_line_attribute7 IN
132: ra_customer_trx_lines.interface_line_attribute7%type,
133: p_interface_line_attribute8 IN
134: ra_customer_trx_lines.interface_line_attribute8%type,
135: p_interface_line_attribute9 IN
136: ra_customer_trx_lines.interface_line_attribute9%type,
130: ra_customer_trx_lines.interface_line_attribute6%type,
131: p_interface_line_attribute7 IN
132: ra_customer_trx_lines.interface_line_attribute7%type,
133: p_interface_line_attribute8 IN
134: ra_customer_trx_lines.interface_line_attribute8%type,
135: p_interface_line_attribute9 IN
136: ra_customer_trx_lines.interface_line_attribute9%type,
137: p_interface_line_attribute10 IN
138: ra_customer_trx_lines.interface_line_attribute10%type,
132: ra_customer_trx_lines.interface_line_attribute7%type,
133: p_interface_line_attribute8 IN
134: ra_customer_trx_lines.interface_line_attribute8%type,
135: p_interface_line_attribute9 IN
136: ra_customer_trx_lines.interface_line_attribute9%type,
137: p_interface_line_attribute10 IN
138: ra_customer_trx_lines.interface_line_attribute10%type,
139: p_interface_line_attribute11 IN
140: ra_customer_trx_lines.interface_line_attribute11%type,
134: ra_customer_trx_lines.interface_line_attribute8%type,
135: p_interface_line_attribute9 IN
136: ra_customer_trx_lines.interface_line_attribute9%type,
137: p_interface_line_attribute10 IN
138: ra_customer_trx_lines.interface_line_attribute10%type,
139: p_interface_line_attribute11 IN
140: ra_customer_trx_lines.interface_line_attribute11%type,
141: p_interface_line_attribute12 IN
142: ra_customer_trx_lines.interface_line_attribute12%type,
136: ra_customer_trx_lines.interface_line_attribute9%type,
137: p_interface_line_attribute10 IN
138: ra_customer_trx_lines.interface_line_attribute10%type,
139: p_interface_line_attribute11 IN
140: ra_customer_trx_lines.interface_line_attribute11%type,
141: p_interface_line_attribute12 IN
142: ra_customer_trx_lines.interface_line_attribute12%type,
143: p_interface_line_attribute13 IN
144: ra_customer_trx_lines.interface_line_attribute13%type,
138: ra_customer_trx_lines.interface_line_attribute10%type,
139: p_interface_line_attribute11 IN
140: ra_customer_trx_lines.interface_line_attribute11%type,
141: p_interface_line_attribute12 IN
142: ra_customer_trx_lines.interface_line_attribute12%type,
143: p_interface_line_attribute13 IN
144: ra_customer_trx_lines.interface_line_attribute13%type,
145: p_interface_line_attribute14 IN
146: ra_customer_trx_lines.interface_line_attribute14%type,
140: ra_customer_trx_lines.interface_line_attribute11%type,
141: p_interface_line_attribute12 IN
142: ra_customer_trx_lines.interface_line_attribute12%type,
143: p_interface_line_attribute13 IN
144: ra_customer_trx_lines.interface_line_attribute13%type,
145: p_interface_line_attribute14 IN
146: ra_customer_trx_lines.interface_line_attribute14%type,
147: p_interface_line_attribute15 IN
148: ra_customer_trx_lines.interface_line_attribute15%type,
142: ra_customer_trx_lines.interface_line_attribute12%type,
143: p_interface_line_attribute13 IN
144: ra_customer_trx_lines.interface_line_attribute13%type,
145: p_interface_line_attribute14 IN
146: ra_customer_trx_lines.interface_line_attribute14%type,
147: p_interface_line_attribute15 IN
148: ra_customer_trx_lines.interface_line_attribute15%type,
149: p_attribute_category IN
150: ra_customer_trx_lines.attribute_category%type,
144: ra_customer_trx_lines.interface_line_attribute13%type,
145: p_interface_line_attribute14 IN
146: ra_customer_trx_lines.interface_line_attribute14%type,
147: p_interface_line_attribute15 IN
148: ra_customer_trx_lines.interface_line_attribute15%type,
149: p_attribute_category IN
150: ra_customer_trx_lines.attribute_category%type,
151: p_attribute1 IN
152: ra_customer_trx_lines.attribute1%type,
146: ra_customer_trx_lines.interface_line_attribute14%type,
147: p_interface_line_attribute15 IN
148: ra_customer_trx_lines.interface_line_attribute15%type,
149: p_attribute_category IN
150: ra_customer_trx_lines.attribute_category%type,
151: p_attribute1 IN
152: ra_customer_trx_lines.attribute1%type,
153: p_attribute2 IN
154: ra_customer_trx_lines.attribute2%type,
148: ra_customer_trx_lines.interface_line_attribute15%type,
149: p_attribute_category IN
150: ra_customer_trx_lines.attribute_category%type,
151: p_attribute1 IN
152: ra_customer_trx_lines.attribute1%type,
153: p_attribute2 IN
154: ra_customer_trx_lines.attribute2%type,
155: p_attribute3 IN
156: ra_customer_trx_lines.attribute3%type,
150: ra_customer_trx_lines.attribute_category%type,
151: p_attribute1 IN
152: ra_customer_trx_lines.attribute1%type,
153: p_attribute2 IN
154: ra_customer_trx_lines.attribute2%type,
155: p_attribute3 IN
156: ra_customer_trx_lines.attribute3%type,
157: p_attribute4 IN
158: ra_customer_trx_lines.attribute4%type,
152: ra_customer_trx_lines.attribute1%type,
153: p_attribute2 IN
154: ra_customer_trx_lines.attribute2%type,
155: p_attribute3 IN
156: ra_customer_trx_lines.attribute3%type,
157: p_attribute4 IN
158: ra_customer_trx_lines.attribute4%type,
159: p_attribute5 IN
160: ra_customer_trx_lines.attribute5%type,
154: ra_customer_trx_lines.attribute2%type,
155: p_attribute3 IN
156: ra_customer_trx_lines.attribute3%type,
157: p_attribute4 IN
158: ra_customer_trx_lines.attribute4%type,
159: p_attribute5 IN
160: ra_customer_trx_lines.attribute5%type,
161: p_attribute6 IN
162: ra_customer_trx_lines.attribute6%type,
156: ra_customer_trx_lines.attribute3%type,
157: p_attribute4 IN
158: ra_customer_trx_lines.attribute4%type,
159: p_attribute5 IN
160: ra_customer_trx_lines.attribute5%type,
161: p_attribute6 IN
162: ra_customer_trx_lines.attribute6%type,
163: p_attribute7 IN
164: ra_customer_trx_lines.attribute7%type,
158: ra_customer_trx_lines.attribute4%type,
159: p_attribute5 IN
160: ra_customer_trx_lines.attribute5%type,
161: p_attribute6 IN
162: ra_customer_trx_lines.attribute6%type,
163: p_attribute7 IN
164: ra_customer_trx_lines.attribute7%type,
165: p_attribute8 IN
166: ra_customer_trx_lines.attribute8%type,
160: ra_customer_trx_lines.attribute5%type,
161: p_attribute6 IN
162: ra_customer_trx_lines.attribute6%type,
163: p_attribute7 IN
164: ra_customer_trx_lines.attribute7%type,
165: p_attribute8 IN
166: ra_customer_trx_lines.attribute8%type,
167: p_attribute9 IN
168: ra_customer_trx_lines.attribute9%type,
162: ra_customer_trx_lines.attribute6%type,
163: p_attribute7 IN
164: ra_customer_trx_lines.attribute7%type,
165: p_attribute8 IN
166: ra_customer_trx_lines.attribute8%type,
167: p_attribute9 IN
168: ra_customer_trx_lines.attribute9%type,
169: p_attribute10 IN
170: ra_customer_trx_lines.attribute10%type,
164: ra_customer_trx_lines.attribute7%type,
165: p_attribute8 IN
166: ra_customer_trx_lines.attribute8%type,
167: p_attribute9 IN
168: ra_customer_trx_lines.attribute9%type,
169: p_attribute10 IN
170: ra_customer_trx_lines.attribute10%type,
171: p_attribute11 IN
172: ra_customer_trx_lines.attribute11%type,
166: ra_customer_trx_lines.attribute8%type,
167: p_attribute9 IN
168: ra_customer_trx_lines.attribute9%type,
169: p_attribute10 IN
170: ra_customer_trx_lines.attribute10%type,
171: p_attribute11 IN
172: ra_customer_trx_lines.attribute11%type,
173: p_attribute12 IN
174: ra_customer_trx_lines.attribute12%type,
168: ra_customer_trx_lines.attribute9%type,
169: p_attribute10 IN
170: ra_customer_trx_lines.attribute10%type,
171: p_attribute11 IN
172: ra_customer_trx_lines.attribute11%type,
173: p_attribute12 IN
174: ra_customer_trx_lines.attribute12%type,
175: p_attribute13 IN
176: ra_customer_trx_lines.attribute13%type,
170: ra_customer_trx_lines.attribute10%type,
171: p_attribute11 IN
172: ra_customer_trx_lines.attribute11%type,
173: p_attribute12 IN
174: ra_customer_trx_lines.attribute12%type,
175: p_attribute13 IN
176: ra_customer_trx_lines.attribute13%type,
177: p_attribute14 IN
178: ra_customer_trx_lines.attribute14%type,
172: ra_customer_trx_lines.attribute11%type,
173: p_attribute12 IN
174: ra_customer_trx_lines.attribute12%type,
175: p_attribute13 IN
176: ra_customer_trx_lines.attribute13%type,
177: p_attribute14 IN
178: ra_customer_trx_lines.attribute14%type,
179: p_attribute15 IN
180: ra_customer_trx_lines.attribute15%type,
174: ra_customer_trx_lines.attribute12%type,
175: p_attribute13 IN
176: ra_customer_trx_lines.attribute13%type,
177: p_attribute14 IN
178: ra_customer_trx_lines.attribute14%type,
179: p_attribute15 IN
180: ra_customer_trx_lines.attribute15%type,
181: p_header_currency_code IN
182: ra_customer_trx.invoice_currency_code%type,
176: ra_customer_trx_lines.attribute13%type,
177: p_attribute14 IN
178: ra_customer_trx_lines.attribute14%type,
179: p_attribute15 IN
180: ra_customer_trx_lines.attribute15%type,
181: p_header_currency_code IN
182: ra_customer_trx.invoice_currency_code%type,
183: p_gross_extended_amount IN
184: ra_customer_trx_lines.gross_extended_amount%type,
180: ra_customer_trx_lines.attribute15%type,
181: p_header_currency_code IN
182: ra_customer_trx.invoice_currency_code%type,
183: p_gross_extended_amount IN
184: ra_customer_trx_lines.gross_extended_amount%type,
185: p_gross_unit_selling_price IN
186: ra_customer_trx_lines.gross_unit_selling_price%type,
187: p_amount_includes_tax_flag IN
188: ra_customer_trx_lines.amount_includes_tax_flag%type,
182: ra_customer_trx.invoice_currency_code%type,
183: p_gross_extended_amount IN
184: ra_customer_trx_lines.gross_extended_amount%type,
185: p_gross_unit_selling_price IN
186: ra_customer_trx_lines.gross_unit_selling_price%type,
187: p_amount_includes_tax_flag IN
188: ra_customer_trx_lines.amount_includes_tax_flag%type,
189: p_status OUT NOCOPY
190: varchar2,
184: ra_customer_trx_lines.gross_extended_amount%type,
185: p_gross_unit_selling_price IN
186: ra_customer_trx_lines.gross_unit_selling_price%type,
187: p_amount_includes_tax_flag IN
188: ra_customer_trx_lines.amount_includes_tax_flag%type,
189: p_status OUT NOCOPY
190: varchar2,
191: p_global_attribute_category IN
192: ra_customer_trx_lines.global_attribute_category%type,
188: ra_customer_trx_lines.amount_includes_tax_flag%type,
189: p_status OUT NOCOPY
190: varchar2,
191: p_global_attribute_category IN
192: ra_customer_trx_lines.global_attribute_category%type,
193: p_global_attribute1 IN
194: ra_customer_trx_lines.global_attribute1%type,
195: p_global_attribute2 IN
196: ra_customer_trx_lines.global_attribute2%type,
190: varchar2,
191: p_global_attribute_category IN
192: ra_customer_trx_lines.global_attribute_category%type,
193: p_global_attribute1 IN
194: ra_customer_trx_lines.global_attribute1%type,
195: p_global_attribute2 IN
196: ra_customer_trx_lines.global_attribute2%type,
197: p_global_attribute3 IN
198: ra_customer_trx_lines.global_attribute3%type,
192: ra_customer_trx_lines.global_attribute_category%type,
193: p_global_attribute1 IN
194: ra_customer_trx_lines.global_attribute1%type,
195: p_global_attribute2 IN
196: ra_customer_trx_lines.global_attribute2%type,
197: p_global_attribute3 IN
198: ra_customer_trx_lines.global_attribute3%type,
199: p_global_attribute4 IN
200: ra_customer_trx_lines.global_attribute4%type,
194: ra_customer_trx_lines.global_attribute1%type,
195: p_global_attribute2 IN
196: ra_customer_trx_lines.global_attribute2%type,
197: p_global_attribute3 IN
198: ra_customer_trx_lines.global_attribute3%type,
199: p_global_attribute4 IN
200: ra_customer_trx_lines.global_attribute4%type,
201: p_global_attribute5 IN
202: ra_customer_trx_lines.global_attribute5%type,
196: ra_customer_trx_lines.global_attribute2%type,
197: p_global_attribute3 IN
198: ra_customer_trx_lines.global_attribute3%type,
199: p_global_attribute4 IN
200: ra_customer_trx_lines.global_attribute4%type,
201: p_global_attribute5 IN
202: ra_customer_trx_lines.global_attribute5%type,
203: p_global_attribute6 IN
204: ra_customer_trx_lines.global_attribute6%type,
198: ra_customer_trx_lines.global_attribute3%type,
199: p_global_attribute4 IN
200: ra_customer_trx_lines.global_attribute4%type,
201: p_global_attribute5 IN
202: ra_customer_trx_lines.global_attribute5%type,
203: p_global_attribute6 IN
204: ra_customer_trx_lines.global_attribute6%type,
205: p_global_attribute7 IN
206: ra_customer_trx_lines.global_attribute7%type,
200: ra_customer_trx_lines.global_attribute4%type,
201: p_global_attribute5 IN
202: ra_customer_trx_lines.global_attribute5%type,
203: p_global_attribute6 IN
204: ra_customer_trx_lines.global_attribute6%type,
205: p_global_attribute7 IN
206: ra_customer_trx_lines.global_attribute7%type,
207: p_global_attribute8 IN
208: ra_customer_trx_lines.global_attribute8%type,
202: ra_customer_trx_lines.global_attribute5%type,
203: p_global_attribute6 IN
204: ra_customer_trx_lines.global_attribute6%type,
205: p_global_attribute7 IN
206: ra_customer_trx_lines.global_attribute7%type,
207: p_global_attribute8 IN
208: ra_customer_trx_lines.global_attribute8%type,
209: p_global_attribute9 IN
210: ra_customer_trx_lines.global_attribute9%type,
204: ra_customer_trx_lines.global_attribute6%type,
205: p_global_attribute7 IN
206: ra_customer_trx_lines.global_attribute7%type,
207: p_global_attribute8 IN
208: ra_customer_trx_lines.global_attribute8%type,
209: p_global_attribute9 IN
210: ra_customer_trx_lines.global_attribute9%type,
211: p_global_attribute10 IN
212: ra_customer_trx_lines.global_attribute10%type,
206: ra_customer_trx_lines.global_attribute7%type,
207: p_global_attribute8 IN
208: ra_customer_trx_lines.global_attribute8%type,
209: p_global_attribute9 IN
210: ra_customer_trx_lines.global_attribute9%type,
211: p_global_attribute10 IN
212: ra_customer_trx_lines.global_attribute10%type,
213: p_global_attribute11 IN
214: ra_customer_trx_lines.global_attribute11%type,
208: ra_customer_trx_lines.global_attribute8%type,
209: p_global_attribute9 IN
210: ra_customer_trx_lines.global_attribute9%type,
211: p_global_attribute10 IN
212: ra_customer_trx_lines.global_attribute10%type,
213: p_global_attribute11 IN
214: ra_customer_trx_lines.global_attribute11%type,
215: p_global_attribute12 IN
216: ra_customer_trx_lines.global_attribute12%type,
210: ra_customer_trx_lines.global_attribute9%type,
211: p_global_attribute10 IN
212: ra_customer_trx_lines.global_attribute10%type,
213: p_global_attribute11 IN
214: ra_customer_trx_lines.global_attribute11%type,
215: p_global_attribute12 IN
216: ra_customer_trx_lines.global_attribute12%type,
217: p_global_attribute13 IN
218: ra_customer_trx_lines.global_attribute13%type,
212: ra_customer_trx_lines.global_attribute10%type,
213: p_global_attribute11 IN
214: ra_customer_trx_lines.global_attribute11%type,
215: p_global_attribute12 IN
216: ra_customer_trx_lines.global_attribute12%type,
217: p_global_attribute13 IN
218: ra_customer_trx_lines.global_attribute13%type,
219: p_global_attribute14 IN
220: ra_customer_trx_lines.global_attribute14%type,
214: ra_customer_trx_lines.global_attribute11%type,
215: p_global_attribute12 IN
216: ra_customer_trx_lines.global_attribute12%type,
217: p_global_attribute13 IN
218: ra_customer_trx_lines.global_attribute13%type,
219: p_global_attribute14 IN
220: ra_customer_trx_lines.global_attribute14%type,
221: p_global_attribute15 IN
222: ra_customer_trx_lines.global_attribute15%type,
216: ra_customer_trx_lines.global_attribute12%type,
217: p_global_attribute13 IN
218: ra_customer_trx_lines.global_attribute13%type,
219: p_global_attribute14 IN
220: ra_customer_trx_lines.global_attribute14%type,
221: p_global_attribute15 IN
222: ra_customer_trx_lines.global_attribute15%type,
223: p_global_attribute16 IN
224: ra_customer_trx_lines.global_attribute16%type,
218: ra_customer_trx_lines.global_attribute13%type,
219: p_global_attribute14 IN
220: ra_customer_trx_lines.global_attribute14%type,
221: p_global_attribute15 IN
222: ra_customer_trx_lines.global_attribute15%type,
223: p_global_attribute16 IN
224: ra_customer_trx_lines.global_attribute16%type,
225: p_global_attribute17 IN
226: ra_customer_trx_lines.global_attribute17%type,
220: ra_customer_trx_lines.global_attribute14%type,
221: p_global_attribute15 IN
222: ra_customer_trx_lines.global_attribute15%type,
223: p_global_attribute16 IN
224: ra_customer_trx_lines.global_attribute16%type,
225: p_global_attribute17 IN
226: ra_customer_trx_lines.global_attribute17%type,
227: p_global_attribute18 IN
228: ra_customer_trx_lines.global_attribute18%type,
222: ra_customer_trx_lines.global_attribute15%type,
223: p_global_attribute16 IN
224: ra_customer_trx_lines.global_attribute16%type,
225: p_global_attribute17 IN
226: ra_customer_trx_lines.global_attribute17%type,
227: p_global_attribute18 IN
228: ra_customer_trx_lines.global_attribute18%type,
229: p_global_attribute19 IN
230: ra_customer_trx_lines.global_attribute19%type,
224: ra_customer_trx_lines.global_attribute16%type,
225: p_global_attribute17 IN
226: ra_customer_trx_lines.global_attribute17%type,
227: p_global_attribute18 IN
228: ra_customer_trx_lines.global_attribute18%type,
229: p_global_attribute19 IN
230: ra_customer_trx_lines.global_attribute19%type,
231: p_global_attribute20 IN
232: ra_customer_trx_lines.global_attribute20%type,
226: ra_customer_trx_lines.global_attribute17%type,
227: p_global_attribute18 IN
228: ra_customer_trx_lines.global_attribute18%type,
229: p_global_attribute19 IN
230: ra_customer_trx_lines.global_attribute19%type,
231: p_global_attribute20 IN
232: ra_customer_trx_lines.global_attribute20%type,
233: p_payment_set_id IN
234: ra_customer_trx_lines.payment_set_id%type
228: ra_customer_trx_lines.global_attribute18%type,
229: p_global_attribute19 IN
230: ra_customer_trx_lines.global_attribute19%type,
231: p_global_attribute20 IN
232: ra_customer_trx_lines.global_attribute20%type,
233: p_payment_set_id IN
234: ra_customer_trx_lines.payment_set_id%type
235: );
236:
230: ra_customer_trx_lines.global_attribute19%type,
231: p_global_attribute20 IN
232: ra_customer_trx_lines.global_attribute20%type,
233: p_payment_set_id IN
234: ra_customer_trx_lines.payment_set_id%type
235: );
236:
237: END ARP_DELETE_LINE_COVER;