1 package body AP_INVOICE_LINES_INTERFACE_PKG as
2 /* $Header: apailthb.pls 120.10 2008/03/04 06:45:30 imandal 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,
240 EXPENDITURE_ORGANIZATION_ID,
241 PROJECT_ACCOUNTING_CONTEXT,
242 PA_ADDITION_FLAG,
243 PA_QUANTITY,
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,
363 X_GLOBAL_ATTRIBUTE15,
360 X_GLOBAL_ATTRIBUTE12,
361 X_GLOBAL_ATTRIBUTE13,
362 X_GLOBAL_ATTRIBUTE14,
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,
406 X_REQUESTER_FIRST_NAME,
407 X_REQUESTER_LAST_NAME,
408 X_REQUESTER_EMPLOYEE_NUM,
409 X_REQUESTER_ID,
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,
477 X_TAX_CODE_ID IN NUMBER,
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,
495 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
492 X_DIST_CODE_CONCATENATED IN VARCHAR2,
493 X_DIST_CODE_COMBINATION_ID IN NUMBER,
494 X_AWT_GROUP_ID IN NUMBER,
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,
523 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
524 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
525 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
526 X_GLOBAL_ATTRIBUTE14 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,
576 X_ASSESSABLE_VALUE 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,
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,
612 TAX_CODE_ID,
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,
625 UNIT_PRICE,
626 DISTRIBUTION_SET_ID,
627 DIST_CODE_CONCATENATED,
628 DIST_CODE_COMBINATION_ID,
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,
716 USER_DEFINED_FISC_CLASS,
713 PRODUCT_TYPE,
714 PRODUCT_CATEGORY,
715 PRODUCT_FISC_CLASSIFICATION,
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)
783 OR ((tlinfo.AMOUNT_INCLUDES_TAX_FLAG is null)
784 AND (X_AMOUNT_INCLUDES_TAX_FLAG is null)))
785 */
786 AND ((tlinfo.PRORATE_ACROSS_FLAG = X_PRORATE_ACROSS_FLAG)
787 OR ((tlinfo.PRORATE_ACROSS_FLAG is null)
788 AND (X_PRORATE_ACROSS_FLAG is null)))
789 AND ((tlinfo.TAX_CODE = X_TAX_CODE)
790 OR ((tlinfo.TAX_CODE is null)
791 AND (X_TAX_CODE is null)))
792 AND ((tlinfo.TAX_CODE_ID = X_TAX_CODE_ID)
793 OR ((tlinfo.TAX_CODE_ID is null)
794 AND (X_TAX_CODE_ID is null)))
795 /*
796 AND ((tlinfo.TAX_CODE_OVERRIDE_FLAG = X_TAX_CODE_OVERRIDE_FLAG)
797 OR ((tlinfo.TAX_CODE_OVERRIDE_FLAG is null)
798 AND (X_TAX_CODE_OVERRIDE_FLAG is null)))
799 AND ((tlinfo.TAX_RECOVERY_RATE = X_TAX_RECOVERY_RATE)
800 OR ((tlinfo.TAX_RECOVERY_RATE is null)
801 AND (X_TAX_RECOVERY_RATE is null)))
802 AND ((tlinfo.TAX_RECOVERY_OVERRIDE_FLAG = X_TAX_RECOVERY_OVERRIDE_FLAG)
803 OR ((tlinfo.TAX_RECOVERY_OVERRIDE_FLAG is null)
804 AND (X_TAX_RECOVERY_OVERRIDE_FLAG is null)))
805 AND ((tlinfo.TAX_RECOVERABLE_FLAG = X_TAX_RECOVERABLE_FLAG)
806 OR ((tlinfo.TAX_RECOVERABLE_FLAG is null)
807 AND (X_TAX_RECOVERABLE_FLAG is null)))
808 */
809 AND ((tlinfo.FINAL_MATCH_FLAG = X_FINAL_MATCH_FLAG)
810 OR ((tlinfo.FINAL_MATCH_FLAG is null)
811 AND (X_FINAL_MATCH_FLAG is null)))
812 AND ((tlinfo.PO_HEADER_ID = X_PO_HEADER_ID)
813 OR ((tlinfo.PO_HEADER_ID is null)
814 AND (X_PO_HEADER_ID is null)))
815 AND ((tlinfo.PO_LINE_ID = X_PO_LINE_ID)
816 OR ((tlinfo.PO_LINE_ID is null)
817 AND (X_PO_LINE_ID is null)))
818 AND ((tlinfo.PO_LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID)
819 OR ((tlinfo.PO_LINE_LOCATION_ID is null)
820 AND (X_PO_LINE_LOCATION_ID is null)))
821 AND ((tlinfo.PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID)
822 OR ((tlinfo.PO_DISTRIBUTION_ID is null)
823 AND (X_PO_DISTRIBUTION_ID is null)))
824 AND ((tlinfo.UNIT_OF_MEAS_LOOKUP_CODE = X_UNIT_OF_MEAS_LOOKUP_CODE)
825 OR ((tlinfo.UNIT_OF_MEAS_LOOKUP_CODE is null)
826 AND (X_UNIT_OF_MEAS_LOOKUP_CODE is null)))
827 AND ((tlinfo.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID)
828 OR ((tlinfo.INVENTORY_ITEM_ID is null)
829 AND (X_INVENTORY_ITEM_ID is null)))
830 AND ((tlinfo.QUANTITY_INVOICED = X_QUANTITY_INVOICED)
831 OR ((tlinfo.QUANTITY_INVOICED is null)
832 AND (X_QUANTITY_INVOICED is null)))
836 AND ((tlinfo.DISTRIBUTION_SET_ID = X_DISTRIBUTION_SET_ID)
833 AND ((tlinfo.UNIT_PRICE = X_UNIT_PRICE)
834 OR ((tlinfo.UNIT_PRICE is null)
835 AND (X_UNIT_PRICE is null)))
837 OR ((tlinfo.DISTRIBUTION_SET_ID is null)
838 AND (X_DISTRIBUTION_SET_ID is null)))
839 AND ((tlinfo.DIST_CODE_CONCATENATED = X_DIST_CODE_CONCATENATED)
840 OR ((tlinfo.DIST_CODE_CONCATENATED is null)
841 AND (X_DIST_CODE_CONCATENATED is null)))
842 AND ((tlinfo.DIST_CODE_COMBINATION_ID = X_DIST_CODE_COMBINATION_ID)
843 OR ((tlinfo.DIST_CODE_COMBINATION_ID is null)
844 AND (X_DIST_CODE_COMBINATION_ID is null)))
845 AND ((tlinfo.AWT_GROUP_ID = X_AWT_GROUP_ID)
846 OR ((tlinfo.AWT_GROUP_ID is null)
847 AND (X_AWT_GROUP_ID is null)))
848 AND ((tlinfo.PAY_AWT_GROUP_ID = X_PAY_AWT_GROUP_ID)
849 OR ((tlinfo.PAY_AWT_GROUP_ID is null)
850 AND (X_PAY_AWT_GROUP_ID is null))) --bug6639866
851 AND ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
852 OR ((tlinfo.ATTRIBUTE_CATEGORY is null)
853 AND (X_ATTRIBUTE_CATEGORY is null)))
854 AND ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
855 OR ((tlinfo.ATTRIBUTE1 is null)
856 AND (X_ATTRIBUTE1 is null)))
857 AND ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
858 OR ((tlinfo.ATTRIBUTE2 is null)
859 AND (X_ATTRIBUTE2 is null)))
860 AND ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
861 OR ((tlinfo.ATTRIBUTE3 is null)
862 AND (X_ATTRIBUTE3 is null)))
863 AND ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
864 OR ((tlinfo.ATTRIBUTE4 is null)
865 AND (X_ATTRIBUTE4 is null)))
866 AND ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
867 OR ((tlinfo.ATTRIBUTE5 is null)
868 AND (X_ATTRIBUTE5 is null)))
869 AND ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
870 OR ((tlinfo.ATTRIBUTE6 is null)
871 AND (X_ATTRIBUTE6 is null)))
872 AND ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
873 OR ((tlinfo.ATTRIBUTE7 is null)
874 AND (X_ATTRIBUTE7 is null)))
875 AND ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
876 OR ((tlinfo.ATTRIBUTE8 is null)
877 AND (X_ATTRIBUTE8 is null)))
878 AND ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
879 OR ((tlinfo.ATTRIBUTE9 is null)
880 AND (X_ATTRIBUTE9 is null)))
881 AND ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
882 OR ((tlinfo.ATTRIBUTE10 is null)
883 AND (X_ATTRIBUTE10 is null)))
884 AND ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
885 OR ((tlinfo.ATTRIBUTE11 is null)
886 AND (X_ATTRIBUTE11 is null)))
887 AND ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
888 OR ((tlinfo.ATTRIBUTE12 is null)
889 AND (X_ATTRIBUTE12 is null)))
890 AND ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
891 OR ((tlinfo.ATTRIBUTE13 is null)
892 AND (X_ATTRIBUTE13 is null)))
893 AND ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
894 OR ((tlinfo.ATTRIBUTE14 is null)
895 AND (X_ATTRIBUTE14 is null)))
896 AND ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
897 OR ((tlinfo.ATTRIBUTE15 is null)
898 AND (X_ATTRIBUTE15 is null)))
899 AND ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY)
900 OR ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY is null)
901 AND (X_GLOBAL_ATTRIBUTE_CATEGORY is null)))
902 AND ((tlinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1)
903 OR ((tlinfo.GLOBAL_ATTRIBUTE1 is null)
904 AND (X_GLOBAL_ATTRIBUTE1 is null)))
905 AND ((tlinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2)
906 OR ((tlinfo.GLOBAL_ATTRIBUTE2 is null)
907 AND (X_GLOBAL_ATTRIBUTE2 is null)))
908 AND ((tlinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3)
909 OR ((tlinfo.GLOBAL_ATTRIBUTE3 is null)
910 AND (X_GLOBAL_ATTRIBUTE3 is null)))
911 AND ((tlinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4)
912 OR ((tlinfo.GLOBAL_ATTRIBUTE4 is null)
913 AND (X_GLOBAL_ATTRIBUTE4 is null)))
914 AND ((tlinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5)
915 OR ((tlinfo.GLOBAL_ATTRIBUTE5 is null)
916 AND (X_GLOBAL_ATTRIBUTE5 is null)))
917 AND ((tlinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6)
918 OR ((tlinfo.GLOBAL_ATTRIBUTE6 is null)
919 AND (X_GLOBAL_ATTRIBUTE6 is null)))
920 AND ((tlinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7)
921 OR ((tlinfo.GLOBAL_ATTRIBUTE7 is null)
922 AND (X_GLOBAL_ATTRIBUTE7 is null)))
923 AND ((tlinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8)
924 OR ((tlinfo.GLOBAL_ATTRIBUTE8 is null)
925 AND (X_GLOBAL_ATTRIBUTE8 is null)))
926 AND ((tlinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9)
927 OR ((tlinfo.GLOBAL_ATTRIBUTE9 is null)
928 AND (X_GLOBAL_ATTRIBUTE9 is null)))
929 AND ((tlinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10)
930 OR ((tlinfo.GLOBAL_ATTRIBUTE10 is null)
931 AND (X_GLOBAL_ATTRIBUTE10 is null)))
932 AND ((tlinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11)
933 OR ((tlinfo.GLOBAL_ATTRIBUTE11 is null)
937 AND (X_GLOBAL_ATTRIBUTE12 is null)))
934 AND (X_GLOBAL_ATTRIBUTE11 is null)))
935 AND ((tlinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12)
936 OR ((tlinfo.GLOBAL_ATTRIBUTE12 is null)
938 AND ((tlinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13)
939 OR ((tlinfo.GLOBAL_ATTRIBUTE13 is null)
940 AND (X_GLOBAL_ATTRIBUTE13 is null)))
941 AND ((tlinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14)
942 OR ((tlinfo.GLOBAL_ATTRIBUTE14 is null)
943 AND (X_GLOBAL_ATTRIBUTE14 is null)))
944 AND ((tlinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15)
945 OR ((tlinfo.GLOBAL_ATTRIBUTE15 is null)
946 AND (X_GLOBAL_ATTRIBUTE15 is null)))
947 AND ((tlinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16)
948 OR ((tlinfo.GLOBAL_ATTRIBUTE16 is null)
949 AND (X_GLOBAL_ATTRIBUTE16 is null)))
950 AND ((tlinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17)
951 OR ((tlinfo.GLOBAL_ATTRIBUTE17 is null)
952 AND (X_GLOBAL_ATTRIBUTE17 is null)))
953 AND ((tlinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18)
954 OR ((tlinfo.GLOBAL_ATTRIBUTE18 is null)
955 AND (X_GLOBAL_ATTRIBUTE18 is null)))
956 AND ((tlinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19)
957 OR ((tlinfo.GLOBAL_ATTRIBUTE19 is null)
958 AND (X_GLOBAL_ATTRIBUTE19 is null)))
959 AND ((tlinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20)
960 OR ((tlinfo.GLOBAL_ATTRIBUTE20 is null)
961 AND (X_GLOBAL_ATTRIBUTE20 is null)))
962 AND ((tlinfo.PO_RELEASE_ID = X_PO_RELEASE_ID)
963 OR ((tlinfo.PO_RELEASE_ID is null)
964 AND (X_PO_RELEASE_ID is null)))
965 AND ((tlinfo.BALANCING_SEGMENT = X_BALANCING_SEGMENT)
966 OR ((tlinfo.BALANCING_SEGMENT is null)
967 AND (X_BALANCING_SEGMENT is null)))
968 AND ((tlinfo.COST_CENTER_SEGMENT = X_COST_CENTER_SEGMENT)
969 OR ((tlinfo.COST_CENTER_SEGMENT is null)
970 AND (X_COST_CENTER_SEGMENT is null)))
971 AND ((tlinfo.ACCOUNT_SEGMENT = X_ACCOUNT_SEGMENT)
972 OR ((tlinfo.ACCOUNT_SEGMENT is null)
973 AND (X_ACCOUNT_SEGMENT is null)))
974 AND ((tlinfo.PROJECT_ID = X_PROJECT_ID)
975 OR ((tlinfo.PROJECT_ID is null)
976 AND (X_PROJECT_ID is null)))
977 AND ((tlinfo.TASK_ID = X_TASK_ID)
978 OR ((tlinfo.TASK_ID is null)
979 AND (X_TASK_ID is null)))
980 AND ((tlinfo.EXPENDITURE_TYPE = X_EXPENDITURE_TYPE)
981 OR ((tlinfo.EXPENDITURE_TYPE is null)
982 AND (X_EXPENDITURE_TYPE is null)))
983 AND ((tlinfo.EXPENDITURE_ITEM_DATE = X_EXPENDITURE_ITEM_DATE)
984 OR ((tlinfo.EXPENDITURE_ITEM_DATE is null)
985 AND (X_EXPENDITURE_ITEM_DATE is null)))
986 AND ((tlinfo.EXPENDITURE_ORGANIZATION_ID = X_EXPENDITURE_ORGANIZATION_ID)
987 OR ((tlinfo.EXPENDITURE_ORGANIZATION_ID is null)
988 AND (X_EXPENDITURE_ORGANIZATION_ID is null)))
989 AND ((tlinfo.PROJECT_ACCOUNTING_CONTEXT = X_PROJECT_ACCOUNTING_CONTEXT)
990 OR ((tlinfo.PROJECT_ACCOUNTING_CONTEXT is null)
991 AND (X_PROJECT_ACCOUNTING_CONTEXT is null)))
992 AND ((tlinfo.PA_ADDITION_FLAG = X_PA_ADDITION_FLAG)
993 OR ((tlinfo.PA_ADDITION_FLAG is null)
994 AND (X_PA_ADDITION_FLAG is null)))
995 AND ((tlinfo.PA_QUANTITY = X_PA_QUANTITY)
996 OR ((tlinfo.PA_QUANTITY is null)
997 AND (X_PA_QUANTITY is null)))
998 AND ((tlinfo.STAT_AMOUNT = X_STAT_AMOUNT)
999 OR ((tlinfo.STAT_AMOUNT is null)
1000 AND (X_STAT_AMOUNT is null)))
1001 AND ((tlinfo.TYPE_1099 = X_TYPE_1099)
1002 OR ((tlinfo.TYPE_1099 is null)
1003 AND (X_TYPE_1099 is null)))
1004 AND ((tlinfo.INCOME_TAX_REGION = X_INCOME_TAX_REGION)
1005 OR ((tlinfo.INCOME_TAX_REGION is null)
1006 AND (X_INCOME_TAX_REGION is null)))
1007 AND ((tlinfo.ASSETS_TRACKING_FLAG = X_ASSETS_TRACKING_FLAG)
1008 OR ((tlinfo.ASSETS_TRACKING_FLAG is null)
1009 AND (X_ASSETS_TRACKING_FLAG is null)))
1010 AND ((tlinfo.PRICE_CORRECTION_FLAG = X_PRICE_CORRECTION_FLAG)
1011 OR ((tlinfo.PRICE_CORRECTION_FLAG is null)
1012 AND (X_PRICE_CORRECTION_FLAG is null)))
1013 AND ((tlinfo.PRICE_CORRECT_INV_NUM = X_PRICE_CORRECT_INV_NUM)
1014 OR ((tlinfo.PRICE_CORRECT_INV_NUM is null)
1015 AND (X_PRICE_CORRECT_INV_NUM is null)))
1016 -- Removed for bug 4277744
1017 -- AND ((tlinfo.USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE)
1018 -- OR ((tlinfo.USSGL_TRANSACTION_CODE is null)
1019 -- AND (X_USSGL_TRANSACTION_CODE is null)))
1020 AND ((tlinfo.RECEIPT_NUMBER = X_RECEIPT_NUMBER)
1021 OR ((tlinfo.RECEIPT_NUMBER is null)
1022 AND (X_RECEIPT_NUMBER is null)))
1023 AND ((tlinfo.MATCH_OPTION = X_MATCH_OPTION)
1024 OR ((tlinfo.MATCH_OPTION is null)
1025 AND (X_MATCH_OPTION is null)))
1026 AND ((tlinfo.AWARD_ID = X_AWARD_ID)
1027 OR ((tlinfo.AWARD_ID is null)
1028 AND (X_AWARD_ID is null)))
1029 AND ((tlinfo.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID)
1030 OR ((tlinfo.RCV_TRANSACTION_ID is null)
1031 AND (X_RCV_TRANSACTION_ID is null)))
1032 -- Invoice Lines Project Stage 1
1033 AND ((tlinfo.PRICE_CORRECT_INV_LINE_NUM = X_PRICE_CORRECT_INV_LINE_NUM)
1034 OR ((tlinfo.PRICE_CORRECT_INV_LINE_NUM is null)
1038 AND (X_SERIAL_NUMBER is null)))
1035 AND (X_PRICE_CORRECT_INV_LINE_NUM is null)))
1036 AND ((tlinfo.SERIAL_NUMBER = X_SERIAL_NUMBER)
1037 OR ((tlinfo.SERIAL_NUMBER is null)
1039 AND ((tlinfo.MANUFACTURER = X_MANUFACTURER)
1040 OR ((tlinfo.MANUFACTURER is null)
1041 AND (X_MANUFACTURER is null)))
1042 AND ((tlinfo.MODEL_NUMBER = X_MODEL_NUMBER)
1043 OR ((tlinfo.MODEL_NUMBER is null)
1044 AND (X_MODEL_NUMBER is null)))
1045 AND ((tlinfo.WARRANTY_NUMBER = X_WARRANTY_NUMBER)
1046 OR ((tlinfo.WARRANTY_NUMBER is null)
1047 AND (X_WARRANTY_NUMBER is null)))
1048 AND ((tlinfo.ASSET_BOOK_TYPE_CODE = X_ASSET_BOOK_TYPE_CODE)
1049 OR ((tlinfo.ASSET_BOOK_TYPE_CODE is null)
1050 AND (X_ASSET_BOOK_TYPE_CODE is null)))
1051 AND ((tlinfo.ASSET_CATEGORY_ID = X_ASSET_CATEGORY_ID)
1052 OR ((tlinfo.ASSET_CATEGORY_ID is null)
1053 AND (X_ASSET_CATEGORY_ID is null)))
1054 AND ((tlinfo.REQUESTER_FIRST_NAME = X_REQUESTER_FIRST_NAME)
1055 OR ((tlinfo.REQUESTER_FIRST_NAME is null)
1056 AND (X_REQUESTER_FIRST_NAME is null)))
1057 AND ((tlinfo.REQUESTER_LAST_NAME = X_REQUESTER_LAST_NAME)
1058 OR ((tlinfo.REQUESTER_LAST_NAME is null)
1059 AND (X_REQUESTER_LAST_NAME is null)))
1060 AND ((tlinfo.REQUESTER_EMPLOYEE_NUM = X_REQUESTER_EMPLOYEE_NUM)
1061 OR ((tlinfo.REQUESTER_EMPLOYEE_NUM is null)
1062 AND (X_REQUESTER_EMPLOYEE_NUM is null)))
1063 AND ((tlinfo.REQUESTER_ID = X_REQUESTER_ID)
1064 OR ((tlinfo.REQUESTER_ID is null)
1065 AND (X_REQUESTER_ID is null)))
1066 AND ((tlinfo.DEFERRED_ACCTG_FLAG = X_DEFERRED_ACCTG_FLAG)
1067 OR ((tlinfo.DEFERRED_ACCTG_FLAG is null)
1068 AND (X_DEFERRED_ACCTG_FLAG is null)))
1069 AND ((tlinfo.DEF_ACCTG_START_DATE = X_DEF_ACCTG_START_DATE)
1070 OR ((tlinfo.DEF_ACCTG_START_DATE is null)
1071 AND (X_DEF_ACCTG_START_DATE is null)))
1072 AND ((tlinfo.DEF_ACCTG_END_DATE = X_DEF_ACCTG_END_DATE)
1073 OR ((tlinfo.DEF_ACCTG_END_DATE is null)
1074 AND (X_DEF_ACCTG_END_DATE is null)))
1075 AND ((tlinfo.DEF_ACCTG_NUMBER_OF_PERIODS = X_DEF_ACCTG_NUMBER_OF_PERIODS)
1076 OR ((tlinfo.DEF_ACCTG_NUMBER_OF_PERIODS is null)
1077 AND (X_DEF_ACCTG_NUMBER_OF_PERIODS is null)))
1078 AND ((tlinfo.DEF_ACCTG_PERIOD_TYPE = X_DEF_ACCTG_PERIOD_TYPE)
1079 OR ((tlinfo.DEF_ACCTG_PERIOD_TYPE is null)
1080 AND (X_DEF_ACCTG_PERIOD_TYPE is null)))
1081 -- eTax Uptake
1082 AND ((tlinfo.CONTROL_AMOUNT = X_CONTROL_AMOUNT)
1083 OR ((tlinfo.CONTROL_AMOUNT is null)
1084 AND (X_CONTROL_AMOUNT is null)))
1085 AND ((tlinfo.ASSESSABLE_VALUE = X_ASSESSABLE_VALUE)
1086 OR ((tlinfo.ASSESSABLE_VALUE is null)
1087 AND (X_ASSESSABLE_VALUE is null)))
1088 AND ((tlinfo.DEFAULT_DIST_CCID = X_DEFAULT_DIST_CCID)
1089 OR ((tlinfo.DEFAULT_DIST_CCID is null)
1090 AND (X_DEFAULT_DIST_CCID is null)))
1091 AND ((tlinfo.PRIMARY_INTENDED_USE = X_PRIMARY_INTENDED_USE)
1092 OR ((tlinfo.PRIMARY_INTENDED_USE is null)
1093 AND (X_PRIMARY_INTENDED_USE is null)))
1094 AND ((tlinfo.SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID)
1095 OR ((tlinfo.SHIP_TO_LOCATION_ID is null)
1096 AND (X_SHIP_TO_LOCATION_ID is null)))
1097 AND ((tlinfo.PRODUCT_TYPE = X_PRODUCT_TYPE)
1098 OR ((tlinfo.PRODUCT_TYPE is null)
1099 AND (X_PRODUCT_TYPE is null)))
1100 AND ((tlinfo.PRODUCT_CATEGORY = X_PRODUCT_CATEGORY)
1101 OR ((tlinfo.PRODUCT_CATEGORY is null)
1102 AND (X_PRODUCT_CATEGORY is null)))
1103 AND ((tlinfo.PRODUCT_FISC_CLASSIFICATION = X_PRODUCT_FISC_CLASSIFICATION)
1104 OR ((tlinfo.PRODUCT_FISC_CLASSIFICATION is null)
1105 AND (X_PRODUCT_FISC_CLASSIFICATION is null)))
1106 AND ((tlinfo.USER_DEFINED_FISC_CLASS = X_USER_DEFINED_FISC_CLASS)
1107 OR ((tlinfo.USER_DEFINED_FISC_CLASS is null)
1108 AND (X_USER_DEFINED_FISC_CLASS is null)))
1109 AND ((tlinfo.TRX_BUSINESS_CATEGORY = X_TRX_BUSINESS_CATEGORY)
1110 OR ((tlinfo.TRX_BUSINESS_CATEGORY is null)
1111 AND (X_TRX_BUSINESS_CATEGORY is null)))
1112 AND ((tlinfo.TAX_REGIME_CODE = X_TAX_REGIME_CODE)
1113 OR ((tlinfo.TAX_REGIME_CODE is null)
1114 AND (X_TAX_REGIME_CODE is null)))
1115 AND ((tlinfo.TAX = X_TAX)
1116 OR ((tlinfo.TAX is null)
1117 AND (X_TAX is null)))
1118 AND ((tlinfo.TAX_JURISDICTION_CODE = X_TAX_JURISDICTION_CODE)
1119 OR ((tlinfo.TAX_JURISDICTION_CODE is null)
1120 AND (X_TAX_JURISDICTION_CODE is null)))
1121 AND ((tlinfo.TAX_STATUS_CODE = X_TAX_STATUS_CODE)
1122 OR ((tlinfo.TAX_STATUS_CODE is null)
1123 AND (X_TAX_STATUS_CODE is null)))
1124 AND ((tlinfo.TAX_RATE_ID = X_TAX_RATE_ID)
1125 OR ((tlinfo.TAX_RATE_ID is null)
1126 AND (X_TAX_RATE_ID is null)))
1127 AND ((tlinfo.TAX_RATE_CODE = X_TAX_RATE_CODE)
1128 OR ((tlinfo.TAX_RATE_CODE is null)
1129 AND (X_TAX_RATE_CODE is null)))
1130 AND ((tlinfo.TAX_RATE = X_TAX_RATE)
1131 OR ((tlinfo.TAX_RATE is null)
1132 AND (X_TAX_RATE is null)))
1136 AND ((tlinfo.PURCHASING_CATEGORY = X_PURCHASING_CATEGORY)
1133 AND ((tlinfo.INCL_IN_TAXABLE_LINE_FLAG = X_INCL_IN_TAXABLE_LINE_FLAG)
1134 OR ((tlinfo.INCL_IN_TAXABLE_LINE_FLAG is null)
1135 AND (X_INCL_IN_TAXABLE_LINE_FLAG is null)))
1137 OR ((tlinfo.PURCHASING_CATEGORY IS NULL)
1138 AND (X_PURCHASING_CATEGORY IS NULL)))
1139 AND ((tlinfo.PURCHASING_CATEGORY_ID = X_PURCHASING_CATEGORY_ID)
1140 OR ((tlinfo.PURCHASING_CATEGORY_ID IS NULL)
1141 AND (X_PURCHASING_CATEGORY_ID IS NULL)))
1142 AND ((tlinfo.COST_FACTOR_NAME = X_COST_FACTOR_NAME)
1143 OR ((tlinfo.COST_FACTOR_NAME IS NULL)
1144 AND (X_COST_FACTOR_NAME IS NULL)))
1145 AND ((tlinfo.COST_FACTOR_ID = X_COST_FACTOR_ID)
1146 OR ((tlinfo.COST_FACTOR_ID IS NULL)
1147 AND (X_COST_FACTOR_ID IS NULL)))
1148 AND ((tlinfo.TAX_CLASSIFICATION_CODE = X_TAX_CLASSIFICATION_CODE)
1149 OR ((tlinfo.TAX_CLASSIFICATION_CODE IS NULL)
1150 AND (X_TAX_CLASSIFICATION_CODE IS NULL)))
1151 ) THEN
1152 NULL;
1153 ELSE
1154 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1155 app_exception.raise_exception;
1156 END IF;
1157 RETURN;
1158 EXCEPTION
1159 WHEN OTHERS THEN
1160 if (SQLCODE <> -20001) then
1161 IF (SQLCODE = -54) THEN
1162 FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1163 ELSE
1164 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1165 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1166 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1167 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1168 END IF;
1169 END IF;
1170 APP_EXCEPTION.RAISE_EXCEPTION;
1171 END LOCK_ROW;
1172
1173 procedure UPDATE_ROW (
1174 X_Rowid IN VARCHAR2,
1175 X_INVOICE_ID IN NUMBER,
1176 X_INVOICE_LINE_ID IN NUMBER,
1177 X_LINE_NUMBER IN NUMBER,
1178 X_LINE_TYPE_LOOKUP_CODE IN VARCHAR2,
1179 X_LINE_GROUP_NUMBER IN NUMBER,
1180 X_AMOUNT IN NUMBER,
1181 X_ACCOUNTING_DATE IN DATE,
1182 X_DESCRIPTION IN VARCHAR2,
1183 -- X_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
1184 X_PRORATE_ACROSS_FLAG IN VARCHAR2,
1185 X_TAX_CODE IN VARCHAR2,
1186 X_TAX_CODE_ID IN NUMBER,
1187 -- X_TAX_CODE_OVERRIDE_FLAG IN VARCHAR2,
1188 -- X_TAX_RECOVERY_RATE IN NUMBER,
1189 -- X_TAX_RECOVERY_OVERRIDE_FLAG IN VARCHAR2,
1190 -- X_TAX_RECOVERABLE_FLAG IN VARCHAR2,
1191 X_FINAL_MATCH_FLAG IN VARCHAR2,
1192 X_PO_HEADER_ID IN NUMBER,
1193 X_PO_LINE_ID IN NUMBER,
1194 X_PO_LINE_LOCATION_ID IN NUMBER,
1195 X_PO_DISTRIBUTION_ID IN NUMBER,
1196 X_UNIT_OF_MEAS_LOOKUP_CODE IN VARCHAR2,
1197 X_INVENTORY_ITEM_ID IN NUMBER,
1198 X_QUANTITY_INVOICED IN NUMBER,
1199 X_UNIT_PRICE IN NUMBER,
1200 X_DISTRIBUTION_SET_ID IN NUMBER,
1201 X_DIST_CODE_CONCATENATED IN VARCHAR2,
1202 X_DIST_CODE_COMBINATION_ID IN NUMBER,
1203 X_AWT_GROUP_ID IN NUMBER,
1204 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
1205 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
1206 X_ATTRIBUTE1 IN VARCHAR2,
1207 X_ATTRIBUTE2 IN VARCHAR2,
1208 X_ATTRIBUTE3 IN VARCHAR2,
1209 X_ATTRIBUTE4 IN VARCHAR2,
1210 X_ATTRIBUTE5 IN VARCHAR2,
1211 X_ATTRIBUTE6 IN VARCHAR2,
1212 X_ATTRIBUTE7 IN VARCHAR2,
1213 X_ATTRIBUTE8 IN VARCHAR2,
1214 X_ATTRIBUTE9 IN VARCHAR2,
1215 X_ATTRIBUTE10 IN VARCHAR2,
1216 X_ATTRIBUTE11 IN VARCHAR2,
1217 X_ATTRIBUTE12 IN VARCHAR2,
1218 X_ATTRIBUTE13 IN VARCHAR2,
1219 X_ATTRIBUTE14 IN VARCHAR2,
1220 X_ATTRIBUTE15 IN VARCHAR2,
1221 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1222 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1223 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1224 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1225 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1226 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1227 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1231 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1228 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1229 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1230 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1232 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1233 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1234 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1235 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1236 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1237 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1238 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1239 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1240 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1241 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
1242 X_PO_RELEASE_ID IN NUMBER,
1243 X_BALANCING_SEGMENT IN VARCHAR2,
1244 X_COST_CENTER_SEGMENT IN VARCHAR2,
1245 X_ACCOUNT_SEGMENT IN VARCHAR2,
1246 X_PROJECT_ID IN NUMBER,
1247 X_TASK_ID IN NUMBER,
1248 X_EXPENDITURE_TYPE IN VARCHAR2,
1249 X_EXPENDITURE_ITEM_DATE IN DATE,
1250 X_EXPENDITURE_ORGANIZATION_ID IN NUMBER,
1251 X_PROJECT_ACCOUNTING_CONTEXT IN VARCHAR2,
1252 X_PA_ADDITION_FLAG IN VARCHAR2,
1253 X_PA_QUANTITY IN NUMBER,
1254 X_STAT_AMOUNT IN NUMBER,
1255 X_TYPE_1099 IN VARCHAR2,
1256 X_INCOME_TAX_REGION IN VARCHAR2,
1257 X_ASSETS_TRACKING_FLAG IN VARCHAR2,
1258 X_PRICE_CORRECTION_FLAG IN VARCHAR2,
1259 -- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
1260 X_RECEIPT_NUMBER IN VARCHAR2,
1261 X_MATCH_OPTION IN VARCHAR2,
1262 X_RCV_TRANSACTION_ID IN NUMBER,
1263 X_LAST_UPDATE_DATE IN DATE,
1264 X_LAST_UPDATED_BY IN NUMBER,
1265 X_LAST_UPDATE_LOGIN IN NUMBER,
1266 X_MODE IN VARCHAR2 DEFAULT 'R',
1267 X_CALLING_SEQUENCE IN VARCHAR2,
1268 X_AWARD_ID IN NUMBER,
1269 X_price_correct_inv_num IN VARCHAR2 DEFAULT NULL,
1270 -- Invoice Lines Project Stage 1
1271 X_PRICE_CORRECT_INV_LINE_NUM IN NUMBER DEFAULT NULL,
1272 X_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
1273 X_MANUFACTURER IN VARCHAR2 DEFAULT NULL,
1274 X_MODEL_NUMBER IN VARCHAR2 DEFAULT NULL,
1275 X_WARRANTY_NUMBER IN VARCHAR2 DEFAULT NULL,
1276 X_ASSET_BOOK_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
1277 X_ASSET_CATEGORY_ID IN NUMBER DEFAULT NULL,
1278 X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
1279 X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
1280 X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
1281 X_REQUESTER_ID IN NUMBER DEFAULT NULL,
1282 X_DEFERRED_ACCTG_FLAG IN VARCHAR2 DEFAULT NULL,
1283 X_DEF_ACCTG_START_DATE IN DATE DEFAULT NULL,
1284 X_DEF_ACCTG_END_DATE IN DATE DEFAULT NULL,
1285 X_DEF_ACCTG_NUMBER_OF_PERIODS IN NUMBER DEFAULT NULL,
1286 X_DEF_ACCTG_PERIOD_TYPE IN VARCHAR2 DEFAULT NULL,
1287 -- eTax Uptake
1288 X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
1289 X_ASSESSABLE_VALUE IN NUMBER DEFAULT NULL,
1290 X_DEFAULT_DIST_CCID IN NUMBER DEFAULT NULL,
1291 X_PRIMARY_INTENDED_USE IN VARCHAR2 DEFAULT NULL,
1292 X_SHIP_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
1293 X_PRODUCT_TYPE IN VARCHAR2 DEFAULT NULL,
1294 X_PRODUCT_CATEGORY IN VARCHAR2 DEFAULT NULL,
1295 X_PRODUCT_FISC_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
1296 X_USER_DEFINED_FISC_CLASS IN VARCHAR2 DEFAULT NULL,
1297 X_TRX_BUSINESS_CATEGORY IN VARCHAR2 DEFAULT NULL,
1298 X_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
1299 X_TAX IN VARCHAR2 DEFAULT NULL,
1300 X_TAX_JURISDICTION_CODE IN VARCHAR2 DEFAULT NULL,
1301 X_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
1302 X_TAX_RATE_ID IN NUMBER DEFAULT NULL,
1303 X_TAX_RATE_CODE IN VARCHAR2 DEFAULT NULL,
1304 X_TAX_RATE IN NUMBER DEFAULT NULL,
1305 X_INCL_IN_TAXABLE_LINE_FLAG IN VARCHAR2 DEFAULT NULL,
1306 X_PURCHASING_CATEGORY IN VARCHAR2 DEFAULT NULL,
1307 X_PURCHASING_CATEGORY_ID IN NUMBER DEFAULT NULL,
1308 X_COST_FACTOR_NAME IN VARCHAR2 DEFAULT NULL,
1309 X_COST_FACTOR_ID IN NUMBER DEFAULT NULL,
1310 X_TAX_CLASSIFICATION_CODE IN VARCHAR2 DEFAULT NULL)
1311 IS
1312
1316 BEGIN
1313 current_calling_sequence VARCHAR2(2000);
1314 debug_info VARCHAR2(100);
1315
1317 -- Update the calling sequence
1318
1319 current_calling_sequence := 'AP_INVOICE_LINES_INTERFACE_PKG.Update_Row<-'
1320 ||X_Calling_Sequence;
1321
1322 debug_info := 'Update ap_invoice_lines_interface';
1323
1324 UPDATE AP_INVOICE_LINES_INTERFACE SET
1325 INVOICE_ID = X_INVOICE_ID,
1326 INVOICE_LINE_ID = X_INVOICE_LINE_ID,
1327 LINE_NUMBER = X_LINE_NUMBER,
1328 LINE_TYPE_LOOKUP_CODE = X_LINE_TYPE_LOOKUP_CODE,
1329 LINE_GROUP_NUMBER = X_LINE_GROUP_NUMBER,
1330 AMOUNT = X_AMOUNT,
1331 ACCOUNTING_DATE = X_ACCOUNTING_DATE,
1332 DESCRIPTION = X_DESCRIPTION,
1333 -- AMOUNT_INCLUDES_TAX_FLAG = X_AMOUNT_INCLUDES_TAX_FLAG,
1334 PRORATE_ACROSS_FLAG = X_PRORATE_ACROSS_FLAG,
1335 TAX_CODE = X_TAX_CODE,
1336 TAX_CODE_ID = X_TAX_CODE_ID,
1337 -- TAX_CODE_OVERRIDE_FLAG = X_TAX_CODE_OVERRIDE_FLAG,
1338 -- TAX_RECOVERY_RATE = X_TAX_RECOVERY_RATE,
1339 -- TAX_RECOVERY_OVERRIDE_FLAG = X_TAX_RECOVERY_OVERRIDE_FLAG,
1340 -- TAX_RECOVERABLE_FLAG = X_TAX_RECOVERABLE_FLAG,
1341 FINAL_MATCH_FLAG = X_FINAL_MATCH_FLAG,
1342 PO_HEADER_ID = X_PO_HEADER_ID,
1343 PO_LINE_ID = X_PO_LINE_ID,
1344 PO_LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID,
1345 PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID,
1346 UNIT_OF_MEAS_LOOKUP_CODE = X_UNIT_OF_MEAS_LOOKUP_CODE,
1347 INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
1348 QUANTITY_INVOICED = X_QUANTITY_INVOICED,
1349 UNIT_PRICE = X_UNIT_PRICE,
1350 DISTRIBUTION_SET_ID = X_DISTRIBUTION_SET_ID,
1351 DIST_CODE_CONCATENATED = X_DIST_CODE_CONCATENATED,
1352 DIST_CODE_COMBINATION_ID = X_DIST_CODE_COMBINATION_ID,
1353 AWT_GROUP_ID = X_AWT_GROUP_ID,
1354 PAY_AWT_GROUP_ID = X_PAY_AWT_GROUP_ID,--bug6639866
1355 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
1356 ATTRIBUTE1 = X_ATTRIBUTE1,
1357 ATTRIBUTE2 = X_ATTRIBUTE2,
1358 ATTRIBUTE3 = X_ATTRIBUTE3,
1359 ATTRIBUTE4 = X_ATTRIBUTE4,
1360 ATTRIBUTE5 = X_ATTRIBUTE5,
1361 ATTRIBUTE6 = X_ATTRIBUTE6,
1362 ATTRIBUTE7 = X_ATTRIBUTE7,
1363 ATTRIBUTE8 = X_ATTRIBUTE8,
1364 ATTRIBUTE9 = X_ATTRIBUTE9,
1365 ATTRIBUTE10 = X_ATTRIBUTE10,
1366 ATTRIBUTE11 = X_ATTRIBUTE11,
1367 ATTRIBUTE12 = X_ATTRIBUTE12,
1368 ATTRIBUTE13 = X_ATTRIBUTE13,
1369 ATTRIBUTE14 = X_ATTRIBUTE14,
1370 ATTRIBUTE15 = X_ATTRIBUTE15,
1371 GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY,
1372 GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1,
1373 GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2,
1374 GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3,
1375 GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4,
1376 GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5,
1377 GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6,
1378 GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
1379 GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,
1380 GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9,
1381 GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10,
1382 GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11,
1383 GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12,
1384 GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13,
1385 GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14,
1386 GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15,
1387 GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16,
1388 GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17,
1389 GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18,
1390 GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19,
1391 GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20,
1392 PO_RELEASE_ID = X_PO_RELEASE_ID,
1393 BALANCING_SEGMENT = X_BALANCING_SEGMENT,
1394 COST_CENTER_SEGMENT = X_COST_CENTER_SEGMENT,
1395 ACCOUNT_SEGMENT = X_ACCOUNT_SEGMENT,
1396 PROJECT_ID = X_PROJECT_ID,
1397 TASK_ID = X_TASK_ID,
1398 EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,
1399 EXPENDITURE_ITEM_DATE = X_EXPENDITURE_ITEM_DATE,
1400 EXPENDITURE_ORGANIZATION_ID= X_EXPENDITURE_ORGANIZATION_ID,
1401 PROJECT_ACCOUNTING_CONTEXT = X_PROJECT_ACCOUNTING_CONTEXT,
1402 PA_ADDITION_FLAG = X_PA_ADDITION_FLAG,
1403 PA_QUANTITY = X_PA_QUANTITY,
1404 STAT_AMOUNT = X_STAT_AMOUNT,
1405 TYPE_1099 = X_TYPE_1099,
1406 INCOME_TAX_REGION = X_INCOME_TAX_REGION,
1407 ASSETS_TRACKING_FLAG = X_ASSETS_TRACKING_FLAG,
1408 PRICE_CORRECTION_FLAG = X_PRICE_CORRECTION_FLAG,
1409 -- USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE, - Bug 4277744
1410 RECEIPT_NUMBER = X_RECEIPT_NUMBER,
1411 MATCH_OPTION = X_MATCH_OPTION,
1412 RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID,
1413 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1414 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1415 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1416 AWARD_ID = X_AWARD_ID,
1417 PRICE_CORRECT_INV_NUM = X_PRICE_CORRECT_INV_NUM,
1418 -- Invoice Lines Project Stage 1
1419 PRICE_CORRECT_INV_LINE_NUM = X_PRICE_CORRECT_INV_LINE_NUM,
1420 SERIAL_NUMBER = X_SERIAL_NUMBER,
1421 MANUFACTURER = X_MANUFACTURER,
1422 MODEL_NUMBER = X_MODEL_NUMBER,
1423 WARRANTY_NUMBER = X_WARRANTY_NUMBER,
1424 ASSET_BOOK_TYPE_CODE = X_ASSET_BOOK_TYPE_CODE,
1425 ASSET_CATEGORY_ID = X_ASSET_CATEGORY_ID,
1426 REQUESTER_FIRST_NAME = X_REQUESTER_FIRST_NAME,
1427 REQUESTER_LAST_NAME = X_REQUESTER_LAST_NAME,
1428 REQUESTER_EMPLOYEE_NUM = X_REQUESTER_EMPLOYEE_NUM,
1429 REQUESTER_ID = X_REQUESTER_ID,
1430 DEFERRED_ACCTG_FLAG = X_DEFERRED_ACCTG_FLAG,
1431 DEF_ACCTG_START_DATE = X_DEF_ACCTG_START_DATE,
1432 DEF_ACCTG_END_DATE = X_DEF_ACCTG_END_DATE,
1433 DEF_ACCTG_NUMBER_OF_PERIODS= X_DEF_ACCTG_NUMBER_OF_PERIODS,
1434 DEF_ACCTG_PERIOD_TYPE = X_DEF_ACCTG_PERIOD_TYPE,
1435 -- eTax Uptake
1436 CONTROL_AMOUNT = X_CONTROL_AMOUNT,
1437 ASSESSABLE_VALUE = X_ASSESSABLE_VALUE,
1438 DEFAULT_DIST_CCID = X_DEFAULT_DIST_CCID,
1439 PRIMARY_INTENDED_USE = X_PRIMARY_INTENDED_USE,
1440 SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID,
1441 PRODUCT_TYPE = X_PRODUCT_TYPE,
1442 PRODUCT_CATEGORY = X_PRODUCT_CATEGORY,
1443 PRODUCT_FISC_CLASSIFICATION = X_PRODUCT_FISC_CLASSIFICATION,
1444 USER_DEFINED_FISC_CLASS = X_USER_DEFINED_FISC_CLASS,
1445 TRX_BUSINESS_CATEGORY = X_TRX_BUSINESS_CATEGORY,
1446 TAX_REGIME_CODE = X_TAX_REGIME_CODE,
1447 TAX = X_TAX,
1448 TAX_JURISDICTION_CODE = X_TAX_JURISDICTION_CODE,
1449 TAX_STATUS_CODE = X_TAX_STATUS_CODE,
1450 TAX_RATE_ID = X_TAX_RATE_ID,
1451 TAX_RATE_CODE = X_TAX_RATE_CODE,
1452 TAX_RATE = X_TAX_RATE,
1453 INCL_IN_TAXABLE_LINE_FLAG = X_INCL_IN_TAXABLE_LINE_FLAG,
1454 PURCHASING_CATEGORY = X_PURCHASING_CATEGORY,
1455 PURCHASING_CATEGORY_ID = X_PURCHASING_CATEGORY_ID,
1456 COST_FACTOR_NAME = X_COST_FACTOR_NAME,
1457 COST_FACTOR_ID = X_COST_FACTOR_ID,
1458 TAX_CLASSIFICATION_CODE = X_TAX_CLASSIFICATION_CODE
1459 WHERE rowid = X_Rowid;
1460
1461 IF (sql%notfound) THEN
1462 Raise no_data_found;
1463 END IF;
1464 EXCEPTION
1465 WHEN OTHERS THEN
1466 IF (SQLCODE <> -20001) THEN
1467 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1468 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1469 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1470 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1471 END IF;
1472 APP_EXCEPTION.RAISE_EXCEPTION;
1473 END UPDATE_ROW;
1474
1475
1476 PROCEDURE Delete_Row(
1477 X_INVOICE_LINE_ID NUMBER,
1478 X_Calling_Sequence VARCHAR2)
1479 IS
1480 current_calling_sequence VARCHAR2(2000);
1481 debug_info VARCHAR2(100);
1482
1483 BEGIN
1484
1485 -- Update the calling sequence
1486
1487 current_calling_sequence := 'AP_INVOICE_LINES_INTERFACE_PKG.Delete_Row<-'
1488 ||X_Calling_Sequence;
1489
1490 -- Bug 2496745. Deleting the rejections for this invoice line.
1491
1492 debug_info := 'Delete from ap_interface_rejections';
1493
1494 DELETE FROM AP_INTERFACE_REJECTIONS
1495 WHERE parent_id = X_invoice_line_id
1496 AND parent_table = 'AP_INVOICE_LINES_INTERFACE';
1497
1498 debug_info := 'Delete from ap_invoice_lines_interface';
1499
1500 DELETE FROM AP_INVOICE_LINES_INTERFACE
1501 WHERE invoice_line_id = X_invoice_line_id;
1502
1503 IF (SQL%NOTFOUND) THEN
1504 Raise NO_DATA_FOUND;
1505 END IF;
1506
1507 EXCEPTION
1508 WHEN OTHERS THEN
1509 IF (SQLCODE <> -20001) THEN
1510 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1511 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1512 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1513 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1514 END IF;
1515 APP_EXCEPTION.RAISE_EXCEPTION;
1516
1517 END Delete_Row;
1518
1519 END AP_INVOICE_LINES_INTERFACE_PKG;
[Home] [Help]