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 213: IF (X_type_lookup_code IN ('PLANNED', 'STANDARD')) THEN

209:
210: X_progress VARCHAR2(3) := '';
211: BEGIN
212:
213: IF (X_type_lookup_code IN ('PLANNED', 'STANDARD')) THEN
214:
215: /* Delete Distributions for a PO */
216: X_progress := '010';
217: --dbms_output.put_line('Before Delete All Distributions');

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

389: AND POL.po_line_id = x_po_line_id;
390:
391: X_allow_delete := 'Y';
392:
393: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN
394:
395: PO_CORE_S.are_any_dists_reserved(
396: p_doc_type => PO_CORE_S.g_doc_type_PO
397: , p_doc_level => PO_CORE_S.g_doc_level_LINE

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

475: ** If it does, display message and prevent deletion.
476: */
477:
478: --
479: -- Only check for reserved distributions for Standard and Planned PO lines.
480:
481: SELECT POH.type_lookup_code
482: INTO l_type_lookup_code
483: FROM PO_HEADERS_ALL POH

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

487: ;
488:
489: -- Bug 3320400,
490: -- Should initialize X_allow_delete for document other than
491: -- Standard/Planned PO, otherwise, val_line_delete will return NULL.
492: X_allow_delete := 'Y';
493:
494: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN
495:

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

490: -- Should initialize X_allow_delete for document other than
491: -- Standard/Planned PO, otherwise, val_line_delete will return NULL.
492: X_allow_delete := 'Y';
493:
494: IF (l_type_lookup_code IN ('STANDARD','PLANNED')) THEN
495:
496: PO_CORE_S.are_any_dists_reserved(
497: p_doc_type => PO_CORE_S.g_doc_type_PO
498: , p_doc_level => PO_CORE_S.g_doc_level_LINE

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

696: BEGIN
697:
698: X_progress := '010';
699:
700: IF (X_type_lookup_code IN ('STANDARD', 'PLANNED')) THEN
701:
702: --dbms_output.put_line('Unit Price = '||X_unit_price);
703: --dbms_output.put_line('Line Num = '||X_line_num);
704: --dbms_output.put_line('Item Id = '||X_item_id);