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