APPS.PO_DRAFT_MERGE_PKG dependencies on PO_HEADERS_ALL

Line 742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

738:
739:
740: l_control_action varchar2(30);
741: p_document_id NUMBER;
742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
745: v_doc_line_id NUMBER;--13004199
746: l_line_id NUMBER;

Line 743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

739:
740: l_control_action varchar2(30);
741: p_document_id NUMBER;
742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
745: v_doc_line_id NUMBER;--13004199
746: l_line_id NUMBER;
747: l_shipment_id NUMBER;

Line 744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

740: l_control_action varchar2(30);
741: p_document_id NUMBER;
742: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
743: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
744: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
745: v_doc_line_id NUMBER;--13004199
746: l_line_id NUMBER;
747: l_shipment_id NUMBER;
748: x_return_status VARCHAR2(1);

Line 963: po_headers_all poh

959: BEGIN
960: SELECT clm_flag
961: INTO l_is_clm_document
962: FROM po_doc_style_headers psh,
963: po_headers_all poh
964: WHERE psh.style_id = poh.style_id
965: AND poh.po_header_id = l_document_id;
966: EXCEPTION
967: WHEN no_data_found THEN

Line 1075: FROM po_headers_all

1071: --Mod Commercialization
1072:
1073: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID
1074: INTO l_functional_area_code, l_document_type_code, l_document_style_id
1075: FROM po_headers_all
1076: WHERE PO_HEADER_ID = p_document_id;
1077:
1078: g_action := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : PO_CLM_CLO_UTIL.Check_Uda_Enabled';
1079: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,g_action);

Line 2017: l_effective_date po_headers_all.clm_effective_date%TYPE;

2013: )
2014: IS
2015: d_progress NUMBER;
2016: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_delivery_event_attr';
2017: l_effective_date po_headers_all.clm_effective_date%TYPE;
2018: BEGIN
2019:
2020: d_progress := 0;
2021: IF (PO_LOG.d_proc) THEN

Line 2034: FROM po_headers_all

2030: IF(p_draft_id = -1) THEN
2031:
2032: SELECT clm_effective_date
2033: INTO l_effective_date
2034: FROM po_headers_all
2035: WHERE po_header_id = p_document_id;
2036:
2037: d_progress := 1;
2038:

Line 2043: FROM po_headers_all pha, po_drafts pd

2039: ELSE
2040:
2041: SELECT pd.MOD_EFFECTIVE_DATE
2042: INTO l_effective_date
2043: FROM po_headers_all pha, po_drafts pd
2044: WHERE pha.po_header_id = p_document_id
2045: AND pha.po_header_id = pd.document_id
2046: AND pd.draft_id = p_draft_id;
2047: