APPS.PO_LINES_SV dependencies on STANDARD

Line 65: ELSIF (X_type_lookup_code IN ('STANDARD', 'PLANNED','BLANKET')) THEN

61:
62: -- bug 424099
63: -- Check for Blanket PO
64:
65: ELSIF (X_type_lookup_code IN ('STANDARD', 'PLANNED','BLANKET')) THEN
66: /*
67: ** verify PO line can be deleted.
68: */
69: --Bug 3453216. Added token values for the message

Line 73: IF X_type_lookup_code IN ('STANDARD','PLANNED') THEN

69: --Bug 3453216. Added token values for the message
70: --'PO_PO_USE_CANCEL_ON_APRVD_PO3'. Deriving the token values here from
71: --X_type_lookup_code
72: Begin
73: IF X_type_lookup_code IN ('STANDARD','PLANNED') THEN
74: select type_name
75: into l_type_name
76: from po_document_types
77: where document_type_code = 'PO'

Line 239: IF (X_type_lookup_code IN ('PLANNED', 'STANDARD')) THEN

235: X_progress VARCHAR2(3) := '';
236: l_isucaenabled VARCHAR2(1) :='N';
237: BEGIN
238:
239: IF (X_type_lookup_code IN ('PLANNED', 'STANDARD')) THEN
240:
241: /* Delete Distributions for a PO */
242: X_progress := '010';
243: --dbms_output.put_line('Before Delete All Distributions');

Line 433: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN

429: AND POL.po_line_id = x_po_line_id;
430:
431: X_allow_delete := 'Y';
432:
433: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN
434:
435: PO_CORE_S.are_any_dists_reserved(
436: p_doc_type => PO_CORE_S.g_doc_type_PO
437: , p_doc_level => PO_CORE_S.g_doc_level_LINE

Line 519: -- Only check for reserved distributions for Standard and Planned PO lines.

515: ** If it does, display message and prevent deletion.
516: */
517:
518: --
519: -- Only check for reserved distributions for Standard and Planned PO lines.
520:
521: SELECT POH.type_lookup_code
522: INTO l_type_lookup_code
523: FROM PO_HEADERS_ALL POH

Line 545: -- Standard/Planned PO, otherwise, val_line_delete will return NULL.

541: END IF;
542:
543: -- Bug 3320400,
544: -- Should initialize X_allow_delete for document other than
545: -- Standard/Planned PO, otherwise, val_line_delete will return NULL.
546: X_allow_delete := 'Y';
547:
548: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN
549:

Line 548: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN

544: -- Should initialize X_allow_delete for document other than
545: -- Standard/Planned PO, otherwise, val_line_delete will return NULL.
546: X_allow_delete := 'Y';
547:
548: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN
549:
550: PO_CORE_S.are_any_dists_reserved(
551: p_doc_type => PO_CORE_S.g_doc_type_PO
552: , p_doc_level => PO_CORE_S.g_doc_level_LINE

Line 754: IF (X_type_lookup_code IN ('STANDARD', 'PLANNED')) THEN

750: BEGIN
751:
752: X_progress := '010';
753:
754: IF (X_type_lookup_code IN ('STANDARD', 'PLANNED')) THEN
755:
756: --dbms_output.put_line('Unit Price = '||X_unit_price);
757: --dbms_output.put_line('Line Num = '||X_line_num);
758: --dbms_output.put_line('Item Id = '||X_item_id);