eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_DOCUMENT_TYPES

Line 2071: l_document_type po_document_types_all.document_type_code%type;

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:
2075: l_resp_id number;

Line 2072: l_document_subtype po_document_types_all.document_subtype%type;

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:
2075: l_resp_id number;
2076: l_user_id number;

Line 2174: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

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;
2178: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

Line 2175: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

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;
2178: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
2179: l_vendor_site_code PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;

Line 2340: from po_document_types

2336: l_appl_id number;
2337:
2338: cursor C1 is
2339: select WF_CREATEDOC_ITEMTYPE,WF_CREATEDOC_PROCESS
2340: from po_document_types
2341: where DOCUMENT_TYPE_CODE= 'REQUISITION'
2342: and DOCUMENT_SUBTYPE = 'PURCHASE';
2343:
2344: BEGIN