DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on PO_HEADERS_ALL

Line 551: DELETE FROM po_headers_all_ext_b

547: PO_LOG.proc_begin(d_module);
548: END IF;
549:
550: IF p_entity_level = 'PO_HEADER' THEN
551: DELETE FROM po_headers_all_ext_b
552: WHERE draft_id = p_draft_id
553: AND po_header_id = p_entity_id;
554:
555: DELETE FROM po_headers_all_ext_tl

Line 555: DELETE FROM po_headers_all_ext_tl

551: DELETE FROM po_headers_all_ext_b
552: WHERE draft_id = p_draft_id
553: AND po_header_id = p_entity_id;
554:
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

Line 873: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;

869: ,x_valid_ctrl_ctn_tbl OUT NOCOPY PO_TBL_VARCHAR30)
870: IS
871: l_valid_actions_tbl PO_DOCUMENT_CONTROL_PVT.g_lookup_code_tbl_type;
872: l_displayed_field_tbl PO_DOCUMENT_CONTROL_PVT.g_displayed_field_tbl_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;

Line 908: FROM po_headers_all

904: --Get Document Sub type
905: IF(p_doc_type IN (PO_CORE_S.g_doc_type_PO, PO_CORE_S.g_doc_type_PA)) THEN
906: SELECT type_lookup_code
907: INTO l_doc_subtype
908: FROM po_headers_all
909: WHERE po_header_id = p_doc_header_id;
910: END IF;
911: d_pos := 20;
912: IF (PO_LOG.d_stmt) THEN