APPS.PO_POAPPROVAL_INIT1 dependencies on PO_HEADERS_ALL

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 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 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 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 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 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