eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_HEADERS_ALL

Line 115: PO_HEADERS_ALL.type_lookup_code%TYPE

111:
112:
113: -- doc subtypes
114: g_doc_subtype_STANDARD CONSTANT
115: PO_HEADERS_ALL.type_lookup_code%TYPE
116: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD
117: ;
118: g_doc_subtype_PLANNED CONSTANT
119: PO_HEADERS_ALL.type_lookup_code%TYPE

Line 119: PO_HEADERS_ALL.type_lookup_code%TYPE

115: PO_HEADERS_ALL.type_lookup_code%TYPE
116: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD
117: ;
118: g_doc_subtype_PLANNED CONSTANT
119: PO_HEADERS_ALL.type_lookup_code%TYPE
120: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED
121: ;
122: g_doc_subtype_BLANKET CONSTANT
123: PO_RELEASES_ALL.release_type%TYPE

Line 131: PO_HEADERS_ALL.type_lookup_code%TYPE

127: PO_RELEASES_ALL.release_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED
129: ;
130: g_doc_subtype_MIXED_PO_RELEASE CONSTANT
131: PO_HEADERS_ALL.type_lookup_code%TYPE
132: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_MIXED_PO_RELEASE
133: ;
134:
135:

Line 206: PO_HEADERS_ALL.closed_code%TYPE

202:
203:
204: -- closed codes
205: g_clsd_FINALLY_CLOSED CONSTANT
206: PO_HEADERS_ALL.closed_code%TYPE
207: := 'FINALLY CLOSED'
208: ;
209: g_clsd_OPEN CONSTANT
210: PO_HEADERS_ALL.closed_code%TYPE

Line 210: PO_HEADERS_ALL.closed_code%TYPE

206: PO_HEADERS_ALL.closed_code%TYPE
207: := 'FINALLY CLOSED'
208: ;
209: g_clsd_OPEN CONSTANT
210: PO_HEADERS_ALL.closed_code%TYPE
211: := 'OPEN'
212: ;
213:
214:

Line 489: -- PO_HEADERS_ALL

485: -- PO_ENCUMBRANCE_GT
486: --Locks:
487: -- PO_REQUISITION_HEADERS_ALL
488: -- PO_REQ_DISTRIBUTIONS_ALL
489: -- PO_HEADERS_ALL
490: -- PO_RELEASES_ALL
491: -- PO_DISTRIBUTIONS_ALL
492: --Function:
493: -- This procedure populates the global temp table PO_ENCUMBRANCE_GT

Line 970: -- PO_HEADERS_ALL

966: -- PO_ENCUMBRANCE_GT
967: --Locks:
968: -- PO_REQUISITION_HEADERS_ALL
969: -- PO_REQ_DISTRIBUTIONS_ALL
970: -- PO_HEADERS_ALL
971: -- PO_RELEASES_ALL
972: -- PO_DISTRIBUTIONS_ALL
973: --Function:
974: -- Populate the encumbrance table with whatever data is necessary for

Line 1068: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

1064: l_origin_seq_num_tbl po_tbl_number;
1065:
1066: l_return_status VARCHAR2(1);
1067: l_doc_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1068: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1069: l_doc_level VARCHAR2(25);
1070: l_check_only_flag VARCHAR2(1);
1071:
1072: BEGIN

Line 1846: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

1842:
1843: l_distribution_id_tbl po_tbl_number;
1844:
1845: l_doc_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1846: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1847:
1848: BEGIN
1849:
1850: IF g_debug_stmt THEN

Line 2236: , PO_HEADERS_ALL POH

2232: x_dist_id_tbl
2233: , x_origin_seq_num_tbl
2234: FROM
2235: PO_DISTRIBUTIONS_ALL POD
2236: , PO_HEADERS_ALL POH
2237: , PO_ENCUMBRANCE_GT REL_DIST
2238: WHERE POH.po_header_id = POD.po_header_id --JOIN
2239: AND POD.po_distribution_id = REL_DIST.agreement_dist_id --JOIN
2240: AND NVL(POD.prevent_encumbrance_flag,'N') = 'N'

Line 2320: -- PO_HEADERS_ALL.type_lookup_code%TYPE

2316: -- PA
2317: -- PO
2318: -- RELEASE
2319: --p_doc_subtype
2320: -- PO_HEADERS_ALL.type_lookup_code%TYPE
2321: -- PO_RELEASES_ALL.release_type%TYPE
2322: -- The document subtype. g_doc_subtype_<>
2323: -- STANDARD Standard PO
2324: -- PLANNED Planned PO

Line 2504: -- PO_HEADERS_ALL

2500: --Modifies:
2501: -- PO_ENCUMBRANCE_GT
2502: -- Submission check tables, online report table
2503: --Locks:
2504: -- PO_HEADERS_ALL
2505: -- PO_RELEASES_ALL
2506: -- PO_REQUISITION_HEADERS_ALL
2507: --Function:
2508: -- Performs the validations necessary in order for an encumbrance

Line 2625: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

2621: l_doc_level_tbl po_tbl_varchar30;
2622: l_dist_type_tbl po_tbl_varchar30;
2623: l_count_tbl po_tbl_number;
2624: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2625: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2626: l_doc_level_id_tbl po_tbl_number;
2627: l_id_tbl po_tbl_number;
2628: l_doc_id NUMBER;
2629: l_multiple_docs_flag VARCHAR2(1);

Line 2913: , PO_HEADERS_ALL POH

2909: SELECT POD.po_distribution_id
2910: BULK COLLECT INTO l_id_tbl
2911: FROM
2912: PO_DISTRIBUTIONS_ALL POD
2913: , PO_HEADERS_ALL POH
2914: WHERE POD.po_header_id = l_doc_id
2915: AND POD.distribution_type = g_dist_type_AGREEMENT
2916: AND POH.po_header_id = POD.po_header_id
2917: AND POH.encumbrance_required_flag = 'Y'

Line 4761: l_header_id PO_HEADERS_ALL.po_header_id%TYPE; --

4757: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
4758: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
4759:
4760: l_is_complex_work_po BOOLEAN := FALSE; --
4761: l_header_id PO_HEADERS_ALL.po_header_id%TYPE; --
4762:
4763: BEGIN
4764:
4765: -- ALGORITHM: