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 492: -- PO_HEADERS_ALL

488: -- PO_ENCUMBRANCE_GT
489: --Locks:
490: -- PO_REQUISITION_HEADERS_ALL
491: -- PO_REQ_DISTRIBUTIONS_ALL
492: -- PO_HEADERS_ALL
493: -- PO_RELEASES_ALL
494: -- PO_DISTRIBUTIONS_ALL
495: --Function:
496: -- This procedure populates the global temp table PO_ENCUMBRANCE_GT

Line 973: -- PO_HEADERS_ALL

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

Line 1071: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

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

Line 1884: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

1880:
1881: l_distribution_id_tbl po_tbl_number;
1882:
1883: l_doc_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1884: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1885:
1886: BEGIN
1887:
1888: IF g_debug_stmt THEN

Line 2274: , PO_HEADERS_ALL POH

2270: x_dist_id_tbl
2271: , x_origin_seq_num_tbl
2272: FROM
2273: PO_DISTRIBUTIONS_ALL POD
2274: , PO_HEADERS_ALL POH
2275: , PO_ENCUMBRANCE_GT REL_DIST
2276: WHERE POH.po_header_id = POD.po_header_id --JOIN
2277: AND POD.po_distribution_id = REL_DIST.agreement_dist_id --JOIN
2278: AND NVL(POD.prevent_encumbrance_flag,'N') = 'N'

Line 2358: -- PO_HEADERS_ALL.type_lookup_code%TYPE

2354: -- PA
2355: -- PO
2356: -- RELEASE
2357: --p_doc_subtype
2358: -- PO_HEADERS_ALL.type_lookup_code%TYPE
2359: -- PO_RELEASES_ALL.release_type%TYPE
2360: -- The document subtype. g_doc_subtype_<>
2361: -- STANDARD Standard PO
2362: -- PLANNED Planned PO

Line 2542: -- PO_HEADERS_ALL

2538: --Modifies:
2539: -- PO_ENCUMBRANCE_GT
2540: -- Submission check tables, online report table
2541: --Locks:
2542: -- PO_HEADERS_ALL
2543: -- PO_RELEASES_ALL
2544: -- PO_REQUISITION_HEADERS_ALL
2545: --Function:
2546: -- Performs the validations necessary in order for an encumbrance

Line 2663: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

2659: l_doc_level_tbl po_tbl_varchar30;
2660: l_dist_type_tbl po_tbl_varchar30;
2661: l_count_tbl po_tbl_number;
2662: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2663: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
2664: l_doc_level_id_tbl po_tbl_number;
2665: l_id_tbl po_tbl_number;
2666: l_doc_id NUMBER;
2667: l_multiple_docs_flag VARCHAR2(1);

Line 2951: , PO_HEADERS_ALL POH

2947: SELECT POD.po_distribution_id
2948: BULK COLLECT INTO l_id_tbl
2949: FROM
2950: PO_DISTRIBUTIONS_ALL POD
2951: , PO_HEADERS_ALL POH
2952: WHERE POD.po_header_id = l_doc_id
2953: AND POD.distribution_type = g_dist_type_AGREEMENT
2954: AND POH.po_header_id = POD.po_header_id
2955: AND POH.encumbrance_required_flag = 'Y'

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

4908: l_min_acct_unit_func FND_CURRENCIES.minimum_accountable_unit%TYPE;
4909: l_cur_precision_func FND_CURRENCIES.precision%TYPE;
4910:
4911: l_is_complex_work_po BOOLEAN := FALSE; --
4912: l_header_id PO_HEADERS_ALL.po_header_id%TYPE; --
4913:
4914: BEGIN
4915:
4916: -- ALGORITHM: