[Home] [Help]
PACKAGE: APPS.ARP_LOCK_LINE_COVER
Source
4 PROCEDURE lock_compare_cover(
1 PACKAGE ARP_LOCK_LINE_COVER AUTHID CURRENT_USER AS
2 /* $Header: ARTCTLLS.pls 120.1 2005/10/07 18:32:29 ralat noship $ */
3
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
93 p_movement_id IN
94 ra_customer_trx_lines.movement_id%type,
95 p_default_ussgl_trx_code IN
99 p_interface_line_context 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
215 );
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
216
217
218 END ARP_LOCK_LINE_COVER;