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