eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ARP_DELETE_LINE_COVER

Source


1 PACKAGE ARP_DELETE_LINE_COVER AUTHID CURRENT_USER AS
2 /* $Header: ARTCTLDS.pls 115.3 2002/11/15 03:31:18 anukumar ship $ */
3 
4 PROCEDURE delete_line_cover(
5            p_form_name IN
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,
15            p_trx_amount IN
16              number,
17            p_exchange_rate IN
18              ra_customer_trx.exchange_rate%type,
19            p_gl_date IN OUT NOCOPY
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 
237 END ARP_DELETE_LINE_COVER;