APPS.PO_REQAPPROVAL_ACTION dependencies on PO_HEADERS

Line 204: from po_headers

200: aname => 'DOCUMENT_TYPE');
201:
202: select vendor_contact_id, nvl(acceptance_required_flag, 'N'), acceptance_due_date, nvl(revision_num, 0)
203: into x_vendor_contact_id, x_acceptance_required_flag, x_acceptance_due_date, x_doc_revision
204: from po_headers
205: where po_header_id = document_id;
206:
207: if x_vendor_contact_id is not null then
208:

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

1631:
1632: x_progress varchar2(200);
1633:
1634: l_error VARCHAR2(1) := 'W'; --CONTERMS FPJ
1635: l_conterms_yn PO_headers_all.conterms_exist_Flag%Type :='N'; -- CONTERMS FPJ
1636:
1637: BEGIN
1638:
1639: --

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

2077: --
2078:
2079: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2080: ** with an action_code that is NULL and it sets the status on the
2081: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2082: */
2083:
2084: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2085: itemkey => itemkey,

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

2188: --
2189:
2190: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2191: ** with an action_code that is NULL and it sets the status on the
2192: ** DOCUMENT to 'IN PROCESS' (PO_HEADERS, REQs or RELEASES).
2193: */
2194:
2195: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2196: itemkey => itemkey,

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

2299: --
2300:
2301: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2302: ** with an action_code that is NULL and it sets the status on the
2303: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2304: */
2305:
2306: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,
2307: itemkey => itemkey,