APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_HEADERS

Line 32: po_headers.org_id%type INDEX BY BINARY_INTEGER;

28: TYPE row_id_tbl_type is TABLE OF rowid INDEX BY BINARY_INTEGER;
29: TYPE min_dist_id_tbl_type is TABLE OF
30: po_req_distributions.distribution_id%type INDEX BY BINARY_INTEGER;
31: TYPE org_id_tbl_type is TABLE OF
32: po_headers.org_id%type INDEX BY BINARY_INTEGER;
33: TYPE round_tax_tbl_type is TABLE OF
34: po_req_distributions.recoverable_tax%type INDEX BY BINARY_INTEGER;
35: -- Bug 4723367 START
36: TYPE encumbrance_flag_tbl_type is TABLE OF

Line 2051: * req demand by looking up the consume_Req_demand_flag from po_headers

2047: * Requires: Std. workflow input parameters
2048: * Modifies: NA.
2049: *
2050: * Effects: This procedure checks whether sourcing user wanted to consume the
2051: * req demand by looking up the consume_Req_demand_flag from po_headers
2052: *
2053: * Returns: std. workflow out parameters
2054: */
2055: PROCEDURE Consume_ReqDemandYesNo

Line 2070: l_document_id po_headers.po_header_id%type;

2066: x_progress varchar2(300);
2067:
2068: l_doc_string varchar2(200);
2069: l_preparer_user_name varchar2(100);
2070: l_document_id po_headers.po_header_id%type;
2071: l_document_type po_document_types_all.document_type_code%type;
2072: l_document_subtype po_document_types_all.document_subtype%type;
2073: l_consume_req_demand_flag po_headers.consume_req_demand_flag%type := NULL;
2074:

Line 2073: l_consume_req_demand_flag po_headers.consume_req_demand_flag%type := NULL;

2069: l_preparer_user_name varchar2(100);
2070: l_document_id po_headers.po_header_id%type;
2071: l_document_type po_document_types_all.document_type_code%type;
2072: l_document_subtype po_document_types_all.document_subtype%type;
2073: l_consume_req_demand_flag po_headers.consume_req_demand_flag%type := NULL;
2074:
2075: l_resp_id number;
2076: l_user_id number;
2077: l_appl_id number;

Line 2080: l_po_revision po_headers.revision_num%type;

2076: l_user_id number;
2077: l_appl_id number;
2078:
2079: --bug2829163
2080: l_po_revision po_headers.revision_num%type;
2081:
2082: BEGIN
2083: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 01';
2084: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 2114: FROM po_headers

2110:
2111: --bug2829163
2112: SELECT NVL(REVISION_NUM,0)
2113: INTO l_po_revision
2114: FROM po_headers
2115: WHERE PO_HEADER_ID = l_document_id;
2116:
2117: END IF;
2118:

Line 2129: FROM po_headers

2125: -- place the sourcing info on the requisition. So this
2126: -- information is set in the workflow.
2127: SELECT NVL(consume_req_demand_flag,'N')
2128: INTO l_consume_req_demand_flag
2129: FROM po_headers
2130: WHERE po_header_id = l_document_id;
2131:
2132: END IF;
2133:

Line 2173: l_document_id po_headers.po_header_id%type;

2169: x_progress varchar2(300);
2170:
2171: l_doc_string varchar2(200);
2172: l_preparer_user_name varchar2(100);
2173: l_document_id po_headers.po_header_id%type;
2174: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
2175: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
2176: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
2177: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

Line 2248: FROM po_headers poh ,po_vendors pov,po_vendor_sites povs

2244: pov.vendor_name,
2245: poh.vendor_site_id,
2246: povs.vendor_site_code
2247: INTO l_vendor_id,l_vendor_name,l_vendor_site_id,l_vendor_site_code
2248: FROM po_headers poh ,po_vendors pov,po_vendor_sites povs
2249: WHERE po_header_id = l_document_id
2250: AND poh.vendor_id=pov.vendor_id
2251: AND poh.vendor_site_id=povs.vendor_site_id;
2252:

Line 2332: l_document_id po_headers.po_header_id%type;

2328: l_workflow_process varchar2(30);
2329: l_dummy varchar2(38);
2330: l_orgid number;
2331: l_interface_source varchar2(30);
2332: l_document_id po_headers.po_header_id%type;
2333:
2334: l_user_id number;
2335: l_resp_id number;
2336: l_appl_id number;