APPS.PO_REQAPPROVAL_ACTION dependencies on PO_HEADERS

Line 209: from po_headers

205: aname => 'DOCUMENT_TYPE');
206:
207: select vendor_contact_id, nvl(acceptance_required_flag, 'N'), acceptance_due_date, nvl(revision_num, 0)
208: into x_vendor_contact_id, x_acceptance_required_flag, x_acceptance_due_date, x_doc_revision
209: from po_headers
210: where po_header_id = document_id;
211:
212: if x_vendor_contact_id is not null then
213:

Line 1730: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N'; -- CONTERMS FPJ

1726:
1727: x_progress varchar2(200);
1728:
1729: l_error VARCHAR2(1) := 'W'; --CONTERMS FPJ
1730: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N'; -- CONTERMS FPJ
1731: l_draft_id Number; -- CLM Aprvl
1732:
1733: BEGIN
1734:

Line 2263: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).

2259: --
2260:
2261: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2262: ** with an action_code that is NULL and it sets the status on the
2263: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2264: */
2265:
2266: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2267: itemkey => itemkey,

Line 2374: ** DOCUMENT to 'IN PROCESS' (PO_HEADERS, REQs or RELEASES).

2370: --
2371:
2372: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2373: ** with an action_code that is NULL and it sets the status on the
2374: ** DOCUMENT to 'IN PROCESS' (PO_HEADERS, REQs or RELEASES).
2375: */
2376:
2377: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2378: itemkey => itemkey,

Line 2485: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).

2481: --
2482:
2483: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2484: ** with an action_code that is NULL and it sets the status on the
2485: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2486: */
2487:
2488: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2489: itemkey => itemkey,