[Home] [Help]
PACKAGE BODY: APPS.AP_AIL_TABLE_HANDLER_PKG
Source
1 PACKAGE BODY AP_AIL_TABLE_HANDLER_PKG as
2 /* $Header: apilnthb.pls 120.14.12020000.2 2013/02/07 10:30:46 harsanan ship $ */
3
4 -------------------------------------------------------------------
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_AIL_TABLE_HANDLER_PKG';
6 G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
7 G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
8 G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
9 G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
10 G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
11 G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
12 G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
13
14 G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15 G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16 G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
17 G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
18 G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19 G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20 G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21 G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_AIL_TABLE_HANDLER_PKG.';
22
23 PROCEDURE CHECK_UNIQUE (
24 P_ROWID VARCHAR2,
25 P_INVOICE_ID NUMBER,
26 P_LINE_NUMBER NUMBER,
27 P_CALLING_SEQUENCE VARCHAR2)
28 IS
29 dummy number := 0;
30 current_calling_sequence VARCHAR2(2000);
31 debug_info VARCHAR2(100);
32
33 BEGIN
34 -- Update the calling sequence
35
36 current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE<-'
37 ||p_Calling_Sequence;
38
39 debug_info := 'Select from ap_invoice_lines_all';
40
41 SELECT COUNT(1)
42 INTO dummy
43 FROM ap_invoice_Lines_all
44 where (invoice_id = p_INVOICE_ID AND
45 line_number = p_LINE_NUMBER)
46 AND ((p_ROWID is null) OR
47 (rowid <> p_ROWID));
48
49 IF (dummy >= 1) THEN
50 fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
51 app_exception.raise_exception;
52 END IF;
53
54 EXCEPTION
55 WHEN OTHERS THEN
56 IF (SQLCODE <> -20001) THEN
57 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60 FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61 ||', Invoice Id = '||p_INVOICE_ID
62 ||', Invoice line number = '||
63 p_line_number);
64 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
65 END IF;
66 APP_EXCEPTION.RAISE_EXCEPTION;
67 END CHECK_UNIQUE;
68
69
70 PROCEDURE Insert_Row (
71 p_ROWID IN OUT NOCOPY VARCHAR2,
72 p_INVOICE_ID NUMBER,
73 p_LINE_NUMBER NUMBER,
74 p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
75 p_LINE_GROUP_NUMBER NUMBER,
76 p_REQUESTER_ID NUMBER,
77 p_DESCRIPTION VARCHAR2,
78 p_LINE_SOURCE VARCHAR2,
79 p_ORG_ID NUMBER,
80 p_INVENTORY_ITEM_ID NUMBER,
81 p_ITEM_DESCRIPTION VARCHAR2,
82 p_SERIAL_NUMBER VARCHAR2,
83 p_MANUFACTURER VARCHAR2,
84 p_MODEL_NUMBER VARCHAR2,
85 p_WARRANTY_NUMBER VARCHAR2,
86 p_GENERATE_DISTS VARCHAR2,
87 p_MATCH_TYPE VARCHAR2,
88 p_DISTRIBUTION_SET_ID NUMBER,
89 p_ACCOUNT_SEGMENT VARCHAR2,
90 p_BALANCING_SEGMENT VARCHAR2,
91 p_COST_CENTER_SEGMENT VARCHAR2,
92 p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
93 p_DEFAULT_DIST_CCID NUMBER,
94 p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
95 p_ACCOUNTING_DATE DATE,
96 p_PERIOD_NAME VARCHAR2,
97 p_DEFERRED_ACCTG_FLAG VARCHAR2,
98 p_DEF_ACCTG_START_DATE DATE,
99 p_DEF_ACCTG_END_DATE DATE,
100 p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
101 p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
102 p_SET_OF_BOOKS_ID NUMBER,
103 p_AMOUNT NUMBER,
104 p_BASE_AMOUNT NUMBER,
105 p_ROUNDING_AMT NUMBER,
106 p_QUANTITY_INVOICED NUMBER,
107 p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
108 p_UNIT_PRICE NUMBER,
109 p_WFAPPROVAL_STATUS VARCHAR2,
110 p_DISCARDED_FLAG VARCHAR2,
111 p_ORIGINAL_AMOUNT NUMBER,
112 p_ORIGINAL_BASE_AMOUNT NUMBER,
113 p_ORIGINAL_ROUNDING_AMT NUMBER,
114 p_CANCELLED_FLAG VARCHAR2,
115 p_INCOME_TAX_REGION VARCHAR2,
116 p_TYPE_1099 VARCHAR2,
117 p_STAT_AMOUNT NUMBER,
118 p_PREPAY_INVOICE_ID NUMBER,
119 p_PREPAY_LINE_NUMBER NUMBER,
120 p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
121 p_CORRECTED_INV_ID NUMBER,
122 p_CORRECTED_LINE_NUMBER NUMBER,
123 p_PO_HEADER_ID NUMBER,
124 p_PO_LINE_ID NUMBER,
125 p_PO_RELEASE_ID NUMBER,
126 p_PO_LINE_LOCATION_ID NUMBER,
127 p_PO_DISTRIBUTION_ID NUMBER,
128 p_RCV_TRANSACTION_ID NUMBER,
129 p_FINAL_MATCH_FLAG VARCHAR2,
130 p_ASSETS_TRACKING_FLAG VARCHAR2,
131 p_ASSET_BOOK_TYPE_CODE VARCHAR2,
132 p_ASSET_CATEGORY_ID NUMBER,
133 p_PROJECT_ID NUMBER,
134 p_TASK_ID NUMBER,
135 p_EXPENDITURE_TYPE VARCHAR2,
136 p_EXPENDITURE_ITEM_DATE DATE,
137 p_EXPENDITURE_ORGANIZATION_ID NUMBER,
138 p_PA_QUANTITY NUMBER,
139 p_PA_CC_AR_INVOICE_ID NUMBER,
140 p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
141 p_PA_CC_PROCESSED_CODE VARCHAR2,
142 p_AWARD_ID NUMBER,
143 p_AWT_GROUP_ID NUMBER,
144 p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
145 p_REFERENCE_1 VARCHAR2,
146 p_REFERENCE_2 VARCHAR2,
147 p_RECEIPT_VERIFIED_FLAG VARCHAR2,
148 p_RECEIPT_REQUIRED_FLAG VARCHAR2,
149 p_RECEIPT_MISSING_FLAG VARCHAR2,
150 p_JUSTIFICATION VARCHAR2,
151 p_EXPENSE_GROUP VARCHAR2,
152 p_START_EXPENSE_DATE DATE,
153 p_END_EXPENSE_DATE DATE,
154 p_RECEIPT_CURRENCY_CODE VARCHAR2,
155 p_RECEIPT_CONVERSION_RATE NUMBER,
156 p_RECEIPT_CURRENCY_AMOUNT NUMBER,
157 p_DAILY_AMOUNT NUMBER,
158 p_WEB_PARAMETER_ID NUMBER,
159 p_ADJUSTMENT_REASON VARCHAR2,
160 p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
161 p_MERCHANT_NAME VARCHAR2,
162 p_MERCHANT_REFERENCE VARCHAR2,
163 p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
164 p_MERCHANT_TAXPAYER_ID VARCHAR2,
165 p_COUNTRY_OF_SUPPLY VARCHAR2,
166 p_CREDIT_CARD_TRX_ID NUMBER,
167 p_COMPANY_PREPAID_INVOICE_ID NUMBER,
168 p_CC_REVERSAL_FLAG VARCHAR2,
169 p_CREATION_DATE DATE,
170 p_CREATED_BY NUMBER,
171 p_LAST_UPDATED_BY NUMBER,
172 p_LAST_UPDATE_DATE DATE,
173 p_LAST_UPDATE_LOGIN NUMBER,
174 p_PROGRAM_APPLICATION_ID NUMBER,
175 p_PROGRAM_ID NUMBER,
176 p_PROGRAM_UPDATE_DATE DATE,
177 p_REQUEST_ID NUMBER,
178 p_ATTRIBUTE_CATEGORY VARCHAR2,
179 p_ATTRIBUTE1 VARCHAR2,
180 p_ATTRIBUTE2 VARCHAR2,
181 p_ATTRIBUTE3 VARCHAR2,
182 p_ATTRIBUTE4 VARCHAR2,
183 p_ATTRIBUTE5 VARCHAR2,
184 p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
185 p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
186 p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
187 p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
188 p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
189 p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
190 p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
191 p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
192 p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
193 p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
194 p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
195 p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
196 p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
197 p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
198 p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
199 p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
200 p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
201 p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
202 p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
203 p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
204 p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
205 p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
206 p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
207 p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
208 p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
209 p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
210 p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
211 p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
212 p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
213 p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
214 p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
215 --ETAX: Invwkb
216 p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
217 p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
218 p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
219 p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
220 p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
221 p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
222 p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
223 p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
224 p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
225 p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
226 p_TAX VARCHAR2 DEFAULT NULL,
227 p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
228 p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
229 p_TAX_RATE_ID NUMBER DEFAULT NULL,
230 p_TAX_RATE NUMBER DEFAULT NULL,
231 p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
232 p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
233 p_COST_FACTOR_ID NUMBER DEFAULT NULL,
234 p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
235 p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
236 p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
237 p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
238 p_Calling_Sequence VARCHAR2)
239 IS
240 current_calling_sequence VARCHAR2(2000);
241 debug_info VARCHAR2(100);
242 l_dist_match_type VARCHAR2(25);
243 CURSOR C IS
244 SELECT rowid
245 FROM AP_INVOICE_LINES_ALL
246 WHERE invoice_id = p_Invoice_Id
247 AND line_number = p_Line_Number;
248
249 BEGIN
250 -- Update the calling sequence
251
252 current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row<-'
253 ||p_Calling_Sequence;
254
255 -- Check for uniqueness of the distribution line number
256
257 AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(
258 p_Rowid,
259 p_Invoice_Id,
260 p_Line_Number,
261 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row');
262
263 -- Figure out NOCOPY the dist_match_type (not passed from invoice w/b)
264
265 IF (p_rcv_transaction_id IS NOT NULL AND
266 p_po_distribution_id IS NOT NULL) THEN
267 l_dist_match_type := 'ITEM_TO_RECEIPT';
268 ELSIF (p_rcv_transaction_id IS NOT NULL AND
269 p_po_distribution_id IS NULL) THEN
270 l_dist_match_type := 'OTHER_TO_RECEIPT';
271 ELSIF (p_rcv_transaction_id IS NULL AND
272 p_po_distribution_id IS NOT NULL) THEN
273 l_dist_match_type := 'ITEM_TO_PO';
274 ELSE
275 l_dist_match_type := NULL;
276 END IF;
277
278 debug_info := 'Insert into ap_invoice_lines_all';
279
280 INSERT INTO AP_INVOICE_LINES_ALL(
281 INVOICE_ID ,
282 LINE_NUMBER ,
283 LINE_TYPE_LOOKUP_CODE ,
284 LINE_GROUP_NUMBER ,
285 REQUESTER_ID ,
286 DESCRIPTION ,
287 LINE_SOURCE ,
288 ORG_ID ,
289 INVENTORY_ITEM_ID ,
290 ITEM_DESCRIPTION ,
291 SERIAL_NUMBER ,
292 MANUFACTURER ,
293 MODEL_NUMBER ,
294 WARRANTY_NUMBER ,
295 GENERATE_DISTS ,
296 MATCH_TYPE ,
297 DISTRIBUTION_SET_ID ,
298 ACCOUNT_SEGMENT ,
299 BALANCING_SEGMENT ,
300 COST_CENTER_SEGMENT ,
301 OVERLAY_DIST_CODE_CONCAT ,
302 DEFAULT_DIST_CCID ,
303 PRORATE_ACROSS_ALL_ITEMS ,
304 ACCOUNTING_DATE ,
305 PERIOD_NAME ,
306 DEFERRED_ACCTG_FLAG ,
307 DEF_ACCTG_START_DATE ,
308 DEF_ACCTG_END_DATE ,
309 DEF_ACCTG_NUMBER_OF_PERIODS,
310 DEF_ACCTG_PERIOD_TYPE ,
311 SET_OF_BOOKS_ID ,
312 AMOUNT ,
313 BASE_AMOUNT ,
314 ROUNDING_AMT ,
315 QUANTITY_INVOICED ,
316 UNIT_MEAS_LOOKUP_CODE ,
317 UNIT_PRICE ,
318 WFAPPROVAL_STATUS ,
319 DISCARDED_FLAG ,
320 ORIGINAL_AMOUNT ,
321 ORIGINAL_BASE_AMOUNT ,
322 ORIGINAL_ROUNDING_AMT ,
323 CANCELLED_FLAG ,
324 INCOME_TAX_REGION ,
325 TYPE_1099 ,
326 STAT_AMOUNT ,
327 PREPAY_INVOICE_ID ,
328 PREPAY_LINE_NUMBER ,
329 INVOICE_INCLUDES_PREPAY_FLAG,
330 CORRECTED_INV_ID ,
331 CORRECTED_LINE_NUMBER ,
332 PO_HEADER_ID ,
333 PO_LINE_ID ,
334 PO_RELEASE_ID ,
335 PO_LINE_LOCATION_ID ,
336 PO_DISTRIBUTION_ID ,
337 RCV_TRANSACTION_ID ,
338 FINAL_MATCH_FLAG ,
339 ASSETS_TRACKING_FLAG ,
340 ASSET_BOOK_TYPE_CODE ,
341 ASSET_CATEGORY_ID ,
342 PROJECT_ID ,
346 EXPENDITURE_ORGANIZATION_ID,
343 TASK_ID ,
344 EXPENDITURE_TYPE ,
345 EXPENDITURE_ITEM_DATE ,
347 PA_QUANTITY ,
348 PA_CC_AR_INVOICE_ID ,
349 PA_CC_AR_INVOICE_LINE_NUM,
350 PA_CC_PROCESSED_CODE ,
351 AWARD_ID ,
352 AWT_GROUP_ID ,
353 PAY_AWT_GROUP_ID ,--bug6639866
354 REFERENCE_1 ,
355 REFERENCE_2 ,
356 RECEIPT_VERIFIED_FLAG ,
357 RECEIPT_REQUIRED_FLAG ,
358 RECEIPT_MISSING_FLAG ,
359 JUSTIFICATION ,
360 EXPENSE_GROUP ,
361 START_EXPENSE_DATE ,
362 END_EXPENSE_DATE ,
363 RECEIPT_CURRENCY_CODE ,
364 RECEIPT_CONVERSION_RATE ,
365 RECEIPT_CURRENCY_AMOUNT ,
366 DAILY_AMOUNT ,
367 WEB_PARAMETER_ID ,
368 ADJUSTMENT_REASON ,
369 MERCHANT_DOCUMENT_NUMBER ,
370 MERCHANT_NAME ,
371 MERCHANT_REFERENCE ,
372 MERCHANT_TAX_REG_NUMBER ,
373 MERCHANT_TAXPAYER_ID ,
374 COUNTRY_OF_SUPPLY ,
375 CREDIT_CARD_TRX_ID ,
376 COMPANY_PREPAID_INVOICE_ID,
377 CC_REVERSAL_FLAG ,
378 CREATION_DATE ,
379 CREATED_BY ,
380 LAST_UPDATED_BY ,
381 LAST_UPDATE_DATE ,
382 LAST_UPDATE_LOGIN ,
383 PROGRAM_APPLICATION_ID ,
384 PROGRAM_ID ,
385 PROGRAM_UPDATE_DATE ,
386 REQUEST_ID ,
387 ATTRIBUTE_CATEGORY ,
388 ATTRIBUTE1 ,
389 ATTRIBUTE2 ,
390 ATTRIBUTE3 ,
391 ATTRIBUTE4 ,
392 ATTRIBUTE5 ,
393 ATTRIBUTE6 ,
394 ATTRIBUTE7 ,
395 ATTRIBUTE8 ,
396 ATTRIBUTE9 ,
397 ATTRIBUTE10 ,
398 ATTRIBUTE11 ,
399 ATTRIBUTE12 ,
400 ATTRIBUTE13 ,
401 ATTRIBUTE14 ,
402 ATTRIBUTE15 ,
403 GLOBAL_ATTRIBUTE_CATEGORY,
404 GLOBAL_ATTRIBUTE1 ,
405 GLOBAL_ATTRIBUTE2 ,
406 GLOBAL_ATTRIBUTE3 ,
407 GLOBAL_ATTRIBUTE4 ,
408 GLOBAL_ATTRIBUTE5 ,
409 GLOBAL_ATTRIBUTE6 ,
410 GLOBAL_ATTRIBUTE7 ,
411 GLOBAL_ATTRIBUTE8 ,
412 GLOBAL_ATTRIBUTE9 ,
413 GLOBAL_ATTRIBUTE10 ,
414 GLOBAL_ATTRIBUTE11 ,
415 GLOBAL_ATTRIBUTE12 ,
416 GLOBAL_ATTRIBUTE13 ,
417 GLOBAL_ATTRIBUTE14 ,
418 GLOBAL_ATTRIBUTE15 ,
419 GLOBAL_ATTRIBUTE16 ,
420 GLOBAL_ATTRIBUTE17 ,
421 GLOBAL_ATTRIBUTE18 ,
422 GLOBAL_ATTRIBUTE19 ,
423 GLOBAL_ATTRIBUTE20 ,
424 PRIMARY_INTENDED_USE ,
425 SHIP_TO_LOCATION_ID ,
426 PRODUCT_FISC_CLASSIFICATION,
427 USER_DEFINED_FISC_CLASS ,
428 TRX_BUSINESS_CATEGORY ,
429 PRODUCT_TYPE ,
430 PRODUCT_CATEGORY ,
431 ASSESSABLE_VALUE ,
432 CONTROL_AMOUNT ,
433 TAX_REGIME_CODE ,
434 TAX ,
435 TAX_STATUS_CODE ,
436 TAX_RATE_CODE ,
437 TAX_RATE_ID ,
438 TAX_RATE ,
439 TAX_JURISDICTION_CODE ,
440 PURCHASING_CATEGORY_ID ,
441 COST_FACTOR_ID ,
442 RETAINED_AMOUNT ,
443 RETAINED_AMOUNT_REMAINING,
444 RETAINED_INVOICE_ID ,
445 RETAINED_LINE_NUMBER ,
446 TAX_CLASSIFICATION_CODE
447 )
448 VALUES (
449 p_INVOICE_ID ,
450 p_LINE_NUMBER ,
451 p_LINE_TYPE_LOOKUP_CODE ,
452 p_LINE_GROUP_NUMBER ,
453 p_REQUESTER_ID ,
454 p_DESCRIPTION ,
455 p_LINE_SOURCE ,
456 p_ORG_ID ,
457 p_INVENTORY_ITEM_ID ,
458 p_ITEM_DESCRIPTION ,
459 p_SERIAL_NUMBER ,
460 p_MANUFACTURER ,
461 p_MODEL_NUMBER ,
462 p_WARRANTY_NUMBER ,
463 p_GENERATE_DISTS ,
464 p_MATCH_TYPE ,
465 p_DISTRIBUTION_SET_ID ,
466 p_ACCOUNT_SEGMENT ,
467 p_BALANCING_SEGMENT ,
468 p_COST_CENTER_SEGMENT ,
469 p_OVERLAY_DIST_CODE_CONCAT ,
470 p_DEFAULT_DIST_CCID ,
471 p_PRORATE_ACROSS_ALL_ITEMS ,
472 p_ACCOUNTING_DATE ,
473 p_PERIOD_NAME ,
474 p_DEFERRED_ACCTG_FLAG ,
475 p_DEF_ACCTG_START_DATE ,
476 p_DEF_ACCTG_END_DATE ,
477 p_DEF_ACCTG_NUMBER_OF_PERIODS,
478 p_DEF_ACCTG_PERIOD_TYPE ,
479 p_SET_OF_BOOKS_ID ,
480 p_AMOUNT ,
481 p_BASE_AMOUNT ,
482 p_ROUNDING_AMT ,
483 p_QUANTITY_INVOICED ,
484 p_UNIT_MEAS_LOOKUP_CODE ,
485 p_UNIT_PRICE ,
486 p_WFAPPROVAL_STATUS ,
490 p_ORIGINAL_ROUNDING_AMT ,
487 p_DISCARDED_FLAG ,
488 p_ORIGINAL_AMOUNT ,
489 p_ORIGINAL_BASE_AMOUNT ,
491 p_CANCELLED_FLAG ,
492 p_INCOME_TAX_REGION ,
493 p_TYPE_1099 ,
494 p_STAT_AMOUNT ,
495 p_PREPAY_INVOICE_ID ,
496 p_PREPAY_LINE_NUMBER ,
497 p_INVOICE_INCLUDES_PREPAY_FLAG,
498 p_CORRECTED_INV_ID ,
499 p_CORRECTED_LINE_NUMBER ,
500 p_PO_HEADER_ID ,
501 p_PO_LINE_ID ,
502 p_PO_RELEASE_ID ,
503 p_PO_LINE_LOCATION_ID ,
504 p_PO_DISTRIBUTION_ID ,
505 p_RCV_TRANSACTION_ID ,
506 p_FINAL_MATCH_FLAG ,
507 p_ASSETS_TRACKING_FLAG ,
508 p_ASSET_BOOK_TYPE_CODE ,
509 p_ASSET_CATEGORY_ID ,
510 p_PROJECT_ID ,
511 p_TASK_ID ,
512 p_EXPENDITURE_TYPE ,
513 p_EXPENDITURE_ITEM_DATE ,
514 p_EXPENDITURE_ORGANIZATION_ID,
515 p_PA_QUANTITY ,
516 p_PA_CC_AR_INVOICE_ID ,
517 p_PA_CC_AR_INVOICE_LINE_NUM,
518 p_PA_CC_PROCESSED_CODE ,
519 p_AWARD_ID ,
520 p_AWT_GROUP_ID ,
521 p_PAY_AWT_GROUP_ID ,--bug6639866
522 p_REFERENCE_1 ,
523 p_REFERENCE_2 ,
524 p_RECEIPT_VERIFIED_FLAG ,
525 p_RECEIPT_REQUIRED_FLAG ,
526 p_RECEIPT_MISSING_FLAG ,
527 p_JUSTIFICATION ,
528 p_EXPENSE_GROUP ,
529 p_START_EXPENSE_DATE ,
530 p_END_EXPENSE_DATE ,
531 p_RECEIPT_CURRENCY_CODE ,
532 p_RECEIPT_CONVERSION_RATE ,
533 p_RECEIPT_CURRENCY_AMOUNT ,
534 p_DAILY_AMOUNT ,
535 p_WEB_PARAMETER_ID ,
536 p_ADJUSTMENT_REASON ,
537 p_MERCHANT_DOCUMENT_NUMBER ,
538 p_MERCHANT_NAME ,
539 p_MERCHANT_REFERENCE ,
540 p_MERCHANT_TAX_REG_NUMBER ,
541 p_MERCHANT_TAXPAYER_ID ,
542 p_COUNTRY_OF_SUPPLY ,
543 p_CREDIT_CARD_TRX_ID ,
544 p_COMPANY_PREPAID_INVOICE_ID,
545 p_CC_REVERSAL_FLAG ,
546 p_CREATION_DATE ,
547 p_CREATED_BY ,
548 p_LAST_UPDATED_BY ,
549 p_LAST_UPDATE_DATE ,
550 p_LAST_UPDATE_LOGIN ,
551 p_PROGRAM_APPLICATION_ID ,
552 p_PROGRAM_ID ,
553 p_PROGRAM_UPDATE_DATE ,
554 p_REQUEST_ID ,
555 p_ATTRIBUTE_CATEGORY ,
556 p_ATTRIBUTE1 ,
557 p_ATTRIBUTE2 ,
558 p_ATTRIBUTE3 ,
559 p_ATTRIBUTE4 ,
560 p_ATTRIBUTE5 ,
561 p_ATTRIBUTE6 ,
562 p_ATTRIBUTE7 ,
563 p_ATTRIBUTE8 ,
564 p_ATTRIBUTE9 ,
565 p_ATTRIBUTE10 ,
566 p_ATTRIBUTE11 ,
567 p_ATTRIBUTE12 ,
568 p_ATTRIBUTE13 ,
569 p_ATTRIBUTE14 ,
570 p_ATTRIBUTE15 ,
571 p_GLOBAL_ATTRIBUTE_CATEGORY,
572 p_GLOBAL_ATTRIBUTE1 ,
573 p_GLOBAL_ATTRIBUTE2 ,
574 p_GLOBAL_ATTRIBUTE3 ,
575 p_GLOBAL_ATTRIBUTE4 ,
576 p_GLOBAL_ATTRIBUTE5 ,
577 p_GLOBAL_ATTRIBUTE6 ,
578 p_GLOBAL_ATTRIBUTE7 ,
579 p_GLOBAL_ATTRIBUTE8 ,
580 p_GLOBAL_ATTRIBUTE9 ,
581 p_GLOBAL_ATTRIBUTE10 ,
582 p_GLOBAL_ATTRIBUTE11 ,
583 p_GLOBAL_ATTRIBUTE12 ,
584 p_GLOBAL_ATTRIBUTE13 ,
585 p_GLOBAL_ATTRIBUTE14 ,
586 p_GLOBAL_ATTRIBUTE15 ,
587 p_GLOBAL_ATTRIBUTE16 ,
588 p_GLOBAL_ATTRIBUTE17 ,
589 p_GLOBAL_ATTRIBUTE18 ,
590 p_GLOBAL_ATTRIBUTE19 ,
591 p_GLOBAL_ATTRIBUTE20 ,
592 p_PRIMARY_INTENDED_USE ,
593 p_SHIP_TO_LOCATION_ID ,
594 p_PRODUCT_FISC_CLASSIFICATION,
595 p_USER_DEFINED_FISC_CLASS ,
596 p_TRX_BUSINESS_CATEGORY ,
597 p_PRODUCT_TYPE ,
598 p_PRODUCT_CATEGORY ,
599 p_ASSESSABLE_VALUE ,
600 p_CONTROL_AMOUNT ,
601 p_TAX_REGIME_CODE ,
602 p_TAX ,
603 p_TAX_STATUS_CODE ,
604 p_TAX_RATE_CODE ,
605 p_TAX_RATE_ID ,
606 p_TAX_RATE ,
607 p_TAX_JURISDICTION_CODE ,
608 p_PURCHASING_CATEGORY_ID ,
609 p_COST_FACTOR_ID ,
610 p_RETAINED_AMOUNT ,
611 -(p_RETAINED_AMOUNT) ,
612 p_RETAINED_INVOICE_ID ,
613 p_RETAINED_LINE_NUMBER ,
614 p_TAX_CLASSIFICATION_CODE );
615
616 debug_info := 'Open cursor C';
617 OPEN C;
618 debug_info := 'Fetch cursor C';
619 FETCH C INTO p_Rowid;
620 IF (C%NOTFOUND) THEN
621 debug_info := 'Close cursor C - ROW NOTFOUND';
622 CLOSE C;
623 Raise NO_DATA_FOUND;
624 END IF;
625 debug_info := 'Close cursor C';
626 CLOSE C;
627
628 EXCEPTION
629 WHEN OTHERS THEN
633 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
630 IF (SQLCODE <> -20001) THEN
631 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
634 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635 END IF;
636 APP_EXCEPTION.RAISE_EXCEPTION;
637
638 END Insert_Row;
639
640
641 PROCEDURE Lock_Row(
642 p_ROWID VARCHAR2,
643 p_INVOICE_ID NUMBER,
644 p_LINE_NUMBER NUMBER,
645 p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
646 p_LINE_GROUP_NUMBER NUMBER,
647 p_REQUESTER_ID NUMBER,
648 p_DESCRIPTION VARCHAR2,
649 p_LINE_SOURCE VARCHAR2,
650 p_ORG_ID NUMBER,
651 p_INVENTORY_ITEM_ID NUMBER,
652 p_ITEM_DESCRIPTION VARCHAR2,
653 p_SERIAL_NUMBER VARCHAR2,
654 p_MANUFACTURER VARCHAR2,
655 p_MODEL_NUMBER VARCHAR2,
656 p_WARRANTY_NUMBER VARCHAR2,
657 p_GENERATE_DISTS VARCHAR2,
658 p_MATCH_TYPE VARCHAR2,
659 p_DISTRIBUTION_SET_ID NUMBER,
660 p_ACCOUNT_SEGMENT VARCHAR2,
661 p_BALANCING_SEGMENT VARCHAR2,
662 p_COST_CENTER_SEGMENT VARCHAR2,
663 p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
664 p_DEFAULT_DIST_CCID NUMBER,
665 p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
666 p_ACCOUNTING_DATE DATE,
667 p_PERIOD_NAME VARCHAR2,
668 p_DEFERRED_ACCTG_FLAG VARCHAR2,
669 p_DEF_ACCTG_START_DATE DATE,
670 p_DEF_ACCTG_END_DATE DATE,
671 p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
672 p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
673 p_SET_OF_BOOKS_ID NUMBER,
674 p_AMOUNT NUMBER,
675 p_BASE_AMOUNT NUMBER,
676 p_ROUNDING_AMT NUMBER,
677 p_QUANTITY_INVOICED NUMBER,
678 p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
679 p_UNIT_PRICE NUMBER,
680 p_WFAPPROVAL_STATUS VARCHAR2,
681 p_DISCARDED_FLAG VARCHAR2,
682 p_ORIGINAL_AMOUNT NUMBER,
683 p_ORIGINAL_BASE_AMOUNT NUMBER,
684 p_ORIGINAL_ROUNDING_AMT NUMBER,
685 p_CANCELLED_FLAG VARCHAR2,
686 p_INCOME_TAX_REGION VARCHAR2,
687 p_TYPE_1099 VARCHAR2,
688 p_STAT_AMOUNT NUMBER,
689 p_PREPAY_INVOICE_ID NUMBER,
690 p_PREPAY_LINE_NUMBER NUMBER,
691 p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
692 p_CORRECTED_INV_ID NUMBER,
693 p_CORRECTED_LINE_NUMBER NUMBER,
694 p_PO_HEADER_ID NUMBER,
695 p_PO_LINE_ID NUMBER,
696 p_PO_RELEASE_ID NUMBER,
697 p_PO_LINE_LOCATION_ID NUMBER,
698 p_PO_DISTRIBUTION_ID NUMBER,
699 p_RCV_TRANSACTION_ID NUMBER,
700 p_FINAL_MATCH_FLAG VARCHAR2,
701 p_ASSETS_TRACKING_FLAG VARCHAR2,
702 p_ASSET_BOOK_TYPE_CODE VARCHAR2,
703 p_ASSET_CATEGORY_ID NUMBER,
704 p_PROJECT_ID NUMBER,
705 p_TASK_ID NUMBER,
706 p_EXPENDITURE_TYPE VARCHAR2,
707 p_EXPENDITURE_ITEM_DATE DATE,
708 p_EXPENDITURE_ORGANIZATION_ID NUMBER,
709 p_PA_QUANTITY NUMBER,
710 p_PA_CC_AR_INVOICE_ID NUMBER,
711 p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
712 p_PA_CC_PROCESSED_CODE VARCHAR2,
713 p_AWARD_ID NUMBER,
714 p_AWT_GROUP_ID NUMBER,
715 p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
716 p_REFERENCE_1 VARCHAR2,
717 p_REFERENCE_2 VARCHAR2,
718 p_RECEIPT_VERIFIED_FLAG VARCHAR2,
719 p_RECEIPT_REQUIRED_FLAG VARCHAR2,
720 p_RECEIPT_MISSING_FLAG VARCHAR2,
721 p_JUSTIFICATION VARCHAR2,
722 p_EXPENSE_GROUP VARCHAR2,
723 p_START_EXPENSE_DATE DATE,
724 p_END_EXPENSE_DATE DATE,
725 p_RECEIPT_CURRENCY_CODE VARCHAR2,
726 p_RECEIPT_CONVERSION_RATE NUMBER,
727 p_RECEIPT_CURRENCY_AMOUNT NUMBER,
728 p_DAILY_AMOUNT NUMBER,
729 p_WEB_PARAMETER_ID NUMBER,
730 p_ADJUSTMENT_REASON VARCHAR2,
731 p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
732 p_MERCHANT_NAME VARCHAR2,
733 p_MERCHANT_REFERENCE VARCHAR2,
734 p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
735 p_MERCHANT_TAXPAYER_ID VARCHAR2,
736 p_COUNTRY_OF_SUPPLY VARCHAR2,
737 p_CREDIT_CARD_TRX_ID NUMBER,
738 p_COMPANY_PREPAID_INVOICE_ID NUMBER,
739 p_CC_REVERSAL_FLAG VARCHAR2,
740 p_CREATION_DATE DATE,
744 p_LAST_UPDATE_LOGIN NUMBER,
741 p_CREATED_BY NUMBER,
742 p_LAST_UPDATED_BY NUMBER,
743 p_LAST_UPDATE_DATE DATE,
745 p_PROGRAM_APPLICATION_ID NUMBER,
746 p_PROGRAM_ID NUMBER,
747 p_PROGRAM_UPDATE_DATE DATE,
748 p_REQUEST_ID NUMBER,
749 p_ATTRIBUTE_CATEGORY VARCHAR2,
750 p_ATTRIBUTE1 VARCHAR2,
751 p_ATTRIBUTE2 VARCHAR2,
752 p_ATTRIBUTE3 VARCHAR2,
753 p_ATTRIBUTE4 VARCHAR2,
754 p_ATTRIBUTE5 VARCHAR2,
755 p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
756 p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
757 p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
758 p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
759 p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
760 p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
761 p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
762 p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
763 p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
764 p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
765 p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
766 p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
767 p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
768 p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
769 p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
770 p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
771 p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
772 p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
773 p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
774 p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
775 p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
776 p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
777 p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
778 p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
779 p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
780 p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
781 p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
782 p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
783 p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
784 p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
785 p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
786 p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
787 p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
788 p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
789 p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
790 p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
791 p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
792 p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
793 p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
794 p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
795 p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
796 p_TAX VARCHAR2 DEFAULT NULL,
797 p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
798 p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
799 p_TAX_RATE_ID NUMBER DEFAULT NULL,
800 p_TAX_RATE NUMBER DEFAULT NULL,
801 p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
802 p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
803 p_COST_FACTOR_ID NUMBER DEFAULT NULL,
804 p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
805 p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
806 p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
807 p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
808 p_Calling_Sequence VARCHAR2)
809 IS
810 current_calling_sequence VARCHAR2(2000);
811 debug_info VARCHAR2(100);
812 CURSOR C IS
813 SELECT
814 INVOICE_ID ,
815 LINE_NUMBER ,
816 LINE_TYPE_LOOKUP_CODE ,
817 LINE_GROUP_NUMBER ,
818 REQUESTER_ID ,
819 DESCRIPTION ,
820 LINE_SOURCE ,
821 ORG_ID ,
822 INVENTORY_ITEM_ID ,
823 ITEM_DESCRIPTION ,
824 SERIAL_NUMBER ,
825 MANUFACTURER ,
826 MODEL_NUMBER ,
827 WARRANTY_NUMBER ,
828 GENERATE_DISTS ,
829 MATCH_TYPE ,
830 DISTRIBUTION_SET_ID ,
831 ACCOUNT_SEGMENT ,
832 BALANCING_SEGMENT ,
833 COST_CENTER_SEGMENT ,
834 OVERLAY_DIST_CODE_CONCAT ,
835 DEFAULT_DIST_CCID ,
836 PRORATE_ACROSS_ALL_ITEMS ,
837 ACCOUNTING_DATE ,
838 PERIOD_NAME ,
839 DEFERRED_ACCTG_FLAG ,
840 DEF_ACCTG_START_DATE ,
841 DEF_ACCTG_END_DATE ,
842 DEF_ACCTG_NUMBER_OF_PERIODS,
843 DEF_ACCTG_PERIOD_TYPE ,
844 SET_OF_BOOKS_ID ,
845 AMOUNT ,
846 BASE_AMOUNT ,
847 ROUNDING_AMT ,
848 QUANTITY_INVOICED ,
849 UNIT_MEAS_LOOKUP_CODE ,
850 UNIT_PRICE ,
854 ORIGINAL_BASE_AMOUNT ,
851 WFAPPROVAL_STATUS ,
852 DISCARDED_FLAG ,
853 ORIGINAL_AMOUNT ,
855 ORIGINAL_ROUNDING_AMT ,
856 CANCELLED_FLAG ,
857 INCOME_TAX_REGION ,
858 TYPE_1099 ,
859 STAT_AMOUNT ,
860 PREPAY_INVOICE_ID ,
861 PREPAY_LINE_NUMBER ,
862 INVOICE_INCLUDES_PREPAY_FLAG,
863 CORRECTED_INV_ID ,
864 CORRECTED_LINE_NUMBER ,
865 PO_HEADER_ID ,
866 PO_LINE_ID ,
867 PO_RELEASE_ID ,
868 PO_LINE_LOCATION_ID ,
869 PO_DISTRIBUTION_ID ,
870 RCV_TRANSACTION_ID ,
871 FINAL_MATCH_FLAG ,
872 ASSETS_TRACKING_FLAG ,
873 ASSET_BOOK_TYPE_CODE ,
874 ASSET_CATEGORY_ID ,
875 PROJECT_ID ,
876 TASK_ID ,
877 EXPENDITURE_TYPE ,
878 EXPENDITURE_ITEM_DATE ,
879 EXPENDITURE_ORGANIZATION_ID,
880 PA_QUANTITY ,
881 PA_CC_AR_INVOICE_ID ,
882 PA_CC_AR_INVOICE_LINE_NUM,
883 PA_CC_PROCESSED_CODE ,
884 AWARD_ID ,
885 AWT_GROUP_ID ,
886 PAY_AWT_GROUP_ID ,--bug6639866
887 REFERENCE_1 ,
888 REFERENCE_2 ,
889 RECEIPT_VERIFIED_FLAG ,
890 RECEIPT_REQUIRED_FLAG ,
891 RECEIPT_MISSING_FLAG ,
892 JUSTIFICATION ,
893 EXPENSE_GROUP ,
894 START_EXPENSE_DATE ,
895 END_EXPENSE_DATE ,
896 RECEIPT_CURRENCY_CODE ,
897 RECEIPT_CONVERSION_RATE ,
898 RECEIPT_CURRENCY_AMOUNT ,
899 DAILY_AMOUNT ,
900 WEB_PARAMETER_ID ,
901 ADJUSTMENT_REASON ,
902 MERCHANT_DOCUMENT_NUMBER ,
903 MERCHANT_NAME ,
904 MERCHANT_REFERENCE ,
905 MERCHANT_TAX_REG_NUMBER ,
906 MERCHANT_TAXPAYER_ID ,
907 COUNTRY_OF_SUPPLY ,
908 CREDIT_CARD_TRX_ID ,
909 COMPANY_PREPAID_INVOICE_ID,
910 CC_REVERSAL_FLAG ,
911 CREATION_DATE ,
912 CREATED_BY ,
913 LAST_UPDATED_BY ,
914 LAST_UPDATE_DATE ,
915 LAST_UPDATE_LOGIN ,
916 PROGRAM_APPLICATION_ID ,
917 PROGRAM_ID ,
918 TRUNC(PROGRAM_UPDATE_DATE) PROGRAM_UPDATE_DATE, --BUG 16282205
919 REQUEST_ID ,
920 ATTRIBUTE_CATEGORY ,
921 ATTRIBUTE1 ,
922 ATTRIBUTE2 ,
923 ATTRIBUTE3 ,
924 ATTRIBUTE4 ,
925 ATTRIBUTE5 ,
926 ATTRIBUTE6 ,
927 ATTRIBUTE7 ,
928 ATTRIBUTE8 ,
929 ATTRIBUTE9 ,
930 ATTRIBUTE10 ,
931 ATTRIBUTE11 ,
932 ATTRIBUTE12 ,
933 ATTRIBUTE13 ,
934 ATTRIBUTE14 ,
935 ATTRIBUTE15 ,
936 GLOBAL_ATTRIBUTE_CATEGORY,
937 GLOBAL_ATTRIBUTE1 ,
938 GLOBAL_ATTRIBUTE2 ,
939 GLOBAL_ATTRIBUTE3 ,
940 GLOBAL_ATTRIBUTE4 ,
941 GLOBAL_ATTRIBUTE5 ,
942 GLOBAL_ATTRIBUTE6 ,
943 GLOBAL_ATTRIBUTE7 ,
944 GLOBAL_ATTRIBUTE8 ,
945 GLOBAL_ATTRIBUTE9 ,
946 GLOBAL_ATTRIBUTE10 ,
947 GLOBAL_ATTRIBUTE11 ,
948 GLOBAL_ATTRIBUTE12 ,
949 GLOBAL_ATTRIBUTE13 ,
950 GLOBAL_ATTRIBUTE14 ,
951 GLOBAL_ATTRIBUTE15 ,
952 GLOBAL_ATTRIBUTE16 ,
953 GLOBAL_ATTRIBUTE17 ,
954 GLOBAL_ATTRIBUTE18 ,
955 GLOBAL_ATTRIBUTE19 ,
956 GLOBAL_ATTRIBUTE20 ,
957 PRIMARY_INTENDED_USE ,
958 SHIP_TO_LOCATION_ID ,
959 PRODUCT_FISC_CLASSIFICATION,
960 USER_DEFINED_FISC_CLASS ,
961 TRX_BUSINESS_CATEGORY ,
962 PRODUCT_TYPE ,
963 PRODUCT_CATEGORY ,
964 ASSESSABLE_VALUE ,
965 CONTROL_AMOUNT ,
966 TAX_REGIME_CODE ,
967 TAX ,
968 TAX_STATUS_CODE ,
969 TAX_RATE_CODE ,
970 TAX_RATE_ID ,
971 TAX_RATE ,
972 TAX_JURISDICTION_CODE ,
973 PURCHASING_CATEGORY_ID ,
974 COST_FACTOR_ID ,
975 RETAINED_AMOUNT ,
976 RETAINED_INVOICE_ID ,
977 RETAINED_LINE_NUMBER ,
978 TAX_CLASSIFICATION_CODE
979 FROM AP_INVOICE_LINES_ALL
980 WHERE rowid = P_Rowid
981 FOR UPDATE of Invoice_Id NOWAIT;
982 Recinfo C%ROWTYPE;
983
984 BEGIN
985
986 -- Update the calling sequence
987 --
988 current_calling_sequence := 'AP_INVOICE_LINES_PKG.Lock_Row<-'
989 ||P_Calling_Sequence;
990
991 debug_info := 'Select from ap_invoice_lines_all';
992 OPEN C;
993
994 debug_info := 'Fetch cursor C';
995 FETCH C INTO Recinfo;
996 IF (C%NOTFOUND) THEN
997 debug_info := 'Close cursor C - ROW NOTFOUND';
1001 END IF;
998 CLOSE C;
999 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1000 APP_EXCEPTION.Raise_Exception;
1002 debug_info := 'Close cursor C';
1003 CLOSE C;
1004 IF ( (Recinfo.invoice_id = P_Invoice_Id)
1005 AND (Recinfo.line_number = P_Line_Number)
1006 AND (Recinfo.accounting_date = P_Accounting_Date)
1007 AND (Recinfo.wfapproval_status = P_Wfapproval_Status)
1008 AND (Recinfo.amount = P_Amount)
1009 AND (Recinfo.org_id = P_org_id)
1010 AND (Recinfo.set_of_books_id = P_Set_Of_Books_Id)
1011 AND ( (Recinfo.type_1099 = P_Type_1099)
1012 OR ( (Recinfo.type_1099 IS NULL)
1013 AND (P_Type_1099 IS NULL)))
1014 AND ( (Recinfo.quantity_invoiced = P_Quantity_Invoiced)
1015 OR ( (Recinfo.quantity_invoiced IS NULL)
1016 AND (P_Quantity_Invoiced IS NULL)))
1017 AND ( (Recinfo.unit_price = P_Unit_Price)
1018 OR ( (Recinfo.unit_price IS NULL)
1019 AND (P_Unit_Price IS NULL)))
1020 AND ( (Recinfo.attribute_category = P_Attribute_Category)
1021 OR ( (Recinfo.attribute_category IS NULL)
1022 AND (P_Attribute_Category IS NULL)))
1023 AND ( (Recinfo.attribute1 = P_Attribute1)
1027 OR ( (Recinfo.attribute2 IS NULL)
1024 OR ( (Recinfo.attribute1 IS NULL)
1025 AND (P_Attribute1 IS NULL)))
1026 AND ( (Recinfo.attribute2 = P_Attribute2)
1028 AND (P_Attribute2 IS NULL)))
1029 AND ( (Recinfo.attribute3 = P_Attribute3)
1030 OR ( (Recinfo.attribute3 IS NULL)
1031 AND (P_Attribute3 IS NULL)))
1032 AND ( (Recinfo.attribute4 = P_Attribute4)
1033 OR ( (Recinfo.attribute4 IS NULL)
1034 AND (P_Attribute4 IS NULL)))
1035 AND ( (Recinfo.attribute5 = P_Attribute5)
1036 OR ( (Recinfo.attribute5 IS NULL)
1037 AND (P_Attribute5 IS NULL)))
1038 AND ( (Recinfo.PO_HEADER_ID = P_PO_HEADER_ID)
1039 OR ( (Recinfo.PO_HEADER_ID IS NULL)
1040 AND (P_PO_HEADER_ID IS NULL)))
1041 AND ( (Recinfo.PO_LINE_ID = P_PO_LINE_ID)
1042 OR ( (Recinfo.PO_LINE_ID IS NULL)
1043 AND (P_PO_LINE_ID IS NULL)))
1044 AND ( (Recinfo.PO_RELEASE_ID = P_PO_RELEASE_ID)
1045 OR ( (Recinfo.PO_RELEASE_ID IS NULL)
1046 AND (P_PO_RELEASE_ID IS NULL)))
1047 AND ( (Recinfo.PO_LINE_LOCATION_ID = P_PO_LINE_LOCATION_ID)
1048 OR ( (Recinfo.PO_LINE_LOCATION_ID IS NULL)
1049 AND (P_PO_LINE_LOCATION_ID IS NULL)))
1050 AND ( (Recinfo.PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID)
1051 OR ( (Recinfo.PO_DISTRIBUTION_ID IS NULL)
1052 AND (P_PO_DISTRIBUTION_ID IS NULL)))
1053 AND ( (Recinfo.RCV_TRANSACTION_ID = P_RCV_TRANSACTION_ID)
1054 OR ( (Recinfo.RCV_TRANSACTION_ID IS NULL)
1055 AND (P_RCV_TRANSACTION_ID IS NULL)))
1056 AND ( (Recinfo.base_amount = P_Base_Amount)
1057 OR ( (Recinfo.base_amount IS NULL)
1058 AND (P_Base_Amount IS NULL)))
1059 AND ( (Recinfo.stat_amount = P_Stat_Amount)
1060 OR ( (Recinfo.stat_amount IS NULL)
1061 AND (P_Stat_Amount IS NULL)))
1062 AND ( (Recinfo.attribute11 = P_Attribute11)
1063 OR ( (Recinfo.attribute11 IS NULL)
1064 AND (P_Attribute11 IS NULL)))
1065 AND ( (Recinfo.attribute12 = P_Attribute12)
1066 OR ( (Recinfo.attribute12 IS NULL)
1067 AND (P_Attribute12 IS NULL)))
1068 AND ( (Recinfo.attribute13 = P_Attribute13)
1069 OR ( (Recinfo.attribute13 IS NULL)
1070 AND (P_Attribute13 IS NULL)))) THEN
1071 NULL;
1072 ELSE
1073 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1074 APP_EXCEPTION.Raise_Exception;
1075 END IF;
1076 IF (
1077 ( (Recinfo.attribute14 = P_Attribute14)
1078 OR ( (Recinfo.attribute14 IS NULL)
1079 AND (P_Attribute14 IS NULL)))
1080 AND ( (Recinfo.attribute6 = P_Attribute6)
1081 OR ( (Recinfo.attribute6 IS NULL)
1082 AND (P_Attribute6 IS NULL)))
1083 AND ( (Recinfo.attribute7 = P_Attribute7)
1084 OR ( (Recinfo.attribute7 IS NULL)
1085 AND (P_Attribute7 IS NULL)))
1086 AND ( (Recinfo.attribute8 = P_Attribute8)
1087 OR ( (Recinfo.attribute8 IS NULL)
1091 AND (P_Attribute9 IS NULL)))
1088 AND (P_Attribute8 IS NULL)))
1089 AND ( (Recinfo.attribute9 = P_Attribute9)
1090 OR ( (Recinfo.attribute9 IS NULL)
1092 AND ( (Recinfo.attribute10 = P_Attribute10)
1093 OR ( (Recinfo.attribute10 IS NULL)
1094 AND (P_Attribute10 IS NULL)))
1095 AND ( (Recinfo.attribute15 = P_Attribute15)
1096 OR ( (Recinfo.attribute15 IS NULL)
1097 AND (P_Attribute15 IS NULL)))
1098 AND ( (Recinfo.income_tax_region = P_Income_Tax_Region)
1099 OR ( (Recinfo.income_tax_region IS NULL)
1100 AND (P_Income_Tax_Region IS NULL)))
1101 AND ( (Recinfo.final_match_flag = P_Final_Match_Flag)
1102 OR ( (Recinfo.final_match_flag IS NULL)
1103 AND (P_Final_Match_Flag IS NULL)))
1104 AND ( (Recinfo.assets_tracking_flag = P_assets_tracking_flag)
1105 OR ( (Recinfo.assets_tracking_flag IS NULL)
1106 AND (P_assets_tracking_Flag IS NULL)))
1107 AND ( (Recinfo.asset_book_type_code = P_asset_book_type_code)
1108 OR ( (Recinfo.asset_book_type_code IS NULL)
1109 AND (P_asset_book_type_code IS NULL)))
1110 AND ( (Recinfo.asset_category_id = P_asset_category_id)
1111 OR ( (Recinfo.asset_category_id IS NULL)
1112 AND (P_asset_category_id IS NULL)))
1113 AND ( (Recinfo.expenditure_item_date = P_Expenditure_Item_Date)
1114 OR ( (Recinfo.expenditure_item_date IS NULL)
1115 AND (P_Expenditure_Item_Date IS NULL)))
1116 AND ( (Recinfo.expenditure_organization_id
1117 = P_Expenditure_Organization_Id)
1118 OR ( (Recinfo.expenditure_organization_id IS NULL)
1119 AND (P_Expenditure_Organization_Id IS NULL)))
1120 AND ( (Recinfo.expenditure_type = P_Expenditure_Type)
1121 OR ( (Recinfo.expenditure_type IS NULL)
1122 AND (P_Expenditure_Type IS NULL)))
1123 AND ( (Recinfo.project_id = P_Project_Id)
1124 OR ( (Recinfo.project_id IS NULL)
1125 AND (P_Project_Id IS NULL)))
1126 AND ( (Recinfo.task_id = P_Task_Id)
1127 OR ( (Recinfo.task_id IS NULL)
1128 AND (P_Task_Id IS NULL)))
1129 AND ( (Recinfo.pa_quantity = P_Pa_Quantity)
1130 OR ( (Recinfo.pa_quantity IS NULL)
1131 AND (P_Pa_Quantity IS NULL)))
1132 AND ( (Recinfo.awt_group_id = P_Awt_Group_Id)
1133 OR ( (Recinfo.awt_group_id IS NULL)
1134 AND (P_Awt_Group_Id IS NULL)))
1135 AND ( (Recinfo.pay_awt_group_id = P_Pay_Awt_Group_Id)
1136 OR ( (Recinfo.pay_awt_group_id IS NULL)
1137 AND (P_Pay_Awt_Group_Id IS NULL))) --bug6639866
1138 AND ( (Recinfo.reference_1 = P_Reference_1)
1139 OR ( (Recinfo.reference_1 IS NULL)
1140 AND (P_Reference_1 IS NULL)))
1141 AND ( (Recinfo.reference_2 = P_Reference_2)
1142 OR ( (Recinfo.reference_2 IS NULL)
1143 AND (P_Reference_2 IS NULL)))
1144 AND ( (Recinfo.program_application_id = P_Program_Application_Id)
1145 OR ( (Recinfo.program_application_id IS NULL)
1146 AND (P_Program_Application_id IS NULL)))
1147 AND ( (Recinfo.program_id = P_Program_Id)
1148 OR ( (Recinfo.program_id IS NULL)
1149 AND (P_Program_Id IS NULL)))
1150 AND ( (Recinfo.program_update_date = TRUNC(P_Program_Update_Date)) -- BUG 16282205
1151 OR ( (Recinfo.program_update_date IS NULL)
1152 AND (P_Program_Update_Date IS NULL)))
1153 AND ( (Recinfo.request_id = P_Request_Id)
1154 OR ( (Recinfo.request_id IS NULL)
1155 AND (P_Request_Id IS NULL)))
1156 AND ( (Recinfo.award_id = P_Award_Id)
1157 OR ( (Recinfo.award_id IS NULL)
1158 AND (P_Award_Id IS NULL)))
1159 AND ( (Recinfo.Expense_Group = P_Expense_Group)
1160 OR ( (Recinfo.Expense_Group IS NULL)
1161 AND (P_Expense_Group IS NULL)))
1162 AND ( (Recinfo.start_expense_date = P_Start_Expense_Date)
1163 OR ( (Recinfo.start_expense_date IS NULL)
1164 AND (P_Start_Expense_Date IS NULL)))
1165 AND ( (Recinfo.End_Expense_Date = P_End_Expense_Date)
1166 OR ( (Recinfo.End_Expense_Date IS NULL)
1167 AND (P_End_Expense_Date IS NULL)))
1168 AND ( (Recinfo.merchant_document_number
1169 = P_Merchant_Document_Number)
1170 OR ( (Recinfo.merchant_document_number IS NULL)
1171 AND (P_Merchant_Document_Number IS NULL)))
1172 AND ( (Recinfo.merchant_name = P_Merchant_Name)
1173 OR ( (Recinfo.merchant_name IS NULL)
1174 AND (P_Merchant_Name IS NULL)))
1175 AND ( (Recinfo.merchant_tax_reg_number
1176 = P_Merchant_Tax_Reg_Number)
1177 OR ( (Recinfo.merchant_tax_reg_number IS NULL)
1178 AND (P_Merchant_Tax_Reg_Number IS NULL)))
1179 AND ( (Recinfo.merchant_taxpayer_id = P_Merchant_Taxpayer_Id)
1180 OR ( (Recinfo.merchant_taxpayer_id IS NULL)
1181 AND (P_Merchant_Taxpayer_Id IS NULL)))
1182 AND ( (Recinfo.merchant_reference = P_Merchant_Reference)
1183 OR ( (Recinfo.merchant_reference IS NULL)
1184 AND (P_Merchant_Reference IS NULL)))
1188 NULL;
1185 AND ( (Recinfo.country_of_supply = P_Country_Of_Supply)
1186 OR ( (Recinfo.country_of_supply IS NULL)
1187 AND (P_Country_Of_Supply IS NULL)))) THEN
1189 ELSE
1190 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1191 APP_EXCEPTION.Raise_Exception;
1192 END IF;
1193 IF (
1194 ( (Recinfo.global_attribute_category =
1195 P_global_attribute_category)
1196 OR ( (Recinfo.global_attribute_category IS NULL)
1197 AND (P_global_attribute_category IS NULL)))
1198 AND ( (Recinfo.global_attribute1 = P_global_attribute1)
1199 OR ( (Recinfo.global_attribute1 IS NULL)
1200 AND (P_global_attribute1 IS NULL)))
1201 AND ( (Recinfo.global_attribute2 = P_global_attribute2)
1202 OR ( (Recinfo.global_attribute2 IS NULL)
1203 AND (P_global_attribute2 IS NULL)))
1204 AND ( (Recinfo.global_attribute3 = P_global_attribute3)
1205 OR ( (Recinfo.global_attribute3 IS NULL)
1206 AND (P_global_attribute3 IS NULL)))
1207 AND ( (Recinfo.global_attribute4 = P_global_attribute4)
1208 OR ( (Recinfo.global_attribute4 IS NULL)
1209 AND (P_global_attribute4 IS NULL)))
1210 AND ( (Recinfo.global_attribute5 = P_global_attribute5)
1211 OR ( (Recinfo.global_attribute5 IS NULL)
1212 AND (P_global_attribute5 IS NULL)))
1213 AND ( (Recinfo.global_attribute6 = P_global_attribute6)
1214 OR ( (Recinfo.global_attribute6 IS NULL)
1215 AND (P_global_attribute6 IS NULL)))
1216 AND ( (Recinfo.global_attribute7 = P_global_attribute7)
1217 OR ( (Recinfo.global_attribute7 IS NULL)
1218 AND (P_global_attribute7 IS NULL)))
1219 AND ( (Recinfo.global_attribute8 = P_global_attribute8)
1220 OR ( (Recinfo.global_attribute8 IS NULL)
1221 AND (P_global_attribute8 IS NULL)))
1222 AND ( (Recinfo.global_attribute9 = P_global_attribute9)
1223 OR ( (Recinfo.global_attribute9 IS NULL)
1224 AND (P_global_attribute9 IS NULL)))
1225 AND ( (Recinfo.global_attribute10 = P_global_attribute10)
1226 OR ( (Recinfo.global_attribute10 IS NULL)
1227 AND (P_global_attribute10 IS NULL)))
1228 AND ( (Recinfo.global_attribute11 = P_global_attribute11)
1229 OR ( (Recinfo.global_attribute11 IS NULL)
1230 AND (P_global_attribute11 IS NULL)))
1231 AND ( (Recinfo.global_attribute12 = P_global_attribute12)
1232 OR ( (Recinfo.global_attribute12 IS NULL)
1233 AND (P_global_attribute12 IS NULL)))
1234 AND ( (Recinfo.global_attribute13 = P_global_attribute13)
1235 OR ( (Recinfo.global_attribute13 IS NULL)
1236 AND (P_global_attribute13 IS NULL)))
1237 AND ( (Recinfo.global_attribute14 = P_global_attribute14)
1238 OR ( (Recinfo.global_attribute14 IS NULL)
1239 AND (P_global_attribute14 IS NULL)))
1240 AND ( (Recinfo.global_attribute15 = P_global_attribute15)
1241 OR ( (Recinfo.global_attribute15 IS NULL)
1242 AND (P_global_attribute15 IS NULL)))
1243 AND ( (Recinfo.global_attribute16 = P_global_attribute16)
1244 OR ( (Recinfo.global_attribute16 IS NULL)
1245 AND (P_global_attribute16 IS NULL)))
1246 AND ( (Recinfo.global_attribute17 = P_global_attribute17)
1247 OR ( (Recinfo.global_attribute17 IS NULL)
1248 AND (P_global_attribute17 IS NULL)))
1249 AND ( (Recinfo.global_attribute18 = P_global_attribute18)
1250 OR ( (Recinfo.global_attribute18 IS NULL)
1251 AND (P_global_attribute18 IS NULL)))
1252 AND ( (Recinfo.global_attribute19 = P_global_attribute19)
1253 OR ( (Recinfo.global_attribute19 IS NULL)
1254 AND (P_global_attribute19 IS NULL)))
1255 AND ( (Recinfo.global_attribute20 = P_global_attribute20)
1256 OR ( (Recinfo.global_attribute20 IS NULL)
1257 AND (P_global_attribute20 IS NULL)))
1258 AND (Recinfo.line_type_lookup_code = P_Line_Type_Lookup_Code)
1259 AND ( (Recinfo.line_group_number = P_line_group_number)
1260 OR ( (Recinfo.line_group_number IS NULL)
1261 AND (P_LINE_GROUP_NUMBER IS NULL)))
1262 AND ( (Recinfo.REQUESTER_ID = P_REQUESTER_ID)
1263 OR ( (Recinfo.REQUESTER_ID IS NULL)
1264 AND (P_REQUESTER_ID IS NULL)))
1265 AND ( (Recinfo.DESCRIPTION = P_DESCRIPTION)
1266 OR ( (Recinfo.DESCRIPTION IS NULL)
1267 AND (P_DESCRIPTION IS NULL)))
1268 AND ( (Recinfo.LINE_SOURCE = P_LINE_SOURCE)
1269 OR ( (Recinfo.LINE_SOURCE IS NULL)
1270 AND (P_LINE_SOURCE IS NULL)))
1271 AND ( (Recinfo.INVENTORY_ITEM_Id = P_INVENTORY_ITEM_ID)
1272 OR ( (Recinfo.INVENTORY_ITEM_ID IS NULL)
1273 AND (P_INVENTORY_ITEM_ID IS NULL)))
1274 AND ( (Recinfo.ITEM_DESCRIPTION = P_ITEM_DESCRIPTION)
1275 OR ( (Recinfo.ITEM_DESCRIPTION IS NULL)
1276 AND (P_ITEM_DESCRIPTION IS NULL)))
1277 AND ( (Recinfo.SERIAL_NUMBER = P_SERIAL_NUMBER)
1278 OR ( (Recinfo.SERIAL_NUMBER IS NULL)
1279 AND (P_SERIAL_NUMBER IS NULL)))
1280 AND ( (Recinfo.MANUFACTURER = P_MANUFACTURER)
1281 OR ( (Recinfo.MANUFACTURER IS NULL)
1282 AND (P_MANUFACTURER IS NULL)))
1286 AND ( (Recinfo.WARRANTY_NUMBER = P_WARRANTY_NUMBER)
1283 AND ( (Recinfo.MODEL_NUMBER = P_MODEL_NUMBER)
1284 OR ( (Recinfo.MODEL_NUMBER IS NULL)
1285 AND (P_MODEL_NUMBER IS NULL)))
1287 OR ( (Recinfo.WARRANTY_NUMBER IS NULL)
1288 AND (P_WARRANTY_NUMBER IS NULL)))
1289 AND ( (Recinfo.GENERATE_DISTS = P_GENERATE_DISTS)
1290 OR ( (Recinfo.GENERATE_DISTS IS NULL)
1291 AND (P_GENERATE_DISTS IS NULL)))
1292 AND ( (Recinfo.MATCH_TYPE = P_MATCH_TYPE)
1293 OR ( (Recinfo.MATCH_TYPE IS NULL)
1294 AND (P_MATCH_TYPE IS NULL)))
1295 AND ( (Recinfo.DISTRIBUTION_SET_ID = P_DISTRIBUTION_SET_ID)
1296 OR ( (Recinfo.DISTRIBUTION_SET_ID IS NULL)
1297 AND (P_DISTRIBUTION_SET_ID IS NULL)))
1298 AND ( (Recinfo.ACCOUNT_SEGMENT = P_ACCOUNT_SEGMENT)
1299 OR ( (Recinfo.ACCOUNT_SEGMENT IS NULL)
1300 AND (P_ACCOUNT_SEGMENT IS NULL)))
1301 AND ( (Recinfo.BALANCING_SEGMENT = P_BALANCING_SEGMENT)
1302 OR ( (Recinfo.BALANCING_SEGMENT IS NULL)
1303 AND (P_BALANCING_SEGMENT IS NULL)))
1304 AND ( (Recinfo.COST_CENTER_SEGMENT = P_COST_CENTER_SEGMENT)
1305 OR ( (Recinfo.COST_CENTER_SEGMENT IS NULL)
1306 AND (P_COST_CENTER_SEGMENT IS NULL)))
1307 AND ( (Recinfo.OVERLAY_DIST_CODE_CONCAT
1308 = P_OVERLAY_DIST_CODE_CONCAT)
1309 OR ( (Recinfo.OVERLAY_DIST_CODE_CONCAT IS NULL)
1310 AND (P_OVERLAY_DIST_CODE_CONCAT IS NULL)))
1311 AND ( (Recinfo.DEFAULT_DIST_CCID = P_DEFAULT_DIST_CCID)
1312 OR ( (Recinfo.DEFAULT_DIST_CCID IS NULL)
1313 AND (P_DEFAULT_DIST_CCID IS NULL)))
1314 AND ( (Recinfo.PRORATE_ACROSS_ALL_ITEMS
1315 = P_PRORATE_ACROSS_ALL_ITEMS)
1316 OR ( (Recinfo.PRORATE_ACROSS_ALL_ITEMS IS NULL)
1317 AND (P_PRORATE_ACROSS_ALL_ITEMS IS NULL)))
1318 AND ( (Recinfo.ROUNDING_AMT = P_ROUNDING_AMT)
1319 OR ( (Recinfo.ROUNDING_AMT IS NULL)
1320 AND (P_ROUNDING_AMT IS NULL)))
1321 AND ( (Recinfo.DEFERRED_ACCTG_FLAG = P_DEFERRED_ACCTG_FLAG)
1322 OR ( (Recinfo.DEFERRED_ACCTG_FLAG IS NULL)
1323 AND (P_DEFERRED_ACCTG_FLAG IS NULL)))
1324 AND ( (Recinfo.DEF_ACCTG_START_DATE = P_DEF_ACCTG_START_DATE)
1325 OR ( (Recinfo.DEF_ACCTG_START_DATE IS NULL)
1326 AND (P_DEF_ACCTG_START_DATE IS NULL)))
1327 AND ( (Recinfo.DEF_ACCTG_END_DATE = P_DEF_ACCTG_END_DATE)
1328 OR ( (Recinfo.DEF_ACCTG_END_DATE IS NULL)
1329 AND (P_DEF_ACCTG_END_DATE IS NULL)))
1330 AND ( (Recinfo.DEF_ACCTG_NUMBER_OF_PERIODS
1331 = P_DEF_ACCTG_NUMBER_OF_PERIODS)
1332 OR ( (Recinfo.DEF_ACCTG_NUMBER_OF_PERIODS IS NULL)
1333 AND (P_DEF_ACCTG_NUMBER_OF_PERIODS IS NULL)))
1334 AND ( (Recinfo.DEF_ACCTG_PERIOD_TYPE = P_DEF_ACCTG_PERIOD_TYPE)
1335 OR ( (Recinfo.DEF_ACCTG_PERIOD_TYPE IS NULL)
1336 AND (P_DEF_ACCTG_PERIOD_TYPE IS NULL)))
1337 AND ( (Recinfo.UNIT_MEAS_LOOKUP_CODE = P_UNIT_MEAS_LOOKUP_CODE)
1338 OR ( (Recinfo.UNIT_MEAS_LOOKUP_CODE IS NULL)
1339 AND (P_UNIT_MEAS_LOOKUP_CODE IS NULL)))
1340 AND ( (Recinfo.PERIOD_NAME = P_PERIOD_NAME)
1341 OR ( (Recinfo.PERIOD_NAME IS NULL)
1342 AND (P_PERIOD_NAME IS NULL)))
1343 AND ( (Recinfo.DISCARDED_FLAG = P_DISCARDED_FLAG)
1344 OR ( (Recinfo.DISCARDED_FLAG IS NULL)
1345 AND (P_DISCARDED_FLAG IS NULL)))
1346 AND ( (Recinfo.ORIGINAL_AMOUNT = P_ORIGINAL_AMOUNT)
1347 OR ( (Recinfo.ORIGINAL_AMOUNT IS NULL)
1348 AND (P_ORIGINAL_AMOUNT IS NULL)))
1349 AND ( (Recinfo.ORIGINAL_BASE_AMOUNT = P_ORIGINAL_BASE_AMOUNT)
1350 OR ( (Recinfo.ORIGINAL_BASE_AMOUNT IS NULL)
1351 AND (P_ORIGINAL_BASE_AMOUNT IS NULL)))
1352 AND ( (Recinfo.ORIGINAL_ROUNDING_AMT = P_ORIGINAL_ROUNDING_AMT)
1353 OR ( (Recinfo.ORIGINAL_ROUNDING_AMT IS NULL)
1354 AND (P_ORIGINAL_ROUNDING_AMT IS NULL)))
1355 AND ( (Recinfo.CANCELLED_FLAG = P_CANCELLED_FLAG)
1356 OR ( (Recinfo.CANCELLED_FLAG IS NULL)
1357 AND (P_CANCELLED_FLAG IS NULL)))
1358 AND ( (Recinfo.PREPAY_INVOICE_ID = P_PREPAY_INVOICE_ID)
1359 OR ( (Recinfo.PREPAY_INVOICE_ID IS NULL)
1360 AND (P_PREPAY_INVOICE_ID IS NULL)))
1361 AND ( (Recinfo.PREPAY_LINE_NUMBER = P_PREPAY_LINE_NUMBER)
1362 OR ( (Recinfo.PREPAY_LINE_NUMBER IS NULL)
1363 AND (P_PREPAY_LINE_NUMBER IS NULL)))
1364 AND ( (Recinfo.INVOICE_INCLUDES_PREPAY_FLAG
1365 = P_INVOICE_INCLUDES_PREPAY_FLAG)
1366 OR ( (Recinfo.INVOICE_INCLUDES_PREPAY_FLAG IS NULL)
1367 AND (P_INVOICE_INCLUDES_PREPAY_FLAG IS NULL)))
1368 AND ( (Recinfo.CORRECTED_INV_ID = P_CORRECTED_INV_ID)
1369 OR ( (Recinfo.CORRECTED_INV_ID IS NULL)
1370 AND (P_CORRECTED_INV_ID IS NULL)))
1371 AND ( (Recinfo.CORRECTED_LINE_NUMBER = P_CORRECTED_LINE_NUMBER)
1372 OR ( (Recinfo.CORRECTED_LINE_NUMBER IS NULL)
1373 AND (P_CORRECTED_LINE_NUMBER IS NULL)))
1374 AND ( (Recinfo.PA_CC_AR_INVOICE_ID = P_PA_CC_AR_INVOICE_ID)
1375 OR ( (Recinfo.PA_CC_AR_INVOICE_ID IS NULL)
1376 AND (P_PA_CC_AR_INVOICE_ID IS NULL)))
1377 AND ( (Recinfo.PA_CC_AR_INVOICE_LINE_NUM
1381 AND ( (Recinfo.PA_CC_PROCESSED_CODE = P_PA_CC_PROCESSED_CODE)
1378 = P_PA_CC_AR_INVOICE_LINE_NUM)
1379 OR ( (Recinfo.PA_CC_AR_INVOICE_LINE_NUM IS NULL)
1380 AND (P_PA_CC_AR_INVOICE_LINE_NUM IS NULL)))
1382 OR ( (Recinfo.PA_CC_PROCESSED_CODE IS NULL)
1383 AND (P_PA_CC_PROCESSED_CODE IS NULL)))
1384 AND ( (Recinfo.RECEIPT_VERIFIED_FLAG = P_RECEIPT_VERIFIED_FLAG)
1385 OR ( (Recinfo.RECEIPT_VERIFIED_FLAG IS NULL)
1386 AND (P_RECEIPT_VERIFIED_FLAG IS NULL)))
1387 AND ( (Recinfo.RECEIPT_REQUIRED_FLAG = P_RECEIPT_REQUIRED_FLAG)
1388 OR ( (Recinfo.RECEIPT_REQUIRED_FLAG IS NULL)
1389 AND (P_RECEIPT_REQUIRED_FLAG IS NULL)))
1390 AND ( (Recinfo.RECEIPT_MISSING_FLAG = P_RECEIPT_MISSING_FLAG)
1391 OR ( (Recinfo.RECEIPT_MISSING_FLAG IS NULL)
1392 AND (P_RECEIPT_MISSING_FLAG IS NULL)))
1393 AND ( (Recinfo.JUSTIFICATION = P_JUSTIFICATION)
1394 OR ( (Recinfo.JUSTIFICATION IS NULL)
1395 AND (P_JUSTIFICATION IS NULL)))
1396 AND ( (Recinfo.RECEIPT_CURRENCY_CODE = P_RECEIPT_CURRENCY_CODE)
1397 OR ( (Recinfo.RECEIPT_CURRENCY_CODE IS NULL)
1398 AND (P_RECEIPT_CURRENCY_CODE IS NULL)))
1399 AND ( (Recinfo.RECEIPT_CONVERSION_RATE = P_RECEIPT_CONVERSION_RATE)
1400 OR ( (Recinfo.RECEIPT_CONVERSION_RATE IS NULL)
1401 AND (P_RECEIPT_CONVERSION_RATE IS NULL)))
1402 AND ( (Recinfo.RECEIPT_CURRENCY_AMOUNT = P_RECEIPT_CURRENCY_AMOUNT)
1403 OR ( (Recinfo.RECEIPT_CURRENCY_AMOUNT IS NULL)
1404 AND (P_RECEIPT_CURRENCY_AMOUNT IS NULL)))
1405 AND ( (Recinfo.DAILY_AMOUNT = P_DAILY_AMOUNT)
1406 OR ( (Recinfo.DAILY_AMOUNT IS NULL)
1407 AND (P_DAILY_AMOUNT IS NULL)))
1408 AND ( (Recinfo.WEB_PARAMETER_ID = P_WEB_PARAMETER_ID)
1409 OR ( (Recinfo.WEB_PARAMETER_ID IS NULL)
1410 AND (P_WEB_PARAMETER_ID IS NULL)))
1411 AND ( (Recinfo.ADJUSTMENT_REASON = P_ADJUSTMENT_REASON)
1412 OR ( (Recinfo.ADJUSTMENT_REASON IS NULL)
1413 AND (P_ADJUSTMENT_REASON IS NULL)))
1414 AND ( (Recinfo.CREDIT_CARD_TRX_ID = P_CREDIT_CARD_TRX_ID)
1415 OR ( (Recinfo.CREDIT_CARD_TRX_ID IS NULL)
1416 AND (P_CREDIT_CARD_TRX_ID IS NULL)))
1417 AND ( (Recinfo.COMPANY_PREPAID_INVOICE_ID
1418 = P_COMPANY_PREPAID_INVOICE_ID)
1419 OR ( (Recinfo.COMPANY_PREPAID_INVOICE_ID IS NULL)
1420 AND (P_COMPANY_PREPAID_INVOICE_ID IS NULL)))
1421 AND ( (Recinfo.CC_REVERSAL_FLAG = P_CC_REVERSAL_FLAG)
1422 OR ( (Recinfo.CC_REVERSAL_FLAG IS NULL)
1423 AND (P_CC_REVERSAL_FLAG IS NULL)))
1424 --ETAX: Invwkb
1425 AND ( (Recinfo.PRIMARY_INTENDED_USE = P_PRIMARY_INTENDED_USE)
1426 OR ( (Recinfo.PRIMARY_INTENDED_USE IS NULL)
1427 AND (P_PRIMARY_INTENDED_USE IS NULL)))
1428 AND ( (Recinfo.SHIP_TO_LOCATION_ID = P_SHIP_TO_LOCATION_ID)
1429 OR ( (Recinfo.SHIP_TO_LOCATION_ID IS NULL)
1430 AND (P_SHIP_TO_LOCATION_ID IS NULL)))
1431 AND ( (Recinfo.PRODUCT_FISC_CLASSIFICATION = P_PRODUCT_FISC_CLASSIFICATION)
1432 OR ( (Recinfo.PRODUCT_FISC_CLASSIFICATION IS NULL)
1433 AND (P_PRODUCT_FISC_CLASSIFICATION IS NULL)))
1434 AND ( (Recinfo.USER_DEFINED_FISC_CLASS = P_USER_DEFINED_FISC_CLASS)
1435 OR ( (Recinfo.USER_DEFINED_FISC_CLASS IS NULL)
1436 AND (P_USER_DEFINED_FISC_CLASS IS NULL)))
1437 AND ( (Recinfo.TRX_BUSINESS_CATEGORY = P_TRX_BUSINESS_CATEGORY)
1438 OR ( (Recinfo.TRX_BUSINESS_CATEGORY IS NULL)
1439 AND (P_TRX_BUSINESS_CATEGORY IS NULL)))
1440 AND ( (Recinfo.PRODUCT_TYPE = P_PRODUCT_TYPE)
1441 OR ( (Recinfo.PRODUCT_TYPE IS NULL)
1442 AND (P_PRODUCT_TYPE IS NULL)))
1443 AND ( (Recinfo.PRODUCT_CATEGORY = P_PRODUCT_CATEGORY)
1444 OR ( (Recinfo.PRODUCT_CATEGORY IS NULL)
1445 AND (P_PRODUCT_CATEGORY IS NULL)))
1446 AND ( (Recinfo.ASSESSABLE_VALUE = P_ASSESSABLE_VALUE)
1447 OR ( (Recinfo.ASSESSABLE_VALUE IS NULL)
1448 AND (P_ASSESSABLE_VALUE IS NULL)))
1449 AND ( (Recinfo.CONTROL_AMOUNT = P_CONTROL_AMOUNT)
1450 OR ( (Recinfo.CONTROL_AMOUNT IS NULL)
1451 AND (P_CONTROL_AMOUNT IS NULL)))
1452 AND ( (Recinfo.TAX_REGIME_CODE = P_TAX_REGIME_CODE)
1453 OR ( (Recinfo.TAX_REGIME_CODE IS NULL)
1454 AND (P_TAX_REGIME_CODE IS NULL)))
1455 AND ( (Recinfo.TAX = P_TAX)
1456 OR ( (Recinfo.TAX IS NULL)
1457 AND (P_TAX IS NULL)))
1458 AND ( (Recinfo.TAX_STATUS_CODE = P_TAX_STATUS_CODE)
1459 OR ( (Recinfo.TAX_STATUS_CODE IS NULL)
1460 AND (P_TAX_STATUS_CODE IS NULL)))
1461 AND ( (Recinfo.TAX_RATE_CODE = P_TAX_RATE_CODE)
1462 OR ( (Recinfo.TAX_RATE_CODE IS NULL)
1463 AND (P_TAX_RATE_CODE IS NULL)))
1464 AND ( (Recinfo.TAX_RATE_ID = P_TAX_RATE_ID)
1465 OR ( (Recinfo.TAX_RATE_ID IS NULL)
1466 AND (P_TAX_RATE_ID IS NULL)))
1467 AND ( (Recinfo.TAX_RATE = P_TAX_RATE)
1468 OR ( (Recinfo.TAX_RATE IS NULL)
1469 AND (P_TAX_RATE IS NULL)))
1470 AND ( (Recinfo.TAX_JURISDICTION_CODE = P_TAX_JURISDICTION_CODE)
1471 OR ( (Recinfo.TAX_JURISDICTION_CODE IS NULL)
1472 AND (P_TAX_JURISDICTION_CODE IS NULL)))
1473 AND (Recinfo.po_header_id IS NOT NULL OR
1474 ((Recinfo.PURCHASING_CATEGORY_ID = P_PURCHASING_CATEGORY_ID)
1475 OR ( (Recinfo.PURCHASING_CATEGORY_ID IS NULL)
1476 AND (P_PURCHASING_CATEGORY_ID IS NULL)))
1480 AND (P_COST_FACTOR_ID IS NULL)))
1477 )
1478 AND ( (Recinfo.COST_FACTOR_ID = P_COST_FACTOR_ID)
1479 OR ( (Recinfo.COST_FACTOR_ID IS NULL)
1481 AND ( (Recinfo.RETAINED_AMOUNT = P_RETAINED_AMOUNT)
1482 OR ( (Recinfo.RETAINED_AMOUNT IS NULL)
1483 AND (P_RETAINED_AMOUNT IS NULL)))
1484 AND ( (Recinfo.RETAINED_INVOICE_ID = P_RETAINED_INVOICE_ID)
1485 OR ( (Recinfo.RETAINED_INVOICE_ID IS NULL)
1486 AND (P_RETAINED_INVOICE_ID IS NULL)))
1487 AND ( (Recinfo.RETAINED_LINE_NUMBER = P_RETAINED_LINE_NUMBER)
1488 OR ( (Recinfo.RETAINED_LINE_NUMBER IS NULL)
1489 AND (P_RETAINED_LINE_NUMBER IS NULL)))
1490 AND ( (Recinfo.TAX_CLASSIFICATION_CODE = P_TAX_CLASSIFICATION_CODE)
1491 OR ( (Recinfo.TAX_CLASSIFICATION_CODE IS NULL)
1492 AND (P_TAX_CLASSIFICATION_CODE IS NULL)))
1493 ) THEN
1494 RETURN;
1495 ELSE
1496 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1497 APP_EXCEPTION.Raise_Exception;
1498 END IF;
1499
1500 EXCEPTION
1501 WHEN OTHERS THEN
1502 IF (SQLCODE <> -20001) THEN
1503 IF (SQLCODE = -54) THEN
1504 FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505 ELSE
1506 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510 END IF;
1511 END IF;
1512 APP_EXCEPTION.RAISE_EXCEPTION;
1513
1514 END Lock_Row;
1515
1516
1517 PROCEDURE Update_Row (
1518 p_ROWID IN OUT NOCOPY VARCHAR2,
1519 p_INVOICE_ID NUMBER,
1520 p_LINE_NUMBER NUMBER,
1521 p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
1522 p_LINE_GROUP_NUMBER NUMBER,
1523 p_REQUESTER_ID NUMBER,
1524 p_DESCRIPTION VARCHAR2,
1525 p_LINE_SOURCE VARCHAR2,
1526 p_ORG_ID NUMBER,
1527 p_INVENTORY_ITEM_ID NUMBER,
1528 p_ITEM_DESCRIPTION VARCHAR2,
1529 p_SERIAL_NUMBER VARCHAR2,
1530 p_MANUFACTURER VARCHAR2,
1531 p_MODEL_NUMBER VARCHAR2,
1532 p_WARRANTY_NUMBER VARCHAR2,
1533 p_GENERATE_DISTS VARCHAR2,
1534 p_MATCH_TYPE VARCHAR2,
1535 p_DISTRIBUTION_SET_ID NUMBER,
1536 p_ACCOUNT_SEGMENT VARCHAR2,
1537 p_BALANCING_SEGMENT VARCHAR2,
1538 p_COST_CENTER_SEGMENT VARCHAR2,
1539 p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
1540 p_DEFAULT_DIST_CCID NUMBER,
1541 p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
1542 p_ACCOUNTING_DATE DATE,
1543 p_PERIOD_NAME VARCHAR2,
1544 p_DEFERRED_ACCTG_FLAG VARCHAR2,
1545 p_DEF_ACCTG_START_DATE DATE,
1546 p_DEF_ACCTG_END_DATE DATE,
1547 p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
1548 p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
1549 p_SET_OF_BOOKS_ID NUMBER,
1550 p_AMOUNT NUMBER,
1551 p_BASE_AMOUNT NUMBER,
1552 p_ROUNDING_AMT NUMBER,
1553 p_QUANTITY_INVOICED NUMBER,
1554 p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
1555 p_UNIT_PRICE NUMBER,
1556 p_WFAPPROVAL_STATUS VARCHAR2,
1557 p_DISCARDED_FLAG VARCHAR2,
1558 p_ORIGINAL_AMOUNT NUMBER,
1559 p_ORIGINAL_BASE_AMOUNT NUMBER,
1560 p_ORIGINAL_ROUNDING_AMT NUMBER,
1561 p_CANCELLED_FLAG VARCHAR2,
1562 p_INCOME_TAX_REGION VARCHAR2,
1563 p_TYPE_1099 VARCHAR2,
1564 p_STAT_AMOUNT NUMBER,
1565 p_PREPAY_INVOICE_ID NUMBER,
1566 p_PREPAY_LINE_NUMBER NUMBER,
1567 p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
1568 p_CORRECTED_INV_ID NUMBER,
1569 p_CORRECTED_LINE_NUMBER NUMBER,
1570 p_PO_HEADER_ID NUMBER,
1571 p_PO_LINE_ID NUMBER,
1572 p_PO_RELEASE_ID NUMBER,
1573 p_PO_LINE_LOCATION_ID NUMBER,
1574 p_PO_DISTRIBUTION_ID NUMBER,
1575 p_RCV_TRANSACTION_ID NUMBER,
1576 p_FINAL_MATCH_FLAG VARCHAR2,
1577 p_ASSETS_TRACKING_FLAG VARCHAR2,
1578 p_ASSET_BOOK_TYPE_CODE VARCHAR2,
1579 p_ASSET_CATEGORY_ID NUMBER,
1580 p_PROJECT_ID NUMBER,
1581 p_TASK_ID NUMBER,
1582 p_EXPENDITURE_TYPE VARCHAR2,
1583 p_EXPENDITURE_ITEM_DATE DATE,
1584 p_EXPENDITURE_ORGANIZATION_ID NUMBER,
1585 p_PA_QUANTITY NUMBER,
1586 p_PA_CC_AR_INVOICE_ID NUMBER,
1587 p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
1588 p_PA_CC_PROCESSED_CODE VARCHAR2,
1589 p_AWARD_ID NUMBER,
1590 p_AWT_GROUP_ID NUMBER,
1591 p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
1592 p_REFERENCE_1 VARCHAR2,
1593 p_REFERENCE_2 VARCHAR2,
1597 p_JUSTIFICATION VARCHAR2,
1594 p_RECEIPT_VERIFIED_FLAG VARCHAR2,
1595 p_RECEIPT_REQUIRED_FLAG VARCHAR2,
1596 p_RECEIPT_MISSING_FLAG VARCHAR2,
1598 p_EXPENSE_GROUP VARCHAR2,
1599 p_START_EXPENSE_DATE DATE,
1600 p_END_EXPENSE_DATE DATE,
1601 p_RECEIPT_CURRENCY_CODE VARCHAR2,
1602 p_RECEIPT_CONVERSION_RATE NUMBER,
1603 p_RECEIPT_CURRENCY_AMOUNT NUMBER,
1604 p_DAILY_AMOUNT NUMBER,
1605 p_WEB_PARAMETER_ID NUMBER,
1606 p_ADJUSTMENT_REASON VARCHAR2,
1607 p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
1608 p_MERCHANT_NAME VARCHAR2,
1609 p_MERCHANT_REFERENCE VARCHAR2,
1610 p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
1611 p_MERCHANT_TAXPAYER_ID VARCHAR2,
1612 p_COUNTRY_OF_SUPPLY VARCHAR2,
1613 p_CREDIT_CARD_TRX_ID NUMBER,
1614 p_COMPANY_PREPAID_INVOICE_ID NUMBER,
1615 p_CC_REVERSAL_FLAG VARCHAR2,
1616 p_CREATION_DATE DATE,
1617 p_CREATED_BY NUMBER,
1618 p_LAST_UPDATED_BY NUMBER,
1619 p_LAST_UPDATE_DATE DATE,
1620 p_LAST_UPDATE_LOGIN NUMBER,
1621 p_PROGRAM_APPLICATION_ID NUMBER,
1622 p_PROGRAM_ID NUMBER,
1623 p_PROGRAM_UPDATE_DATE DATE,
1624 p_REQUEST_ID NUMBER,
1625 p_ATTRIBUTE_CATEGORY VARCHAR2,
1626 p_ATTRIBUTE1 VARCHAR2,
1627 p_ATTRIBUTE2 VARCHAR2,
1628 p_ATTRIBUTE3 VARCHAR2,
1629 p_ATTRIBUTE4 VARCHAR2,
1630 p_ATTRIBUTE5 VARCHAR2,
1631 p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
1632 p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
1633 p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
1634 p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
1635 p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
1636 p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
1637 p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
1638 p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
1639 p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
1640 p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
1641 p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
1642 p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
1643 p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
1644 p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
1645 p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
1646 p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
1647 p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
1648 p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
1649 p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
1650 p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
1651 p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
1652 p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
1653 p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
1654 p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
1655 p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
1656 p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
1657 p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
1658 p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
1659 p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
1660 p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
1661 p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
1662 --ETAX: Invwkb
1663 p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
1664 p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
1665 p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
1666 p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
1667 p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
1668 p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
1669 p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
1670 p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
1671 p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
1672 p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
1673 p_TAX VARCHAR2 DEFAULT NULL,
1674 p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
1675 p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
1676 p_TAX_RATE_ID NUMBER DEFAULT NULL,
1677 p_TAX_RATE NUMBER DEFAULT NULL,
1678 p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
1679 p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
1680 p_COST_FACTOR_ID NUMBER DEFAULT NULL,
1681 p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
1682 p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
1683 p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
1684 p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
1685 p_Calling_Sequence VARCHAR2)
1686 IS
1687 current_calling_sequence VARCHAR2(2000);
1688 debug_info VARCHAR2(100);
1689 BEGIN
1690 -- Update the calling sequence
1691
1692 current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Update_Row<-'
1693 ||p_Calling_Sequence;
1694
1695 -- Check for uniqueness of the distribution line number
1696
1700 p_Line_Number,
1697 AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE(
1698 p_Rowid,
1699 p_Invoice_Id,
1701 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');
1702
1703 debug_info := 'Update ap_invoice_lines_all';
1704
1705 UPDATE AP_INVOICE_LINES_ALL
1706 SET
1707 INVOICE_ID = P_INVOICE_ID,
1708 LINE_NUMBER = P_LINE_NUMBER,
1709 LINE_TYPE_LOOKUP_CODE = P_LINE_TYPE_LOOKUP_CODE,
1710 LINE_GROUP_NUMBER = p_LINE_GROUP_NUMBER,
1711 REQUESTER_ID = P_REQUESTER_ID,
1712 DESCRIPTION = P_DESCRIPTION,
1713 LINE_SOURCE = P_LINE_SOURCE,
1714 ORG_ID = P_ORG_ID,
1715 INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
1716 ITEM_DESCRIPTION = P_ITEM_DESCRIPTION,
1717 SERIAL_NUMBER = P_SERIAL_NUMBER,
1718 MANUFACTURER = P_MANUFACTURER,
1719 MODEL_NUMBER = P_MODEL_NUMBER,
1720 WARRANTY_NUMBER = P_WARRANTY_NUMBER,
1721 GENERATE_DISTS = P_GENERATE_DISTS,
1722 MATCH_TYPE = P_MATCH_TYPE,
1723 DISTRIBUTION_SET_ID = P_DISTRIBUTION_SET_ID,
1724 ACCOUNT_SEGMENT = P_ACCOUNT_SEGMENT,
1725 BALANCING_SEGMENT = P_BALANCING_SEGMENT,
1726 COST_CENTER_SEGMENT = P_COST_CENTER_SEGMENT,
1727 OVERLAY_DIST_CODE_CONCAT = P_OVERLAY_DIST_CODE_CONCAT,
1728 DEFAULT_DIST_CCID = P_DEFAULT_DIST_CCID,
1729 PRORATE_ACROSS_ALL_ITEMS = P_PRORATE_ACROSS_ALL_ITEMS,
1730 ACCOUNTING_DATE = P_ACCOUNTING_DATE,
1731 PERIOD_NAME = P_PERIOD_NAME,
1732 DEFERRED_ACCTG_FLAG = P_DEFERRED_ACCTG_FLAG ,
1733 DEF_ACCTG_START_DATE = P_DEF_ACCTG_START_DATE,
1734 DEF_ACCTG_END_DATE = P_DEF_ACCTG_END_DATE ,
1735 DEF_ACCTG_NUMBER_OF_PERIODS = P_DEF_ACCTG_NUMBER_OF_PERIODS,
1736 DEF_ACCTG_PERIOD_TYPE = P_DEF_ACCTG_PERIOD_TYPE,
1737 SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID,
1738 AMOUNT = P_AMOUNT,
1739 BASE_AMOUNT = P_BASE_AMOUNT,
1740 ROUNDING_AMT = P_ROUNDING_AMT ,
1741 QUANTITY_INVOICED = P_QUANTITY_INVOICED,
1742 UNIT_MEAS_LOOKUP_CODE = P_UNIT_MEAS_LOOKUP_CODE,
1743 UNIT_PRICE = P_UNIT_PRICE,
1744 WFAPPROVAL_STATUS = P_WFAPPROVAL_STATUS,
1745 DISCARDED_FLAG = P_DISCARDED_FLAG,
1746 ORIGINAL_AMOUNT = P_ORIGINAL_AMOUNT,
1747 ORIGINAL_BASE_AMOUNT = P_ORIGINAL_BASE_AMOUNT,
1748 ORIGINAL_ROUNDING_AMT = P_ORIGINAL_ROUNDING_AMT,
1749 CANCELLED_FLAG = P_CANCELLED_FLAG,
1750 INCOME_TAX_REGION = P_INCOME_TAX_REGION,
1751 TYPE_1099 = P_TYPE_1099,
1752 STAT_AMOUNT = P_STAT_AMOUNT,
1753 PREPAY_INVOICE_ID = P_PREPAY_INVOICE_ID,
1754 PREPAY_LINE_NUMBER = P_PREPAY_LINE_NUMBER,
1755 INVOICE_INCLUDES_PREPAY_FLAG = P_INVOICE_INCLUDES_PREPAY_FLAG,
1756 CORRECTED_INV_ID = P_CORRECTED_INV_ID,
1757 CORRECTED_LINE_NUMBER = P_CORRECTED_LINE_NUMBER,
1758 PO_HEADER_ID = P_PO_HEADER_ID,
1759 PO_LINE_ID = P_PO_LINE_ID,
1760 --bugfix:4990529, changed the p_po_line_location_id to
1761 --p_po_release_id
1762 PO_RELEASE_ID = P_PO_RELEASE_ID,
1763 PO_LINE_LOCATION_ID = P_PO_LINE_LOCATION_ID,
1764 PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID,
1765 RCV_TRANSACTION_ID = P_RCV_TRANSACTION_ID,
1766 FINAL_MATCH_FLAG = P_FINAL_MATCH_FLAG,
1767 ASSETS_TRACKING_FLAG = P_ASSETS_TRACKING_FLAG,
1768 ASSET_BOOK_TYPE_CODE = P_ASSET_BOOK_TYPE_CODE,
1769 ASSET_CATEGORY_ID = P_ASSET_CATEGORY_ID,
1770 PROJECT_ID = P_PROJECT_ID,
1771 TASK_ID = P_TASK_ID,
1772 EXPENDITURE_TYPE = P_EXPENDITURE_TYPE,
1773 EXPENDITURE_ITEM_DATE = P_EXPENDITURE_ITEM_DATE,
1774 EXPENDITURE_ORGANIZATION_ID = P_EXPENDITURE_ORGANIZATION_ID,
1775 PA_QUANTITY = P_PA_QUANTITY,
1776 PA_CC_AR_INVOICE_ID = P_PA_CC_AR_INVOICE_ID,
1777 PA_CC_AR_INVOICE_LINE_NUM = P_PA_CC_AR_INVOICE_LINE_NUM,
1778 PA_CC_PROCESSED_CODE = P_PA_CC_PROCESSED_CODE,
1779 AWARD_ID = P_AWARD_ID,
1780 AWT_GROUP_ID = P_AWT_GROUP_ID,
1781 PAY_AWT_GROUP_ID = P_PAY_AWT_GROUP_ID,--bug6639866
1782 REFERENCE_1 = P_REFERENCE_1,
1783 REFERENCE_2 = P_REFERENCE_2,
1784 RECEIPT_VERIFIED_FLAG = P_RECEIPT_REQUIRED_FLAG,
1785 RECEIPT_REQUIRED_FLAG = P_RECEIPT_REQUIRED_FLAG,
1786 RECEIPT_MISSING_FLAG = P_RECEIPT_MISSING_FLAG,
1787 JUSTIFICATION = P_JUSTIFICATION,
1788 EXPENSE_GROUP = P_EXPENSE_GROUP,
1789 START_EXPENSE_DATE = P_START_EXPENSE_DATE,
1790 END_EXPENSE_DATE = P_END_EXPENSE_DATE,
1791 RECEIPT_CURRENCY_CODE = P_RECEIPT_CURRENCY_CODE,
1792 RECEIPT_CONVERSION_RATE = P_RECEIPT_CONVERSION_RATE,
1793 RECEIPT_CURRENCY_AMOUNT = P_RECEIPT_CURRENCY_AMOUNT,
1794 DAILY_AMOUNT = P_DAILY_AMOUNT,
1795 WEB_PARAMETER_ID = P_WEB_PARAMETER_ID,
1799 MERCHANT_REFERENCE = P_MERCHANT_REFERENCE,
1796 ADJUSTMENT_REASON = P_ADJUSTMENT_REASON,
1797 MERCHANT_DOCUMENT_NUMBER = P_MERCHANT_DOCUMENT_NUMBER,
1798 MERCHANT_NAME = P_MERCHANT_NAME,
1800 MERCHANT_TAX_REG_NUMBER = P_MERCHANT_TAX_REG_NUMBER,
1801 MERCHANT_TAXPAYER_ID = P_MERCHANT_TAXPAYER_ID,
1802 COUNTRY_OF_SUPPLY = P_COUNTRY_OF_SUPPLY,
1803 CREDIT_CARD_TRX_ID = P_CREDIT_CARD_TRX_ID,
1804 COMPANY_PREPAID_INVOICE_ID = P_COMPANY_PREPAID_INVOICE_ID,
1805 CC_REVERSAL_FLAG = P_CC_REVERSAL_FLAG,
1806 CREATION_DATE = P_CREATION_DATE,
1807 CREATED_BY = P_CREATED_BY,
1808 LAST_UPDATED_BY = P_LAST_UPDATED_BY,
1809 LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
1810 LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
1811 PROGRAM_APPLICATION_ID = P_PROGRAM_APPLICATION_ID,
1812 PROGRAM_ID = P_PROGRAM_ID,
1813 PROGRAM_UPDATE_DATE = P_PROGRAM_UPDATE_DATE,
1814 REQUEST_ID = P_REQUEST_ID,
1815 ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
1816 ATTRIBUTE1 = P_ATTRIBUTE1,
1817 ATTRIBUTE2 = P_ATTRIBUTE2,
1818 ATTRIBUTE3 = P_ATTRIBUTE3,
1819 ATTRIBUTE4 = P_ATTRIBUTE4,
1820 ATTRIBUTE5 = P_ATTRIBUTE5,
1821 ATTRIBUTE6 = P_ATTRIBUTE6,
1822 ATTRIBUTE7 = P_ATTRIBUTE7,
1823 ATTRIBUTE8 = P_ATTRIBUTE8,
1824 ATTRIBUTE9 = P_ATTRIBUTE9,
1825 ATTRIBUTE10 = P_ATTRIBUTE10,
1826 ATTRIBUTE11 = P_ATTRIBUTE11,
1827 ATTRIBUTE12 = P_ATTRIBUTE12,
1828 ATTRIBUTE13 = P_ATTRIBUTE13,
1829 ATTRIBUTE14 = P_ATTRIBUTE14,
1830 ATTRIBUTE15 = P_ATTRIBUTE15,
1831 GLOBAL_ATTRIBUTE_CATEGORY = P_GLOBAL_ATTRIBUTE_CATEGORY,
1832 GLOBAL_ATTRIBUTE1 = P_GLOBAL_ATTRIBUTE1,
1833 GLOBAL_ATTRIBUTE2 = P_GLOBAL_ATTRIBUTE2,
1834 GLOBAL_ATTRIBUTE3 = P_GLOBAL_ATTRIBUTE3,
1835 GLOBAL_ATTRIBUTE4 = P_GLOBAL_ATTRIBUTE4,
1836 GLOBAL_ATTRIBUTE5 = P_GLOBAL_ATTRIBUTE5,
1837 GLOBAL_ATTRIBUTE6 = P_GLOBAL_ATTRIBUTE6,
1838 GLOBAL_ATTRIBUTE7 = P_GLOBAL_ATTRIBUTE7,
1839 GLOBAL_ATTRIBUTE8 = P_GLOBAL_ATTRIBUTE8,
1840 GLOBAL_ATTRIBUTE9 = P_GLOBAL_ATTRIBUTE9,
1841 GLOBAL_ATTRIBUTE10 = P_GLOBAL_ATTRIBUTE10,
1842 GLOBAL_ATTRIBUTE11 = P_GLOBAL_ATTRIBUTE11,
1843 GLOBAL_ATTRIBUTE12 = P_GLOBAL_ATTRIBUTE12,
1844 GLOBAL_ATTRIBUTE13 = P_GLOBAL_ATTRIBUTE13,
1845 GLOBAL_ATTRIBUTE14 = P_GLOBAL_ATTRIBUTE14,
1846 GLOBAL_ATTRIBUTE15 = P_GLOBAL_ATTRIBUTE15,
1847 GLOBAL_ATTRIBUTE16 = P_GLOBAL_ATTRIBUTE16,
1848 GLOBAL_ATTRIBUTE17 = P_GLOBAL_ATTRIBUTE17,
1849 GLOBAL_ATTRIBUTE18 = P_GLOBAL_ATTRIBUTE18,
1850 GLOBAL_ATTRIBUTE19 = P_GLOBAL_ATTRIBUTE19,
1851 GLOBAL_ATTRIBUTE20 = P_GLOBAL_ATTRIBUTE20,
1852 PRIMARY_INTENDED_USE = P_PRIMARY_INTENDED_USE,
1853 SHIP_TO_LOCATION_ID = P_SHIP_TO_LOCATION_ID,
1854 PRODUCT_FISC_CLASSIFICATION = P_PRODUCT_FISC_CLASSIFICATION,
1855 USER_DEFINED_FISC_CLASS = P_USER_DEFINED_FISC_CLASS,
1856 TRX_BUSINESS_CATEGORY = P_TRX_BUSINESS_CATEGORY,
1857 PRODUCT_TYPE = P_PRODUCT_TYPE,
1858 PRODUCT_CATEGORY = P_PRODUCT_CATEGORY,
1859 ASSESSABLE_VALUE = P_ASSESSABLE_VALUE,
1860 CONTROL_AMOUNT = P_CONTROL_AMOUNT,
1861 TAX_REGIME_CODE = P_TAX_REGIME_CODE,
1862 TAX = P_TAX,
1863 TAX_STATUS_CODE = P_TAX_STATUS_CODE,
1864 TAX_RATE_CODE = P_TAX_RATE_CODE,
1865 TAX_RATE_ID = P_TAX_RATE_ID,
1866 TAX_RATE = P_TAX_RATE,
1867 TAX_JURISDICTION_CODE = P_TAX_JURISDICTION_CODE,
1868 PURCHASING_CATEGORY_ID = P_PURCHASING_CATEGORY_ID,
1869 COST_FACTOR_ID = P_COST_FACTOR_ID,
1870 RETAINED_AMOUNT = P_RETAINED_AMOUNT,
1871 RETAINED_AMOUNT_REMAINING = -(P_RETAINED_AMOUNT),
1872 RETAINED_INVOICE_ID = P_RETAINED_INVOICE_ID,
1873 RETAINED_LINE_NUMBER = P_RETAINED_LINE_NUMBER,
1874 TAX_CLASSIFICATION_CODE = P_TAX_CLASSIFICATION_CODE
1875 WHERE rowid = p_Rowid;
1876
1877 IF (SQL%NOTFOUND) THEN
1878 Raise NO_DATA_FOUND;
1879 END IF;
1880
1881 EXCEPTION
1882 WHEN OTHERS THEN
1883 IF (SQLCODE <> -20001) THEN
1884 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888 END IF;
1889 APP_EXCEPTION.RAISE_EXCEPTION;
1890
1891 END Update_Row;
1892
1893
1894 PROCEDURE Delete_Row (
1895 p_Rowid VARCHAR2,
1896 p_Calling_Sequence VARCHAR2)
1897 IS
1898 current_calling_sequence VARCHAR2(2000);
1899 debug_info VARCHAR2(100);
1900 --Bugfix:4670908
1901 l_invoice_id AP_INVOICES_ALL.INVOICE_ID%TYPE;
1902 l_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
1903 l_invoice_distribution_id NUMBER;
1904 --Bug9295867
1905 l_line_type AP_INVOICE_LINES_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;
1906 l_tax_calculated_flag VARCHAR2(3);
1907 l_success BOOLEAN;
1911 -- Update the calling sequence
1908 l_error_code VARCHAR2(4000);
1909 l_api_name CONSTANT VARCHAR2(200) := 'Delete_Row';
1910 BEGIN
1912
1913 current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Delete_Row<-' ||
1914 p_Calling_Sequence;
1915
1916 debug_info := 'Delete from child entity ap_invoice_distributions_all';
1917 IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1918 FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,debug_info);
1919 END IF;
1920 --Bugfix:4670908
1921 --Bug9295867 : added l_line_type, l_tax_calculated_flag
1922 SELECT invoice_id,line_number,line_type_lookup_code,tax_already_calculated_flag
1923 INTO l_invoice_id,l_line_number, l_line_type, l_tax_calculated_flag
1924 FROM ap_invoice_lines_all
1925 WHERE rowid=p_rowid;
1926
1927 DELETE FROM ap_invoice_distributions_all
1928 WHERE invoice_id = l_invoice_id
1929 AND invoice_line_number = l_line_number;
1930
1931 --Bug9295867
1932 --Bug9729201 : Modified line type check :Call etax if line is not tax or awt
1933 if(l_line_type NOT IN ('TAX','AWT') and l_tax_calculated_flag ='Y') THEN
1934 debug_info := 'Calling eTax to delete corresponding tax data';
1935 IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1936 FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,debug_info);
1937 END IF;
1938 l_success := ap_etax_pkg.calling_etax(
1939 P_Invoice_Id => l_invoice_id,
1940 P_Calling_Mode => 'MARK TAX LINES DELETED',
1941 P_Line_Number_To_Delete =>l_line_number,
1942 P_All_Error_Messages => 'N',
1943 P_error_code => l_error_code,
1944 P_calling_sequence => current_calling_sequence);
1945
1946 IF(not l_success) THEN
1947 FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_TAX_LINE_DEL_FAIL');
1948 FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1949 APP_EXCEPTION.RAISE_EXCEPTION;
1950 END IF;
1951 END IF;
1952 --End of Bug9295867
1953
1954 debug_info := 'Delete from ap_invoice_lines';
1955 DELETE FROM AP_INVOICE_LINES_ALL
1956 WHERE rowid = p_Rowid;
1957
1958 IF (SQL%NOTFOUND) THEN
1959 Raise NO_DATA_FOUND;
1960 END IF;
1961
1962 EXCEPTION
1963 WHEN OTHERS THEN
1964 IF (SQLCODE <> -20001) THEN
1965 FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966 FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967 FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968 FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969 END IF;
1970 APP_EXCEPTION.RAISE_EXCEPTION;
1971
1972 END Delete_Row;
1973
1974 END AP_AIL_TABLE_HANDLER_PKG;