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_DISTRIBUTIONS_ALL

Line 157: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

153:
154:
155: -- distribution types
156: g_dist_type_STANDARD CONSTANT
157: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
158: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD
159: ;
160: g_dist_type_PLANNED CONSTANT
161: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 161: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

157: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
158: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD
159: ;
160: g_dist_type_PLANNED CONSTANT
161: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
162: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED
163: ;
164: g_dist_type_SCHEDULED CONSTANT
165: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 165: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

161: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
162: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED
163: ;
164: g_dist_type_SCHEDULED CONSTANT
165: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
166: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED
167: ;
168: g_dist_type_BLANKET CONSTANT
169: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 169: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

165: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
166: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED
167: ;
168: g_dist_type_BLANKET CONSTANT
169: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
170: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET
171: ;
172: g_dist_type_AGREEMENT CONSTANT
173: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 173: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

169: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
170: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET
171: ;
172: g_dist_type_AGREEMENT CONSTANT
173: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
174: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT
175: ;
176: g_dist_type_REQUISITION CONSTANT
177: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 177: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

173: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
174: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT
175: ;
176: g_dist_type_REQUISITION CONSTANT
177: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
178: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION
179: ;
180: g_dist_type_MIXED_PO_RELEASE CONSTANT
181: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 181: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

177: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
178: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION
179: ;
180: g_dist_type_MIXED_PO_RELEASE CONSTANT
181: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
182: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE
183: ;
184: g_dist_type_PREPAYMENT CONSTANT
185: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 185: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

181: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
182: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE
183: ;
184: g_dist_type_PREPAYMENT CONSTANT
185: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
186: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PREPAYMENT
187: ;
188:
189: -- parameter values

Line 491: -- PO_DISTRIBUTIONS_ALL

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
494: -- with all of the information required for each distribution that has any
495: -- encumbrance impact.

Line 589: l_dist_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

585: l_api_name CONSTANT VARCHAR2(30) := 'GET_ALL_DISTRIBUTIONS';
586: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
587: l_progress VARCHAR2(3) := '000';
588:
589: l_dist_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
590:
591: l_count NUMBER;
592:
593: BEGIN

Line 972: -- PO_DISTRIBUTIONS_ALL

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
975: -- main or backing documents. This procedure retrieves distributions
976: -- that should be acted upon, and retrieves prevent encumbrance

Line 1705: FROM PO_DISTRIBUTIONS_ALL BPA_DIST

1701:
1702: UPDATE PO_ENCUMBRANCE_GT REL_DIST
1703: SET REL_DIST.agreement_dist_id =
1704: ( SELECT BPA_DIST.po_distribution_id
1705: FROM PO_DISTRIBUTIONS_ALL BPA_DIST
1706: WHERE BPA_DIST.po_header_id = REL_DIST.header_id
1707: AND BPA_DIST.distribution_type = g_dist_type_AGREEMENT
1708: -- we don't want release distributions here.
1709: )

Line 1818: -- PO_DISTRIBUTIONS_ALL

1814: -- in the encumbrance table.
1815: --Modifies:
1816: -- None.
1817: --Locks:
1818: -- PO_DISTRIBUTIONS_ALL
1819: -- PO_REQ_DISTRIBUTIONS_ALL
1820: --Function:
1821: -- Locks all of the backing distributions of the given type that are
1822: -- referenced by main doc rows in the encumbrance table.

Line 2196: PO_DISTRIBUTIONS_ALL POD

2192: BULK COLLECT INTO
2193: x_dist_id_tbl
2194: , x_origin_seq_num_tbl
2195: FROM
2196: PO_DISTRIBUTIONS_ALL POD
2197: , PO_LINE_LOCATIONS_ALL POLL
2198: , PO_ENCUMBRANCE_GT SR_DIST
2199: WHERE POLL.line_location_id = POD.line_location_id --JOIN
2200: AND POD.po_distribution_id = SR_DIST.source_distribution_id --JOIN

Line 2235: PO_DISTRIBUTIONS_ALL POD

2231: BULK COLLECT INTO
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

Line 2435: -- PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

2431: -- SCHEDULED Scheduled Release
2432: -- This parameter is not checked for requisitions.
2433: --OUT:
2434: --x_distribution_type
2435: -- PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
2436: -- Use the g_dist_type_<> variables, which map to the distribution_type
2437: -- column, except for the following:
2438: -- REQUISITION for requisitions
2439: --Testing:

Line 2912: PO_DISTRIBUTIONS_ALL POD

2908:
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