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_POAPPROVAL_INIT1 dependencies on PO_HEADERS

Line 26: from po_headers_all

22:
23: Cursor GetPOHdr_csr(p_po_header_id NUMBER) RETURN POHdrRecord is
24: select PO_HEADER_ID,COMMENTS,AUTHORIZATION_STATUS,
25: TYPE_LOOKUP_CODE,AGENT_ID,SEGMENT1,CLOSED_CODE,CURRENCY_CODE
26: from po_headers_all
27: where PO_HEADER_ID = p_po_header_id;
28:
29: Cursor GetRelHdr_csr(p_rel_header_id NUMBER) RETURN RelHdrRecord is
30: select PORL.PO_RELEASE_ID,PORL.PO_HEADER_ID,PORL.AUTHORIZATION_STATUS,

Line 33: from po_releases_all PORL, po_headers_all POH

29: Cursor GetRelHdr_csr(p_rel_header_id NUMBER) RETURN RelHdrRecord is
30: select PORL.PO_RELEASE_ID,PORL.PO_HEADER_ID,PORL.AUTHORIZATION_STATUS,
31: PORL.RELEASE_TYPE,PORL.AGENT_ID,PORL.RELEASE_NUM,PORL.CLOSED_CODE,
32: POH.SEGMENT1, POH.CURRENCY_CODE
33: from po_releases_all PORL, po_headers_all POH
34: where PORL.PO_RELEASE_ID = p_rel_header_id
35: and PORL.po_header_id = POH.po_header_id;
36:
37: -- The following are local/Private procedure that support the workflow APIs:

Line 317: from po_headers

313: IF l_doc_type IN ('PO','PA') THEN
314:
315: select acceptance_required_flag,acceptance_due_date
316: into l_acceptance_required, l_acceptance_due_date
317: from po_headers
318: where po_header_id= l_po_header_id;
319:
320: ELSIF l_doc_type='RELEASE' THEN
321:

Line 1005: l_doc_subtype po_headers_all.type_lookup_code%TYPE;

1001: doc_cancel_flag VARCHAR2)
1002: return BOOLEAN
1003: is
1004: l_progress varchar2(200);
1005: l_doc_subtype po_headers_all.type_lookup_code%TYPE;
1006: p_return_status varchar2(1);
1007: p_action_flag varchar2(1);
1008:
1009: begin

Line 1028: FROM po_headers

1024: IF (doc_type_code IN ('PO', 'PA')) THEN
1025:
1026: SELECT type_lookup_code
1027: INTO l_doc_subtype
1028: FROM po_headers
1029: WHERE po_header_id = doc_header_id;
1030:
1031: ELSIF (doc_type_code = 'RELEASE') THEN
1032: SELECT shipment_type

Line 1281: po_headers POH

1277: po_line_locations PLL,
1278: -- For Shared Procurement, the destination OU may be different from
1279: -- the Purchasing OU:
1280: po_requisition_lines_all PRL,
1281: po_headers POH
1282: WHERE POL.po_line_id = p_po_line_id
1283: AND POL.po_line_id = PLL.po_line_id -- JOIN
1284: AND PLL.line_location_id = PRL.line_location_id (+) -- JOIN
1285: AND POH.po_header_id = POL.po_header_id -- JOIN

Line 1312: l_agent_id PO_HEADERS.agent_id%TYPE;

1308: AND PLL.shipment_type <> 'PREPAYMENT'
1309: ORDER BY PLL.shipment_num, POD.distribution_num ASC;
1310:
1311: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE := null;
1312: l_agent_id PO_HEADERS.agent_id%TYPE;
1313: l_po_header_id PO_HEADERS.po_header_id%TYPE;
1314: BEGIN
1315: -- Determine the recipient of this notification using the 3 rules below:
1316:

Line 1313: l_po_header_id PO_HEADERS.po_header_id%TYPE;

1309: ORDER BY PLL.shipment_num, POD.distribution_num ASC;
1310:
1311: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE := null;
1312: l_agent_id PO_HEADERS.agent_id%TYPE;
1313: l_po_header_id PO_HEADERS.po_header_id%TYPE;
1314: BEGIN
1315: -- Determine the recipient of this notification using the 3 rules below:
1316:
1317: -- Rule 1. If the PO line has a backing requisition, use the requester

Line 1427: p_po_header_id PO_HEADERS.po_header_id%TYPE,

1423: l_proc_name VARCHAR2(30) := 'launch_notify_tl_requesters';
1424: l_progress VARCHAR2(3) := '000';
1425:
1426: CURSOR l_temp_labor_lines_csr (
1427: p_po_header_id PO_HEADERS.po_header_id%TYPE,
1428: p_is_new_document VARCHAR2
1429: ) IS
1430: -- SQL What: Retrieves the Temp Labor lines of the given PO.
1431: -- We retrieve all lines if this is a new PO, or just the

Line 1438: FROM po_headers POH,

1434: SELECT POL.po_line_id,
1435: POL.contractor_first_name,
1436: POL.contractor_last_name,
1437: PJ.name job_name
1438: FROM po_headers POH,
1439: po_lines POL,
1440: per_jobs_vl PJ
1441: WHERE POH.po_header_id = p_po_header_id
1442: AND POH.po_header_id = POL.po_header_id -- JOIN

Line 1458: l_document_id PO_HEADERS.po_header_id%TYPE;

1454: AND PLA.revision_num <> POH.revision_num));
1455:
1456: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
1457:
1458: l_document_id PO_HEADERS.po_header_id%TYPE;
1459: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1460: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1461: l_is_new_document VARCHAR2(1);
1462: l_contractor_or_job VARCHAR2(500);

Line 1609: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

1605: l_proc_name VARCHAR2(30) := 'start_po_line_wf_process';
1606: l_progress VARCHAR2(3) := '000';
1607: l_requester_user_name WF_USERS.name%TYPE;
1608: l_requester_disp_name WF_USERS.display_name%TYPE;
1609: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1610: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1611: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1612: l_create_cwk_url VARCHAR2(500);
1613: BEGIN

Line 1611: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1607: l_requester_user_name WF_USERS.name%TYPE;
1608: l_requester_disp_name WF_USERS.display_name%TYPE;
1609: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1610: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1611: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1612: l_create_cwk_url VARCHAR2(500);
1613: BEGIN
1614: IF (g_po_wf_debug = 'Y') THEN
1615: PO_WF_DEBUG_PKG.insert_debug ( p_item_type, p_item_key,

Line 1676: po_headers POH,

1672: INTO l_po_header_id,
1673: l_document_number,
1674: l_req_header_id
1675: FROM po_lines POL,
1676: po_headers POH,
1677: po_line_locations PLL,
1678: po_requisition_lines_all PRL
1679: WHERE POL.po_line_id = p_po_line_id
1680: AND POL.po_header_id = POH.po_header_id -- JOIN

Line 1794: FROM po_headers_all

1790: WHERE po_release_id = p_doc_id;
1791: ELSE
1792: SELECT approved_date
1793: INTO x_approved_date
1794: FROM po_headers_all
1795: WHERE po_header_id= p_doc_id;
1796: END IF;
1797:
1798: IF g_debug_stmt THEN