APPS.PO_MOD_CONTROL_PVT dependencies on PO_LINES_ALL

Line 559: DELETE FROM po_lines_all_ext_b

555: DELETE FROM po_headers_all_ext_tl
556: WHERE draft_id = p_draft_id
557: AND po_header_id = p_entity_id;
558:
559: DELETE FROM po_lines_all_ext_b
560: WHERE (draft_id = p_draft_id --main record for Mod
561: AND po_line_id IN (SELECT po_line_id
562: FROM po_lines_draft_all
563: WHERE po_header_id = p_entity_id

Line 578: DELETE FROM po_lines_all_ext_tl

574: FROM po_lines_draft_all
575: WHERE po_header_id = p_entity_id
576: AND draft_id = p_draft_id));
577:
578: DELETE FROM po_lines_all_ext_tl
579: WHERE (draft_id = p_draft_id --main record for Mod
580: AND po_line_id IN (SELECT po_line_id
581: FROM po_lines_draft_all
582: WHERE po_header_id = p_entity_id

Line 613: DELETE FROM po_lines_all_ext_b

609: AND draft_id = p_draft_id);
610:
611: ELSIF p_entity_level = 'PO_LINE' THEN
612:
613: DELETE FROM po_lines_all_ext_b
614: WHERE ( draft_id = p_draft_id -- main record for Mod
615: AND po_line_id = p_entity_id)
616: OR ( draft_id = -p_draft_id -- delta record for complex pricing
617: AND po_line_id = -p_entity_id

Line 630: DELETE FROM po_lines_all_ext_tl

626: FROM po_line_locations_draft_all
627: WHERE po_line_id = p_entity_id
628: AND draft_id = p_draft_id);
629:
630: DELETE FROM po_lines_all_ext_tl
631: WHERE ( draft_id = p_draft_id -- main record for Mod
632: AND po_line_id = p_entity_id)
633: OR ( draft_id = -p_draft_id -- delta record for complex pricing
634: AND po_line_id = -p_entity_id

Line 877: l_item_id PO_LINES_ALL.item_Id%TYPE;

873: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;
874: l_cons_trans_exist VARCHAR2(1);
875: l_index NUMBER;
876: l_agent_id NUMBER;
877: l_item_id PO_LINES_ALL.item_Id%TYPE;
878: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
879: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
880: l_mode VARCHAR2(30);
881: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';

Line 878: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

874: l_cons_trans_exist VARCHAR2(1);
875: l_index NUMBER;
876: l_agent_id NUMBER;
877: l_item_id PO_LINES_ALL.item_Id%TYPE;
878: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
879: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
880: l_mode VARCHAR2(30);
881: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';
882: d_pos NUMBER;

Line 932: FROM po_lines_merge_v -- Replaced po_lines_all

928: d_pos := 40;
929: --get the itme_id for the consumption transaction existence check
930: SELECT item_id
931: INTO l_item_id
932: FROM po_lines_merge_v -- Replaced po_lines_all
933: WHERE po_line_id = p_doc_level_id
934: AND draft_id = p_draft_id;
935:
936: IF (PO_LOG.d_stmt) THEN