1 package body AP_INVOICE_LINES_INTERFACE_PKG as
2 /* $Header: apailthb.pls 120.10.12010000.2 2009/04/09 12:42:29 sbonala ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_INVOICE_ID IN NUMBER,
7 X_INVOICE_LINE_ID IN NUMBER,
8 X_LINE_NUMBER IN NUMBER,
9 X_LINE_TYPE_LOOKUP_CODE IN VARCHAR2,
10 X_LINE_GROUP_NUMBER IN NUMBER,
11 X_AMOUNT IN NUMBER,
12 X_ACCOUNTING_DATE IN DATE,
13 X_DESCRIPTION IN VARCHAR2,
14 -- X_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
15 X_PRORATE_ACROSS_FLAG IN VARCHAR2,
16 X_TAX_CODE IN VARCHAR2,
17 X_TAX_CODE_ID IN NUMBER,
18 -- X_TAX_CODE_OVERRIDE_FLAG IN VARCHAR2,
19 -- X_TAX_RECOVERY_RATE IN NUMBER,
20 -- X_TAX_RECOVERY_OVERRIDE_FLAG IN VARCHAR2,
21 -- X_TAX_RECOVERABLE_FLAG IN VARCHAR2,
22 X_FINAL_MATCH_FLAG IN VARCHAR2,
23 X_PO_HEADER_ID IN NUMBER,
24 X_PO_LINE_ID IN NUMBER,
25 X_PO_LINE_LOCATION_ID IN NUMBER,
26 X_PO_DISTRIBUTION_ID IN NUMBER,
27 X_UNIT_OF_MEAS_LOOKUP_CODE IN VARCHAR2,
28 X_INVENTORY_ITEM_ID IN NUMBER,
29 X_QUANTITY_INVOICED IN NUMBER,
30 X_UNIT_PRICE IN NUMBER,
31 X_DISTRIBUTION_SET_ID IN NUMBER,
32 X_DIST_CODE_CONCATENATED IN VARCHAR2,
33 X_DIST_CODE_COMBINATION_ID IN NUMBER,
34 X_AWT_GROUP_ID IN NUMBER,
35 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
36 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
37 X_ATTRIBUTE1 IN VARCHAR2,
38 X_ATTRIBUTE2 IN VARCHAR2,
39 X_ATTRIBUTE3 IN VARCHAR2,
40 X_ATTRIBUTE4 IN VARCHAR2,
41 X_ATTRIBUTE5 IN VARCHAR2,
42 X_ATTRIBUTE6 IN VARCHAR2,
43 X_ATTRIBUTE7 IN VARCHAR2,
44 X_ATTRIBUTE8 IN VARCHAR2,
45 X_ATTRIBUTE9 IN VARCHAR2,
46 X_ATTRIBUTE10 IN VARCHAR2,
47 X_ATTRIBUTE11 IN VARCHAR2,
48 X_ATTRIBUTE12 IN VARCHAR2,
49 X_ATTRIBUTE13 IN VARCHAR2,
50 X_ATTRIBUTE14 IN VARCHAR2,
51 X_ATTRIBUTE15 IN VARCHAR2,
52 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
53 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
54 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
55 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
56 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
57 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
58 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
59 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
60 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
61 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
62 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
63 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
64 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
65 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
66 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
67 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
68 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
69 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
70 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
71 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
72 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
73 X_PO_RELEASE_ID IN NUMBER,
74 X_BALANCING_SEGMENT IN VARCHAR2,
75 X_COST_CENTER_SEGMENT IN VARCHAR2,
76 X_ACCOUNT_SEGMENT IN VARCHAR2,
77 X_PROJECT_ID IN NUMBER,
78 X_TASK_ID IN NUMBER,
79 X_EXPENDITURE_TYPE IN VARCHAR2,
80 X_EXPENDITURE_ITEM_DATE IN DATE,
81 X_EXPENDITURE_ORGANIZATION_ID IN NUMBER,
82 X_PROJECT_ACCOUNTING_CONTEXT IN VARCHAR2,
83 X_PA_ADDITION_FLAG IN VARCHAR2,
84 X_PA_QUANTITY IN NUMBER,
85 X_STAT_AMOUNT IN NUMBER,
86 X_TYPE_1099 IN VARCHAR2,
87 X_INCOME_TAX_REGION IN VARCHAR2,
88 X_ASSETS_TRACKING_FLAG IN VARCHAR2,
89 X_PRICE_CORRECTION_FLAG IN VARCHAR2,
90 -- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
91 X_RECEIPT_NUMBER IN VARCHAR2,
92 X_MATCH_OPTION IN VARCHAR2,
93 X_RCV_TRANSACTION_ID IN NUMBER,
94 X_CREATION_DATE IN DATE,
95 X_CREATED_BY IN NUMBER,
96 X_LAST_UPDATE_DATE IN DATE,
97 X_LAST_UPDATED_BY IN NUMBER,
98 X_LAST_UPDATE_LOGIN IN NUMBER,
99 X_ORG_ID IN NUMBER,
100 X_MODE IN VARCHAR2 DEFAULT 'R',
101 X_Calling_Sequence IN VARCHAR2,
102 X_award_id IN NUMBER DEFAULT NULL,
103 X_price_correct_inv_num IN VARCHAR2 DEFAULT NULL,
104 -- Invoice Lines Project Stage 1
105 X_PRICE_CORRECT_INV_LINE_NUM IN NUMBER DEFAULT NULL,
106 X_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
107 X_MANUFACTURER IN VARCHAR2 DEFAULT NULL,
108 X_MODEL_NUMBER IN VARCHAR2 DEFAULT NULL,
109 X_WARRANTY_NUMBER IN VARCHAR2 DEFAULT NULL,
110 X_ASSET_BOOK_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
111 X_ASSET_CATEGORY_ID IN NUMBER DEFAULT NULL,
112 X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
113 X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
114 X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
115 X_REQUESTER_ID IN NUMBER DEFAULT NULL,
116 X_DEFERRED_ACCTG_FLAG IN VARCHAR2 DEFAULT NULL,
117 X_DEF_ACCTG_START_DATE IN DATE DEFAULT NULL,
118 X_DEF_ACCTG_END_DATE IN DATE DEFAULT NULL,
119 X_DEF_ACCTG_NUMBER_OF_PERIODS IN NUMBER DEFAULT NULL,
120 X_DEF_ACCTG_PERIOD_TYPE IN VARCHAR2 DEFAULT NULL,
121 -- eTax Uptake
122 X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
123 X_ASSESSABLE_VALUE IN NUMBER DEFAULT NULL,
124 X_DEFAULT_DIST_CCID IN NUMBER DEFAULT NULL,
125 X_PRIMARY_INTENDED_USE IN VARCHAR2 DEFAULT NULL,
126 X_SHIP_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
127 X_PRODUCT_TYPE IN VARCHAR2 DEFAULT NULL,
128 X_PRODUCT_CATEGORY IN VARCHAR2 DEFAULT NULL,
129 X_PRODUCT_FISC_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
130 X_USER_DEFINED_FISC_CLASS IN VARCHAR2 DEFAULT NULL,
131 X_TRX_BUSINESS_CATEGORY IN VARCHAR2 DEFAULT NULL,
132 X_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
133 X_TAX IN VARCHAR2 DEFAULT NULL,
134 X_TAX_JURISDICTION_CODE IN VARCHAR2 DEFAULT NULL,
135 X_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
136 X_TAX_RATE_ID IN NUMBER DEFAULT NULL,
137 X_TAX_RATE_CODE IN VARCHAR2 DEFAULT NULL,
138 X_TAX_RATE IN NUMBER DEFAULT NULL,
139 X_INCL_IN_TAXABLE_LINE_FLAG IN VARCHAR2 DEFAULT NULL,
140 X_PURCHASING_CATEGORY IN VARCHAR2 DEFAULT NULL,
141 X_PURCHASING_CATEGORY_ID IN NUMBER DEFAULT NULL,
142 X_COST_FACTOR_NAME IN VARCHAR2 DEFAULT NULL,
143 X_COST_FACTOR_ID IN NUMBER DEFAULT NULL,
144 X_TAX_CLASSIFICATION_CODE IN VARCHAR2 DEFAULT NULL)
145 IS
146 current_calling_sequence VARCHAR2(2000);
147 debug_info VARCHAR2(100);
148
149 CURSOR C IS
150 SELECT ROWID
151 FROM AP_INVOICE_LINES_INTERFACE
152 WHERE invoice_id = X_Invoice_Id
153 AND invoice_line_id = X_Invoice_Line_Id;
154 BEGIN
155 -- Update the calling sequence
156
157 current_calling_sequence :='AP_INVOICE_LINES_INTERFACE_PKG.Insert_Row<-'||
158 X_Calling_Sequence;
159
160 -- Check for uniqueness of the line number in the process.
161
162 debug_info := 'Insert into ap_invoice_distributions';
163
164 INSERT INTO AP_INVOICE_LINES_INTERFACE (
165 INVOICE_ID,
166 INVOICE_LINE_ID,
167 LINE_NUMBER,
168 LINE_TYPE_LOOKUP_CODE,
169 LINE_GROUP_NUMBER,
170 AMOUNT,
171 ACCOUNTING_DATE,
172 DESCRIPTION,
173 -- AMOUNT_INCLUDES_TAX_FLAG,
174 PRORATE_ACROSS_FLAG,
175 TAX_CODE,
176 TAX_CODE_ID,
177 -- TAX_CODE_OVERRIDE_FLAG,
178 -- TAX_RECOVERY_RATE,
179 -- TAX_RECOVERY_OVERRIDE_FLAG,
180 -- TAX_RECOVERABLE_FLAG,
181 FINAL_MATCH_FLAG,
182 PO_HEADER_ID,
183 PO_LINE_ID,
184 PO_LINE_LOCATION_ID,
185 PO_DISTRIBUTION_ID,
186 UNIT_OF_MEAS_LOOKUP_CODE,
187 INVENTORY_ITEM_ID,
188 QUANTITY_INVOICED,
189 UNIT_PRICE,
190 DISTRIBUTION_SET_ID,
191 DIST_CODE_CONCATENATED,
192 DIST_CODE_COMBINATION_ID,
193 AWT_GROUP_ID,
194 PAY_AWT_GROUP_ID,--bug6639866
195 ATTRIBUTE_CATEGORY,
196 ATTRIBUTE1,
197 ATTRIBUTE2,
198 ATTRIBUTE3,
199 ATTRIBUTE4,
200 ATTRIBUTE5,
201 ATTRIBUTE6,
202 ATTRIBUTE7,
203 ATTRIBUTE8,
204 ATTRIBUTE9,
205 ATTRIBUTE10,
206 ATTRIBUTE11,
207 ATTRIBUTE12,
208 ATTRIBUTE13,
209 ATTRIBUTE14,
210 ATTRIBUTE15,
211 GLOBAL_ATTRIBUTE_CATEGORY,
212 GLOBAL_ATTRIBUTE1,
213 GLOBAL_ATTRIBUTE2,
214 GLOBAL_ATTRIBUTE3,
215 GLOBAL_ATTRIBUTE4,
216 GLOBAL_ATTRIBUTE5,
217 GLOBAL_ATTRIBUTE6,
218 GLOBAL_ATTRIBUTE7,
219 GLOBAL_ATTRIBUTE8,
220 GLOBAL_ATTRIBUTE9,
221 GLOBAL_ATTRIBUTE10,
222 GLOBAL_ATTRIBUTE11,
223 GLOBAL_ATTRIBUTE12,
224 GLOBAL_ATTRIBUTE13,
225 GLOBAL_ATTRIBUTE14,
226 GLOBAL_ATTRIBUTE15,
227 GLOBAL_ATTRIBUTE16,
228 GLOBAL_ATTRIBUTE17,
229 GLOBAL_ATTRIBUTE18,
230 GLOBAL_ATTRIBUTE19,
231 GLOBAL_ATTRIBUTE20,
232 PO_RELEASE_ID,
233 BALANCING_SEGMENT,
234 COST_CENTER_SEGMENT,
235 ACCOUNT_SEGMENT,
236 PROJECT_ID,
237 TASK_ID,
238 EXPENDITURE_TYPE,
239 EXPENDITURE_ITEM_DATE,
243 PA_QUANTITY,
240 EXPENDITURE_ORGANIZATION_ID,
241 PROJECT_ACCOUNTING_CONTEXT,
242 PA_ADDITION_FLAG,
244 STAT_AMOUNT,
245 TYPE_1099,
246 INCOME_TAX_REGION,
247 ASSETS_TRACKING_FLAG,
248 PRICE_CORRECTION_FLAG,
249 -- USSGL_TRANSACTION_CODE, - Bug 4277744
250 RECEIPT_NUMBER,
251 MATCH_OPTION,
252 RCV_TRANSACTION_ID,
253 CREATION_DATE,
254 CREATED_BY,
255 LAST_UPDATE_DATE,
256 LAST_UPDATED_BY,
257 LAST_UPDATE_LOGIN,
258 ORG_ID,
259 AWARD_ID,
260 PRICE_CORRECT_INV_NUM,
261 -- Invoice Lines Project Stage 1
262 PRICE_CORRECT_INV_LINE_NUM,
263 SERIAL_NUMBER,
264 MANUFACTURER,
265 MODEL_NUMBER,
266 WARRANTY_NUMBER,
267 ASSET_BOOK_TYPE_CODE,
268 ASSET_CATEGORY_ID,
269 REQUESTER_FIRST_NAME,
270 REQUESTER_LAST_NAME,
271 REQUESTER_EMPLOYEE_NUM,
272 REQUESTER_ID,
273 DEFERRED_ACCTG_FLAG,
274 DEF_ACCTG_START_DATE,
275 DEF_ACCTG_END_DATE,
276 DEF_ACCTG_NUMBER_OF_PERIODS,
277 DEF_ACCTG_PERIOD_TYPE,
278 CONTROL_AMOUNT,
279 ASSESSABLE_VALUE,
280 DEFAULT_DIST_CCID,
281 PRIMARY_INTENDED_USE,
282 SHIP_TO_LOCATION_ID,
283 PRODUCT_TYPE,
284 PRODUCT_CATEGORY,
285 PRODUCT_FISC_CLASSIFICATION,
286 USER_DEFINED_FISC_CLASS,
287 TRX_BUSINESS_CATEGORY,
288 TAX_REGIME_CODE,
289 TAX,
290 TAX_JURISDICTION_CODE,
291 TAX_STATUS_CODE,
292 TAX_RATE_ID,
293 TAX_RATE_CODE,
294 TAX_RATE,
295 INCL_IN_TAXABLE_LINE_FLAG,
296 PURCHASING_CATEGORY,
297 PURCHASING_CATEGORY_ID,
298 COST_FACTOR_NAME,
299 COST_FACTOR_ID,
300 TAX_CLASSIFICATION_CODE)
301 VALUES (
302 X_INVOICE_ID,
303 X_INVOICE_LINE_ID,
304 X_LINE_NUMBER,
305 X_LINE_TYPE_LOOKUP_CODE,
306 X_LINE_GROUP_NUMBER,
307 X_AMOUNT,
308 X_ACCOUNTING_DATE,
309 X_DESCRIPTION,
310 -- X_AMOUNT_INCLUDES_TAX_FLAG,
311 X_PRORATE_ACROSS_FLAG,
312 X_TAX_CODE,
313 X_TAX_CODE_ID,
314 -- X_TAX_CODE_OVERRIDE_FLAG,
315 -- X_TAX_RECOVERY_RATE,
316 -- X_TAX_RECOVERY_OVERRIDE_FLAG,
317 -- X_TAX_RECOVERABLE_FLAG,
318 X_FINAL_MATCH_FLAG,
319 X_PO_HEADER_ID,
320 X_PO_LINE_ID,
321 X_PO_LINE_LOCATION_ID,
322 X_PO_DISTRIBUTION_ID,
323 X_UNIT_OF_MEAS_LOOKUP_CODE,
324 X_INVENTORY_ITEM_ID,
325 X_QUANTITY_INVOICED,
326 X_UNIT_PRICE,
327 X_DISTRIBUTION_SET_ID,
328 X_DIST_CODE_CONCATENATED,
329 X_DIST_CODE_COMBINATION_ID,
330 X_AWT_GROUP_ID,
331 X_PAY_AWT_GROUP_ID,--bug6639866
332 X_ATTRIBUTE_CATEGORY,
333 X_ATTRIBUTE1,
334 X_ATTRIBUTE2,
335 X_ATTRIBUTE3,
336 X_ATTRIBUTE4,
337 X_ATTRIBUTE5,
338 X_ATTRIBUTE6,
339 X_ATTRIBUTE7,
340 X_ATTRIBUTE8,
341 X_ATTRIBUTE9,
342 X_ATTRIBUTE10,
343 X_ATTRIBUTE11,
344 X_ATTRIBUTE12,
345 X_ATTRIBUTE13,
346 X_ATTRIBUTE14,
347 X_ATTRIBUTE15,
348 X_GLOBAL_ATTRIBUTE_CATEGORY,
349 X_GLOBAL_ATTRIBUTE1,
350 X_GLOBAL_ATTRIBUTE2,
351 X_GLOBAL_ATTRIBUTE3,
352 X_GLOBAL_ATTRIBUTE4,
353 X_GLOBAL_ATTRIBUTE5,
354 X_GLOBAL_ATTRIBUTE6,
355 X_GLOBAL_ATTRIBUTE7,
356 X_GLOBAL_ATTRIBUTE8,
357 X_GLOBAL_ATTRIBUTE9,
358 X_GLOBAL_ATTRIBUTE10,
359 X_GLOBAL_ATTRIBUTE11,
360 X_GLOBAL_ATTRIBUTE12,
361 X_GLOBAL_ATTRIBUTE13,
362 X_GLOBAL_ATTRIBUTE14,
363 X_GLOBAL_ATTRIBUTE15,
364 X_GLOBAL_ATTRIBUTE16,
365 X_GLOBAL_ATTRIBUTE17,
366 X_GLOBAL_ATTRIBUTE18,
367 X_GLOBAL_ATTRIBUTE19,
368 X_GLOBAL_ATTRIBUTE20,
369 X_PO_RELEASE_ID,
370 X_BALANCING_SEGMENT,
371 X_COST_CENTER_SEGMENT,
372 X_ACCOUNT_SEGMENT,
373 X_PROJECT_ID,
374 X_TASK_ID,
375 X_EXPENDITURE_TYPE,
376 X_EXPENDITURE_ITEM_DATE,
377 X_EXPENDITURE_ORGANIZATION_ID,
378 X_PROJECT_ACCOUNTING_CONTEXT,
379 X_PA_ADDITION_FLAG,
380 X_PA_QUANTITY,
381 X_STAT_AMOUNT,
382 X_TYPE_1099,
383 X_INCOME_TAX_REGION,
384 X_ASSETS_TRACKING_FLAG,
385 X_PRICE_CORRECTION_FLAG,
386 -- X_USSGL_TRANSACTION_CODE, - Bug 4277744
387 X_RECEIPT_NUMBER,
388 X_MATCH_OPTION,
389 X_RCV_TRANSACTION_ID,
390 X_LAST_UPDATE_DATE,
391 X_LAST_UPDATED_BY,
392 X_LAST_UPDATE_DATE,
393 X_LAST_UPDATED_BY,
394 X_LAST_UPDATE_LOGIN,
395 X_ORG_ID,
396 X_AWARD_ID,
397 X_price_correct_inv_num,
398 -- Invoice Lines Project Stage 1
399 X_PRICE_CORRECT_INV_LINE_NUM,
400 X_SERIAL_NUMBER,
401 X_MANUFACTURER,
402 X_MODEL_NUMBER,
403 X_WARRANTY_NUMBER,
404 X_ASSET_BOOK_TYPE_CODE,
405 X_ASSET_CATEGORY_ID,
409 X_REQUESTER_ID,
406 X_REQUESTER_FIRST_NAME,
407 X_REQUESTER_LAST_NAME,
408 X_REQUESTER_EMPLOYEE_NUM,
410 X_DEFERRED_ACCTG_FLAG,
411 X_DEF_ACCTG_START_DATE,
412 X_DEF_ACCTG_END_DATE,
413 X_DEF_ACCTG_NUMBER_OF_PERIODS,
414 X_DEF_ACCTG_PERIOD_TYPE,
415 -- eTax Uptake
416 X_CONTROL_AMOUNT,
417 X_ASSESSABLE_VALUE,
418 X_DEFAULT_DIST_CCID,
419 X_PRIMARY_INTENDED_USE,
420 X_SHIP_TO_LOCATION_ID,
421 X_PRODUCT_TYPE,
422 X_PRODUCT_CATEGORY,
423 X_PRODUCT_FISC_CLASSIFICATION,
424 X_USER_DEFINED_FISC_CLASS,
425 X_TRX_BUSINESS_CATEGORY,
426 X_TAX_REGIME_CODE,
427 X_TAX,
428 X_TAX_JURISDICTION_CODE,
429 X_TAX_STATUS_CODE,
430 X_TAX_RATE_ID,
431 X_TAX_RATE_CODE,
432 X_TAX_RATE,
433 X_INCL_IN_TAXABLE_LINE_FLAG,
434 X_PURCHASING_CATEGORY,
435 X_PURCHASING_CATEGORY_ID,
436 X_COST_FACTOR_NAME,
437 X_COST_FACTOR_ID,
438 X_TAX_CLASSIFICATION_CODE);
439
440 debug_info := 'Open cursor C';
441 OPEN C;
442 debug_info := 'Fetch cursor C';
443 FETCH C INTO X_Rowid;
444 IF (C%NOTFOUND) THEN
445 debug_info := 'Close cursor C - ROW NOTFOUND';
446 CLOSE C;
447 Raise NO_DATA_FOUND;
448 END IF;
449 debug_info := 'Close cursor C';
450 CLOSE C;
451
452 EXCEPTION
453 WHEN OTHERS THEN
454 IF (SQLCODE <> -20001) THEN
455 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
456 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
457 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
458 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
459 END IF;
460 APP_EXCEPTION.RAISE_EXCEPTION;
461
462 END INSERT_ROW;
463
464 procedure LOCK_ROW (
465 X_ROWID IN VARCHAR2,
466 X_INVOICE_ID IN NUMBER,
467 X_INVOICE_LINE_ID IN NUMBER,
468 X_LINE_NUMBER IN NUMBER,
469 X_LINE_TYPE_LOOKUP_CODE IN VARCHAR2,
470 X_LINE_GROUP_NUMBER IN NUMBER,
471 X_AMOUNT IN NUMBER,
472 X_ACCOUNTING_DATE IN DATE,
473 X_DESCRIPTION IN VARCHAR2,
474 -- X_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
475 X_PRORATE_ACROSS_FLAG IN VARCHAR2,
476 -- X_TAX_CODE IN VARCHAR2, -- Commented for bug 8330367/8304429
477 -- X_TAX_CODE_ID IN NUMBER, -- Commented for bug 8330367/8304429
478 -- X_TAX_CODE_OVERRIDE_FLAG IN VARCHAR2,
479 -- X_TAX_RECOVERY_RATE IN NUMBER,
480 -- X_TAX_RECOVERY_OVERRIDE_FLAG IN VARCHAR2,
481 -- X_TAX_RECOVERABLE_FLAG IN VARCHAR2,
482 X_FINAL_MATCH_FLAG IN VARCHAR2,
483 X_PO_HEADER_ID IN NUMBER,
484 X_PO_LINE_ID IN NUMBER,
485 X_PO_LINE_LOCATION_ID IN NUMBER,
486 X_PO_DISTRIBUTION_ID IN NUMBER,
487 X_UNIT_OF_MEAS_LOOKUP_CODE IN VARCHAR2,
488 X_INVENTORY_ITEM_ID IN NUMBER,
489 X_QUANTITY_INVOICED IN NUMBER,
490 X_UNIT_PRICE IN NUMBER,
491 X_DISTRIBUTION_SET_ID IN NUMBER,
492 X_DIST_CODE_CONCATENATED IN VARCHAR2,
493 X_DIST_CODE_COMBINATION_ID IN NUMBER,
494 X_AWT_GROUP_ID IN NUMBER,
495 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
496 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
497 X_ATTRIBUTE1 IN VARCHAR2,
498 X_ATTRIBUTE2 IN VARCHAR2,
499 X_ATTRIBUTE3 IN VARCHAR2,
500 X_ATTRIBUTE4 IN VARCHAR2,
501 X_ATTRIBUTE5 IN VARCHAR2,
502 X_ATTRIBUTE6 IN VARCHAR2,
503 X_ATTRIBUTE7 IN VARCHAR2,
504 X_ATTRIBUTE8 IN VARCHAR2,
505 X_ATTRIBUTE9 IN VARCHAR2,
506 X_ATTRIBUTE10 IN VARCHAR2,
507 X_ATTRIBUTE11 IN VARCHAR2,
508 X_ATTRIBUTE12 IN VARCHAR2,
509 X_ATTRIBUTE13 IN VARCHAR2,
510 X_ATTRIBUTE14 IN VARCHAR2,
511 X_ATTRIBUTE15 IN VARCHAR2,
512 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
513 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
514 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
515 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
516 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
517 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
518 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
519 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
520 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
521 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
522 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
526 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
523 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
524 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
525 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
527 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
528 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
529 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
530 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
531 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
532 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
533 X_PO_RELEASE_ID IN NUMBER,
534 X_BALANCING_SEGMENT IN VARCHAR2,
535 X_COST_CENTER_SEGMENT IN VARCHAR2,
536 X_ACCOUNT_SEGMENT IN VARCHAR2,
537 X_PROJECT_ID IN NUMBER,
538 X_TASK_ID IN NUMBER,
539 X_EXPENDITURE_TYPE IN VARCHAR2,
540 X_EXPENDITURE_ITEM_DATE IN DATE,
541 X_EXPENDITURE_ORGANIZATION_ID IN NUMBER,
542 X_PROJECT_ACCOUNTING_CONTEXT IN VARCHAR2,
543 X_PA_ADDITION_FLAG IN VARCHAR2,
544 X_PA_QUANTITY IN NUMBER,
545 X_STAT_AMOUNT IN NUMBER,
546 X_TYPE_1099 IN VARCHAR2,
547 X_INCOME_TAX_REGION IN VARCHAR2,
548 X_ASSETS_TRACKING_FLAG IN VARCHAR2,
549 X_PRICE_CORRECTION_FLAG IN VARCHAR2,
550 -- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
551 X_RECEIPT_NUMBER IN VARCHAR2,
552 X_MATCH_OPTION IN VARCHAR2,
553 X_RCV_TRANSACTION_ID IN NUMBER,
554 X_CALLING_SEQUENCE IN VARCHAR2,
555 X_AWARD_ID IN NUMBER DEFAULT NULL,
556 X_PRICE_CORRECT_INV_NUM IN VARCHAR2 DEFAULT NULL,
557 -- Invoice Lines Project Stage 1
558 X_PRICE_CORRECT_INV_LINE_NUM IN NUMBER DEFAULT NULL,
559 X_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
560 X_MANUFACTURER IN VARCHAR2 DEFAULT NULL,
561 X_MODEL_NUMBER IN VARCHAR2 DEFAULT NULL,
562 X_WARRANTY_NUMBER IN VARCHAR2 DEFAULT NULL,
563 X_ASSET_BOOK_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
564 X_ASSET_CATEGORY_ID IN NUMBER DEFAULT NULL,
565 X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
566 X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
567 X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
568 X_REQUESTER_ID IN NUMBER DEFAULT NULL,
569 X_DEFERRED_ACCTG_FLAG IN VARCHAR2 DEFAULT NULL,
570 X_DEF_ACCTG_START_DATE IN DATE DEFAULT NULL,
571 X_DEF_ACCTG_END_DATE IN DATE DEFAULT NULL,
572 X_DEF_ACCTG_NUMBER_OF_PERIODS IN NUMBER DEFAULT NULL,
573 X_DEF_ACCTG_PERIOD_TYPE IN VARCHAR2 DEFAULT NULL,
574 -- eTax Uptake
575 X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
576 X_ASSESSABLE_VALUE IN NUMBER DEFAULT NULL,
577 X_DEFAULT_DIST_CCID IN NUMBER DEFAULT NULL,
578 X_PRIMARY_INTENDED_USE IN VARCHAR2 DEFAULT NULL,
579 X_SHIP_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
580 X_PRODUCT_TYPE IN VARCHAR2 DEFAULT NULL,
581 X_PRODUCT_CATEGORY IN VARCHAR2 DEFAULT NULL,
582 X_PRODUCT_FISC_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
583 X_USER_DEFINED_FISC_CLASS IN VARCHAR2 DEFAULT NULL,
584 X_TRX_BUSINESS_CATEGORY IN VARCHAR2 DEFAULT NULL,
585 X_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
586 X_TAX IN VARCHAR2 DEFAULT NULL,
587 X_TAX_JURISDICTION_CODE IN VARCHAR2 DEFAULT NULL,
588 X_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
589 X_TAX_RATE_ID IN NUMBER DEFAULT NULL,
590 X_TAX_RATE_CODE IN VARCHAR2 DEFAULT NULL,
591 X_TAX_RATE IN NUMBER DEFAULT NULL,
592 X_INCL_IN_TAXABLE_LINE_FLAG IN VARCHAR2 DEFAULT NULL,
593 X_PURCHASING_CATEGORY IN VARCHAR2 DEFAULT NULL,
594 X_PURCHASING_CATEGORY_ID IN NUMBER DEFAULT NULL,
595 X_COST_FACTOR_NAME IN VARCHAR2 DEFAULT NULL,
596 X_COST_FACTOR_ID IN NUMBER DEFAULT NULL,
597 X_TAX_CLASSIFICATION_CODE IN VARCHAR2 DEFAULT NULL)
598 IS
599 CURSOR C1 IS
600 SELECT
601 INVOICE_ID,
602 INVOICE_LINE_ID,
603 LINE_NUMBER,
604 LINE_TYPE_LOOKUP_CODE,
605 LINE_GROUP_NUMBER,
606 AMOUNT,
607 ACCOUNTING_DATE,
608 DESCRIPTION,
609 -- AMOUNT_INCLUDES_TAX_FLAG,
610 PRORATE_ACROSS_FLAG,
611 -- TAX_CODE, -- Commented for bug 8330367/8304429
612 -- TAX_CODE_ID, -- Commented for bug 8330367/8304429
613 -- TAX_CODE_OVERRIDE_FLAG,
614 -- TAX_RECOVERY_RATE,
615 -- TAX_RECOVERY_OVERRIDE_FLAG,
616 -- TAX_RECOVERABLE_FLAG,
617 FINAL_MATCH_FLAG,
618 PO_HEADER_ID,
619 PO_LINE_ID,
620 PO_LINE_LOCATION_ID,
621 PO_DISTRIBUTION_ID,
622 UNIT_OF_MEAS_LOOKUP_CODE,
623 INVENTORY_ITEM_ID,
624 QUANTITY_INVOICED,
628 DIST_CODE_COMBINATION_ID,
625 UNIT_PRICE,
626 DISTRIBUTION_SET_ID,
627 DIST_CODE_CONCATENATED,
629 AWT_GROUP_ID,
630 PAY_AWT_GROUP_ID,--bug6639866
631 ATTRIBUTE_CATEGORY,
632 ATTRIBUTE1,
633 ATTRIBUTE2,
634 ATTRIBUTE3,
635 ATTRIBUTE4,
636 ATTRIBUTE5,
637 ATTRIBUTE6,
638 ATTRIBUTE7,
639 ATTRIBUTE8,
640 ATTRIBUTE9,
641 ATTRIBUTE10,
642 ATTRIBUTE11,
643 ATTRIBUTE12,
644 ATTRIBUTE13,
645 ATTRIBUTE14,
646 ATTRIBUTE15,
647 GLOBAL_ATTRIBUTE_CATEGORY,
648 GLOBAL_ATTRIBUTE1,
649 GLOBAL_ATTRIBUTE2,
650 GLOBAL_ATTRIBUTE3,
651 GLOBAL_ATTRIBUTE4,
652 GLOBAL_ATTRIBUTE5,
653 GLOBAL_ATTRIBUTE6,
654 GLOBAL_ATTRIBUTE7,
655 GLOBAL_ATTRIBUTE8,
656 GLOBAL_ATTRIBUTE9,
657 GLOBAL_ATTRIBUTE10,
658 GLOBAL_ATTRIBUTE11,
659 GLOBAL_ATTRIBUTE12,
660 GLOBAL_ATTRIBUTE13,
661 GLOBAL_ATTRIBUTE14,
662 GLOBAL_ATTRIBUTE15,
663 GLOBAL_ATTRIBUTE16,
664 GLOBAL_ATTRIBUTE17,
665 GLOBAL_ATTRIBUTE18,
666 GLOBAL_ATTRIBUTE19,
667 GLOBAL_ATTRIBUTE20,
668 PO_RELEASE_ID,
669 BALANCING_SEGMENT,
670 COST_CENTER_SEGMENT,
671 ACCOUNT_SEGMENT,
672 PROJECT_ID,
673 TASK_ID,
674 EXPENDITURE_TYPE,
675 EXPENDITURE_ITEM_DATE,
676 EXPENDITURE_ORGANIZATION_ID,
677 PROJECT_ACCOUNTING_CONTEXT,
678 PA_ADDITION_FLAG,
679 PA_QUANTITY,
680 STAT_AMOUNT,
681 TYPE_1099,
682 INCOME_TAX_REGION,
683 ASSETS_TRACKING_FLAG,
684 PRICE_CORRECTION_FLAG,
685 -- USSGL_TRANSACTION_CODE, - Bug 4277744
686 RECEIPT_NUMBER,
687 MATCH_OPTION,
688 RCV_TRANSACTION_ID,
689 AWARD_ID,
690 PRICE_CORRECT_INV_NUM,
691 -- Invoice Lines Project Stage 1
692 PRICE_CORRECT_INV_LINE_NUM,
693 SERIAL_NUMBER,
694 MANUFACTURER,
695 MODEL_NUMBER,
696 WARRANTY_NUMBER,
697 ASSET_BOOK_TYPE_CODE,
698 ASSET_CATEGORY_ID,
699 REQUESTER_FIRST_NAME,
700 REQUESTER_LAST_NAME,
701 REQUESTER_EMPLOYEE_NUM,
702 REQUESTER_ID,
703 DEFERRED_ACCTG_FLAG,
704 DEF_ACCTG_START_DATE,
705 DEF_ACCTG_END_DATE,
706 DEF_ACCTG_NUMBER_OF_PERIODS,
707 DEF_ACCTG_PERIOD_TYPE,
708 CONTROL_AMOUNT,
709 ASSESSABLE_VALUE,
710 DEFAULT_DIST_CCID,
711 PRIMARY_INTENDED_USE,
712 SHIP_TO_LOCATION_ID,
713 PRODUCT_TYPE,
714 PRODUCT_CATEGORY,
715 PRODUCT_FISC_CLASSIFICATION,
716 USER_DEFINED_FISC_CLASS,
717 TRX_BUSINESS_CATEGORY,
718 TAX_REGIME_CODE,
719 TAX,
720 TAX_JURISDICTION_CODE,
721 TAX_STATUS_CODE,
722 TAX_RATE_ID,
723 TAX_RATE_CODE,
724 TAX_RATE,
725 INCL_IN_TAXABLE_LINE_FLAG,
726 PURCHASING_CATEGORY,
727 PURCHASING_CATEGORY_ID,
728 COST_FACTOR_NAME,
729 COST_FACTOR_ID,
730 TAX_CLASSIFICATION_CODE
731 FROM AP_INVOICE_LINES_INTERFACE
732 WHERE rowid = X_Rowid
733 FOR UPDATE OF Invoice_id NOWAIT;
734
735 tlinfo c1%rowtype;
736 current_calling_sequence VARCHAR2(2000);
737 debug_info VARCHAR2(100);
738 BEGIN
739 -- Update the calling sequence
740
741 current_calling_sequence :='AP_INVOICE_LINES_INTERFACE_PKG.Lock_Row<-'
742 ||X_Calling_Sequence;
743
744 debug_info := 'Select from ap_invoice_lines_interface';
745
746 OPEN c1;
747
748 debug_info := 'Fetch cursor C1';
749 FETCH c1 INTO tlinfo;
750 IF (c1%notfound) THEN
751 debug_info := 'Close cursor C - ROW NOTFOUND';
752 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
753 app_exception.raise_exception;
754 CLOSE c1;
755 RETURN;
756 END IF;
757 CLOSE c1;
758
759 IF ( (tlinfo.INVOICE_ID = X_INVOICE_ID)
760 AND ((tlinfo.INVOICE_LINE_ID = X_INVOICE_LINE_ID)
761 OR ((tlinfo.INVOICE_LINE_ID is null)
762 AND (X_INVOICE_LINE_ID is null)))
763 AND ((tlinfo.LINE_NUMBER = X_LINE_NUMBER)
764 OR ((tlinfo.LINE_NUMBER is null)
765 AND (X_LINE_NUMBER is null)))
766 AND ((tlinfo.LINE_TYPE_LOOKUP_CODE = X_LINE_TYPE_LOOKUP_CODE)
767 OR ((tlinfo.LINE_TYPE_LOOKUP_CODE is null)
768 AND (X_LINE_TYPE_LOOKUP_CODE is null)))
769 AND ((tlinfo.LINE_GROUP_NUMBER = X_LINE_GROUP_NUMBER)
770 OR ((tlinfo.LINE_GROUP_NUMBER is null)
771 AND (X_LINE_GROUP_NUMBER is null)))
772 AND ((tlinfo.AMOUNT = X_AMOUNT)
773 OR ((tlinfo.AMOUNT is null)
774 AND (X_AMOUNT is null)))
775 AND ((tlinfo.ACCOUNTING_DATE = X_ACCOUNTING_DATE)
776 OR ((tlinfo.ACCOUNTING_DATE is null)
777 AND (X_ACCOUNTING_DATE is null)))
778 AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
779 OR ((tlinfo.DESCRIPTION is null)
780 AND (X_DESCRIPTION is null)))
781 /*
782 AND ((tlinfo.AMOUNT_INCLUDES_TAX_FLAG = X_AMOUNT_INCLUDES_TAX_FLAG)
786 AND ((tlinfo.PRORATE_ACROSS_FLAG = X_PRORATE_ACROSS_FLAG)
783 OR ((tlinfo.AMOUNT_INCLUDES_TAX_FLAG is null)
784 AND (X_AMOUNT_INCLUDES_TAX_FLAG is null)))
785 */
787 OR ((tlinfo.PRORATE_ACROSS_FLAG is null)
788 AND (X_PRORATE_ACROSS_FLAG is null)))
789
790 -- Commented for bug 8330367/8304429
791 /* AND ((tlinfo.TAX_CODE = X_TAX_CODE)
792 OR ((tlinfo.TAX_CODE is null)
793 AND (X_TAX_CODE is null)))
794 AND ((tlinfo.TAX_CODE_ID = X_TAX_CODE_ID)
795 OR ((tlinfo.TAX_CODE_ID is null)
796 AND (X_TAX_CODE_ID is null))) */
797 -- End of 8330367/8304429
798 /*
799 AND ((tlinfo.TAX_CODE_OVERRIDE_FLAG = X_TAX_CODE_OVERRIDE_FLAG)
800 OR ((tlinfo.TAX_CODE_OVERRIDE_FLAG is null)
801 AND (X_TAX_CODE_OVERRIDE_FLAG is null)))
802 AND ((tlinfo.TAX_RECOVERY_RATE = X_TAX_RECOVERY_RATE)
803 OR ((tlinfo.TAX_RECOVERY_RATE is null)
804 AND (X_TAX_RECOVERY_RATE is null)))
805 AND ((tlinfo.TAX_RECOVERY_OVERRIDE_FLAG = X_TAX_RECOVERY_OVERRIDE_FLAG)
806 OR ((tlinfo.TAX_RECOVERY_OVERRIDE_FLAG is null)
807 AND (X_TAX_RECOVERY_OVERRIDE_FLAG is null)))
808 AND ((tlinfo.TAX_RECOVERABLE_FLAG = X_TAX_RECOVERABLE_FLAG)
809 OR ((tlinfo.TAX_RECOVERABLE_FLAG is null)
810 AND (X_TAX_RECOVERABLE_FLAG is null)))
811 */
812 AND ((tlinfo.FINAL_MATCH_FLAG = X_FINAL_MATCH_FLAG)
813 OR ((tlinfo.FINAL_MATCH_FLAG is null)
814 AND (X_FINAL_MATCH_FLAG is null)))
815 AND ((tlinfo.PO_HEADER_ID = X_PO_HEADER_ID)
816 OR ((tlinfo.PO_HEADER_ID is null)
817 AND (X_PO_HEADER_ID is null)))
818 AND ((tlinfo.PO_LINE_ID = X_PO_LINE_ID)
819 OR ((tlinfo.PO_LINE_ID is null)
820 AND (X_PO_LINE_ID is null)))
821 AND ((tlinfo.PO_LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID)
822 OR ((tlinfo.PO_LINE_LOCATION_ID is null)
823 AND (X_PO_LINE_LOCATION_ID is null)))
824 AND ((tlinfo.PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID)
825 OR ((tlinfo.PO_DISTRIBUTION_ID is null)
826 AND (X_PO_DISTRIBUTION_ID is null)))
827 AND ((tlinfo.UNIT_OF_MEAS_LOOKUP_CODE = X_UNIT_OF_MEAS_LOOKUP_CODE)
828 OR ((tlinfo.UNIT_OF_MEAS_LOOKUP_CODE is null)
829 AND (X_UNIT_OF_MEAS_LOOKUP_CODE is null)))
830 AND ((tlinfo.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID)
831 OR ((tlinfo.INVENTORY_ITEM_ID is null)
832 AND (X_INVENTORY_ITEM_ID is null)))
833 AND ((tlinfo.QUANTITY_INVOICED = X_QUANTITY_INVOICED)
834 OR ((tlinfo.QUANTITY_INVOICED is null)
835 AND (X_QUANTITY_INVOICED is null)))
836 AND ((tlinfo.UNIT_PRICE = X_UNIT_PRICE)
837 OR ((tlinfo.UNIT_PRICE is null)
838 AND (X_UNIT_PRICE is null)))
839 AND ((tlinfo.DISTRIBUTION_SET_ID = X_DISTRIBUTION_SET_ID)
840 OR ((tlinfo.DISTRIBUTION_SET_ID is null)
841 AND (X_DISTRIBUTION_SET_ID is null)))
842 AND ((tlinfo.DIST_CODE_CONCATENATED = X_DIST_CODE_CONCATENATED)
843 OR ((tlinfo.DIST_CODE_CONCATENATED is null)
844 AND (X_DIST_CODE_CONCATENATED is null)))
845 AND ((tlinfo.DIST_CODE_COMBINATION_ID = X_DIST_CODE_COMBINATION_ID)
846 OR ((tlinfo.DIST_CODE_COMBINATION_ID is null)
847 AND (X_DIST_CODE_COMBINATION_ID is null)))
848 AND ((tlinfo.AWT_GROUP_ID = X_AWT_GROUP_ID)
849 OR ((tlinfo.AWT_GROUP_ID is null)
850 AND (X_AWT_GROUP_ID is null)))
851 AND ((tlinfo.PAY_AWT_GROUP_ID = X_PAY_AWT_GROUP_ID)
852 OR ((tlinfo.PAY_AWT_GROUP_ID is null)
853 AND (X_PAY_AWT_GROUP_ID is null))) --bug6639866
854 AND ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
855 OR ((tlinfo.ATTRIBUTE_CATEGORY is null)
856 AND (X_ATTRIBUTE_CATEGORY is null)))
857 AND ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
858 OR ((tlinfo.ATTRIBUTE1 is null)
859 AND (X_ATTRIBUTE1 is null)))
860 AND ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
861 OR ((tlinfo.ATTRIBUTE2 is null)
862 AND (X_ATTRIBUTE2 is null)))
863 AND ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
864 OR ((tlinfo.ATTRIBUTE3 is null)
865 AND (X_ATTRIBUTE3 is null)))
866 AND ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
867 OR ((tlinfo.ATTRIBUTE4 is null)
868 AND (X_ATTRIBUTE4 is null)))
869 AND ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
870 OR ((tlinfo.ATTRIBUTE5 is null)
871 AND (X_ATTRIBUTE5 is null)))
872 AND ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
873 OR ((tlinfo.ATTRIBUTE6 is null)
874 AND (X_ATTRIBUTE6 is null)))
875 AND ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
876 OR ((tlinfo.ATTRIBUTE7 is null)
877 AND (X_ATTRIBUTE7 is null)))
878 AND ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
879 OR ((tlinfo.ATTRIBUTE8 is null)
880 AND (X_ATTRIBUTE8 is null)))
881 AND ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
882 OR ((tlinfo.ATTRIBUTE9 is null)
883 AND (X_ATTRIBUTE9 is null)))
884 AND ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
885 OR ((tlinfo.ATTRIBUTE10 is null)
886 AND (X_ATTRIBUTE10 is null)))
887 AND ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
888 OR ((tlinfo.ATTRIBUTE11 is null)
889 AND (X_ATTRIBUTE11 is null)))
890 AND ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
891 OR ((tlinfo.ATTRIBUTE12 is null)
892 AND (X_ATTRIBUTE12 is null)))
893 AND ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
894 OR ((tlinfo.ATTRIBUTE13 is null)
895 AND (X_ATTRIBUTE13 is null)))
896 AND ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
900 OR ((tlinfo.ATTRIBUTE15 is null)
897 OR ((tlinfo.ATTRIBUTE14 is null)
898 AND (X_ATTRIBUTE14 is null)))
899 AND ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
901 AND (X_ATTRIBUTE15 is null)))
902 AND ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY)
903 OR ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY is null)
904 AND (X_GLOBAL_ATTRIBUTE_CATEGORY is null)))
905 AND ((tlinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1)
906 OR ((tlinfo.GLOBAL_ATTRIBUTE1 is null)
907 AND (X_GLOBAL_ATTRIBUTE1 is null)))
908 AND ((tlinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2)
909 OR ((tlinfo.GLOBAL_ATTRIBUTE2 is null)
910 AND (X_GLOBAL_ATTRIBUTE2 is null)))
911 AND ((tlinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3)
912 OR ((tlinfo.GLOBAL_ATTRIBUTE3 is null)
913 AND (X_GLOBAL_ATTRIBUTE3 is null)))
914 AND ((tlinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4)
915 OR ((tlinfo.GLOBAL_ATTRIBUTE4 is null)
916 AND (X_GLOBAL_ATTRIBUTE4 is null)))
917 AND ((tlinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5)
918 OR ((tlinfo.GLOBAL_ATTRIBUTE5 is null)
919 AND (X_GLOBAL_ATTRIBUTE5 is null)))
920 AND ((tlinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6)
921 OR ((tlinfo.GLOBAL_ATTRIBUTE6 is null)
922 AND (X_GLOBAL_ATTRIBUTE6 is null)))
923 AND ((tlinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7)
924 OR ((tlinfo.GLOBAL_ATTRIBUTE7 is null)
925 AND (X_GLOBAL_ATTRIBUTE7 is null)))
926 AND ((tlinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8)
927 OR ((tlinfo.GLOBAL_ATTRIBUTE8 is null)
928 AND (X_GLOBAL_ATTRIBUTE8 is null)))
929 AND ((tlinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9)
930 OR ((tlinfo.GLOBAL_ATTRIBUTE9 is null)
931 AND (X_GLOBAL_ATTRIBUTE9 is null)))
932 AND ((tlinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10)
933 OR ((tlinfo.GLOBAL_ATTRIBUTE10 is null)
934 AND (X_GLOBAL_ATTRIBUTE10 is null)))
935 AND ((tlinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11)
936 OR ((tlinfo.GLOBAL_ATTRIBUTE11 is null)
937 AND (X_GLOBAL_ATTRIBUTE11 is null)))
938 AND ((tlinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12)
939 OR ((tlinfo.GLOBAL_ATTRIBUTE12 is null)
940 AND (X_GLOBAL_ATTRIBUTE12 is null)))
941 AND ((tlinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13)
942 OR ((tlinfo.GLOBAL_ATTRIBUTE13 is null)
943 AND (X_GLOBAL_ATTRIBUTE13 is null)))
944 AND ((tlinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14)
945 OR ((tlinfo.GLOBAL_ATTRIBUTE14 is null)
946 AND (X_GLOBAL_ATTRIBUTE14 is null)))
947 AND ((tlinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15)
948 OR ((tlinfo.GLOBAL_ATTRIBUTE15 is null)
949 AND (X_GLOBAL_ATTRIBUTE15 is null)))
950 AND ((tlinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16)
951 OR ((tlinfo.GLOBAL_ATTRIBUTE16 is null)
952 AND (X_GLOBAL_ATTRIBUTE16 is null)))
953 AND ((tlinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17)
954 OR ((tlinfo.GLOBAL_ATTRIBUTE17 is null)
955 AND (X_GLOBAL_ATTRIBUTE17 is null)))
956 AND ((tlinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18)
957 OR ((tlinfo.GLOBAL_ATTRIBUTE18 is null)
958 AND (X_GLOBAL_ATTRIBUTE18 is null)))
959 AND ((tlinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19)
960 OR ((tlinfo.GLOBAL_ATTRIBUTE19 is null)
961 AND (X_GLOBAL_ATTRIBUTE19 is null)))
962 AND ((tlinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20)
963 OR ((tlinfo.GLOBAL_ATTRIBUTE20 is null)
964 AND (X_GLOBAL_ATTRIBUTE20 is null)))
965 AND ((tlinfo.PO_RELEASE_ID = X_PO_RELEASE_ID)
966 OR ((tlinfo.PO_RELEASE_ID is null)
967 AND (X_PO_RELEASE_ID is null)))
968 AND ((tlinfo.BALANCING_SEGMENT = X_BALANCING_SEGMENT)
969 OR ((tlinfo.BALANCING_SEGMENT is null)
970 AND (X_BALANCING_SEGMENT is null)))
971 AND ((tlinfo.COST_CENTER_SEGMENT = X_COST_CENTER_SEGMENT)
972 OR ((tlinfo.COST_CENTER_SEGMENT is null)
973 AND (X_COST_CENTER_SEGMENT is null)))
974 AND ((tlinfo.ACCOUNT_SEGMENT = X_ACCOUNT_SEGMENT)
975 OR ((tlinfo.ACCOUNT_SEGMENT is null)
976 AND (X_ACCOUNT_SEGMENT is null)))
977 AND ((tlinfo.PROJECT_ID = X_PROJECT_ID)
978 OR ((tlinfo.PROJECT_ID is null)
979 AND (X_PROJECT_ID is null)))
980 AND ((tlinfo.TASK_ID = X_TASK_ID)
981 OR ((tlinfo.TASK_ID is null)
982 AND (X_TASK_ID is null)))
983 AND ((tlinfo.EXPENDITURE_TYPE = X_EXPENDITURE_TYPE)
984 OR ((tlinfo.EXPENDITURE_TYPE is null)
985 AND (X_EXPENDITURE_TYPE is null)))
986 AND ((tlinfo.EXPENDITURE_ITEM_DATE = X_EXPENDITURE_ITEM_DATE)
987 OR ((tlinfo.EXPENDITURE_ITEM_DATE is null)
988 AND (X_EXPENDITURE_ITEM_DATE is null)))
989 AND ((tlinfo.EXPENDITURE_ORGANIZATION_ID = X_EXPENDITURE_ORGANIZATION_ID)
990 OR ((tlinfo.EXPENDITURE_ORGANIZATION_ID is null)
991 AND (X_EXPENDITURE_ORGANIZATION_ID is null)))
992 AND ((tlinfo.PROJECT_ACCOUNTING_CONTEXT = X_PROJECT_ACCOUNTING_CONTEXT)
993 OR ((tlinfo.PROJECT_ACCOUNTING_CONTEXT is null)
994 AND (X_PROJECT_ACCOUNTING_CONTEXT is null)))
995 AND ((tlinfo.PA_ADDITION_FLAG = X_PA_ADDITION_FLAG)
996 OR ((tlinfo.PA_ADDITION_FLAG is null)
997 AND (X_PA_ADDITION_FLAG is null)))
998 AND ((tlinfo.PA_QUANTITY = X_PA_QUANTITY)
999 OR ((tlinfo.PA_QUANTITY is null)
1000 AND (X_PA_QUANTITY is null)))
1001 AND ((tlinfo.STAT_AMOUNT = X_STAT_AMOUNT)
1002 OR ((tlinfo.STAT_AMOUNT is null)
1006 AND (X_TYPE_1099 is null)))
1003 AND (X_STAT_AMOUNT is null)))
1004 AND ((tlinfo.TYPE_1099 = X_TYPE_1099)
1005 OR ((tlinfo.TYPE_1099 is null)
1007 AND ((tlinfo.INCOME_TAX_REGION = X_INCOME_TAX_REGION)
1008 OR ((tlinfo.INCOME_TAX_REGION is null)
1009 AND (X_INCOME_TAX_REGION is null)))
1010 AND ((tlinfo.ASSETS_TRACKING_FLAG = X_ASSETS_TRACKING_FLAG)
1011 OR ((tlinfo.ASSETS_TRACKING_FLAG is null)
1012 AND (X_ASSETS_TRACKING_FLAG is null)))
1013 AND ((tlinfo.PRICE_CORRECTION_FLAG = X_PRICE_CORRECTION_FLAG)
1014 OR ((tlinfo.PRICE_CORRECTION_FLAG is null)
1015 AND (X_PRICE_CORRECTION_FLAG is null)))
1016 AND ((tlinfo.PRICE_CORRECT_INV_NUM = X_PRICE_CORRECT_INV_NUM)
1017 OR ((tlinfo.PRICE_CORRECT_INV_NUM is null)
1018 AND (X_PRICE_CORRECT_INV_NUM is null)))
1019 -- Removed for bug 4277744
1020 -- AND ((tlinfo.USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE)
1021 -- OR ((tlinfo.USSGL_TRANSACTION_CODE is null)
1022 -- AND (X_USSGL_TRANSACTION_CODE is null)))
1023 AND ((tlinfo.RECEIPT_NUMBER = X_RECEIPT_NUMBER)
1024 OR ((tlinfo.RECEIPT_NUMBER is null)
1025 AND (X_RECEIPT_NUMBER is null)))
1026 AND ((tlinfo.MATCH_OPTION = X_MATCH_OPTION)
1027 OR ((tlinfo.MATCH_OPTION is null)
1028 AND (X_MATCH_OPTION is null)))
1029 AND ((tlinfo.AWARD_ID = X_AWARD_ID)
1030 OR ((tlinfo.AWARD_ID is null)
1031 AND (X_AWARD_ID is null)))
1032 AND ((tlinfo.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID)
1033 OR ((tlinfo.RCV_TRANSACTION_ID is null)
1034 AND (X_RCV_TRANSACTION_ID is null)))
1035 -- Invoice Lines Project Stage 1
1036 AND ((tlinfo.PRICE_CORRECT_INV_LINE_NUM = X_PRICE_CORRECT_INV_LINE_NUM)
1037 OR ((tlinfo.PRICE_CORRECT_INV_LINE_NUM is null)
1038 AND (X_PRICE_CORRECT_INV_LINE_NUM is null)))
1039 AND ((tlinfo.SERIAL_NUMBER = X_SERIAL_NUMBER)
1040 OR ((tlinfo.SERIAL_NUMBER is null)
1041 AND (X_SERIAL_NUMBER is null)))
1042 AND ((tlinfo.MANUFACTURER = X_MANUFACTURER)
1043 OR ((tlinfo.MANUFACTURER is null)
1044 AND (X_MANUFACTURER is null)))
1045 AND ((tlinfo.MODEL_NUMBER = X_MODEL_NUMBER)
1046 OR ((tlinfo.MODEL_NUMBER is null)
1047 AND (X_MODEL_NUMBER is null)))
1048 AND ((tlinfo.WARRANTY_NUMBER = X_WARRANTY_NUMBER)
1049 OR ((tlinfo.WARRANTY_NUMBER is null)
1050 AND (X_WARRANTY_NUMBER is null)))
1051 AND ((tlinfo.ASSET_BOOK_TYPE_CODE = X_ASSET_BOOK_TYPE_CODE)
1052 OR ((tlinfo.ASSET_BOOK_TYPE_CODE is null)
1053 AND (X_ASSET_BOOK_TYPE_CODE is null)))
1054 AND ((tlinfo.ASSET_CATEGORY_ID = X_ASSET_CATEGORY_ID)
1055 OR ((tlinfo.ASSET_CATEGORY_ID is null)
1056 AND (X_ASSET_CATEGORY_ID is null)))
1057 AND ((tlinfo.REQUESTER_FIRST_NAME = X_REQUESTER_FIRST_NAME)
1058 OR ((tlinfo.REQUESTER_FIRST_NAME is null)
1059 AND (X_REQUESTER_FIRST_NAME is null)))
1060 AND ((tlinfo.REQUESTER_LAST_NAME = X_REQUESTER_LAST_NAME)
1061 OR ((tlinfo.REQUESTER_LAST_NAME is null)
1062 AND (X_REQUESTER_LAST_NAME is null)))
1063 AND ((tlinfo.REQUESTER_EMPLOYEE_NUM = X_REQUESTER_EMPLOYEE_NUM)
1064 OR ((tlinfo.REQUESTER_EMPLOYEE_NUM is null)
1065 AND (X_REQUESTER_EMPLOYEE_NUM is null)))
1066 AND ((tlinfo.REQUESTER_ID = X_REQUESTER_ID)
1067 OR ((tlinfo.REQUESTER_ID is null)
1068 AND (X_REQUESTER_ID is null)))
1069 AND ((tlinfo.DEFERRED_ACCTG_FLAG = X_DEFERRED_ACCTG_FLAG)
1070 OR ((tlinfo.DEFERRED_ACCTG_FLAG is null)
1071 AND (X_DEFERRED_ACCTG_FLAG is null)))
1072 AND ((tlinfo.DEF_ACCTG_START_DATE = X_DEF_ACCTG_START_DATE)
1073 OR ((tlinfo.DEF_ACCTG_START_DATE is null)
1074 AND (X_DEF_ACCTG_START_DATE is null)))
1075 AND ((tlinfo.DEF_ACCTG_END_DATE = X_DEF_ACCTG_END_DATE)
1076 OR ((tlinfo.DEF_ACCTG_END_DATE is null)
1077 AND (X_DEF_ACCTG_END_DATE is null)))
1078 AND ((tlinfo.DEF_ACCTG_NUMBER_OF_PERIODS = X_DEF_ACCTG_NUMBER_OF_PERIODS)
1079 OR ((tlinfo.DEF_ACCTG_NUMBER_OF_PERIODS is null)
1080 AND (X_DEF_ACCTG_NUMBER_OF_PERIODS is null)))
1081 AND ((tlinfo.DEF_ACCTG_PERIOD_TYPE = X_DEF_ACCTG_PERIOD_TYPE)
1082 OR ((tlinfo.DEF_ACCTG_PERIOD_TYPE is null)
1083 AND (X_DEF_ACCTG_PERIOD_TYPE is null)))
1084 -- eTax Uptake
1085 AND ((tlinfo.CONTROL_AMOUNT = X_CONTROL_AMOUNT)
1086 OR ((tlinfo.CONTROL_AMOUNT is null)
1087 AND (X_CONTROL_AMOUNT is null)))
1088 AND ((tlinfo.ASSESSABLE_VALUE = X_ASSESSABLE_VALUE)
1089 OR ((tlinfo.ASSESSABLE_VALUE is null)
1090 AND (X_ASSESSABLE_VALUE is null)))
1091 AND ((tlinfo.DEFAULT_DIST_CCID = X_DEFAULT_DIST_CCID)
1092 OR ((tlinfo.DEFAULT_DIST_CCID is null)
1093 AND (X_DEFAULT_DIST_CCID is null)))
1094 AND ((tlinfo.PRIMARY_INTENDED_USE = X_PRIMARY_INTENDED_USE)
1095 OR ((tlinfo.PRIMARY_INTENDED_USE is null)
1096 AND (X_PRIMARY_INTENDED_USE is null)))
1097 AND ((tlinfo.SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID)
1098 OR ((tlinfo.SHIP_TO_LOCATION_ID is null)
1099 AND (X_SHIP_TO_LOCATION_ID is null)))
1100 AND ((tlinfo.PRODUCT_TYPE = X_PRODUCT_TYPE)
1101 OR ((tlinfo.PRODUCT_TYPE is null)
1102 AND (X_PRODUCT_TYPE is null)))
1103 AND ((tlinfo.PRODUCT_CATEGORY = X_PRODUCT_CATEGORY)
1104 OR ((tlinfo.PRODUCT_CATEGORY is null)
1105 AND (X_PRODUCT_CATEGORY is null)))
1106 AND ((tlinfo.PRODUCT_FISC_CLASSIFICATION = X_PRODUCT_FISC_CLASSIFICATION)
1107 OR ((tlinfo.PRODUCT_FISC_CLASSIFICATION is null)
1108 AND (X_PRODUCT_FISC_CLASSIFICATION is null)))
1112 AND ((tlinfo.TRX_BUSINESS_CATEGORY = X_TRX_BUSINESS_CATEGORY)
1109 AND ((tlinfo.USER_DEFINED_FISC_CLASS = X_USER_DEFINED_FISC_CLASS)
1110 OR ((tlinfo.USER_DEFINED_FISC_CLASS is null)
1111 AND (X_USER_DEFINED_FISC_CLASS is null)))
1113 OR ((tlinfo.TRX_BUSINESS_CATEGORY is null)
1114 AND (X_TRX_BUSINESS_CATEGORY is null)))
1115 AND ((tlinfo.TAX_REGIME_CODE = X_TAX_REGIME_CODE)
1116 OR ((tlinfo.TAX_REGIME_CODE is null)
1117 AND (X_TAX_REGIME_CODE is null)))
1118 AND ((tlinfo.TAX = X_TAX)
1119 OR ((tlinfo.TAX is null)
1120 AND (X_TAX is null)))
1121 AND ((tlinfo.TAX_JURISDICTION_CODE = X_TAX_JURISDICTION_CODE)
1122 OR ((tlinfo.TAX_JURISDICTION_CODE is null)
1123 AND (X_TAX_JURISDICTION_CODE is null)))
1124 AND ((tlinfo.TAX_STATUS_CODE = X_TAX_STATUS_CODE)
1125 OR ((tlinfo.TAX_STATUS_CODE is null)
1126 AND (X_TAX_STATUS_CODE is null)))
1127 AND ((tlinfo.TAX_RATE_ID = X_TAX_RATE_ID)
1128 OR ((tlinfo.TAX_RATE_ID is null)
1129 AND (X_TAX_RATE_ID is null)))
1130 AND ((tlinfo.TAX_RATE_CODE = X_TAX_RATE_CODE)
1131 OR ((tlinfo.TAX_RATE_CODE is null)
1132 AND (X_TAX_RATE_CODE is null)))
1133 AND ((tlinfo.TAX_RATE = X_TAX_RATE)
1134 OR ((tlinfo.TAX_RATE is null)
1135 AND (X_TAX_RATE is null)))
1136 AND ((tlinfo.INCL_IN_TAXABLE_LINE_FLAG = X_INCL_IN_TAXABLE_LINE_FLAG)
1137 OR ((tlinfo.INCL_IN_TAXABLE_LINE_FLAG is null)
1138 AND (X_INCL_IN_TAXABLE_LINE_FLAG is null)))
1139 AND ((tlinfo.PURCHASING_CATEGORY = X_PURCHASING_CATEGORY)
1140 OR ((tlinfo.PURCHASING_CATEGORY IS NULL)
1141 AND (X_PURCHASING_CATEGORY IS NULL)))
1142 AND ((tlinfo.PURCHASING_CATEGORY_ID = X_PURCHASING_CATEGORY_ID)
1143 OR ((tlinfo.PURCHASING_CATEGORY_ID IS NULL)
1144 AND (X_PURCHASING_CATEGORY_ID IS NULL)))
1145 AND ((tlinfo.COST_FACTOR_NAME = X_COST_FACTOR_NAME)
1146 OR ((tlinfo.COST_FACTOR_NAME IS NULL)
1147 AND (X_COST_FACTOR_NAME IS NULL)))
1148 AND ((tlinfo.COST_FACTOR_ID = X_COST_FACTOR_ID)
1149 OR ((tlinfo.COST_FACTOR_ID IS NULL)
1150 AND (X_COST_FACTOR_ID IS NULL)))
1151 AND ((tlinfo.TAX_CLASSIFICATION_CODE = X_TAX_CLASSIFICATION_CODE)
1152 OR ((tlinfo.TAX_CLASSIFICATION_CODE IS NULL)
1153 AND (X_TAX_CLASSIFICATION_CODE IS NULL)))
1154 ) THEN
1155 NULL;
1156 ELSE
1157 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1158 app_exception.raise_exception;
1159 END IF;
1160 RETURN;
1161 EXCEPTION
1162 WHEN OTHERS THEN
1163 if (SQLCODE <> -20001) then
1164 IF (SQLCODE = -54) THEN
1165 FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1166 ELSE
1167 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1168 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1169 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1170 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1171 END IF;
1172 END IF;
1173 APP_EXCEPTION.RAISE_EXCEPTION;
1174 END LOCK_ROW;
1175
1176 procedure UPDATE_ROW (
1177 X_Rowid IN VARCHAR2,
1178 X_INVOICE_ID IN NUMBER,
1179 X_INVOICE_LINE_ID IN NUMBER,
1180 X_LINE_NUMBER IN NUMBER,
1181 X_LINE_TYPE_LOOKUP_CODE IN VARCHAR2,
1182 X_LINE_GROUP_NUMBER IN NUMBER,
1183 X_AMOUNT IN NUMBER,
1184 X_ACCOUNTING_DATE IN DATE,
1185 X_DESCRIPTION IN VARCHAR2,
1186 -- X_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
1187 X_PRORATE_ACROSS_FLAG IN VARCHAR2,
1188 X_TAX_CODE IN VARCHAR2,
1189 X_TAX_CODE_ID IN NUMBER,
1190 -- X_TAX_CODE_OVERRIDE_FLAG IN VARCHAR2,
1191 -- X_TAX_RECOVERY_RATE IN NUMBER,
1192 -- X_TAX_RECOVERY_OVERRIDE_FLAG IN VARCHAR2,
1193 -- X_TAX_RECOVERABLE_FLAG IN VARCHAR2,
1194 X_FINAL_MATCH_FLAG IN VARCHAR2,
1195 X_PO_HEADER_ID IN NUMBER,
1196 X_PO_LINE_ID IN NUMBER,
1197 X_PO_LINE_LOCATION_ID IN NUMBER,
1198 X_PO_DISTRIBUTION_ID IN NUMBER,
1199 X_UNIT_OF_MEAS_LOOKUP_CODE IN VARCHAR2,
1200 X_INVENTORY_ITEM_ID IN NUMBER,
1201 X_QUANTITY_INVOICED IN NUMBER,
1202 X_UNIT_PRICE IN NUMBER,
1203 X_DISTRIBUTION_SET_ID IN NUMBER,
1204 X_DIST_CODE_CONCATENATED IN VARCHAR2,
1205 X_DIST_CODE_COMBINATION_ID IN NUMBER,
1206 X_AWT_GROUP_ID IN NUMBER,
1207 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
1208 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
1209 X_ATTRIBUTE1 IN VARCHAR2,
1210 X_ATTRIBUTE2 IN VARCHAR2,
1211 X_ATTRIBUTE3 IN VARCHAR2,
1212 X_ATTRIBUTE4 IN VARCHAR2,
1213 X_ATTRIBUTE5 IN VARCHAR2,
1214 X_ATTRIBUTE6 IN VARCHAR2,
1215 X_ATTRIBUTE7 IN VARCHAR2,
1216 X_ATTRIBUTE8 IN VARCHAR2,
1220 X_ATTRIBUTE12 IN VARCHAR2,
1217 X_ATTRIBUTE9 IN VARCHAR2,
1218 X_ATTRIBUTE10 IN VARCHAR2,
1219 X_ATTRIBUTE11 IN VARCHAR2,
1221 X_ATTRIBUTE13 IN VARCHAR2,
1222 X_ATTRIBUTE14 IN VARCHAR2,
1223 X_ATTRIBUTE15 IN VARCHAR2,
1224 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1225 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1226 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1227 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1228 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1229 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1230 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1231 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1232 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1233 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1234 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1235 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1236 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1237 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1238 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1239 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1240 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1241 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1242 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1243 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1244 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
1245 X_PO_RELEASE_ID IN NUMBER,
1246 X_BALANCING_SEGMENT IN VARCHAR2,
1247 X_COST_CENTER_SEGMENT IN VARCHAR2,
1248 X_ACCOUNT_SEGMENT IN VARCHAR2,
1249 X_PROJECT_ID IN NUMBER,
1250 X_TASK_ID IN NUMBER,
1251 X_EXPENDITURE_TYPE IN VARCHAR2,
1252 X_EXPENDITURE_ITEM_DATE IN DATE,
1253 X_EXPENDITURE_ORGANIZATION_ID IN NUMBER,
1254 X_PROJECT_ACCOUNTING_CONTEXT IN VARCHAR2,
1255 X_PA_ADDITION_FLAG IN VARCHAR2,
1256 X_PA_QUANTITY IN NUMBER,
1257 X_STAT_AMOUNT IN NUMBER,
1258 X_TYPE_1099 IN VARCHAR2,
1259 X_INCOME_TAX_REGION IN VARCHAR2,
1260 X_ASSETS_TRACKING_FLAG IN VARCHAR2,
1261 X_PRICE_CORRECTION_FLAG IN VARCHAR2,
1262 -- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
1263 X_RECEIPT_NUMBER IN VARCHAR2,
1264 X_MATCH_OPTION IN VARCHAR2,
1265 X_RCV_TRANSACTION_ID IN NUMBER,
1266 X_LAST_UPDATE_DATE IN DATE,
1267 X_LAST_UPDATED_BY IN NUMBER,
1268 X_LAST_UPDATE_LOGIN IN NUMBER,
1269 X_MODE IN VARCHAR2 DEFAULT 'R',
1270 X_CALLING_SEQUENCE IN VARCHAR2,
1271 X_AWARD_ID IN NUMBER,
1272 X_price_correct_inv_num IN VARCHAR2 DEFAULT NULL,
1273 -- Invoice Lines Project Stage 1
1274 X_PRICE_CORRECT_INV_LINE_NUM IN NUMBER DEFAULT NULL,
1275 X_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
1276 X_MANUFACTURER IN VARCHAR2 DEFAULT NULL,
1277 X_MODEL_NUMBER IN VARCHAR2 DEFAULT NULL,
1278 X_WARRANTY_NUMBER IN VARCHAR2 DEFAULT NULL,
1279 X_ASSET_BOOK_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
1280 X_ASSET_CATEGORY_ID IN NUMBER DEFAULT NULL,
1281 X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
1282 X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
1283 X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
1284 X_REQUESTER_ID IN NUMBER DEFAULT NULL,
1285 X_DEFERRED_ACCTG_FLAG IN VARCHAR2 DEFAULT NULL,
1286 X_DEF_ACCTG_START_DATE IN DATE DEFAULT NULL,
1287 X_DEF_ACCTG_END_DATE IN DATE DEFAULT NULL,
1288 X_DEF_ACCTG_NUMBER_OF_PERIODS IN NUMBER DEFAULT NULL,
1289 X_DEF_ACCTG_PERIOD_TYPE IN VARCHAR2 DEFAULT NULL,
1290 -- eTax Uptake
1291 X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
1292 X_ASSESSABLE_VALUE IN NUMBER DEFAULT NULL,
1293 X_DEFAULT_DIST_CCID IN NUMBER DEFAULT NULL,
1294 X_PRIMARY_INTENDED_USE IN VARCHAR2 DEFAULT NULL,
1295 X_SHIP_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
1296 X_PRODUCT_TYPE IN VARCHAR2 DEFAULT NULL,
1297 X_PRODUCT_CATEGORY IN VARCHAR2 DEFAULT NULL,
1298 X_PRODUCT_FISC_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
1299 X_USER_DEFINED_FISC_CLASS IN VARCHAR2 DEFAULT NULL,
1300 X_TRX_BUSINESS_CATEGORY IN VARCHAR2 DEFAULT NULL,
1301 X_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
1302 X_TAX IN VARCHAR2 DEFAULT NULL,
1303 X_TAX_JURISDICTION_CODE IN VARCHAR2 DEFAULT NULL,
1304 X_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
1305 X_TAX_RATE_ID IN NUMBER DEFAULT NULL,
1306 X_TAX_RATE_CODE IN VARCHAR2 DEFAULT NULL,
1310 X_PURCHASING_CATEGORY_ID IN NUMBER DEFAULT NULL,
1307 X_TAX_RATE IN NUMBER DEFAULT NULL,
1308 X_INCL_IN_TAXABLE_LINE_FLAG IN VARCHAR2 DEFAULT NULL,
1309 X_PURCHASING_CATEGORY IN VARCHAR2 DEFAULT NULL,
1311 X_COST_FACTOR_NAME IN VARCHAR2 DEFAULT NULL,
1312 X_COST_FACTOR_ID IN NUMBER DEFAULT NULL,
1313 X_TAX_CLASSIFICATION_CODE IN VARCHAR2 DEFAULT NULL)
1314 IS
1315
1316 current_calling_sequence VARCHAR2(2000);
1317 debug_info VARCHAR2(100);
1318
1319 BEGIN
1320 -- Update the calling sequence
1321
1322 current_calling_sequence := 'AP_INVOICE_LINES_INTERFACE_PKG.Update_Row<-'
1323 ||X_Calling_Sequence;
1324
1325 debug_info := 'Update ap_invoice_lines_interface';
1326
1327 UPDATE AP_INVOICE_LINES_INTERFACE SET
1328 INVOICE_ID = X_INVOICE_ID,
1329 INVOICE_LINE_ID = X_INVOICE_LINE_ID,
1330 LINE_NUMBER = X_LINE_NUMBER,
1331 LINE_TYPE_LOOKUP_CODE = X_LINE_TYPE_LOOKUP_CODE,
1332 LINE_GROUP_NUMBER = X_LINE_GROUP_NUMBER,
1333 AMOUNT = X_AMOUNT,
1334 ACCOUNTING_DATE = X_ACCOUNTING_DATE,
1335 DESCRIPTION = X_DESCRIPTION,
1336 -- AMOUNT_INCLUDES_TAX_FLAG = X_AMOUNT_INCLUDES_TAX_FLAG,
1337 PRORATE_ACROSS_FLAG = X_PRORATE_ACROSS_FLAG,
1338 TAX_CODE = X_TAX_CODE,
1339 TAX_CODE_ID = X_TAX_CODE_ID,
1340 -- TAX_CODE_OVERRIDE_FLAG = X_TAX_CODE_OVERRIDE_FLAG,
1341 -- TAX_RECOVERY_RATE = X_TAX_RECOVERY_RATE,
1342 -- TAX_RECOVERY_OVERRIDE_FLAG = X_TAX_RECOVERY_OVERRIDE_FLAG,
1343 -- TAX_RECOVERABLE_FLAG = X_TAX_RECOVERABLE_FLAG,
1344 FINAL_MATCH_FLAG = X_FINAL_MATCH_FLAG,
1345 PO_HEADER_ID = X_PO_HEADER_ID,
1346 PO_LINE_ID = X_PO_LINE_ID,
1347 PO_LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID,
1348 PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID,
1349 UNIT_OF_MEAS_LOOKUP_CODE = X_UNIT_OF_MEAS_LOOKUP_CODE,
1350 INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
1351 QUANTITY_INVOICED = X_QUANTITY_INVOICED,
1352 UNIT_PRICE = X_UNIT_PRICE,
1353 DISTRIBUTION_SET_ID = X_DISTRIBUTION_SET_ID,
1354 DIST_CODE_CONCATENATED = X_DIST_CODE_CONCATENATED,
1355 DIST_CODE_COMBINATION_ID = X_DIST_CODE_COMBINATION_ID,
1356 AWT_GROUP_ID = X_AWT_GROUP_ID,
1357 PAY_AWT_GROUP_ID = X_PAY_AWT_GROUP_ID,--bug6639866
1358 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
1359 ATTRIBUTE1 = X_ATTRIBUTE1,
1360 ATTRIBUTE2 = X_ATTRIBUTE2,
1361 ATTRIBUTE3 = X_ATTRIBUTE3,
1362 ATTRIBUTE4 = X_ATTRIBUTE4,
1363 ATTRIBUTE5 = X_ATTRIBUTE5,
1364 ATTRIBUTE6 = X_ATTRIBUTE6,
1365 ATTRIBUTE7 = X_ATTRIBUTE7,
1366 ATTRIBUTE8 = X_ATTRIBUTE8,
1367 ATTRIBUTE9 = X_ATTRIBUTE9,
1368 ATTRIBUTE10 = X_ATTRIBUTE10,
1369 ATTRIBUTE11 = X_ATTRIBUTE11,
1370 ATTRIBUTE12 = X_ATTRIBUTE12,
1371 ATTRIBUTE13 = X_ATTRIBUTE13,
1372 ATTRIBUTE14 = X_ATTRIBUTE14,
1373 ATTRIBUTE15 = X_ATTRIBUTE15,
1374 GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY,
1375 GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1,
1376 GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2,
1377 GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3,
1378 GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4,
1379 GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5,
1380 GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6,
1381 GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
1382 GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,
1383 GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9,
1384 GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10,
1385 GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11,
1386 GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12,
1387 GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13,
1388 GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14,
1389 GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15,
1390 GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16,
1391 GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17,
1392 GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18,
1393 GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19,
1394 GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20,
1395 PO_RELEASE_ID = X_PO_RELEASE_ID,
1396 BALANCING_SEGMENT = X_BALANCING_SEGMENT,
1397 COST_CENTER_SEGMENT = X_COST_CENTER_SEGMENT,
1398 ACCOUNT_SEGMENT = X_ACCOUNT_SEGMENT,
1399 PROJECT_ID = X_PROJECT_ID,
1400 TASK_ID = X_TASK_ID,
1401 EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,
1402 EXPENDITURE_ITEM_DATE = X_EXPENDITURE_ITEM_DATE,
1403 EXPENDITURE_ORGANIZATION_ID= X_EXPENDITURE_ORGANIZATION_ID,
1404 PROJECT_ACCOUNTING_CONTEXT = X_PROJECT_ACCOUNTING_CONTEXT,
1405 PA_ADDITION_FLAG = X_PA_ADDITION_FLAG,
1406 PA_QUANTITY = X_PA_QUANTITY,
1407 STAT_AMOUNT = X_STAT_AMOUNT,
1408 TYPE_1099 = X_TYPE_1099,
1409 INCOME_TAX_REGION = X_INCOME_TAX_REGION,
1410 ASSETS_TRACKING_FLAG = X_ASSETS_TRACKING_FLAG,
1414 MATCH_OPTION = X_MATCH_OPTION,
1411 PRICE_CORRECTION_FLAG = X_PRICE_CORRECTION_FLAG,
1412 -- USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE, - Bug 4277744
1413 RECEIPT_NUMBER = X_RECEIPT_NUMBER,
1415 RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID,
1416 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1417 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1418 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1419 AWARD_ID = X_AWARD_ID,
1420 PRICE_CORRECT_INV_NUM = X_PRICE_CORRECT_INV_NUM,
1421 -- Invoice Lines Project Stage 1
1422 PRICE_CORRECT_INV_LINE_NUM = X_PRICE_CORRECT_INV_LINE_NUM,
1423 SERIAL_NUMBER = X_SERIAL_NUMBER,
1424 MANUFACTURER = X_MANUFACTURER,
1425 MODEL_NUMBER = X_MODEL_NUMBER,
1426 WARRANTY_NUMBER = X_WARRANTY_NUMBER,
1427 ASSET_BOOK_TYPE_CODE = X_ASSET_BOOK_TYPE_CODE,
1428 ASSET_CATEGORY_ID = X_ASSET_CATEGORY_ID,
1429 REQUESTER_FIRST_NAME = X_REQUESTER_FIRST_NAME,
1430 REQUESTER_LAST_NAME = X_REQUESTER_LAST_NAME,
1431 REQUESTER_EMPLOYEE_NUM = X_REQUESTER_EMPLOYEE_NUM,
1432 REQUESTER_ID = X_REQUESTER_ID,
1433 DEFERRED_ACCTG_FLAG = X_DEFERRED_ACCTG_FLAG,
1434 DEF_ACCTG_START_DATE = X_DEF_ACCTG_START_DATE,
1435 DEF_ACCTG_END_DATE = X_DEF_ACCTG_END_DATE,
1436 DEF_ACCTG_NUMBER_OF_PERIODS= X_DEF_ACCTG_NUMBER_OF_PERIODS,
1437 DEF_ACCTG_PERIOD_TYPE = X_DEF_ACCTG_PERIOD_TYPE,
1438 -- eTax Uptake
1439 CONTROL_AMOUNT = X_CONTROL_AMOUNT,
1440 ASSESSABLE_VALUE = X_ASSESSABLE_VALUE,
1441 DEFAULT_DIST_CCID = X_DEFAULT_DIST_CCID,
1442 PRIMARY_INTENDED_USE = X_PRIMARY_INTENDED_USE,
1443 SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID,
1444 PRODUCT_TYPE = X_PRODUCT_TYPE,
1445 PRODUCT_CATEGORY = X_PRODUCT_CATEGORY,
1446 PRODUCT_FISC_CLASSIFICATION = X_PRODUCT_FISC_CLASSIFICATION,
1447 USER_DEFINED_FISC_CLASS = X_USER_DEFINED_FISC_CLASS,
1448 TRX_BUSINESS_CATEGORY = X_TRX_BUSINESS_CATEGORY,
1449 TAX_REGIME_CODE = X_TAX_REGIME_CODE,
1450 TAX = X_TAX,
1451 TAX_JURISDICTION_CODE = X_TAX_JURISDICTION_CODE,
1452 TAX_STATUS_CODE = X_TAX_STATUS_CODE,
1453 TAX_RATE_ID = X_TAX_RATE_ID,
1454 TAX_RATE_CODE = X_TAX_RATE_CODE,
1455 TAX_RATE = X_TAX_RATE,
1456 INCL_IN_TAXABLE_LINE_FLAG = X_INCL_IN_TAXABLE_LINE_FLAG,
1457 PURCHASING_CATEGORY = X_PURCHASING_CATEGORY,
1458 PURCHASING_CATEGORY_ID = X_PURCHASING_CATEGORY_ID,
1459 COST_FACTOR_NAME = X_COST_FACTOR_NAME,
1460 COST_FACTOR_ID = X_COST_FACTOR_ID,
1461 TAX_CLASSIFICATION_CODE = X_TAX_CLASSIFICATION_CODE
1462 WHERE rowid = X_Rowid;
1463
1464 IF (sql%notfound) THEN
1465 Raise no_data_found;
1466 END IF;
1467 EXCEPTION
1468 WHEN OTHERS THEN
1469 IF (SQLCODE <> -20001) THEN
1470 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1471 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1472 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1473 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1474 END IF;
1475 APP_EXCEPTION.RAISE_EXCEPTION;
1476 END UPDATE_ROW;
1477
1478
1479 PROCEDURE Delete_Row(
1480 X_INVOICE_LINE_ID NUMBER,
1481 X_Calling_Sequence VARCHAR2)
1482 IS
1483 current_calling_sequence VARCHAR2(2000);
1484 debug_info VARCHAR2(100);
1485
1486 BEGIN
1487
1488 -- Update the calling sequence
1489
1490 current_calling_sequence := 'AP_INVOICE_LINES_INTERFACE_PKG.Delete_Row<-'
1491 ||X_Calling_Sequence;
1492
1493 -- Bug 2496745. Deleting the rejections for this invoice line.
1494
1495 debug_info := 'Delete from ap_interface_rejections';
1496
1497 DELETE FROM AP_INTERFACE_REJECTIONS
1498 WHERE parent_id = X_invoice_line_id
1499 AND parent_table = 'AP_INVOICE_LINES_INTERFACE';
1500
1501 debug_info := 'Delete from ap_invoice_lines_interface';
1502
1503 DELETE FROM AP_INVOICE_LINES_INTERFACE
1504 WHERE invoice_line_id = X_invoice_line_id;
1505
1506 IF (SQL%NOTFOUND) THEN
1507 Raise NO_DATA_FOUND;
1508 END IF;
1509
1510 EXCEPTION
1511 WHEN OTHERS THEN
1512 IF (SQLCODE <> -20001) THEN
1513 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1514 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1515 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1516 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1517 END IF;
1518 APP_EXCEPTION.RAISE_EXCEPTION;
1519
1520 END Delete_Row;
1521
1522 END AP_INVOICE_LINES_INTERFACE_PKG;
[Home] [Help]