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 2132: * req demand by looking up the consume_Req_demand_flag from po_headers

2128: * Requires: Std. workflow input parameters
2129: * Modifies: NA.
2130: *
2131: * Effects: This procedure checks whether sourcing user wanted to consume the
2132: * req demand by looking up the consume_Req_demand_flag from po_headers
2133: *
2134: * Returns: std. workflow out parameters
2135: */
2136: PROCEDURE Consume_ReqDemandYesNo

Line 2151: l_document_id po_headers.po_header_id%type;

2147: x_progress varchar2(300);
2148:
2149: l_doc_string varchar2(200);
2150: l_preparer_user_name varchar2(100);
2151: l_document_id po_headers.po_header_id%type;
2152: l_document_type po_document_types_all.document_type_code%type;
2153: l_document_subtype po_document_types_all.document_subtype%type;
2154: l_consume_req_demand_flag po_headers.consume_req_demand_flag%type := NULL;
2155:

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

2150: l_preparer_user_name varchar2(100);
2151: l_document_id po_headers.po_header_id%type;
2152: l_document_type po_document_types_all.document_type_code%type;
2153: l_document_subtype po_document_types_all.document_subtype%type;
2154: l_consume_req_demand_flag po_headers.consume_req_demand_flag%type := NULL;
2155:
2156: l_resp_id number;
2157: l_user_id number;
2158: l_appl_id number;

Line 2161: l_po_revision po_headers.revision_num%type;

2157: l_user_id number;
2158: l_appl_id number;
2159:
2160: --bug2829163
2161: l_po_revision po_headers.revision_num%type;
2162:
2163: BEGIN
2164: x_progress := 'PO_NEGOTIATIONS4_PVT.Consume_ReqDemandYesNo: 01';
2165: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 2195: FROM po_headers

2191:
2192: --bug2829163
2193: SELECT NVL(REVISION_NUM,0)
2194: INTO l_po_revision
2195: FROM po_headers
2196: WHERE PO_HEADER_ID = l_document_id;
2197:
2198: END IF;
2199:

Line 2210: FROM po_headers

2206: -- place the sourcing info on the requisition. So this
2207: -- information is set in the workflow.
2208: SELECT NVL(consume_req_demand_flag,'N')
2209: INTO l_consume_req_demand_flag
2210: FROM po_headers
2211: WHERE po_header_id = l_document_id;
2212:
2213: END IF;
2214:

Line 2254: l_document_id po_headers.po_header_id%type;

2250: x_progress varchar2(300);
2251:
2252: l_doc_string varchar2(200);
2253: l_preparer_user_name varchar2(100);
2254: l_document_id po_headers.po_header_id%type;
2255: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
2256: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
2257: l_vendor_id PO_VENDORS.VENDOR_ID%TYPE;
2258: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

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

2325: pov.vendor_name,
2326: poh.vendor_site_id,
2327: povs.vendor_site_code
2328: INTO l_vendor_id,l_vendor_name,l_vendor_site_id,l_vendor_site_code
2329: FROM po_headers poh ,po_vendors pov,po_vendor_sites povs
2330: WHERE po_header_id = l_document_id
2331: AND poh.vendor_id=pov.vendor_id
2332: AND poh.vendor_site_id=povs.vendor_site_id;
2333:

Line 2413: l_document_id po_headers.po_header_id%type;

2409: l_workflow_process varchar2(30);
2410: l_dummy varchar2(38);
2411: l_orgid number;
2412: l_interface_source varchar2(30);
2413: l_document_id po_headers.po_header_id%type;
2414:
2415: l_user_id number;
2416: l_resp_id number;
2417: l_appl_id number;