APPS.PO_POAPPROVAL_INIT1 dependencies on PO_HEADERS_ALL

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