[Home] [Help]
PACKAGE BODY: APPS.AR_TRX_GLOBAL_PROCESS_LINES
Source
1 PACKAGE BODY AR_TRX_GLOBAL_PROCESS_LINES AS
2 /* $Header: ARINGTLB.pls 120.17.12020000.2 2012/07/25 06:11:57 ashlkuma ship $ */
3
4 pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
5
6 PROCEDURE INSERT_ROW (
7 p_trx_lines_tbl IN AR_INVOICE_API_PUB.trx_line_tbl_type,
8 x_errmsg OUT NOCOPY VARCHAR2,
9 x_return_status OUT NOCOPY VARCHAR2 ) IS
10 BEGIN
11
12 IF pg_debug = 'Y'
13 THEN
14 ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_LINES.INSERT_ROW (+)');
15 END IF;
16 x_return_status := FND_API.G_RET_STS_SUCCESS;
17 -- Now populate the lines global Temp. Table
18 FOR i IN p_trx_lines_tbl.FIRST .. p_trx_lines_tbl.LAST
19 LOOP
20
21 INSERT INTO ar_trx_lines_gt (
22 trx_line_id,
23 trx_header_id ,
24 customer_trx_line_id ,
25 link_to_trx_line_id,
26 LINE_NUMBER , -- required
27 LINE_TYPE , -- required
28 customer_trx_id ,
29 REASON_CODE ,
30 INVENTORY_ITEM_ID ,
31 DESCRIPTION ,
32 QUANTITY_ORDERED ,
33 QUANTITY_CREDITED ,
34 QUANTITY_INVOICED ,
35 UNIT_STANDARD_PRICE ,
36 UNIT_SELLING_PRICE ,
37 SALES_ORDER ,
38 SALES_ORDER_LINE ,
39 SALES_ORDER_DATE ,
40 ACCOUNTING_RULE_ID ,
41 ACCOUNTING_RULE_DURATION ,
42 RULE_START_DATE ,
43 ATTRIBUTE_CATEGORY ,
44 ATTRIBUTE1 ,
45 ATTRIBUTE2 ,
46 ATTRIBUTE3 ,
47 ATTRIBUTE4 ,
48 ATTRIBUTE5 ,
49 ATTRIBUTE6 ,
50 ATTRIBUTE7 ,
51 ATTRIBUTE8 ,
52 ATTRIBUTE9 ,
53 ATTRIBUTE10 ,
54 ATTRIBUTE11 ,
55 ATTRIBUTE12 ,
56 ATTRIBUTE13 ,
57 ATTRIBUTE14 ,
58 ATTRIBUTE15 ,
59 INTERFACE_LINE_CONTEXT ,
60 INTERFACE_LINE_ATTRIBUTE1 ,
61 INTERFACE_LINE_ATTRIBUTE2 ,
62 INTERFACE_LINE_ATTRIBUTE3 ,
63 INTERFACE_LINE_ATTRIBUTE4 ,
64 INTERFACE_LINE_ATTRIBUTE5 ,
65 INTERFACE_LINE_ATTRIBUTE6 ,
66 INTERFACE_LINE_ATTRIBUTE7 ,
67 INTERFACE_LINE_ATTRIBUTE8 ,
68 INTERFACE_LINE_ATTRIBUTE9 ,
69 INTERFACE_LINE_ATTRIBUTE10 ,
70 INTERFACE_LINE_ATTRIBUTE11 ,
71 INTERFACE_LINE_ATTRIBUTE12 ,
72 INTERFACE_LINE_ATTRIBUTE13 ,
73 INTERFACE_LINE_ATTRIBUTE14 ,
74 INTERFACE_LINE_ATTRIBUTE15 ,
75 SALES_ORDER_SOURCE , --channel in the form
76 EXTENDED_AMOUNT , -- required
77 REVENUE_AMOUNT ,
78 AUTORULE_COMPLETE_FLAG ,
79 TAX_PRECEDENCE ,
80 TAX_RATE ,
81 ITEM_EXCEPTION_RATE_ID ,
82 TAX_EXEMPTION_ID ,
83 MEMO_LINE_ID ,
84 AUTORULE_DURATION_PROCESSED ,
85 UOM_CODE ,
86 DEFAULT_USSGL_TRANSACTION_CODE ,
87 DEFAULT_USSGL_TRX_CODE_CONTEXT ,
88 VAT_TAX_ID ,
89 AUTOTAX ,
90 LAST_PERIOD_TO_CREDIT ,
91 ITEM_CONTEXT ,
92 TAX_EXEMPT_FLAG ,
93 TAX_EXEMPT_NUMBER ,
94 TAX_EXEMPT_REASON_CODE ,
95 TAX_VENDOR_RETURN_CODE ,
96 LOCATION_SEGMENT_ID ,
97 MOVEMENT_ID ,
98 GLOBAL_ATTRIBUTE1 ,
99 GLOBAL_ATTRIBUTE2 ,
100 GLOBAL_ATTRIBUTE3 ,
101 GLOBAL_ATTRIBUTE4 ,
102 GLOBAL_ATTRIBUTE5 ,
103 GLOBAL_ATTRIBUTE6 ,
104 GLOBAL_ATTRIBUTE7 ,
105 GLOBAL_ATTRIBUTE8 ,
106 GLOBAL_ATTRIBUTE9 ,
107 GLOBAL_ATTRIBUTE10 ,
108 GLOBAL_ATTRIBUTE11 ,
109 GLOBAL_ATTRIBUTE12 ,
110 GLOBAL_ATTRIBUTE13 ,
111 GLOBAL_ATTRIBUTE14 ,
112 GLOBAL_ATTRIBUTE15 ,
113 GLOBAL_ATTRIBUTE16 ,
114 GLOBAL_ATTRIBUTE17 ,
115 GLOBAL_ATTRIBUTE18 ,
116 GLOBAL_ATTRIBUTE19 ,
117 GLOBAL_ATTRIBUTE20 ,
118 GLOBAL_ATTRIBUTE_CATEGORY ,
119 GROSS_UNIT_SELLING_PRICE ,
120 GROSS_EXTENDED_AMOUNT ,
121 AMOUNT_INCLUDES_TAX_FLAG ,
122 TAXABLE_AMOUNT ,
123 WAREHOUSE_ID ,
124 EXTENDED_ACCTD_AMOUNT ,
125 CONTRACT_LINE_ID ,
126 SOURCE_DATA_KEY1 ,
127 SOURCE_DATA_KEY2 ,
128 SOURCE_DATA_KEY3 ,
129 SOURCE_DATA_KEY4 ,
130 SOURCE_DATA_KEY5 ,
131 INVOICED_LINE_ACCTG_LEVEL,
132 ship_via,
133 fob_point ,
134 waybill_number ,
135 SHIP_DATE_ACTUAL,
136 override_auto_accounting_flag ,
137 ORG_ID ,
138 rule_end_date,
139 request_id,
140 SOURCE_APPLICATION_ID,
141 SOURCE_EVENT_CLASS_CODE,
142 SOURCE_ENTITY_CODE,
143 SOURCE_TRX_ID,
144 SOURCE_TRX_LINE_ID,
145 SOURCE_TRX_LINE_TYPE,
146 SOURCE_TRX_DETAIL_TAX_LINE_ID,
147 HISTORICAL_FLAG,
148 TAXABLE_FLAG,
149 TAX_REGIME_CODE,
150 TAX,
151 TAX_STATUS_CODE,
152 TAX_RATE_CODE,
153 TAX_JURISDICTION_CODE,
154 TAX_CLASSIFICATION_CODE,
155 INTEREST_LINE_ID,
156 TRX_BUSINESS_CATEGORY,
157 PRODUCT_FISC_CLASSIFICATION,
158 PRODUCT_CATEGORY,
159 PRODUCT_TYPE,
160 LINE_INTENDED_USE,
161 ASSESSABLE_VALUE
162 )
163 VALUES (
164 p_trx_lines_tbl(i).trx_line_id,
165 p_trx_lines_tbl(i).trx_header_id,
166 RA_CUSTOMER_TRX_LINES_S.NEXTVAL,
167 p_trx_lines_tbl(i).link_to_trx_line_id,
168 p_trx_lines_tbl(i).LINE_number,
169 p_trx_lines_tbl(i).line_type,
170 null, --customer_trx_id
171 p_trx_lines_tbl(i).REASON_CODE,
172 p_trx_lines_tbl(i).INVENTORY_ITEM_ID,
173 p_trx_lines_tbl(i).DESCRIPTION,
174 p_trx_lines_tbl(i).QUANTITY_ORDERED,
175 null, -- p_trx_lines_tbl(i).QUANTITY_CREDITED,
176 p_trx_lines_tbl(i).QUANTITY_INVOICED,
177 p_trx_lines_tbl(i).UNIT_STANDARD_PRICE,
178 p_trx_lines_tbl(i).UNIT_SELLING_PRICE,
179 p_trx_lines_tbl(i).SALES_ORDER,
180 p_trx_lines_tbl(i).SALES_ORDER_LINE,
181 p_trx_lines_tbl(i).SALES_ORDER_DATE,
182 p_trx_lines_tbl(i).ACCOUNTING_RULE_ID,
183 p_trx_lines_tbl(i).ACCOUNTING_RULE_DURATION,
184 p_trx_lines_tbl(i).RULE_START_DATE,
185 p_trx_lines_tbl(i).ATTRIBUTE_CATEGORY,
186 p_trx_lines_tbl(i).ATTRIBUTE1,
187 p_trx_lines_tbl(i).ATTRIBUTE2,
188 p_trx_lines_tbl(i).ATTRIBUTE3,
189 p_trx_lines_tbl(i).ATTRIBUTE4,
190 p_trx_lines_tbl(i).ATTRIBUTE5,
191 p_trx_lines_tbl(i).ATTRIBUTE6,
192 p_trx_lines_tbl(i).ATTRIBUTE7,
193 p_trx_lines_tbl(i).ATTRIBUTE8,
194 p_trx_lines_tbl(i).ATTRIBUTE9,
195 p_trx_lines_tbl(i).ATTRIBUTE10,
196 p_trx_lines_tbl(i).ATTRIBUTE11,
197 p_trx_lines_tbl(i).ATTRIBUTE12,
198 p_trx_lines_tbl(i).ATTRIBUTE13 ,
199 p_trx_lines_tbl(i).ATTRIBUTE14 ,
200 p_trx_lines_tbl(i).ATTRIBUTE15 ,
201 p_trx_lines_tbl(i).INTERFACE_LINE_CONTEXT ,
202 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE1 ,
203 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE2 ,
204 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE3 ,
205 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE4 ,
206 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE5 ,
207 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE6 ,
208 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE7 ,
209 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE8 ,
210 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE9 ,
211 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE10 ,
212 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE11 ,
213 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE12 ,
214 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE13 ,
215 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE14 ,
216 p_trx_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE15 ,
217 p_trx_lines_tbl(i).SALES_ORDER_SOURCE , --channel in the form
218 p_trx_lines_tbl(i).AMOUNT , -- required
219 null, -- p_trx_lines_tbl(i).REVENUE_AMOUNT ,
220 DECODE(p_trx_lines_tbl(i).accounting_rule_id, NULL, NULL, 'N'),
221 p_trx_lines_tbl(i).TAX_PRECEDENCE ,
222 p_trx_lines_tbl(i).TAX_RATE ,
223 null, -- p_trx_lines_tbl(i).ITEM_EXCEPTION_RATE_ID ,
224 p_trx_lines_tbl(i).TAX_EXEMPTION_ID ,
225 p_trx_lines_tbl(i).MEMO_LINE_ID ,
226 null, -- p_trx_lines_tbl(i).AUTORULE_DURATION_PROCESSED ,
227 p_trx_lines_tbl(i).UOM_CODE ,
228 p_trx_lines_tbl(i).DEFAULT_USSGL_TRANSACTION_CODE ,
229 p_trx_lines_tbl(i).DEFAULT_USSGL_TRX_CODE_CONTEXT ,
230 p_trx_lines_tbl(i).VAT_TAX_ID ,
231 'N', -- p_trx_lines_tbl(i).AUTOTAX ,
232 null, -- p_trx_lines_tbl(i).LAST_PERIOD_TO_CREDIT ,
233 null, -- p_trx_lines_tbl(i).ITEM_CONTEXT ,
234 p_trx_lines_tbl(i).TAX_EXEMPT_FLAG ,
235 p_trx_lines_tbl(i).TAX_EXEMPT_NUMBER ,
236 p_trx_lines_tbl(i).TAX_EXEMPT_REASON_CODE ,
237 null, -- p_trx_lines_tbl(i).TAX_VENDOR_RETURN_CODE ,
238 null, -- p_trx_lines_tbl(i).LOCATION_SEGMENT_ID ,
239 p_trx_lines_tbl(i).MOVEMENT_ID ,
240 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE1 ,
241 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE2 ,
242 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE3 ,
243 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE4 ,
244 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE5 ,
245 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE6 ,
246 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE7 ,
247 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE8 ,
248 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE9 ,
249 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE10 ,
250 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE11 ,
251 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE12 ,
252 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE13 ,
253 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE14 ,
254 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE15 ,
255 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE16 ,
256 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE17 ,
257 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE18 ,
258 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE19 ,
259 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE20 ,
260 p_trx_lines_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY ,
261 null, -- p_trx_lines_tbl(i).GROSS_UNIT_SELLING_PRICE,
262 null, -- p_trx_lines_tbl(i).GROSS_EXTENDED_AMOUNT ,
263 p_trx_lines_tbl(i).AMOUNT_INCLUDES_TAX_FLAG,
264 null, -- p_trx_lines_tbl(i).TAXABLE_AMOUNT,
265 p_trx_lines_tbl(i).WAREHOUSE_ID,
266 null, -- p_trx_lines_tbl(i).EXTENDED_ACCTD_AMOUNT,
267 p_trx_lines_tbl(i).CONTRACT_LINE_ID ,
268 p_trx_lines_tbl(i).SOURCE_DATA_KEY1 ,
269 p_trx_lines_tbl(i).SOURCE_DATA_KEY2 ,
270 p_trx_lines_tbl(i).SOURCE_DATA_KEY3 ,
271 p_trx_lines_tbl(i).SOURCE_DATA_KEY4 ,
272 p_trx_lines_tbl(i).SOURCE_DATA_KEY5 ,
273 p_trx_lines_tbl(i).INVOICED_LINE_ACCTG_LEVEL,
274 null, -- p_trx_lines_tbl(i).ship_via ,
275 null, -- p_trx_lines_tbl(i).fob_point ,
276 null, -- p_trx_lines_tbl(i).waybill_number ,
277 p_trx_lines_tbl(i).SHIP_DATE_ACTUAL,
278 p_trx_lines_tbl(i).override_auto_accounting_flag ,
279 arp_standard.sysparm.org_id ,
280 p_trx_lines_tbl(i).rule_end_date,
281 ar_invoice_table_handler.g_request_id,
282 p_trx_lines_tbl(i).source_application_id,
283 p_trx_lines_tbl(i).source_event_class_code,
284 p_trx_lines_tbl(i).source_entity_code,
285 p_trx_lines_tbl(i).source_trx_id,
286 p_trx_lines_tbl(i).source_trx_line_id,
287 p_trx_lines_tbl(i).source_trx_line_type,
288 p_trx_lines_tbl(i).source_trx_detail_tax_line_id,
289 p_trx_lines_tbl(i).historical_flag,
290 p_trx_lines_tbl(i).taxable_flag,
291 p_trx_lines_tbl(i).tax_regime_code,
292 p_trx_lines_tbl(i).tax,
293 p_trx_lines_tbl(i).tax_status_code,
294 p_trx_lines_tbl(i).tax_rate_code,
295 p_trx_lines_tbl(i).tax_jurisdiction_code,
296 p_trx_lines_tbl(i).tax_classification_code,
297 p_trx_lines_tbl(i).interest_line_id,
298 p_trx_lines_tbl(i).trx_business_category,
299 p_trx_lines_tbl(i).product_fisc_classification,
300 p_trx_lines_tbl(i).product_category,
301 p_trx_lines_tbl(i).product_type,
302 p_trx_lines_tbl(i).line_intended_use,
303 p_trx_lines_tbl(i).assessable_value
304 );
305 END LOOP;
306
307 IF pg_debug = 'Y'
308 THEN
309 ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_LINES.INSERT_ROW (-)');
310 END IF;
311 EXCEPTION
312 WHEN OTHERS THEN
313 x_errmsg := 'Error in AR_TRX_GLOBAL_PROCESS_LINES.INSERT_ROW '||sqlerrm;
314 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315 return;
316
317 END INSERT_ROW;
318
319 END AR_TRX_GLOBAL_PROCESS_LINES;