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_SV6 dependencies on STANDARD

Line 24: if X_type_lookup_code in ('BLANKET', 'STANDARD') then

20: x_progress := '010';
21:
22: /* check to see if the segment1 is unique in po_headers table */
23: --
24: if X_type_lookup_code in ('BLANKET', 'STANDARD') then
25: x_progress := '020';
26:
27: SELECT count(*)
28: INTO x_temp

Line 31: AND type_lookup_code in ('BLANKET', 'CONTRACT', 'PLANNED', 'STANDARD')

27: SELECT count(*)
28: INTO x_temp
29: FROM po_headers
30: WHERE segment1 = x_segment1
31: AND type_lookup_code in ('BLANKET', 'CONTRACT', 'PLANNED', 'STANDARD')
32: AND (rowid <> x_rowid OR x_rowid is null);
33:
34: elsif X_type_lookup_code = 'QUOTATION' then
35: x_progress := '030';

Line 273: --frkhan add standard

269: X_error_code := 'PO_PDOI_DOC_NUM_UNIQUE';
270: RETURN FALSE; /* the document_num is not unique */
271: END IF;
272:
273: --frkhan add standard
274: IF (X_doc_type in ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
275:
276: if (X_doc_type = 'QUOTATION' and X_user_defined_num = 'NUMERIC')
277: OR

Line 274: IF (X_doc_type in ('QUOTATION', 'BLANKET', 'STANDARD')) THEN

270: RETURN FALSE; /* the document_num is not unique */
271: END IF;
272:
273: --frkhan add standard
274: IF (X_doc_type in ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
275:
276: if (X_doc_type = 'QUOTATION' and X_user_defined_num = 'NUMERIC')
277: OR
278: (X_doc_type in ('BLANKET','STANDARD') and X_user_defined_po_num_code = 'NUMERIC') then

Line 278: (X_doc_type in ('BLANKET','STANDARD') and X_user_defined_po_num_code = 'NUMERIC') then

274: IF (X_doc_type in ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
275:
276: if (X_doc_type = 'QUOTATION' and X_user_defined_num = 'NUMERIC')
277: OR
278: (X_doc_type in ('BLANKET','STANDARD') and X_user_defined_po_num_code = 'NUMERIC') then
279:
280: x_progress := '020';
281: X_temp_val := po_core_sv1.val_numeric_value(X_doc_num);
282: IF (X_temp_val = FALSE) THEN

Line 495: --frkhan add standard

491: x_header_processable_flag);
492: END IF;
493:
494: X_progress := '011';
495: --frkhan add standard
496: IF (x_type_lookup_code not in ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
497: po_interface_errors_sv1.handle_interface_errors(
498: 'PO_DOCS_OPEN_INTERFACE',
499: 'FATAL',

Line 496: IF (x_type_lookup_code not in ('QUOTATION', 'BLANKET', 'STANDARD')) THEN

492: END IF;
493:
494: X_progress := '011';
495: --frkhan add standard
496: IF (x_type_lookup_code not in ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
497: po_interface_errors_sv1.handle_interface_errors(
498: 'PO_DOCS_OPEN_INTERFACE',
499: 'FATAL',
500: null,

Line 614: --frkhan add standard

610: x_header_processable_flag);
611: END IF;
612:
613: X_progress := '070';
614: --frkhan add standard
615: ELSIF (X_type_lookup_code in ('BLANKET','STANDARD')) THEN
616: IF (X_quote_type_lookup_code is not null) THEN
617: po_interface_errors_sv1.handle_interface_errors(
618: 'PO_DOCS_OPEN_INTERFACE',

Line 615: ELSIF (X_type_lookup_code in ('BLANKET','STANDARD')) THEN

611: END IF;
612:
613: X_progress := '070';
614: --frkhan add standard
615: ELSIF (X_type_lookup_code in ('BLANKET','STANDARD')) THEN
616: IF (X_quote_type_lookup_code is not null) THEN
617: po_interface_errors_sv1.handle_interface_errors(
618: 'PO_DOCS_OPEN_INTERFACE',
619: 'FATAL',

Line 680: --frkhan add standard

676: END IF;
677: END IF;
678:
679: X_progress := '090';
680: --frkhan add standard
681: IF ( X_type_lookup_code IN ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
682: /*** validations common to both blanket/standard and quote ***/
683: IF (X_segment1 IS NULL ) THEN
684: po_interface_errors_sv1.handle_interface_errors(

Line 681: IF ( X_type_lookup_code IN ('QUOTATION', 'BLANKET', 'STANDARD')) THEN

677: END IF;
678:
679: X_progress := '090';
680: --frkhan add standard
681: IF ( X_type_lookup_code IN ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
682: /*** validations common to both blanket/standard and quote ***/
683: IF (X_segment1 IS NULL ) THEN
684: po_interface_errors_sv1.handle_interface_errors(
685: 'PO_DOCS_OPEN_INTERFACE',

Line 682: /* validations common to both blanket/standard and quote */

678:
679: X_progress := '090';
680: --frkhan add standard
681: IF ( X_type_lookup_code IN ('QUOTATION', 'BLANKET', 'STANDARD')) THEN
682: /*** validations common to both blanket/standard and quote ***/
683: IF (X_segment1 IS NULL ) THEN
684: po_interface_errors_sv1.handle_interface_errors(
685: 'PO_DOCS_OPEN_INTERFACE',
686: 'FATAL',

Line 1588: --frkhan add standard

1584: END IF;
1585: END IF; /* end x_type_lookup_code = 'QUOTATION' */
1586:
1587: X_progress := '360';
1588: --frkhan add standard
1589: IF (X_type_lookup_code in ('BLANKET','STANDARD')) THEN
1590: /*** validations which apply to Blanket agreements only ***/
1591:
1592: IF (X_confirming_order_flag IS NOT NULL ) THEN

Line 1589: IF (X_type_lookup_code in ('BLANKET','STANDARD')) THEN

1585: END IF; /* end x_type_lookup_code = 'QUOTATION' */
1586:
1587: X_progress := '360';
1588: --frkhan add standard
1589: IF (X_type_lookup_code in ('BLANKET','STANDARD')) THEN
1590: /*** validations which apply to Blanket agreements only ***/
1591:
1592: IF (X_confirming_order_flag IS NOT NULL ) THEN
1593: X_temp_val := po_core_sv1.val_flag_value(x_confirming_order_flag);

Line 1858: -- (1) QUOTATION is out of scope; STANDARD and BLANKET need to be validated

1854: END IF;
1855:
1856: --
1857: x_progress := '470';
1858: -- (1) QUOTATION is out of scope; STANDARD and BLANKET need to be validated
1859: -- (2) UPDATE only updates lines, does not update vendor/vendor site. Since
1860: -- this piece of code is not called if action is UPDATE, omit the condition
1861: -- (3) INCOMPLETE or INITIATE APPROVAL do no need to pass this validation
1862: IF (x_type_lookup_code <> 'QUOTATION')

Line 1905: /* Now Initiate Approval is also valid for Standard Po's. */

1901: --
1902:
1903: X_progress := '480';
1904: /** also need to make sure approval_status specified is valid ***/
1905: /* Now Initiate Approval is also valid for Standard Po's. */
1906: IF (X_approval_status NOT IN ('INCOMPLETE', 'APPROVED', 'INITIATE APPROVAL')) THEN
1907: /*** should be an error here ***/
1908: po_interface_errors_sv1.handle_interface_errors(
1909: 'PO_DOCS_OPEN_INTERFACE',