eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HEADERS_SV9 dependencies on PO_HEADERS

Line 1: PACKAGE BODY PO_HEADERS_SV9 AS

1: PACKAGE BODY PO_HEADERS_SV9 AS
2: /* $Header: POXPIRDB.pls 115.22 2004/05/25 21:14:59 dreddy ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_pdoi_write_to_file VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_PDOI_WRITE_TO_FILE'),'N');

Line 42: 'PO_HEADERS_INTERFACE',

38: null,
39: X_interface_header_id,
40: X_interface_line_id,
41: 'PO_PDOI_COLUMN_NOT_NULL',
42: 'PO_HEADERS_INTERFACE',
43: 'START_DATE',
44: 'COLUMN_NAME',
45: null,null,null,null,null,
46: 'START_DATE',

Line 60: 'PO_HEADERS_INTERFACE',

56: null,
57: X_interface_header_id,
58: X_interface_line_id,
59: 'PO_PDOI_INVALID_START_DATE',
60: 'PO_HEADERS_INTERFACE',
61: 'START_DATE',
62: 'VALUE',
63: null,null,null,null,null,
64: X_start_date,

Line 71: /* make sure that such a po_header_id exists in po_headers table */

67: END IF;
68:
69: IF (X_header_processable_flag = 'Y') THEN
70: X_progress := '020' ;
71: /* make sure that such a po_header_id exists in po_headers table */
72:
73: /*Bug 1239775
74: Performance issue
75: Before the fix we had one sql statment to handle both

Line 85: FROM po_headers

81: -- Bug 2449186. Truncate dates when comparing them.
82: if (x_document_type_code = 'QUOTATION') then
83: SELECT count(*)
84: INTO x_temp
85: FROM po_headers
86: WHERE vendor_id = X_vendor_id
87: AND quote_vendor_quote_number = X_vendor_doc_num
88: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
89: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))

Line 94: FROM po_headers

90: AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');
91: elsif(x_document_type_code= 'BLANKET') then
92: SELECT count(*)
93: INTO x_temp
94: FROM po_headers
95: WHERE vendor_id = X_vendor_id
96: AND vendor_order_num = X_vendor_doc_num
97: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
98: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))

Line 118: FROM po_headers

114: -- Bug 2449186. Truncate dates when comparing them.
115: if (x_document_type_code = 'QUOTATION') then
116: SELECT count(*)
117: INTO x_temp
118: FROM po_headers
119: WHERE vendor_id = X_vendor_id
120: AND quote_vendor_quote_number = X_vendor_doc_num
121: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
122: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate));

Line 126: FROM po_headers

122: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate));
123: elsif(x_document_type_code= 'BLANKET') then
124: SELECT count(*)
125: INTO x_temp
126: FROM po_headers
127: WHERE vendor_id = X_vendor_id
128: AND vendor_order_num = X_vendor_doc_num
129: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
130: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate));

Line 153: 'PO_HEADERS_INTERFACE',

149: null,
150: X_interface_header_id,
151: X_interface_line_id,
152: 'PO_PDOI_INVALID_ORIG_CATALOG',
153: 'PO_HEADERS_INTERFACE',
154: 'VENDOR_DOC_NUM',
155: 'DOC_NUMBER',
156: null,null,null,null,null,
157: X_vendor_doc_num ,

Line 170: 'PO_HEADERS_INTERFACE',

166: null,
167: X_interface_header_id,
168: X_interface_line_id,
169: 'PO_PDOI_INVAL_MULT_ORIG_CATG',
170: 'PO_HEADERS_INTERFACE',
171: 'VENDOR_DOC_NUM',
172: 'DOC_NUMBER',
173: null,null,null,null,null,
174: X_vendor_doc_num,

Line 190: FROM po_headers

186: of the new replaced blanket exists */
187:
188: SELECT po_header_id
189: INTO l_po_header_id
190: FROM po_headers
191: WHERE vendor_id = X_vendor_id
192: AND DECODE(X_document_type_code, 'QUOTATION', quote_vendor_quote_number,
193: 'BLANKET' , vendor_order_num) = X_vendor_doc_num
194: AND TRUNC(nvl(X_start_date, sysdate)) >=

Line 223: x_table_name => 'PO_HEADERS_INTERFACE',

219: x_batch_id => null,
220: x_interface_header_id => X_interface_header_id,
221: x_interface_line_id => null,
222: x_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
223: x_table_name => 'PO_HEADERS_INTERFACE',
224: x_column_name => 'EFFECTIVE_DATE',
225: x_tokenname1 => null,
226: x_tokenname2 => null,
227: x_tokenname3 => null,

Line 244: po_headers_all ph

240: ELSIF nvl(p_ga_flag, 'N') = 'Y' and x_document_type_code = 'BLANKET' THEN
241: SELECT count(1)
242: INTO l_po_exists_num
243: FROM po_lines_all pl,
244: po_headers_all ph
245: WHERE pl.from_header_id = l_po_header_id
246: AND ph.po_header_id = pl.po_header_id
247: AND ph.creation_date >= X_start_date;
248:

Line 257: x_table_name => 'PO_HEADERS_INTERFACE',

253: x_batch_id => null,
254: x_interface_header_id => X_interface_header_id,
255: x_interface_line_id => null,
256: x_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
257: x_table_name => 'PO_HEADERS_INTERFACE',
258: x_column_name => 'EFFECTIVE_DATE',
259: x_tokenname1 => null,
260: x_tokenname2 => null,
261: x_tokenname3 => null,

Line 278: UPDATE po_headers

274: --
275: END IF;
276:
277: -- Bug 2449186. Truncate dates when comparing them.
278: UPDATE po_headers
279: SET start_date = nvl(start_date, X_start_date - 1),
280: end_date = X_start_date - 1,
281: last_updated_by = fnd_global.user_id,
282: last_update_date = sysdate

Line 293: FROM po_headers

289: of the new replaced blanket exists */
290:
291: SELECT po_header_id
292: INTO l_po_header_id
293: FROM po_headers
294: WHERE vendor_id = X_vendor_id
295: AND DECODE(X_document_type_code, 'QUOTATION', quote_vendor_quote_number,
296: 'BLANKET' , vendor_order_num) = X_vendor_doc_num
297: AND TRUNC(nvl(X_start_date, sysdate)) >=

Line 326: x_table_name => 'PO_HEADERS_INTERFACE',

322: x_batch_id => null,
323: x_interface_header_id => X_interface_header_id,
324: x_interface_line_id => null,
325: x_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
326: x_table_name => 'PO_HEADERS_INTERFACE',
327: x_column_name => 'EFFECTIVE_DATE',
328: x_tokenname1 => null,
329: x_tokenname2 => null,
330: x_tokenname3 => null,

Line 347: po_headers_all ph

343: ELSIF nvl(p_ga_flag, 'N') = 'Y' and x_document_type_code = 'BLANKET' THEN
344: SELECT count(1)
345: INTO l_po_exists_num
346: FROM po_lines_all pl,
347: po_headers_all ph
348: WHERE pl.from_header_id = l_po_header_id AND
349: ph.po_header_id = pl.po_header_id AND
350: ph.creation_date >= X_start_date;
351:

Line 360: x_table_name => 'PO_HEADERS_INTERFACE',

356: x_batch_id => null,
357: x_interface_header_id => X_interface_header_id,
358: x_interface_line_id => null,
359: x_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
360: x_table_name => 'PO_HEADERS_INTERFACE',
361: x_column_name => 'EFFECTIVE_DATE',
362: x_tokenname1 => null,
363: x_tokenname2 => null,
364: x_tokenname3 => null,

Line 381: UPDATE po_headers

377: --
378: END IF;
379:
380: -- Bug 2449186. Truncate dates when comparing them.
381: UPDATE po_headers
382: SET start_date = nvl(start_date, X_start_date - 1),
383: end_date = X_start_date - 1,
384: last_updated_by = fnd_global.user_id,
385: last_update_date = sysdate

Line 425: x_tokenvalue po_headers_interface.vendor_doc_num%type; /* Bug3082104 */

421: x_temp2 binary_integer;
422: /* Cto Changes FPH start */
423: x_colname varchar2(20);
424: x_tokenname varchar2(20);
425: x_tokenvalue po_headers_interface.vendor_doc_num%type; /* Bug3082104 */
426: /* Cto Changes FPH end */
427:
428: --
429: -- added the following variables for PDOI enhancement.

Line 433: x_consigned_consumption_flag po_headers.consigned_consumption_flag%type ;

429: -- added the following variables for PDOI enhancement.
430:
431: x_po_status_rec PO_STATUS_REC_TYPE;
432: x_return_status varchar2(30);
433: x_consigned_consumption_flag po_headers.consigned_consumption_flag%type ;
434:
435: --
436:
437:

Line 473: from po_headers

469: if x_document_type_code = 'STANDARD' then
470:
471: select count(1)
472: into x_temp
473: from po_headers
474: where vendor_id = x_vendor_id
475: and vendor_order_num = x_vendor_doc_num
476: and segment1 = x_document_num;
477:

Line 482: from po_headers

478: else
479:
480: select count(1)
481: into x_temp
482: from po_headers
483: where vendor_id = x_vendor_id
484: and segment1 = x_document_num
485: and decode(x_document_type_code, 'QUOTATION', quote_vendor_quote_number,
486: 'BLANKET', vendor_order_num, NULL) = x_vendor_doc_num

Line 499: FROM po_headers

495: -- Bug 2449186. Truncate dates when comparing them.
496: if (x_document_type_code = 'QUOTATION') then
497: SELECT count(*)
498: INTO x_temp
499: FROM po_headers
500: WHERE vendor_id = X_vendor_id
501: AND quote_vendor_quote_number = X_vendor_doc_num
502: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
503: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))

Line 508: FROM po_headers

504: AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');
505: elsif(x_document_type_code= 'BLANKET') then
506: SELECT count(*)
507: INTO x_temp
508: FROM po_headers
509: WHERE vendor_id = X_vendor_id
510: AND vendor_order_num = X_vendor_doc_num
511: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
512: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))

Line 518: FROM po_headers

514: --
515: ELSIF(x_document_type_code = 'STANDARD') THEN
516: SELECT count(*)
517: INTO x_temp
518: FROM po_headers
519: WHERE vendor_id = x_vendor_id
520: and vendor_order_num = x_vendor_doc_num ;
521: --
522: END IF;

Line 535: FROM po_headers

531: */
532: -- Bug 2449186. Truncate dates when comparing them.
533: SELECT count(*)
534: INTO x_temp
535: FROM po_headers
536: WHERE vendor_id = X_vendor_id
537: AND segment1 = x_document_num
538: AND type_lookup_code= x_document_type_code
539: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))

Line 546: FROM po_headers

542: --
543: else
544: SELECT count(*)
545: INTO x_temp
546: FROM po_headers
547: WHERE vendor_id = x_vendor_id
548: and segment1 = x_document_num ;
549: end if;
550: --

Line 599: 'PO_HEADERS_INTERFACE',

595: null,
596: X_interface_header_id,
597: X_interface_line_id,
598: 'PO_PDOI_INVALID_ORIG_CATALOG',
599: 'PO_HEADERS_INTERFACE',
600: x_colname,
601: x_tokenname,
602: null,null,null,null,null,
603: x_tokenvalue ,

Line 617: x_table_name => 'PO_HEADERS_INTERFACE',

613: x_batch_id => null,
614: x_interface_header_id => X_interface_header_id,
615: x_interface_line_id => null,
616: x_error_message_name => 'PO_PDOI_INVALID_ORIG_STD_PO',
617: x_table_name => 'PO_HEADERS_INTERFACE',
618: x_column_name => x_colname,
619: x_tokenname1 => x_tokenname,
620: x_tokenname2 => null,
621: x_tokenname3 => null,

Line 652: 'PO_HEADERS_INTERFACE',

648: null,
649: X_interface_header_id,
650: X_interface_line_id,
651: 'PO_PDOI_INVAL_MULT_ORIG_CATG',
652: 'PO_HEADERS_INTERFACE',
653: x_colname,
654: x_tokenname,
655: null,null,null,null,null,
656: X_vendor_doc_num,

Line 670: x_table_name => 'PO_HEADERS_INTERFACE',

666: x_batch_id => null,
667: x_interface_header_id => X_interface_header_id,
668: x_interface_line_id => null,
669: x_error_message_name => 'PO_PDOI_MULTIPLE_STD_PO',
670: x_table_name => 'PO_HEADERS_INTERFACE',
671: x_column_name => x_colname,
672: x_tokenname1 => x_tokenname,
673: x_tokenname2 => null,
674: x_tokenname3 => null,

Line 704: FROM po_headers

700:
701: IF (x_document_type_code <> 'STANDARD') THEN
702: SELECT po_header_id
703: INTO X_po_header_id
704: FROM po_headers
705: WHERE vendor_id = X_vendor_id
706: AND decode(x_vendor_doc_num,null,segment1,(DECODE(X_document_type_code,
707: 'QUOTATION', quote_vendor_quote_number,
708: 'BLANKET' , vendor_order_num)))

Line 743: FROM po_headers

739: SELECT po_header_id,
740: consigned_consumption_flag
741: INTO x_po_header_id,
742: x_consigned_consumption_flag
743: FROM po_headers
744: WHERE vendor_order_num = x_vendor_doc_num;
745:
746: ELSE
747:

Line 752: FROM po_headers

748: SELECT po_header_id,
749: consigned_consumption_flag
750: INTO x_po_header_id,
751: x_consigned_consumption_flag
752: FROM po_headers
753: WHERE segment1 = x_document_num ;
754:
755: END IF; /* x_vendor_doc_num is not null */
756:

Line 776: x_table_name => 'PO_HEADERS_INTERFACE',

772: x_batch_id => null,
773: x_interface_header_id => X_interface_header_id,
774: x_interface_line_id => null,
775: x_error_message_name => 'PO_PDOI_STD_PO_INVALID_STATUS',
776: x_table_name => 'PO_HEADERS_INTERFACE',
777: x_column_name => x_colname,
778: x_tokenname1 => x_tokenname,
779: x_tokenname2 => null,
780: x_tokenname3 => null,

Line 801: update po_headers_interface

797: end if;
798:
799: -- update po_header_id in interface table
800:
801: update po_headers_interface
802: set po_header_id = x_po_header_id
803: where interface_header_id = X_interface_header_id; /* nwang, need this */
804:
805:

Line 854: FROM po_headers

850: -- Bug 2449186. Truncate dates when comparing them.
851: if (x_document_type_code = 'QUOTATION') then
852: SELECT count(*)
853: INTO x_temp
854: FROM po_headers
855: WHERE vendor_id = X_vendor_id
856: AND quote_vendor_quote_number = X_vendor_doc_num
857: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
858: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))

Line 863: FROM po_headers

859: AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');
860: elsif(x_document_type_code= 'BLANKET') then
861: SELECT count(*)
862: INTO x_temp
863: FROM po_headers
864: WHERE vendor_id = X_vendor_id
865: AND vendor_order_num = X_vendor_doc_num
866: AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
867: AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))

Line 894: 'PO_HEADERS_INTERFACE',

890: null,
891: X_interface_header_id,
892: X_interface_line_id,
893: 'PO_PDOI_CATG_ALREADY_EXISTS',
894: 'PO_HEADERS_INTERFACE',
895: 'VENDOR_DOC_NUM',
896: 'DOC_NUMBER',
897: null,null,null,null,null,
898: X_vendor_doc_num,

Line 911: END PO_HEADERS_SV9;

907: X_progress, sqlcode);
908: raise;
909: END check_if_catalog_exists;
910:
911: END PO_HEADERS_SV9;