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