APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_HEADERS

Line 2462: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

2458: l_log_head CONSTANT varchar2(240) := g_pkg_name || l_api_name;
2459: l_progress VARCHAR2(3) := '000';
2460: l_action VARCHAR2(30);
2461: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2462: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2463: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
2464: l_po_return_code VARCHAR2(10);
2465: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
2466:

Line 2692: -- relies on the org-striped view po_headers

2688: --Start of Comments
2689: --Name: is_agreement_encumbered
2690: --Pre-reqs:
2691: -- The org context must be set before calling this procedure, as it
2692: -- relies on the org-striped view po_headers
2693: --Modifies:
2694: -- N/A.
2695: --Locks:
2696: -- None.

Line 2796: FROM PO_HEADERS POH

2792:
2793: UPDATE PO_SESSION_GT TEMP
2794: SET char1 =
2795: (SELECT POH.encumbrance_required_flag
2796: FROM PO_HEADERS POH
2797: WHERE POH.po_header_id = TEMP.num1
2798: )
2799: WHERE TEMP.key = l_procedure_id
2800: ;

Line 3126: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;

3122: -- bug 3518116
3123: l_action VARCHAR2(30);
3124: l_doc_id_tbl po_tbl_number;
3125: --
3126: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3127: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3128: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3129: l_return_status VARCHAR2(1);
3130:

Line 3128: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;

3124: l_doc_id_tbl po_tbl_number;
3125: --
3126: l_po_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3127: l_req_document_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%type;
3128: l_rel_document_id PO_HEADERS_ALL.PO_HEADER_ID%type;
3129: l_return_status VARCHAR2(1);
3130:
3131:
3132: /* bug#6069405 start*/

Line 4284: -- PO_HEADERS_ALL

4280: -- None.
4281: --Modifies:
4282: -- PO_ENCUMBRANCE_GT
4283: --Locks:
4284: -- PO_HEADERS_ALL
4285: -- PO_RELEASES_ALL
4286: -- PO_DISTRIBUTIONS_ALL
4287: -- PO_REQUISITION_HEADERS_ALL
4288: -- PO_REQ_DISTRIBUTIONS_ALL

Line 4664: , PO_HEADERS_ALL POH

4660: FROM
4661: PO_DISTRIBUTIONS_ALL POD
4662: , PO_LINE_LOCATIONS_ALL POLL
4663: , PO_LINES_ALL POL
4664: , PO_HEADERS_ALL POH
4665: , PO_SESSION_GT DIST_IDS
4666: WHERE POH.po_header_id = POD.po_header_id --JOIN
4667: AND POL.po_line_id(+) = POD.po_line_id --JOIN
4668: -- the distributions of PAs don't have associated lines