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