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 27: from po_headers_all

23:
24: Cursor GetPOHdr_csr(p_po_header_id NUMBER) RETURN POHdrRecord is
25: select PO_HEADER_ID,COMMENTS,AUTHORIZATION_STATUS,
26: TYPE_LOOKUP_CODE,AGENT_ID,SEGMENT1,CLOSED_CODE,CURRENCY_CODE
27: from po_headers_all
28: where PO_HEADER_ID = p_po_header_id;
29:
30:
31: Cursor GetDraftPOHdr_csr(p_po_header_id NUMBER, p_draft_id number) RETURN POHdrRecord is

Line 34: from po_headers_draft_all

30:
31: Cursor GetDraftPOHdr_csr(p_po_header_id NUMBER, p_draft_id number) RETURN POHdrRecord is
32: select PO_HEADER_ID,COMMENTS,AUTHORIZATION_STATUS,
33: TYPE_LOOKUP_CODE,AGENT_ID,SEGMENT1,CLOSED_CODE,CURRENCY_CODE
34: from po_headers_draft_all
35: where PO_HEADER_ID = p_po_header_id
36: and draft_id = p_draft_id;
37:
38: Cursor GetRelHdr_csr(p_rel_header_id NUMBER) RETURN RelHdrRecord is

Line 43: from po_releases_all PORL, po_headers_all POH

39: select PORL.PO_RELEASE_ID,PORL.PO_HEADER_ID,PORL.AUTHORIZATION_STATUS,
40: PORL.RELEASE_TYPE,PORL.AGENT_ID,PORL.RELEASE_NUM,PORL.CLOSED_CODE,
41: POH.SEGMENT1, POH.CURRENCY_CODE, POH.COMMENTS
42: -- Bug 10140786 Selected comments to set PO_DESCRIPTION in release workflow.
43: from po_releases_all PORL, po_headers_all POH
44: where PORL.PO_RELEASE_ID = p_rel_header_id
45: and PORL.po_header_id = POH.po_header_id;
46:
47: -- The following are local/Private procedure that support the workflow APIs:

Line 142: FROM po_headers_all

138: IF l_doc_type IN ('PO', 'PA') THEN
139:
140: SELECT (Nvl (comm_rev_num, -1))
141: INTO l_po_revision_num_orig
142: FROM po_headers_all
143: WHERE po_header_id = l_po_header_id;
144:
145: -- added for bug 9072034 (to check revision number for releases.)
146: ELSIF l_doc_type in ('RELEASE') THEN

Line 386: from po_headers

382: IF l_doc_type IN ('PO','PA') THEN
383:
384: select acceptance_required_flag,acceptance_due_date
385: into l_acceptance_required, l_acceptance_due_date
386: from po_headers
387: where po_header_id= l_po_header_id;
388:
389: ELSIF l_doc_type='RELEASE' THEN
390:

Line 448: --Bug 13742477 :: If draft id is null, it should fetch the records from PO_HEADERS_ALL

444: -- CLM Aprvl
445: l_draft_id := po_wf_util_pkg. GetItemAttrNumber (itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'DRAFT_ID');
448: --Bug 13742477 :: If draft id is null, it should fetch the records from PO_HEADERS_ALL
449: If (l_draft_id = -1 OR l_draft_id is null) Then
450:
451: /* Fetch the PO Header, then set the attributes. */
452: open GetPOHdr_csr(p_po_header_id);

Line 458: /* Fetch the PO Headers Draft, then set the attributes. */

454: close GetPOHdr_csr;
455:
456: Else
457: -- CLM Aprvl
458: /* Fetch the PO Headers Draft, then set the attributes. */
459: open GetDraftPOHdr_csr(p_po_header_id, l_draft_id);
460: FETCH GetDraftPOHdr_csr into POHdr_rec;
461: close GetDraftPOHdr_csr;
462:

Line 1237: l_doc_subtype po_headers_all.type_lookup_code%TYPE;

1233: doc_cancel_flag VARCHAR2)
1234: return BOOLEAN
1235: is
1236: l_progress varchar2(200);
1237: l_doc_subtype po_headers_all.type_lookup_code%TYPE;
1238: p_return_status varchar2(1);
1239: p_action_flag varchar2(1);
1240:
1241: begin

Line 1260: FROM po_headers

1256: IF (doc_type_code IN ('PO', 'PA')) THEN
1257:
1258: SELECT type_lookup_code
1259: INTO l_doc_subtype
1260: FROM po_headers
1261: WHERE po_header_id = doc_header_id;
1262:
1263: ELSIF (doc_type_code = 'RELEASE') THEN
1264: SELECT shipment_type

Line 1513: po_headers POH

1509: po_line_locations PLL,
1510: -- For Shared Procurement, the destination OU may be different from
1511: -- the Purchasing OU:
1512: po_requisition_lines_all PRL,
1513: po_headers POH
1514: WHERE POL.po_line_id = p_po_line_id
1515: AND POL.po_line_id = PLL.po_line_id -- JOIN
1516: AND PLL.line_location_id = PRL.line_location_id (+) -- JOIN
1517: AND POH.po_header_id = POL.po_header_id -- JOIN

Line 1544: l_agent_id PO_HEADERS.agent_id%TYPE;

1540: AND PLL.shipment_type <> 'PREPAYMENT'
1541: ORDER BY PLL.shipment_num, POD.distribution_num ASC;
1542:
1543: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE := null;
1544: l_agent_id PO_HEADERS.agent_id%TYPE;
1545: l_po_header_id PO_HEADERS.po_header_id%TYPE;
1546: BEGIN
1547: -- Determine the recipient of this notification using the 3 rules below:
1548:

Line 1545: l_po_header_id PO_HEADERS.po_header_id%TYPE;

1541: ORDER BY PLL.shipment_num, POD.distribution_num ASC;
1542:
1543: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE := null;
1544: l_agent_id PO_HEADERS.agent_id%TYPE;
1545: l_po_header_id PO_HEADERS.po_header_id%TYPE;
1546: BEGIN
1547: -- Determine the recipient of this notification using the 3 rules below:
1548:
1549: -- Rule 1. If the PO line has a backing requisition, use the requester

Line 1659: p_po_header_id PO_HEADERS.po_header_id%TYPE,

1655: l_proc_name VARCHAR2(30) := 'launch_notify_tl_requesters';
1656: l_progress VARCHAR2(3) := '000';
1657:
1658: CURSOR l_temp_labor_lines_csr (
1659: p_po_header_id PO_HEADERS.po_header_id%TYPE,
1660: p_is_new_document VARCHAR2
1661: ) IS
1662: -- SQL What: Retrieves the Temp Labor lines of the given PO.
1663: -- We retrieve all lines if this is a new PO, or just the

Line 1670: FROM po_headers POH,

1666: SELECT POL.po_line_id,
1667: POL.contractor_first_name,
1668: POL.contractor_last_name,
1669: PJ.name job_name
1670: FROM po_headers POH,
1671: po_lines POL,
1672: per_jobs_vl PJ
1673: WHERE POH.po_header_id = p_po_header_id
1674: AND POH.po_header_id = POL.po_header_id -- JOIN

Line 1690: l_document_id PO_HEADERS.po_header_id%TYPE;

1686: AND PLA.revision_num <> POH.revision_num));
1687:
1688: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
1689:
1690: l_document_id PO_HEADERS.po_header_id%TYPE;
1691: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1692: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1693: l_is_new_document VARCHAR2(1);
1694: l_contractor_or_job VARCHAR2(500);

Line 1853: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

1849: l_proc_name VARCHAR2(30) := 'start_po_line_wf_process';
1850: l_progress VARCHAR2(3) := '000';
1851: l_requester_user_name WF_USERS.name%TYPE;
1852: l_requester_disp_name WF_USERS.display_name%TYPE;
1853: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1854: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1855: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1856: l_create_cwk_url VARCHAR2(500);
1857: BEGIN

Line 1855: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1851: l_requester_user_name WF_USERS.name%TYPE;
1852: l_requester_disp_name WF_USERS.display_name%TYPE;
1853: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1854: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1855: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1856: l_create_cwk_url VARCHAR2(500);
1857: BEGIN
1858: IF (g_po_wf_debug = 'Y') THEN
1859: PO_WF_DEBUG_PKG.insert_debug ( p_item_type, p_item_key,

Line 1927: po_headers POH,

1923: INTO l_po_header_id,
1924: l_document_number,
1925: l_req_header_id
1926: FROM po_lines POL,
1927: po_headers POH,
1928: po_line_locations PLL,
1929: po_requisition_lines_all PRL
1930: WHERE POL.po_line_id = p_po_line_id
1931: AND POL.po_header_id = POH.po_header_id -- JOIN

Line 2046: FROM po_headers_all

2042: WHERE po_release_id = p_doc_id;
2043: ELSE
2044: SELECT approved_date
2045: INTO x_approved_date
2046: FROM po_headers_all
2047: WHERE po_header_id= p_doc_id;
2048: END IF;
2049:
2050: IF g_debug_stmt THEN