1 package body AP_INVOICES_INTERFACE_PKG as
2 /* $Header: apaiithb.pls 120.11.12010000.2 2008/11/20 14:12:01 dcshanmu ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_INVOICE_ID IN NUMBER,
7 X_INVOICE_NUM IN VARCHAR2,
8 X_INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2,
9 X_INVOICE_DATE IN DATE,
10 X_PO_NUMBER IN VARCHAR2,
11 X_VENDOR_ID IN NUMBER,
12 X_VENDOR_SITE_ID IN NUMBER,
13 X_INVOICE_AMOUNT IN NUMBER,
14 X_INVOICE_CURRENCY_CODE IN VARCHAR2,
15 X_PAYMENT_CURRENCY_CODE IN VARCHAR2,
16 X_PAYMENT_CROSS_RATE IN NUMBER,
17 X_PAYMENT_CROSS_RATE_TYPE IN VARCHAR2,
18 X_PAYMENT_CROSS_RATE_DATE IN DATE,
19 X_EXCHANGE_RATE IN NUMBER,
20 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
21 X_EXCHANGE_DATE IN DATE,
22 X_TERMS_ID IN NUMBER,
23 X_DESCRIPTION IN VARCHAR2,
24 X_AWT_GROUP_ID IN NUMBER,
25 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
26 X_AMT_APPLICABLE_TO_DISCOUNT IN NUMBER,
27 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
28 X_ATTRIBUTE1 IN VARCHAR2,
29 X_ATTRIBUTE2 IN VARCHAR2,
30 X_ATTRIBUTE3 IN VARCHAR2,
31 X_ATTRIBUTE4 IN VARCHAR2,
32 X_ATTRIBUTE5 IN VARCHAR2,
33 X_ATTRIBUTE6 IN VARCHAR2,
34 X_ATTRIBUTE7 IN VARCHAR2,
35 X_ATTRIBUTE8 IN VARCHAR2,
36 X_ATTRIBUTE9 IN VARCHAR2,
37 X_ATTRIBUTE10 IN VARCHAR2,
38 X_ATTRIBUTE11 IN VARCHAR2,
39 X_ATTRIBUTE12 IN VARCHAR2,
40 X_ATTRIBUTE13 IN VARCHAR2,
41 X_ATTRIBUTE14 IN VARCHAR2,
42 X_ATTRIBUTE15 IN VARCHAR2,
43 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
44 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
45 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
46 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
47 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
48 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
49 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
50 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
51 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
52 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
53 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
54 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
55 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
56 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
57 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
58 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
59 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
60 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
61 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
62 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
63 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
64 X_STATUS IN VARCHAR2,
65 X_SOURCE IN VARCHAR2,
66 X_GROUP_ID IN VARCHAR2,
67 X_WORKFLOW_FLAG IN VARCHAR2,
68 X_DOC_CATEGORY_CODE IN VARCHAR2,
69 X_VOUCHER_NUM IN VARCHAR2,
70 X_PAY_GROUP_LOOKUP_CODE IN VARCHAR2,
71 X_GOODS_RECEIVED_DATE IN DATE,
72 X_INVOICE_RECEIVED_DATE IN DATE,
73 X_GL_DATE IN DATE,
74 X_ACCTS_PAY_CCID IN NUMBER,
75 -- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
76 X_EXCLUSIVE_PAYMENT_FLAG IN VARCHAR2,
77 X_INVOICE_INCLUDES_PREPAY_FLAG IN VARCHAR2,
78 X_PREPAY_NUM IN VARCHAR2,
79 X_PREPAY_APPLY_AMOUNT IN NUMBER,
80 X_PREPAY_GL_DATE IN DATE,
81 X_CREATION_DATE IN DATE,
82 X_CREATED_BY IN NUMBER,
83 X_LAST_UPDATE_DATE IN DATE,
84 X_LAST_UPDATED_BY IN NUMBER,
85 X_LAST_UPDATE_LOGIN IN NUMBER,
86 X_ORG_ID IN NUMBER,
87 X_MODE IN VARCHAR2 DEFAULT 'R',
88 X_TERMS_DATE IN DATE DEFAULT NULL,
89 X_REQUESTER_ID IN NUMBER DEFAULT NULL,
90 X_OPERATING_UNIT IN VARCHAR2 DEFAULT NULL,
91 -- Invoice LINes Project Stage 1
92 X_PREPAY_LINE_NUM IN NUMBER DEFAULT NULL,
93 X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
94 X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
95 X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
96 -- eTax Uptake
97 X_CALC_TAX_DURING_IMPORT_FLAG IN VARCHAR2 DEFAULT NULL,
98 X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
99 X_ADD_TAX_TO_INV_AMT_FLAG IN VARCHAR2 DEFAULT NULL,
100 X_TAX_RELATED_INVOICE_ID IN NUMBER DEFAULT NULL,
101 X_TAXATION_COUNTRY IN VARCHAR2 DEFAULT NULL,
102 X_DOCUMENT_SUB_TYPE IN VARCHAR2 DEFAULT NULL,
103 X_SUPPLIER_TAX_INVOICE_NUMBER IN VARCHAR2 DEFAULT NULL,
104 X_SUPPLIER_TAX_INVOICE_DATE IN DATE DEFAULT NULL,
105 X_SUPPLIER_TAX_EXCHANGE_RATE IN NUMBER DEFAULT NULL,
106 X_TAX_INVOICE_RECORDING_DATE IN DATE DEFAULT NULL,
107 X_TAX_INVOICE_INTERNAL_SEQ IN VARCHAR2 DEFAULT NULL,
108 X_LEGAL_ENTITY_ID IN NUMBER DEFAULT NULL,
109 x_PAYMENT_METHOD_CODE in varchar2 default null,
110 x_PAYMENT_REASON_CODE in varchar2 default null,
111 X_PAYMENT_REASON_COMMENTS in varchar2 default null,
112 x_UNIQUE_REMITTANCE_IDENTIFIER in varchar2 default null,
113 x_URI_CHECK_DIGIT in varchar2 default null,
114 x_BANK_CHARGE_BEARER in varchar2 default null,
115 x_DELIVERY_CHANNEL_CODE in varchar2 default null,
116 x_SETTLEMENT_PRIORITY in varchar2 default null,
117 x_remittance_message1 in varchar2 default null,
118 x_remittance_message2 in varchar2 default null,
119 x_remittance_message3 in varchar2 default null,
120 x_NET_OF_RETAINAGE_FLAG in varchar2 default null,
121 x_PORT_OF_ENTRY_CODE in varchar2 default null,
122 X_APPLICATION_ID IN NUMBER DEFAULT NULL,
123 X_PRODUCT_TABLE IN VARCHAR2 DEFAULT NULL,
124 X_REFERENCE_KEY1 IN VARCHAR2 DEFAULT NULL,
125 X_REFERENCE_KEY2 IN VARCHAR2 DEFAULT NULL,
126 X_REFERENCE_KEY3 IN VARCHAR2 DEFAULT NULL,
127 X_REFERENCE_KEY4 IN VARCHAR2 DEFAULT NULL,
128 X_REFERENCE_KEY5 IN VARCHAR2 DEFAULT NULL,
129 X_PARTY_ID IN NUMBER DEFAULT NULL,
130 X_PARTY_SITE_ID IN NUMBER DEFAULT NULL,
131 X_PAY_PROC_TRXN_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
132 X_PAYMENT_FUNCTION IN VARCHAR2 DEFAULT NULL,
133 X_PAYMENT_PRIORITY IN NUMBER DEFAULT NULL,
134 x_external_bank_account_id in number default null,
135 X_REMIT_TO_SUPPLIER_NAME IN VARCHAR2 DEFAULT NULL,
136 X_REMIT_TO_SUPPLIER_ID IN NUMBER DEFAULT NULL,
137 X_REMIT_TO_SUPPLIER_SITE IN VARCHAR2 DEFAULT NULL,
138 X_REMIT_TO_SUPPLIER_SITE_ID IN NUMBER DEFAULT NULL,
139 X_RELATIONSHIP_ID IN NUMBER DEFAULT NULL
140 )
141 IS
142 CURSOR C IS
143 SELECT ROWID
144 FROM AP_INVOICES_INTERFACE
145 WHERE INVOICE_ID = X_INVOICE_ID;
146 BEGIN
147 INSERT INTO AP_INVOICES_INTERFACE (
148 INVOICE_ID,
149 INVOICE_NUM,
150 INVOICE_TYPE_LOOKUP_CODE,
151 INVOICE_DATE,
152 PO_NUMBER,
153 VENDOR_ID,
154 VENDOR_SITE_ID,
155 INVOICE_AMOUNT,
156 INVOICE_CURRENCY_CODE,
157 PAYMENT_CURRENCY_CODE,
158 PAYMENT_CROSS_RATE,
159 PAYMENT_CROSS_RATE_TYPE,
160 PAYMENT_CROSS_RATE_DATE,
161 EXCHANGE_RATE,
162 EXCHANGE_RATE_TYPE,
163 EXCHANGE_DATE,
164 TERMS_ID,
165 DESCRIPTION,
166 AWT_GROUP_ID,
167 PAY_AWT_GROUP_ID,--bug6639866
168 AMOUNT_APPLICABLE_TO_DISCOUNT,
169 ATTRIBUTE_CATEGORY,
170 ATTRIBUTE1,
171 ATTRIBUTE2,
172 ATTRIBUTE3,
173 ATTRIBUTE4,
174 ATTRIBUTE5,
175 ATTRIBUTE6,
176 ATTRIBUTE7,
177 ATTRIBUTE8,
178 ATTRIBUTE9,
179 ATTRIBUTE10,
180 ATTRIBUTE11,
181 ATTRIBUTE12,
182 ATTRIBUTE13,
183 ATTRIBUTE14,
184 ATTRIBUTE15,
185 GLOBAL_ATTRIBUTE_CATEGORY,
186 GLOBAL_ATTRIBUTE1,
187 GLOBAL_ATTRIBUTE2,
188 GLOBAL_ATTRIBUTE3,
189 GLOBAL_ATTRIBUTE4,
190 GLOBAL_ATTRIBUTE5,
191 GLOBAL_ATTRIBUTE6,
192 GLOBAL_ATTRIBUTE7,
193 GLOBAL_ATTRIBUTE8,
194 GLOBAL_ATTRIBUTE9,
195 GLOBAL_ATTRIBUTE10,
196 GLOBAL_ATTRIBUTE11,
197 GLOBAL_ATTRIBUTE12,
198 GLOBAL_ATTRIBUTE13,
199 GLOBAL_ATTRIBUTE14,
200 GLOBAL_ATTRIBUTE15,
201 GLOBAL_ATTRIBUTE16,
202 GLOBAL_ATTRIBUTE17,
203 GLOBAL_ATTRIBUTE18,
204 GLOBAL_ATTRIBUTE19,
205 GLOBAL_ATTRIBUTE20,
206 STATUS,
207 SOURCE,
208 GROUP_ID,
209 WORKFLOW_FLAG,
210 DOC_CATEGORY_CODE,
211 VOUCHER_NUM,
212 PAY_GROUP_LOOKUP_CODE,
213 GOODS_RECEIVED_DATE,
214 INVOICE_RECEIVED_DATE,
215 GL_DATE ,
216 ACCTS_PAY_CODE_COMBINATION_ID ,
217 -- USSGL_TRANSACTION_CODE , - Bug 4277744
218 EXCLUSIVE_PAYMENT_FLAG,
219 INVOICE_INCLUDES_PREPAY_FLAG ,
220 PREPAY_NUM,
221 PREPAY_APPLY_AMOUNT,
222 PREPAY_GL_DATE,
223 CREATION_DATE,
224 CREATED_BY,
225 LAST_UPDATE_DATE,
226 LAST_UPDATED_BY,
227 LAST_UPDATE_LOGIN,
228 ORG_ID,
229 TERMS_DATE ,
230 REQUESTER_ID,
231 OPERATING_UNIT,
232 -- Invoice Lines Project Stage 1
233 PREPAY_LINE_NUM,
234 REQUESTER_FIRST_NAME,
235 REQUESTER_LAST_NAME,
236 REQUESTER_EMPLOYEE_NUM,
237 -- eTax Uptake
238 CALC_TAX_DURING_IMPORT_FLAG,
239 CONTROL_AMOUNT,
240 ADD_TAX_TO_INV_AMT_FLAG,
241 TAX_RELATED_INVOICE_ID,
242 TAXATION_COUNTRY,
243 DOCUMENT_SUB_TYPE,
244 SUPPLIER_TAX_INVOICE_NUMBER,
245 SUPPLIER_TAX_INVOICE_DATE,
246 SUPPLIER_TAX_EXCHANGE_RATE,
247 TAX_INVOICE_RECORDING_DATE,
248 TAX_INVOICE_INTERNAL_SEQ,
249 LEGAL_ENTITY_ID,
250 PAYMENT_METHOD_CODE,
251 PAYMENT_REASON_CODE,
252 PAYMENT_REASON_COMMENTS,
253 UNIQUE_REMITTANCE_IDENTIFIER,
254 URI_CHECK_DIGIT,
255 BANK_CHARGE_BEARER,
256 DELIVERY_CHANNEL_CODE,
257 SETTLEMENT_PRIORITY,
258 REMITTANCE_MESSAGE1,
259 REMITTANCE_MESSAGE2,
260 REMITTANCE_MESSAGE3,
261 NET_OF_RETAINAGE_FLAG,
262 PORT_OF_ENTRY_CODE,
263 APPLICATION_ID,
264 PRODUCT_TABLE,
265 REFERENCE_KEY1,
266 REFERENCE_KEY2,
267 REFERENCE_KEY3,
268 REFERENCE_KEY4,
269 REFERENCE_KEY5,
270 PARTY_ID,
271 PARTY_SITE_ID,
272 PAY_PROC_TRXN_TYPE_CODE,
273 PAYMENT_FUNCTION,
274 PAYMENT_PRIORITY,
275 external_bank_account_id,
276 REMIT_TO_SUPPLIER_NAME,
277 REMIT_TO_SUPPLIER_ID,
278 REMIT_TO_SUPPLIER_SITE,
279 REMIT_TO_SUPPLIER_SITE_ID,
280 RELATIONSHIP_ID
281 )
282 VALUES (
283 X_INVOICE_ID,
284 X_INVOICE_NUM,
285 X_INVOICE_TYPE_LOOKUP_CODE,
286 X_INVOICE_DATE,
287 X_PO_NUMBER,
288 X_VENDOR_ID,
289 X_VENDOR_SITE_ID,
290 X_INVOICE_AMOUNT,
291 X_INVOICE_CURRENCY_CODE,
292 X_PAYMENT_CURRENCY_CODE,
293 X_PAYMENT_CROSS_RATE,
294 X_PAYMENT_CROSS_RATE_TYPE,
295 X_PAYMENT_CROSS_RATE_DATE,
296 X_EXCHANGE_RATE,
297 X_EXCHANGE_RATE_TYPE,
298 X_EXCHANGE_DATE,
299 X_TERMS_ID,
300 X_DESCRIPTION,
301 X_AWT_GROUP_ID,
302 X_PAY_AWT_GROUP_ID, --bug6639866
303 X_AMT_APPLICABLE_TO_DISCOUNT,
304 X_ATTRIBUTE_CATEGORY,
305 X_ATTRIBUTE1,
306 X_ATTRIBUTE2,
307 X_ATTRIBUTE3,
308 X_ATTRIBUTE4,
309 X_ATTRIBUTE5,
310 X_ATTRIBUTE6,
311 X_ATTRIBUTE7,
312 X_ATTRIBUTE8,
313 X_ATTRIBUTE9,
314 X_ATTRIBUTE10,
315 X_ATTRIBUTE11,
316 X_ATTRIBUTE12,
317 X_ATTRIBUTE13,
318 X_ATTRIBUTE14,
319 X_ATTRIBUTE15,
320 X_GLOBAL_ATTRIBUTE_CATEGORY,
321 X_GLOBAL_ATTRIBUTE1,
322 X_GLOBAL_ATTRIBUTE2,
323 X_GLOBAL_ATTRIBUTE3,
324 X_GLOBAL_ATTRIBUTE4,
325 X_GLOBAL_ATTRIBUTE5,
326 X_GLOBAL_ATTRIBUTE6,
327 X_GLOBAL_ATTRIBUTE7,
328 X_GLOBAL_ATTRIBUTE8,
329 X_GLOBAL_ATTRIBUTE9,
330 X_GLOBAL_ATTRIBUTE10,
331 X_GLOBAL_ATTRIBUTE11,
332 X_GLOBAL_ATTRIBUTE12,
333 X_GLOBAL_ATTRIBUTE13,
334 X_GLOBAL_ATTRIBUTE14,
335 X_GLOBAL_ATTRIBUTE15,
336 X_GLOBAL_ATTRIBUTE16,
337 X_GLOBAL_ATTRIBUTE17,
338 X_GLOBAL_ATTRIBUTE18,
339 X_GLOBAL_ATTRIBUTE19,
340 X_GLOBAL_ATTRIBUTE20,
341 X_STATUS,
342 X_SOURCE,
343 X_GROUP_ID,
344 X_WORKFLOW_FLAG,
345 X_DOC_CATEGORY_CODE,
346 X_VOUCHER_NUM,
347 X_PAY_GROUP_LOOKUP_CODE,
348 X_GOODS_RECEIVED_DATE,
349 X_INVOICE_RECEIVED_DATE,
350 X_GL_DATE ,
351 X_ACCTS_PAY_CCID ,
352 -- X_USSGL_TRANSACTION_CODE , - Bug 4277744
353 X_EXCLUSIVE_PAYMENT_FLAG ,
354 X_INVOICE_INCLUDES_PREPAY_FLAG ,
355 X_PREPAY_NUM,
356 X_PREPAY_APPLY_AMOUNT,
357 X_PREPAY_GL_DATE,
358 X_Creation_Date,
359 X_Created_By,
360 X_LAST_UPDATE_DATE,
364 X_TERMS_DATE,
361 X_LAST_UPDATED_BY,
362 X_LAST_UPDATE_LOGIN,
363 X_ORG_ID,
365 X_REQUESTER_ID,
366 X_OPERATING_UNIT,
367 -- Invoice Lines Project Stage 1
368 X_PREPAY_LINE_NUM,
369 X_REQUESTER_FIRST_NAME,
370 X_REQUESTER_LAST_NAME,
371 X_REQUESTER_EMPLOYEE_NUM,
372 -- eTax Uptake
373 X_CALC_TAX_DURING_IMPORT_FLAG,
374 X_CONTROL_AMOUNT,
375 X_ADD_TAX_TO_INV_AMT_FLAG,
376 X_TAX_RELATED_INVOICE_ID,
377 X_TAXATION_COUNTRY,
378 X_DOCUMENT_SUB_TYPE,
379 X_SUPPLIER_TAX_INVOICE_NUMBER,
380 X_SUPPLIER_TAX_INVOICE_DATE,
381 X_SUPPLIER_TAX_EXCHANGE_RATE,
382 X_TAX_INVOICE_RECORDING_DATE,
383 X_TAX_INVOICE_INTERNAL_SEQ,
384 X_LEGAL_ENTITY_ID,
385 x_PAYMENT_METHOD_CODE,
386 x_PAYMENT_REASON_CODE,
387 X_PAYMENT_REASON_COMMENTS,
388 x_UNIQUE_REMITTANCE_IDENTIFIER,
389 x_URI_CHECK_DIGIT,
390 x_BANK_CHARGE_BEARER,
391 x_DELIVERY_CHANNEL_CODE,
392 x_SETTLEMENT_PRIORITY,
393 X_REMITTANCE_MESSAGE1,
394 X_REMITTANCE_MESSAGE2,
395 X_REMITTANCE_MESSAGE3,
396 x_NET_OF_RETAINAGE_FLAG,
397 x_PORT_OF_ENTRY_CODE,
398 X_APPLICATION_ID,
399 X_PRODUCT_TABLE,
400 X_REFERENCE_KEY1,
401 X_REFERENCE_KEY2,
402 X_REFERENCE_KEY3,
403 X_REFERENCE_KEY4,
404 X_REFERENCE_KEY5,
405 X_PARTY_ID,
406 X_PARTY_SITE_ID,
407 X_PAY_PROC_TRXN_TYPE_CODE,
408 X_PAYMENT_FUNCTION,
409 X_PAYMENT_PRIORITY,
410 x_external_bank_account_id,
411 X_REMIT_TO_SUPPLIER_NAME,
412 X_REMIT_TO_SUPPLIER_ID,
413 X_REMIT_TO_SUPPLIER_SITE,
414 X_REMIT_TO_SUPPLIER_SITE_ID,
415 X_RELATIONSHIP_ID);
416
417 OPEN c;
418 FETCH c INTO X_ROWID;
419 IF (c%notfound) THEN
420 CLOSE c;
421 RAISE NO_DATA_FOUND;
422 END IF;
423 CLOSE c;
424
425 END INSERT_ROW;
426
427
428 procedure LOCK_ROW (
429 X_INVOICE_ID IN NUMBER,
430 X_INVOICE_NUM IN VARCHAR2,
431 X_INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2,
432 X_INVOICE_DATE IN DATE,
433 X_PO_NUMBER IN VARCHAR2,
434 X_VENDOR_ID IN NUMBER,
435 X_VENDOR_SITE_ID IN NUMBER,
436 X_INVOICE_AMOUNT IN NUMBER,
437 X_INVOICE_CURRENCY_CODE IN VARCHAR2,
438 X_PAYMENT_CURRENCY_CODE IN VARCHAR2,
439 X_PAYMENT_CROSS_RATE IN NUMBER,
440 X_PAYMENT_CROSS_RATE_TYPE IN VARCHAR2,
441 X_PAYMENT_CROSS_RATE_DATE IN DATE,
442 X_EXCHANGE_RATE IN NUMBER,
443 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
444 X_EXCHANGE_DATE IN DATE,
445 X_TERMS_ID IN NUMBER,
446 X_DESCRIPTION IN VARCHAR2,
447 X_AWT_GROUP_ID IN NUMBER,
448 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
449 X_AMT_APPLICABLE_TO_DISCOUNT IN NUMBER,
450 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
451 X_ATTRIBUTE1 IN VARCHAR2,
452 X_ATTRIBUTE2 IN VARCHAR2,
453 X_ATTRIBUTE3 IN VARCHAR2,
454 X_ATTRIBUTE4 IN VARCHAR2,
455 X_ATTRIBUTE5 IN VARCHAR2,
456 X_ATTRIBUTE6 IN VARCHAR2,
457 X_ATTRIBUTE7 IN VARCHAR2,
458 X_ATTRIBUTE8 IN VARCHAR2,
459 X_ATTRIBUTE9 IN VARCHAR2,
460 X_ATTRIBUTE10 IN VARCHAR2,
461 X_ATTRIBUTE11 IN VARCHAR2,
462 X_ATTRIBUTE12 IN VARCHAR2,
463 X_ATTRIBUTE13 IN VARCHAR2,
464 X_ATTRIBUTE14 IN VARCHAR2,
465 X_ATTRIBUTE15 IN VARCHAR2,
466 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
467 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
468 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
469 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
470 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
471 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
472 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
473 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
474 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
475 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
476 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
477 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
478 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
479 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
483 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
480 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
481 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
482 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
484 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
485 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
486 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
487 X_STATUS IN VARCHAR2,
488 X_SOURCE IN VARCHAR2,
489 X_GROUP_ID IN VARCHAR2,
490 X_WORKFLOW_FLAG IN VARCHAR2,
491 X_DOC_CATEGORY_CODE IN VARCHAR2,
492 X_VOUCHER_NUM IN VARCHAR2,
493 X_PAY_GROUP_LOOKUP_CODE IN VARCHAR2,
494 X_GOODS_RECEIVED_DATE IN DATE,
495 X_INVOICE_RECEIVED_DATE IN DATE,
496 X_GL_DATE IN DATE,
497 X_ACCTS_PAY_CCID IN NUMBER,
498 -- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
499 X_EXCLUSIVE_PAYMENT_FLAG IN VARCHAR2,
500 X_INVOICE_INCLUDES_PREPAY_FLAG IN VARCHAR2,
501 X_PREPAY_NUM IN VARCHAR2,
502 X_PREPAY_APPLY_AMOUNT IN NUMBER,
503 X_PREPAY_GL_DATE IN DATE,
504 X_TERMS_DATE IN DATE DEFAULT NULL,
505 X_REQUESTER_ID IN NUMBER DEFAULT NULL,
506 X_OPERATING_UNIT IN VARCHAR2 DEFAULT NULL,
507 -- Invoice LINes Project Stage 1
508 X_PREPAY_LINE_NUM IN NUMBER DEFAULT NULL,
509 X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
510 X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
511 X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
512 -- eTax Uptake
513 X_CALC_TAX_DURING_IMPORT_FLAG IN VARCHAR2 DEFAULT NULL,
514 X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
515 X_ADD_TAX_TO_INV_AMT_FLAG IN VARCHAR2 DEFAULT NULL,
516 X_TAX_RELATED_INVOICE_ID IN NUMBER DEFAULT NULL,
517 X_TAXATION_COUNTRY IN VARCHAR2 DEFAULT NULL,
518 X_DOCUMENT_SUB_TYPE IN VARCHAR2 DEFAULT NULL,
519 X_SUPPLIER_TAX_INVOICE_NUMBER IN VARCHAR2 DEFAULT NULL,
520 X_SUPPLIER_TAX_INVOICE_DATE IN DATE DEFAULT NULL,
521 X_SUPPLIER_TAX_EXCHANGE_RATE IN NUMBER DEFAULT NULL,
522 X_TAX_INVOICE_RECORDING_DATE IN DATE DEFAULT NULL,
523 X_TAX_INVOICE_INTERNAL_SEQ IN VARCHAR2 DEFAULT NULL,
524 X_LEGAL_ENTITY_ID IN NUMBER DEFAULT NULL,
525 x_PAYMENT_METHOD_CODE in varchar2 default null,
526 x_PAYMENT_REASON_CODE in varchar2 default null,
527 X_PAYMENT_REASON_COMMENTS in varchar2 default null,
528 x_UNIQUE_REMITTANCE_IDENTIFIER in varchar2 default null,
529 x_URI_CHECK_DIGIT in varchar2 default null,
530 x_BANK_CHARGE_BEARER in varchar2 default null,
531 x_DELIVERY_CHANNEL_CODE in varchar2 default null,
532 x_SETTLEMENT_PRIORITY in varchar2 default null,
533 x_remittance_message1 in varchar2 default null,
534 x_remittance_message2 in varchar2 default null,
535 x_remittance_message3 in varchar2 default null,
536 x_NET_OF_RETAINAGE_FLAG in varchar2 default null,
537 x_PORT_OF_ENTRY_CODE in varchar2 default null,
538 X_APPLICATION_ID IN NUMBER DEFAULT NULL,
539 X_PRODUCT_TABLE IN VARCHAR2 DEFAULT NULL,
540 X_REFERENCE_KEY1 IN VARCHAR2 DEFAULT NULL,
541 X_REFERENCE_KEY2 IN VARCHAR2 DEFAULT NULL,
542 X_REFERENCE_KEY3 IN VARCHAR2 DEFAULT NULL,
543 X_REFERENCE_KEY4 IN VARCHAR2 DEFAULT NULL,
544 X_REFERENCE_KEY5 IN VARCHAR2 DEFAULT NULL,
545 X_PARTY_ID IN NUMBER DEFAULT NULL,
546 X_PARTY_SITE_ID IN NUMBER DEFAULT NULL,
547 X_PAY_PROC_TRXN_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
548 X_PAYMENT_FUNCTION IN VARCHAR2 DEFAULT NULL,
549 X_PAYMENT_PRIORITY IN NUMBER DEFAULT NULL,
550 x_external_bank_account_id in number default null,
551 X_REMIT_TO_SUPPLIER_NAME IN VARCHAR2 DEFAULT NULL,
552 X_REMIT_TO_SUPPLIER_ID IN NUMBER DEFAULT NULL,
553 X_REMIT_TO_SUPPLIER_SITE IN VARCHAR2 DEFAULT NULL,
554 X_REMIT_TO_SUPPLIER_SITE_ID IN NUMBER DEFAULT NULL,
555 X_RELATIONSHIP_ID IN NUMBER DEFAULT NULL)
556
557 IS
558 CURSOR c1 IS SELECT
559 INVOICE_NUM,
560 INVOICE_TYPE_LOOKUP_CODE,
561 INVOICE_DATE,
562 PO_NUMBER,
563 VENDOR_ID,
564 VENDOR_SITE_ID,
565 INVOICE_AMOUNT,
566 INVOICE_CURRENCY_CODE,
567 PAYMENT_CURRENCY_CODE,
568 PAYMENT_CROSS_RATE,
572 EXCHANGE_RATE_TYPE,
569 PAYMENT_CROSS_RATE_TYPE,
570 PAYMENT_CROSS_RATE_DATE,
571 EXCHANGE_RATE,
573 EXCHANGE_DATE,
574 TERMS_ID,
575 DESCRIPTION,
576 AWT_GROUP_ID,
577 PAY_AWT_GROUP_ID, --bug6639866
578 AMOUNT_APPLICABLE_TO_DISCOUNT,
579 ATTRIBUTE_CATEGORY,
580 ATTRIBUTE1,
581 ATTRIBUTE2,
582 ATTRIBUTE3,
583 ATTRIBUTE4,
584 ATTRIBUTE5,
585 ATTRIBUTE6,
586 ATTRIBUTE7,
587 ATTRIBUTE8,
588 ATTRIBUTE9,
589 ATTRIBUTE10,
590 ATTRIBUTE11,
591 ATTRIBUTE12,
592 ATTRIBUTE13,
593 ATTRIBUTE14,
594 ATTRIBUTE15,
595 GLOBAL_ATTRIBUTE_CATEGORY,
596 GLOBAL_ATTRIBUTE1,
597 GLOBAL_ATTRIBUTE2,
598 GLOBAL_ATTRIBUTE3,
599 GLOBAL_ATTRIBUTE4,
600 GLOBAL_ATTRIBUTE5,
601 GLOBAL_ATTRIBUTE6,
602 GLOBAL_ATTRIBUTE7,
603 GLOBAL_ATTRIBUTE8,
604 GLOBAL_ATTRIBUTE9,
605 GLOBAL_ATTRIBUTE10,
606 GLOBAL_ATTRIBUTE11,
607 GLOBAL_ATTRIBUTE12,
608 GLOBAL_ATTRIBUTE13,
609 GLOBAL_ATTRIBUTE14,
610 GLOBAL_ATTRIBUTE15,
611 GLOBAL_ATTRIBUTE16,
612 GLOBAL_ATTRIBUTE17,
613 GLOBAL_ATTRIBUTE18,
614 GLOBAL_ATTRIBUTE19,
615 GLOBAL_ATTRIBUTE20,
616 STATUS,
617 SOURCE,
618 GROUP_ID,
619 WORKFLOW_FLAG,
620 DOC_CATEGORY_CODE,
621 VOUCHER_NUM,
622 PAY_GROUP_LOOKUP_CODE,
623 GOODS_RECEIVED_DATE,
624 INVOICE_RECEIVED_DATE,
625 GL_DATE ,
626 ACCTS_PAY_CODE_COMBINATION_ID ,
627 -- USSGL_TRANSACTION_CODE , - Bug 4277744
628 EXCLUSIVE_PAYMENT_FLAG,
629 INVOICE_INCLUDES_PREPAY_FLAG,
630 PREPAY_NUM,
631 PREPAY_APPLY_AMOUNT,
632 PREPAY_GL_DATE,
633 TERMS_DATE ,
634 REQUESTER_ID,
635 OPERATING_UNIT,
636 -- Invoice Lines Project Stage 1
637 PREPAY_LINE_NUM,
638 REQUESTER_FIRST_NAME,
639 REQUESTER_LAST_NAME,
640 REQUESTER_EMPLOYEE_NUM,
641 -- eTax Uptake
642 CALC_TAX_DURING_IMPORT_FLAG,
643 CONTROL_AMOUNT,
644 ADD_TAX_TO_INV_AMT_FLAG,
645 TAX_RELATED_INVOICE_ID,
646 TAXATION_COUNTRY,
647 DOCUMENT_SUB_TYPE,
648 SUPPLIER_TAX_INVOICE_NUMBER,
649 SUPPLIER_TAX_INVOICE_DATE,
650 SUPPLIER_TAX_EXCHANGE_RATE,
651 TAX_INVOICE_RECORDING_DATE,
652 TAX_INVOICE_INTERNAL_SEQ,
653 LEGAL_ENTITY_ID,
654 PAYMENT_METHOD_CODE,
655 PAYMENT_REASON_CODE,
656 PAYMENT_REASON_COMMENTS,
657 UNIQUE_REMITTANCE_IDENTIFIER,
658 URI_CHECK_DIGIT,
659 BANK_CHARGE_BEARER,
660 DELIVERY_CHANNEL_CODE,
661 SETTLEMENT_PRIORITY,
662 REMITTANCE_MESSAGE1,
663 REMITTANCE_MESSAGE2,
664 REMITTANCE_MESSAGE3,
665 NET_OF_RETAINAGE_FLAG,
666 PORT_OF_ENTRY_CODE,
667 APPLICATION_ID,
668 PRODUCT_TABLE,
669 REFERENCE_KEY1,
670 REFERENCE_KEY2,
671 REFERENCE_KEY3,
672 REFERENCE_KEY4,
673 REFERENCE_KEY5,
674 PARTY_ID,
675 PARTY_SITE_ID,
676 PAY_PROC_TRXN_TYPE_CODE,
677 PAYMENT_FUNCTION,
678 PAYMENT_PRIORITY,
679 external_bank_account_id,
680 REMIT_TO_SUPPLIER_NAME,
681 REMIT_TO_SUPPLIER_ID,
682 REMIT_TO_SUPPLIER_SITE,
683 REMIT_TO_SUPPLIER_SITE_ID,
684 RELATIONSHIP_ID
685 FROM AP_INVOICES_INTERFACE
686 WHERE INVOICE_ID = X_INVOICE_ID
687 FOR UPDATE OF INVOICE_ID nowait;
688
689 tlinfo c1%rowtype;
690
691 BEGIN
692 OPEN c1;
693 FETCH c1 INTO tlinfo;
694 IF (c1%notfound) THEN
695 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
696 app_exception.raise_exception;
697 close c1;
698 RETURN;
699 END IF;
700 CLOSE c1;
701
702 IF ( ((tlinfo.INVOICE_NUM = X_INVOICE_NUM)
703 OR ((tlinfo.INVOICE_NUM is null)
704 AND (X_INVOICE_NUM is null)))
705 AND ((tlinfo.INVOICE_TYPE_LOOKUP_CODE = X_INVOICE_TYPE_LOOKUP_CODE)
706 OR ((tlinfo.INVOICE_TYPE_LOOKUP_CODE is null)
707 AND (X_INVOICE_TYPE_LOOKUP_CODE is null)))
708 AND ((tlinfo.INVOICE_DATE = X_INVOICE_DATE)
709 OR ((tlinfo.INVOICE_DATE is null)
710 AND (X_INVOICE_DATE is null)))
711 AND ((tlinfo.PO_NUMBER = X_PO_NUMBER)
712 OR ((tlinfo.PO_NUMBER is null)
713 AND (X_PO_NUMBER is null)))
714 AND ((tlinfo.VENDOR_ID = X_VENDOR_ID)
715 OR ((tlinfo.VENDOR_ID is null)
716 AND (X_VENDOR_ID is null)))
717 AND ((tlinfo.VENDOR_SITE_ID = X_VENDOR_SITE_ID)
718 OR ((tlinfo.VENDOR_SITE_ID is null)
719 AND (X_VENDOR_SITE_ID is null)))
720 AND ((tlinfo.INVOICE_AMOUNT = X_INVOICE_AMOUNT)
724 OR ((tlinfo.INVOICE_CURRENCY_CODE is null)
721 OR ((tlinfo.INVOICE_AMOUNT is null)
722 AND (X_INVOICE_AMOUNT is null)))
723 AND ((tlinfo.INVOICE_CURRENCY_CODE = X_INVOICE_CURRENCY_CODE)
725 AND (X_INVOICE_CURRENCY_CODE is null)))
726 AND ((tlinfo.PAYMENT_CURRENCY_CODE = X_PAYMENT_CURRENCY_CODE)
727 OR ((tlinfo.PAYMENT_CURRENCY_CODE is null)
728 AND (X_PAYMENT_CURRENCY_CODE is null)))
729 AND ((tlinfo.PAYMENT_CROSS_RATE = X_PAYMENT_CROSS_RATE)
730 OR ((tlinfo.PAYMENT_CROSS_RATE is null)
731 AND (X_PAYMENT_CROSS_RATE is null)))
732 AND ((tlinfo.PAYMENT_CROSS_RATE_TYPE = X_PAYMENT_CROSS_RATE_TYPE)
733 OR ((tlinfo.PAYMENT_CROSS_RATE_TYPE is null)
734 AND (X_PAYMENT_CROSS_RATE_TYPE is null)))
735 AND ((tlinfo.PAYMENT_CROSS_RATE_DATE = X_PAYMENT_CROSS_RATE_DATE)
736 OR ((tlinfo.PAYMENT_CROSS_RATE_DATE is null)
737 AND (X_PAYMENT_CROSS_RATE_DATE is null)))
738 AND ((tlinfo.EXCHANGE_RATE = X_EXCHANGE_RATE)
739 OR ((tlinfo.EXCHANGE_RATE is null)
740 AND (X_EXCHANGE_RATE is null)))
741 AND ((tlinfo.EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE)
742 OR ((tlinfo.EXCHANGE_RATE_TYPE is null)
743 AND (X_EXCHANGE_RATE_TYPE is null)))
744 AND ((tlinfo.EXCHANGE_DATE = X_EXCHANGE_DATE)
745 OR ((tlinfo.EXCHANGE_DATE is null)
746 AND (X_EXCHANGE_DATE is null)))
747 AND ((tlinfo.TERMS_ID = X_TERMS_ID)
748 OR ((tlinfo.TERMS_ID is null)
749 AND (X_TERMS_ID is null)))
750 AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
751 OR ((tlinfo.DESCRIPTION is null)
752 AND (X_DESCRIPTION is null)))
753 AND ((tlinfo.PAY_AWT_GROUP_ID = X_PAY_AWT_GROUP_ID)
754 OR ((tlinfo.PAY_AWT_GROUP_ID is null)
755 AND (X_PAY_AWT_GROUP_ID is null))) --bug6639866
756 AND ((tlinfo.AWT_GROUP_ID = X_AWT_GROUP_ID)
757 OR ((tlinfo.AWT_GROUP_ID is null)
758 AND (X_AWT_GROUP_ID is null)))
759 AND ((tlinfo.AMOUNT_APPLICABLE_TO_DISCOUNT =
760 X_AMT_APPLICABLE_TO_DISCOUNT)
761 OR ((tlinfo.AMOUNT_APPLICABLE_TO_DISCOUNT is null)
762 AND (X_AMT_APPLICABLE_TO_DISCOUNT is null)))
763 AND ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
764 OR ((tlinfo.ATTRIBUTE_CATEGORY is null)
765 AND (X_ATTRIBUTE_CATEGORY is null)))
766 AND ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
767 OR ((tlinfo.ATTRIBUTE1 is null)
768 AND (X_ATTRIBUTE1 is null)))
769 AND ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
770 OR ((tlinfo.ATTRIBUTE2 is null)
771 AND (X_ATTRIBUTE2 is null)))
772 AND ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
773 OR ((tlinfo.ATTRIBUTE3 is null)
774 AND (X_ATTRIBUTE3 is null)))
775 AND ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
776 OR ((tlinfo.ATTRIBUTE4 is null)
777 AND (X_ATTRIBUTE4 is null)))
778 AND ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
779 OR ((tlinfo.ATTRIBUTE5 is null)
780 AND (X_ATTRIBUTE5 is null)))
781 AND ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
782 OR ((tlinfo.ATTRIBUTE6 is null)
783 AND (X_ATTRIBUTE6 is null)))
784 AND ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
785 OR ((tlinfo.ATTRIBUTE7 is null)
786 AND (X_ATTRIBUTE7 is null)))
787 AND ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
788 OR ((tlinfo.ATTRIBUTE8 is null)
789 AND (X_ATTRIBUTE8 is null)))
790 AND ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
791 OR ((tlinfo.ATTRIBUTE9 is null)
792 AND (X_ATTRIBUTE9 is null)))
793 AND ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
794 OR ((tlinfo.ATTRIBUTE10 is null)
795 AND (X_ATTRIBUTE10 is null)))
796 AND ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
797 OR ((tlinfo.ATTRIBUTE11 is null)
798 AND (X_ATTRIBUTE11 is null)))
799 AND ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
800 OR ((tlinfo.ATTRIBUTE12 is null)
801 AND (X_ATTRIBUTE12 is null)))
802 AND ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
803 OR ((tlinfo.ATTRIBUTE13 is null)
804 AND (X_ATTRIBUTE13 is null)))
805 AND ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
806 OR ((tlinfo.ATTRIBUTE14 is null)
807 AND (X_ATTRIBUTE14 is null)))
808 AND ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
809 OR ((tlinfo.ATTRIBUTE15 is null)
810 AND (X_ATTRIBUTE15 is null)))
811 AND ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY =
812 X_GLOBAL_ATTRIBUTE_CATEGORY)
813 OR ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY is null)
814 AND (X_GLOBAL_ATTRIBUTE_CATEGORY is null)))
815 AND ((tlinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1)
816 OR ((tlinfo.GLOBAL_ATTRIBUTE1 is null)
817 AND (X_GLOBAL_ATTRIBUTE1 is null)))
818 AND ((tlinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2)
819 OR ((tlinfo.GLOBAL_ATTRIBUTE2 is null)
820 AND (X_GLOBAL_ATTRIBUTE2 is null)))
821 AND ((tlinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3)
822 OR ((tlinfo.GLOBAL_ATTRIBUTE3 is null)
823 AND (X_GLOBAL_ATTRIBUTE3 is null)))
827 AND ((tlinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5)
824 AND ((tlinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4)
825 OR ((tlinfo.GLOBAL_ATTRIBUTE4 is null)
826 AND (X_GLOBAL_ATTRIBUTE4 is null)))
828 OR ((tlinfo.GLOBAL_ATTRIBUTE5 is null)
829 AND (X_GLOBAL_ATTRIBUTE5 is null)))
830 AND ((tlinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6)
831 OR ((tlinfo.GLOBAL_ATTRIBUTE6 is null)
832 AND (X_GLOBAL_ATTRIBUTE6 is null)))
833 AND ((tlinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7)
834 OR ((tlinfo.GLOBAL_ATTRIBUTE7 is null)
835 AND (X_GLOBAL_ATTRIBUTE7 is null)))
836 AND ((tlinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8)
837 OR ((tlinfo.GLOBAL_ATTRIBUTE8 is null)
838 AND (X_GLOBAL_ATTRIBUTE8 is null)))
839 AND ((tlinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9)
840 OR ((tlinfo.GLOBAL_ATTRIBUTE9 is null)
841 AND (X_GLOBAL_ATTRIBUTE9 is null)))
842 AND ((tlinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10)
843 OR ((tlinfo.GLOBAL_ATTRIBUTE10 is null)
844 AND (X_GLOBAL_ATTRIBUTE10 is null)))
845 AND ((tlinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11)
846 OR ((tlinfo.GLOBAL_ATTRIBUTE11 is null)
847 AND (X_GLOBAL_ATTRIBUTE11 is null)))
848 AND ((tlinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12)
849 OR ((tlinfo.GLOBAL_ATTRIBUTE12 is null)
850 AND (X_GLOBAL_ATTRIBUTE12 is null)))
851 AND ((tlinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13)
852 OR ((tlinfo.GLOBAL_ATTRIBUTE13 is null)
853 AND (X_GLOBAL_ATTRIBUTE13 is null)))
854 AND ((tlinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14)
855 OR ((tlinfo.GLOBAL_ATTRIBUTE14 is null)
856 AND (X_GLOBAL_ATTRIBUTE14 is null)))
857 AND ((tlinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15)
858 OR ((tlinfo.GLOBAL_ATTRIBUTE15 is null)
859 AND (X_GLOBAL_ATTRIBUTE15 is null)))
860 AND ((tlinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16)
861 OR ((tlinfo.GLOBAL_ATTRIBUTE16 is null)
862 AND (X_GLOBAL_ATTRIBUTE16 is null)))
863 AND ((tlinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17)
864 OR ((tlinfo.GLOBAL_ATTRIBUTE17 is null)
865 AND (X_GLOBAL_ATTRIBUTE17 is null)))
866 AND ((tlinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18)
867 OR ((tlinfo.GLOBAL_ATTRIBUTE18 is null)
868 AND (X_GLOBAL_ATTRIBUTE18 is null)))
869 AND ((tlinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19)
870 OR ((tlinfo.GLOBAL_ATTRIBUTE19 is null)
871 AND (X_GLOBAL_ATTRIBUTE19 is null)))
872 AND ((tlinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20)
873 OR ((tlinfo.GLOBAL_ATTRIBUTE20 is null)
874 AND (X_GLOBAL_ATTRIBUTE20 is null)))
875 AND ((tlinfo.STATUS = X_STATUS)
876 OR ((tlinfo.STATUS is null)
877 AND (X_STATUS is null)))
878 AND ((tlinfo.SOURCE = X_SOURCE)
879 OR ((tlinfo.SOURCE is null)
880 AND (X_SOURCE is null)))
881 AND ((tlinfo.GROUP_ID = X_GROUP_ID)
882 OR ((tlinfo.GROUP_ID is null)
883 AND (X_GROUP_ID is null)))
884 AND ((tlinfo.WORKFLOW_FLAG = X_WORKFLOW_FLAG)
885 OR ((tlinfo.WORKFLOW_FLAG is null)
886 AND (X_WORKFLOW_FLAG is null)))
887 AND ((tlinfo.DOC_CATEGORY_CODE = X_DOC_CATEGORY_CODE)
888 OR ((tlinfo.DOC_CATEGORY_CODE is null)
889 AND (X_DOC_CATEGORY_CODE is null)))
890 AND ((tlinfo.VOUCHER_NUM = X_VOUCHER_NUM)
891 OR ((tlinfo.VOUCHER_NUM is null)
892 AND (X_VOUCHER_NUM is null)))
893 AND ((tlinfo.PAY_GROUP_LOOKUP_CODE = X_PAY_GROUP_LOOKUP_CODE)
894 OR ((tlinfo.PAY_GROUP_LOOKUP_CODE is null)
895 AND (X_PAY_GROUP_LOOKUP_CODE is null)))
896 AND ((tlinfo.GOODS_RECEIVED_DATE = X_GOODS_RECEIVED_DATE)
897 OR ((tlinfo.GOODS_RECEIVED_DATE is null)
898 AND (X_GOODS_RECEIVED_DATE is null)))
899 AND ((tlinfo.INVOICE_RECEIVED_DATE = X_INVOICE_RECEIVED_DATE)
900 OR ((tlinfo.INVOICE_RECEIVED_DATE is null)
901 AND (X_INVOICE_RECEIVED_DATE is null)))
902 AND ((tlinfo.GL_DATE = X_GL_DATE)
903 OR ((tlinfo.GL_DATE is null)
904 AND (X_GL_DATE is null)))
905 AND ((tlinfo.ACCTS_PAY_CODE_COMBINATION_ID = X_ACCTS_PAY_CCID)
906 OR ((tlinfo.ACCTS_PAY_CODE_COMBINATION_ID is null)
907 AND (X_ACCTS_PAY_CCID is null)))
908 -- Removed for bug 4277744
909 -- AND ((tlinfo.USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE)
910 -- OR ((tlinfo.USSGL_TRANSACTION_CODE is null)
911 -- AND (X_USSGL_TRANSACTION_CODE is null)))
912 AND ((tlinfo.EXCLUSIVE_PAYMENT_FLAG = X_EXCLUSIVE_PAYMENT_FLAG)
913 OR ((tlinfo.EXCLUSIVE_PAYMENT_FLAG is null)
914 AND (X_EXCLUSIVE_PAYMENT_FLAG is null)))
915 AND ((tlinfo.INVOICE_INCLUDES_PREPAY_FLAG =
916 X_INVOICE_INCLUDES_PREPAY_FLAG)
917 OR ((tlinfo.INVOICE_INCLUDES_PREPAY_FLAG is null)
918 AND (X_INVOICE_INCLUDES_PREPAY_FLAG is null)))
919 AND ((tlinfo.PREPAY_NUM = X_PREPAY_NUM)
920 OR ((tlinfo.PREPAY_NUM is null)
921 AND (X_PREPAY_NUM is null)))
922 AND ((tlinfo.PREPAY_APPLY_AMOUNT = X_PREPAY_APPLY_AMOUNT)
923 OR ((tlinfo.PREPAY_APPLY_AMOUNT is null)
924 AND (X_PREPAY_APPLY_AMOUNT is null)))
928 -- Bug 1534162, Added terms_date for PN integration
925 AND ((tlinfo.PREPAY_GL_DATE = X_PREPAY_GL_DATE)
926 OR ((tlinfo.PREPAY_GL_DATE is null)
927 AND (X_PREPAY_GL_DATE is null)))
929 AND ((tlinfo.TERMS_DATE = X_TERMS_DATE)
930 OR ((tlinfo.TERMS_DATE is null)
931 AND (X_TERMS_DATE is null)))
932 AND ((tlinfo.REQUESTER_ID = X_REQUESTER_ID)
933 OR ((tlinfo.REQUESTER_ID is null)
934 AND (X_REQUESTER_ID is null)))
935 AND ((tlinfo.OPERATING_UNIT = X_OPERATING_UNIT)
936 OR ((tlinfo.OPERATING_UNIT is null)
937 AND (X_OPERATING_UNIT is null)))
938 -- Invoice Lines Project Stage 1
939 AND ((tlinfo.PREPAY_LINE_NUM = X_PREPAY_LINE_NUM)
940 OR ((tlinfo.PREPAY_LINE_NUM is null)
941 AND (X_PREPAY_LINE_NUM is null)))
942 AND ((tlinfo.REQUESTER_FIRST_NAME = X_REQUESTER_FIRST_NAME)
943 OR ((tlinfo.REQUESTER_FIRST_NAME is null)
944 AND (X_REQUESTER_FIRST_NAME is null)))
945 AND ((tlinfo.REQUESTER_LAST_NAME = X_REQUESTER_LAST_NAME)
946 OR ((tlinfo.REQUESTER_LAST_NAME is null)
947 AND (X_REQUESTER_LAST_NAME is null)))
948 AND ((tlinfo.REQUESTER_EMPLOYEE_NUM = X_REQUESTER_EMPLOYEE_NUM)
949 OR ((tlinfo.REQUESTER_EMPLOYEE_NUM is null)
950 AND (X_REQUESTER_EMPLOYEE_NUM is null)))
951 AND ((tlinfo.CALC_TAX_DURING_IMPORT_FLAG = X_CALC_TAX_DURING_IMPORT_FLAG)
952 OR ((tlinfo.CALC_TAX_DURING_IMPORT_FLAG is null)
953 AND (X_CALC_TAX_DURING_IMPORT_FLAG is null)))
954 AND ((tlinfo.CONTROL_AMOUNT = X_CONTROL_AMOUNT)
955 OR ((tlinfo.CONTROL_AMOUNT is null)
956 AND (X_CONTROL_AMOUNT is null)))
957 AND ((tlinfo.ADD_TAX_TO_INV_AMT_FLAG = X_ADD_TAX_TO_INV_AMT_FLAG)
958 OR ((tlinfo.ADD_TAX_TO_INV_AMT_FLAG is null)
959 AND (X_ADD_TAX_TO_INV_AMT_FLAG is null)))
960 AND ((tlinfo.TAX_RELATED_INVOICE_ID = X_TAX_RELATED_INVOICE_ID)
961 OR ((tlinfo.TAX_RELATED_INVOICE_ID is null)
962 AND (X_TAX_RELATED_INVOICE_ID is null)))
963 AND ((tlinfo.TAXATION_COUNTRY = X_TAXATION_COUNTRY)
964 OR ((tlinfo.TAXATION_COUNTRY is null)
965 AND (X_TAXATION_COUNTRY is null)))
966 AND ((tlinfo.DOCUMENT_SUB_TYPE = X_DOCUMENT_SUB_TYPE)
967 OR ((tlinfo.DOCUMENT_SUB_TYPE is null)
968 AND (X_DOCUMENT_SUB_TYPE is null)))
969 AND ((tlinfo.SUPPLIER_TAX_INVOICE_NUMBER = X_SUPPLIER_TAX_INVOICE_NUMBER)
970 OR ((tlinfo.SUPPLIER_TAX_INVOICE_NUMBER is null)
971 AND (X_SUPPLIER_TAX_INVOICE_NUMBER is null)))
972 AND ((tlinfo.SUPPLIER_TAX_INVOICE_DATE = X_SUPPLIER_TAX_INVOICE_DATE)
973 OR ((tlinfo.SUPPLIER_TAX_INVOICE_DATE is null)
974 AND (X_SUPPLIER_TAX_INVOICE_DATE is null)))
975 AND ((tlinfo.SUPPLIER_TAX_EXCHANGE_RATE = X_SUPPLIER_TAX_EXCHANGE_RATE)
976 OR ((tlinfo.SUPPLIER_TAX_EXCHANGE_RATE is null)
977 AND (X_SUPPLIER_TAX_EXCHANGE_RATE is null)))
978 AND ((tlinfo.TAX_INVOICE_RECORDING_DATE = X_TAX_INVOICE_RECORDING_DATE)
979 OR ((tlinfo.TAX_INVOICE_RECORDING_DATE is null)
980 AND (X_TAX_INVOICE_RECORDING_DATE is null)))
981 AND ((tlinfo.TAX_INVOICE_INTERNAL_SEQ = X_TAX_INVOICE_INTERNAL_SEQ)
982 OR ((tlinfo.TAX_INVOICE_INTERNAL_SEQ is null)
983 AND (X_TAX_INVOICE_INTERNAL_SEQ is null)))
984 AND ((tlinfo.LEGAL_ENTITY_ID = X_LEGAL_ENTITY_ID)
985 OR ((tlinfo.LEGAL_ENTITY_ID is null)
986 AND (X_LEGAL_ENTITY_ID is null)))
987 AND ((tlinfo.PAYMENT_METHOD_CODE = X_PAYMENT_METHOD_CODE)
988 OR ((tlinfo.PAYMENT_METHOD_CODE is null)
989 AND (X_PAYMENT_METHOD_CODE is null)))
990 AND ((tlinfo.PAYMENT_REASON_CODE = X_PAYMENT_REASON_CODE)
991 OR ((tlinfo.PAYMENT_REASON_CODE is null)
992 AND (X_PAYMENT_REASON_CODE is null)))
993 AND ((tlinfo.PAYMENT_REASON_COMMENTS = X_PAYMENT_REASON_COMMENTS)
994 OR ((tlinfo.PAYMENT_REASON_COMMENTS is null)
995 AND (X_PAYMENT_REASON_COMMENTS is null)))
996 AND ((tlinfo.UNIQUE_REMITTANCE_IDENTIFIER = X_UNIQUE_REMITTANCE_IDENTIFIER)
997 OR ((tlinfo.UNIQUE_REMITTANCE_IDENTIFIER is null)
998 AND (X_UNIQUE_REMITTANCE_IDENTIFIER is null)))
999 AND ((tlinfo.URI_CHECK_DIGIT = X_URI_CHECK_DIGIT)
1000 OR ((tlinfo.URI_CHECK_DIGIT is null)
1001 AND (X_URI_CHECK_DIGIT is null)))
1002 AND ((tlinfo.BANK_CHARGE_BEARER = X_BANK_CHARGE_BEARER)
1003 OR ((tlinfo.BANK_CHARGE_BEARER is null)
1004 AND (X_BANK_CHARGE_BEARER is null)))
1005 AND ((tlinfo.DELIVERY_CHANNEL_CODE = X_DELIVERY_CHANNEL_CODE)
1006 OR ((tlinfo.DELIVERY_CHANNEL_CODE is null)
1007 AND (X_DELIVERY_CHANNEL_CODE is null)))
1008 AND ((tlinfo.SETTLEMENT_PRIORITY = X_SETTLEMENT_PRIORITY)
1009 OR ((tlinfo.SETTLEMENT_PRIORITY is null)
1010 AND (X_SETTLEMENT_PRIORITY is null)))
1011 AND ((tlinfo.REMITTANCE_MESSAGE1 = X_REMITTANCE_MESSAGE1)
1012 OR ((tlinfo.REMITTANCE_MESSAGE1 is null)
1013 AND (X_REMITTANCE_MESSAGE1 is null)))
1014 AND ((tlinfo.REMITTANCE_MESSAGE2 = X_REMITTANCE_MESSAGE2)
1015 OR ((tlinfo.REMITTANCE_MESSAGE2 is null)
1016 AND (X_REMITTANCE_MESSAGE2 is null)))
1017 AND ((tlinfo.REMITTANCE_MESSAGE3 = X_REMITTANCE_MESSAGE3)
1018 OR ((tlinfo.REMITTANCE_MESSAGE3 is null)
1019 AND (X_REMITTANCE_MESSAGE3 is null)))
1023 AND ((tlinfo.PORT_OF_ENTRY_CODE = X_PORT_OF_ENTRY_CODE)
1020 AND ((tlinfo.NET_OF_RETAINAGE_FLAG = X_NET_OF_RETAINAGE_FLAG)
1021 OR ((tlinfo.NET_OF_RETAINAGE_FLAG is null)
1022 AND (X_NET_OF_RETAINAGE_FLAG is null)))
1024 OR ((tlinfo.PORT_OF_ENTRY_CODE is null)
1025 AND (X_PORT_OF_ENTRY_CODE is null)))
1026 AND ((tlinfo.APPLICATION_ID = X_APPLICATION_ID)
1027 OR ((tlinfo.APPLICATION_ID is null)
1028 AND (X_APPLICATION_ID is null)))
1029 AND ((tlinfo.PRODUCT_TABLE = X_PRODUCT_TABLE)
1030 OR ((tlinfo.PRODUCT_TABLE is null)
1031 AND (X_PRODUCT_TABLE is null)))
1032 AND ((tlinfo.REFERENCE_KEY1 = X_REFERENCE_KEY1)
1033 OR ((tlinfo.REFERENCE_KEY1 is null)
1034 AND (X_REFERENCE_KEY1 is null)))
1035 AND ((tlinfo.REFERENCE_KEY2 = X_REFERENCE_KEY2)
1036 OR ((tlinfo.REFERENCE_KEY2 is null)
1037 AND (X_REFERENCE_KEY2 is null)))
1038 AND ((tlinfo.REFERENCE_KEY3 = X_REFERENCE_KEY3)
1039 OR ((tlinfo.REFERENCE_KEY3 is null)
1040 AND (X_REFERENCE_KEY3 is null)))
1041 AND ((tlinfo.REFERENCE_KEY4 = X_REFERENCE_KEY4)
1042 OR ((tlinfo.REFERENCE_KEY4 is null)
1043 AND (X_REFERENCE_KEY4 is null)))
1044 AND ((tlinfo.REFERENCE_KEY5 = X_REFERENCE_KEY5)
1045 OR ((tlinfo.REFERENCE_KEY5 is null)
1046 AND (X_REFERENCE_KEY5 is null)))
1047 AND ((tlinfo.PARTY_ID = X_PARTY_ID)
1048 OR ((tlinfo.PARTY_ID is null)
1049 AND (X_PARTY_ID is null)))
1050 AND ((tlinfo.PARTY_SITE_ID = X_PARTY_SITE_ID)
1051 OR ((tlinfo.PARTY_SITE_ID is null)
1052 AND (X_PARTY_SITE_ID is null)))
1053 AND ((tlinfo.PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE)
1054 OR ((tlinfo.PAY_PROC_TRXN_TYPE_CODE is null)
1055 AND (X_PAY_PROC_TRXN_TYPE_CODE is null)))
1056 AND ((tlinfo.PAYMENT_FUNCTION = X_PAYMENT_FUNCTION)
1057 OR ((tlinfo.PAYMENT_FUNCTION is null)
1058 AND (X_PAYMENT_FUNCTION is null)))
1059 AND ((tlinfo.PAYMENT_PRIORITY = X_PAYMENT_PRIORITY)
1060 OR ((tlinfo.PAYMENT_PRIORITY is null)
1061 AND (X_PAYMENT_PRIORITY is null)))
1062 AND ((tlinfo.external_bank_account_id = X_external_bank_account_id)
1063 OR ((tlinfo.external_bank_account_id is null)
1064 AND (X_external_bank_account_id is null)))
1065 AND ((tlinfo.remit_to_supplier_name = X_remit_to_supplier_name)
1066 OR ((tlinfo.remit_to_supplier_name is null)
1067 AND (X_remit_to_supplier_name is null)))
1068 AND ((tlinfo.remit_to_supplier_id = X_remit_to_supplier_id)
1069 OR ((tlinfo.remit_to_supplier_id is null)
1070 AND (X_remit_to_supplier_id is null)))
1071 AND ((tlinfo.remit_to_supplier_site = X_remit_to_supplier_site)
1072 OR ((tlinfo.remit_to_supplier_site is null)
1073 AND (X_remit_to_supplier_site is null)))
1074 AND ((tlinfo.remit_to_supplier_site_id = X_remit_to_supplier_site_id)
1075 OR ((tlinfo.remit_to_supplier_site_id is null)
1076 AND (X_remit_to_supplier_site_id is null)))
1077 AND ((tlinfo.relationship_id = X_relationship_id)
1078 OR ((tlinfo.relationship_id is null)
1079 AND (X_relationship_id is null)))
1080
1081 ) THEN
1082 NULL;
1083 ELSE
1084 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1085 app_exception.raise_exception;
1086 END IF;
1087 RETURN;
1088 END LOCK_ROW;
1089
1090
1091 procedure UPDATE_ROW (
1092 X_INVOICE_ID IN NUMBER,
1093 X_INVOICE_NUM IN VARCHAR2,
1094 X_INVOICE_TYPE_LOOKUP_CODE IN VARCHAR2,
1095 X_INVOICE_DATE IN DATE,
1096 X_PO_NUMBER IN VARCHAR2,
1097 X_VENDOR_ID IN NUMBER,
1098 X_VENDOR_SITE_ID IN NUMBER,
1099 X_INVOICE_AMOUNT IN NUMBER,
1100 X_INVOICE_CURRENCY_CODE IN VARCHAR2,
1101 X_PAYMENT_CURRENCY_CODE IN VARCHAR2,
1102 X_PAYMENT_CROSS_RATE IN NUMBER,
1103 X_PAYMENT_CROSS_RATE_TYPE IN VARCHAR2,
1104 X_PAYMENT_CROSS_RATE_DATE IN DATE,
1105 X_EXCHANGE_RATE IN NUMBER,
1106 X_EXCHANGE_RATE_TYPE IN VARCHAR2,
1107 X_EXCHANGE_DATE IN DATE,
1108 X_TERMS_ID IN NUMBER,
1109 X_DESCRIPTION IN VARCHAR2,
1110 X_AWT_GROUP_ID IN NUMBER,
1111 X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL, --bug6639866
1112 X_AMT_APPLICABLE_TO_DISCOUNT IN NUMBER,
1113 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
1114 X_ATTRIBUTE1 IN VARCHAR2,
1115 X_ATTRIBUTE2 IN VARCHAR2,
1116 X_ATTRIBUTE3 IN VARCHAR2,
1117 X_ATTRIBUTE4 IN VARCHAR2,
1118 X_ATTRIBUTE5 IN VARCHAR2,
1122 X_ATTRIBUTE9 IN VARCHAR2,
1119 X_ATTRIBUTE6 IN VARCHAR2,
1120 X_ATTRIBUTE7 IN VARCHAR2,
1121 X_ATTRIBUTE8 IN VARCHAR2,
1123 X_ATTRIBUTE10 IN VARCHAR2,
1124 X_ATTRIBUTE11 IN VARCHAR2,
1125 X_ATTRIBUTE12 IN VARCHAR2,
1126 X_ATTRIBUTE13 IN VARCHAR2,
1127 X_ATTRIBUTE14 IN VARCHAR2,
1128 X_ATTRIBUTE15 IN VARCHAR2,
1129 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1130 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1131 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1132 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1133 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1134 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1135 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1136 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1137 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1138 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1139 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1140 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1141 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1142 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1143 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1144 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1145 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1146 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1147 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1148 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1149 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
1150 X_STATUS IN VARCHAR2,
1151 X_SOURCE IN VARCHAR2,
1152 X_GROUP_ID IN VARCHAR2,
1153 X_WORKFLOW_FLAG IN VARCHAR2,
1154 X_DOC_CATEGORY_CODE IN VARCHAR2,
1155 X_VOUCHER_NUM IN VARCHAR2,
1156 X_PAY_GROUP_LOOKUP_CODE IN VARCHAR2,
1157 X_GOODS_RECEIVED_DATE IN DATE,
1158 X_INVOICE_RECEIVED_DATE IN DATE,
1159 X_GL_DATE IN DATE,
1160 X_ACCTS_PAY_CCID IN NUMBER,
1161 -- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
1162 X_EXCLUSIVE_PAYMENT_FLAG IN VARCHAR2,
1163 X_INVOICE_INCLUDES_PREPAY_FLAG IN VARCHAR2,
1164 X_PREPAY_NUM IN VARCHAR2,
1165 X_PREPAY_APPLY_AMOUNT IN NUMBER,
1166 X_PREPAY_GL_DATE IN DATE,
1167 X_LAST_UPDATE_DATE IN DATE,
1168 X_LAST_UPDATED_BY IN NUMBER,
1169 X_LAST_UPDATE_LOGIN IN NUMBER,
1170 X_MODE IN VARCHAR2 DEFAULT 'R',
1171 X_TERMS_DATE IN DATE DEFAULT NULL,
1172 X_REQUESTER_ID IN NUMBER DEFAULT NULL,
1173 X_OPERATING_UNIT IN VARCHAR2 DEFAULT NULL,
1174 -- Invoice LINes Project Stage 1
1175 X_PREPAY_LINE_NUM IN NUMBER DEFAULT NULL,
1176 X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
1177 X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
1178 X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
1179 -- eTax Uptake
1180 X_CALC_TAX_DURING_IMPORT_FLAG IN VARCHAR2 DEFAULT NULL,
1181 X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
1182 X_ADD_TAX_TO_INV_AMT_FLAG IN VARCHAR2 DEFAULT NULL,
1183 X_TAX_RELATED_INVOICE_ID IN NUMBER DEFAULT NULL,
1184 X_TAXATION_COUNTRY IN VARCHAR2 DEFAULT NULL,
1185 X_DOCUMENT_SUB_TYPE IN VARCHAR2 DEFAULT NULL,
1186 X_SUPPLIER_TAX_INVOICE_NUMBER IN VARCHAR2 DEFAULT NULL,
1187 X_SUPPLIER_TAX_INVOICE_DATE IN DATE DEFAULT NULL,
1188 X_SUPPLIER_TAX_EXCHANGE_RATE IN NUMBER DEFAULT NULL,
1189 X_TAX_INVOICE_RECORDING_DATE IN DATE DEFAULT NULL,
1190 X_TAX_INVOICE_INTERNAL_SEQ IN VARCHAR2 DEFAULT NULL,
1191 X_LEGAL_ENTITY_ID IN NUMBER DEFAULT NULL,
1192 x_PAYMENT_METHOD_CODE in varchar2 default null,
1193 x_PAYMENT_REASON_CODE in varchar2 default null,
1194 X_PAYMENT_REASON_COMMENTS in varchar2 default null,
1195 x_UNIQUE_REMITTANCE_IDENTIFIER in varchar2 default null,
1196 x_URI_CHECK_DIGIT in varchar2 default null,
1197 x_BANK_CHARGE_BEARER in varchar2 default null,
1198 x_DELIVERY_CHANNEL_CODE in varchar2 default null,
1199 x_SETTLEMENT_PRIORITY in varchar2 default null,
1200 x_remittance_message1 in varchar2 default null,
1204 x_PORT_OF_ENTRY_CODE in varchar2 default null,
1201 x_remittance_message2 in varchar2 default null,
1202 x_remittance_message3 in varchar2 default null,
1203 x_NET_OF_RETAINAGE_FLAG in varchar2 default null,
1205 X_APPLICATION_ID IN NUMBER DEFAULT NULL,
1206 X_PRODUCT_TABLE IN VARCHAR2 DEFAULT NULL,
1207 X_REFERENCE_KEY1 IN VARCHAR2 DEFAULT NULL,
1208 X_REFERENCE_KEY2 IN VARCHAR2 DEFAULT NULL,
1209 X_REFERENCE_KEY3 IN VARCHAR2 DEFAULT NULL,
1210 X_REFERENCE_KEY4 IN VARCHAR2 DEFAULT NULL,
1211 X_REFERENCE_KEY5 IN VARCHAR2 DEFAULT NULL,
1212 X_PARTY_ID IN NUMBER DEFAULT NULL,
1213 X_PARTY_SITE_ID IN NUMBER DEFAULT NULL,
1214 X_PAY_PROC_TRXN_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
1215 X_PAYMENT_FUNCTION IN VARCHAR2 DEFAULT NULL,
1216 X_PAYMENT_PRIORITY IN NUMBER DEFAULT NULL,
1217 X_external_bank_account_id in number default null,
1218 X_REMIT_TO_SUPPLIER_NAME IN VARCHAR2 DEFAULT NULL,
1219 X_REMIT_TO_SUPPLIER_ID IN NUMBER DEFAULT NULL,
1220 X_REMIT_TO_SUPPLIER_SITE IN VARCHAR2 DEFAULT NULL,
1221 X_REMIT_TO_SUPPLIER_SITE_ID IN NUMBER DEFAULT NULL,
1222 X_RELATIONSHIP_ID IN NUMBER DEFAULT NULL)
1223 IS
1224 BEGIN
1225 UPDATE AP_INVOICES_INTERFACE
1226 SET
1227 INVOICE_NUM = X_INVOICE_NUM,
1228 INVOICE_TYPE_LOOKUP_CODE = X_INVOICE_TYPE_LOOKUP_CODE,
1229 INVOICE_DATE = X_INVOICE_DATE,
1230 PO_NUMBER = X_PO_NUMBER,
1231 VENDOR_ID = X_VENDOR_ID,
1232 VENDOR_SITE_ID = X_VENDOR_SITE_ID,
1233 INVOICE_AMOUNT = X_INVOICE_AMOUNT,
1234 INVOICE_CURRENCY_CODE = X_INVOICE_CURRENCY_CODE,
1235 PAYMENT_CURRENCY_CODE = X_PAYMENT_CURRENCY_CODE,
1236 PAYMENT_CROSS_RATE = X_PAYMENT_CROSS_RATE,
1237 PAYMENT_CROSS_RATE_TYPE = X_PAYMENT_CROSS_RATE_TYPE,
1238 PAYMENT_CROSS_RATE_DATE = X_PAYMENT_CROSS_RATE_DATE,
1239 EXCHANGE_RATE = X_EXCHANGE_RATE,
1240 EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE,
1241 EXCHANGE_DATE = X_EXCHANGE_DATE,
1242 TERMS_ID = X_TERMS_ID,
1243 DESCRIPTION = X_DESCRIPTION,
1244 AWT_GROUP_ID = X_AWT_GROUP_ID,
1245 PAY_AWT_GROUP_ID = X_PAY_AWT_GROUP_ID, --bug6639866
1246 AMOUNT_APPLICABLE_TO_DISCOUNT = X_AMT_APPLICABLE_TO_DISCOUNT,
1247 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
1248 ATTRIBUTE1 = X_ATTRIBUTE1,
1249 ATTRIBUTE2 = X_ATTRIBUTE2,
1250 ATTRIBUTE3 = X_ATTRIBUTE3,
1251 ATTRIBUTE4 = X_ATTRIBUTE4,
1252 ATTRIBUTE5 = X_ATTRIBUTE5,
1253 ATTRIBUTE6 = X_ATTRIBUTE6,
1254 ATTRIBUTE7 = X_ATTRIBUTE7,
1255 ATTRIBUTE8 = X_ATTRIBUTE8,
1256 ATTRIBUTE9 = X_ATTRIBUTE9,
1257 ATTRIBUTE10 = X_ATTRIBUTE10,
1258 ATTRIBUTE11 = X_ATTRIBUTE11,
1259 ATTRIBUTE12 = X_ATTRIBUTE12,
1260 ATTRIBUTE13 = X_ATTRIBUTE13,
1261 ATTRIBUTE14 = X_ATTRIBUTE14,
1262 ATTRIBUTE15 = X_ATTRIBUTE15,
1263 GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY,
1264 GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1,
1265 GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2,
1266 GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3,
1267 GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4,
1268 GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5,
1269 GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6,
1270 GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
1271 GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,
1272 GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9,
1273 GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10,
1274 GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11,
1275 GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12,
1276 GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13,
1277 GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14,
1278 GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15,
1279 GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16,
1280 GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17,
1281 GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18,
1282 GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19,
1283 GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20,
1284 STATUS = X_STATUS,
1285 SOURCE = X_SOURCE,
1286 GROUP_ID = X_GROUP_ID,
1287 WORKFLOW_FLAG = X_WORKFLOW_FLAG,
1288 DOC_CATEGORY_CODE = X_DOC_CATEGORY_CODE,
1289 VOUCHER_NUM = X_VOUCHER_NUM,
1290 PAY_GROUP_LOOKUP_CODE = X_PAY_GROUP_LOOKUP_CODE,
1291 GOODS_RECEIVED_DATE = X_GOODS_RECEIVED_DATE,
1292 GL_DATE = X_GL_DATE,
1293 ACCTS_PAY_CODE_COMBINATION_ID = X_ACCTS_PAY_CCID,
1294 -- Removed for bug 4277744
1295 -- USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE,
1296 EXCLUSIVE_PAYMENT_FLAG = X_EXCLUSIVE_PAYMENT_FLAG,
1297 INVOICE_INCLUDES_PREPAY_FLAG = X_INVOICE_INCLUDES_PREPAY_FLAG,
1298 PREPAY_NUM = X_PREPAY_NUM,
1299 PREPAY_APPLY_AMOUNT = X_PREPAY_APPLY_AMOUNT,
1300 PREPAY_GL_DATE = X_PREPAY_GL_DATE,
1301 INVOICE_RECEIVED_DATE = X_INVOICE_RECEIVED_DATE,
1302 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1303 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1304 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1305 TERMS_DATE = X_TERMS_DATE,
1306 REQUESTER_ID = X_REQUESTER_ID,
1307 OPERATING_UNIT = X_OPERATING_UNIT,
1308 -- Invoice Lines Project Stage 1
1309 PREPAY_LINE_NUM = X_PREPAY_LINE_NUM,
1310 REQUESTER_FIRST_NAME = X_REQUESTER_FIRST_NAME,
1311 REQUESTER_LAST_NAME = X_REQUESTER_LAST_NAME,
1312 REQUESTER_EMPLOYEE_NUM = X_REQUESTER_EMPLOYEE_NUM,
1313 -- eTax Uptake
1314 CALC_TAX_DURING_IMPORT_FLAG = X_CALC_TAX_DURING_IMPORT_FLAG,
1315 CONTROL_AMOUNT = X_CONTROL_AMOUNT,
1316 ADD_TAX_TO_INV_AMT_FLAG = X_ADD_TAX_TO_INV_AMT_FLAG,
1317 TAX_RELATED_INVOICE_ID = X_TAX_RELATED_INVOICE_ID,
1318 TAXATION_COUNTRY = X_TAXATION_COUNTRY,
1319 DOCUMENT_SUB_TYPE = X_DOCUMENT_SUB_TYPE,
1320 SUPPLIER_TAX_INVOICE_NUMBER = X_SUPPLIER_TAX_INVOICE_NUMBER,
1321 SUPPLIER_TAX_INVOICE_DATE = X_SUPPLIER_TAX_INVOICE_DATE,
1322 SUPPLIER_TAX_EXCHANGE_RATE = X_SUPPLIER_TAX_EXCHANGE_RATE,
1323 TAX_INVOICE_RECORDING_DATE = X_TAX_INVOICE_RECORDING_DATE,
1324 TAX_INVOICE_INTERNAL_SEQ = X_TAX_INVOICE_INTERNAL_SEQ,
1325 LEGAL_ENTITY_ID = X_LEGAL_ENTITY_ID,
1326 PAYMENT_METHOD_CODE = x_PAYMENT_METHOD_CODE,
1327 PAYMENT_REASON_CODE = x_PAYMENT_REASON_CODE,
1328 PAYMENT_REASON_COMMENTS = X_PAYMENT_REASON_COMMENTS,
1329 UNIQUE_REMITTANCE_IDENTIFIER = x_UNIQUE_REMITTANCE_IDENTIFIER,
1330 URI_CHECK_DIGIT = x_URI_CHECK_DIGIT,
1331 BANK_CHARGE_BEARER = x_BANK_CHARGE_BEARER,
1332 DELIVERY_CHANNEL_CODE = x_DELIVERY_CHANNEL_CODE,
1333 SETTLEMENT_PRIORITY = x_SETTLEMENT_PRIORITY,
1334 REMITTANCE_MESSAGE1 = X_REMITTANCE_MESSAGE1,
1335 REMITTANCE_MESSAGE2 = X_REMITTANCE_MESSAGE2,
1336 REMITTANCE_MESSAGE3 = X_REMITTANCE_MESSAGE3,
1337 NET_OF_RETAINAGE_FLAG = X_NET_OF_RETAINAGE_FLAG,
1338 PORT_OF_ENTRY_CODE = X_PORT_OF_ENTRY_CODE,
1339 APPLICATION_ID = X_APPLICATION_ID,
1340 PRODUCT_TABLE = X_PRODUCT_TABLE,
1341 REFERENCE_KEY1 = X_REFERENCE_KEY1,
1342 REFERENCE_KEY2 = X_REFERENCE_KEY2,
1343 REFERENCE_KEY3 = X_REFERENCE_KEY3,
1344 REFERENCE_KEY4 = X_REFERENCE_KEY4,
1345 REFERENCE_KEY5 = X_REFERENCE_KEY5,
1346 PARTY_ID = X_PARTY_ID,
1347 PARTY_SITE_ID = X_PARTY_SITE_ID,
1348 PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE,
1349 PAYMENT_FUNCTION = X_PAYMENT_FUNCTION,
1350 PAYMENT_PRIORITY = X_PAYMENT_PRIORITY,
1351 external_bank_account_id = x_external_bank_account_id,
1352 REMIT_TO_SUPPLIER_NAME = x_remit_to_supplier_name,
1353 REMIT_TO_SUPPLIER_ID = x_remit_to_supplier_id,
1354 REMIT_TO_SUPPLIER_SITE = x_remit_to_supplier_site,
1355 REMIT_TO_SUPPLIER_SITE_ID = x_remit_to_supplier_site_id,
1356 RELATIONSHIP_ID = x_relationship_id
1357 WHERE INVOICE_ID = X_INVOICE_ID;
1358
1359 IF (sql%notfound) THEN
1360 RAISE NO_DATA_FOUND;
1361 END IF;
1362 END UPDATE_ROW;
1363
1364 procedure DELETE_ROW (
1365 X_INVOICE_ID IN NUMBER)
1366 IS
1367 BEGIN
1368
1369 -- Bug 2496745. Deleting the interface lines and rejections
1370 -- when the invoice is deleted.
1371
1372 /* Delete invoice rejections from the rejections table */
1373 DELETE FROM ap_interface_rejections
1374 WHERE parent_id = X_INVOICE_ID AND
1375 parent_table = 'AP_INVOICES_INTERFACE';
1376
1377 /* Delete invoice lines rejections from the rejections table */
1378 DELETE FROM ap_interface_rejections
1379 WHERE parent_id IN (SELECT invoice_line_id
1380 FROM ap_invoice_lines_interface
1381 WHERE invoice_id = X_INVOICE_ID)
1382 and parent_table = 'AP_INVOICE_LINES_INTERFACE';
1383
1384 /* Delete invoice lines from interface */
1385 DELETE FROM ap_invoice_lines_interface
1386 WHERE invoice_id = X_INVOICE_ID;
1387
1388 /* Delete invoices from interface */
1389 DELETE FROM AP_INVOICES_INTERFACE
1390 WHERE INVOICE_ID = X_INVOICE_ID;
1391
1392 IF (sql%notfound) THEN
1393 RAISE NO_DATA_FOUND;
1394 END IF;
1395 END DELETE_ROW;
1396
1397 END AP_INVOICES_INTERFACE_PKG;
[Home] [Help]