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 494: -- PO_DISTRIBUTIONS_ALL

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

Line 592: l_dist_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

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

Line 975: -- PO_DISTRIBUTIONS_ALL

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

Line 1743: FROM PO_DISTRIBUTIONS_ALL BPA_DIST

1739:
1740: UPDATE PO_ENCUMBRANCE_GT REL_DIST
1741: SET REL_DIST.agreement_dist_id =
1742: ( SELECT BPA_DIST.po_distribution_id
1743: FROM PO_DISTRIBUTIONS_ALL BPA_DIST
1744: WHERE BPA_DIST.po_header_id = REL_DIST.header_id
1745: AND BPA_DIST.distribution_type = g_dist_type_AGREEMENT
1746: -- we don't want release distributions here.
1747: )

Line 1856: -- PO_DISTRIBUTIONS_ALL

1852: -- in the encumbrance table.
1853: --Modifies:
1854: -- None.
1855: --Locks:
1856: -- PO_DISTRIBUTIONS_ALL
1857: -- PO_REQ_DISTRIBUTIONS_ALL
1858: --Function:
1859: -- Locks all of the backing distributions of the given type that are
1860: -- referenced by main doc rows in the encumbrance table.

Line 2234: PO_DISTRIBUTIONS_ALL POD

2230: BULK COLLECT INTO
2231: x_dist_id_tbl
2232: , x_origin_seq_num_tbl
2233: FROM
2234: PO_DISTRIBUTIONS_ALL POD
2235: , PO_LINE_LOCATIONS_ALL POLL
2236: , PO_ENCUMBRANCE_GT SR_DIST
2237: WHERE POLL.line_location_id = POD.line_location_id --JOIN
2238: AND POD.po_distribution_id = SR_DIST.source_distribution_id --JOIN

Line 2273: PO_DISTRIBUTIONS_ALL POD

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

Line 2473: -- PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

2469: -- SCHEDULED Scheduled Release
2470: -- This parameter is not checked for requisitions.
2471: --OUT:
2472: --x_distribution_type
2473: -- PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
2474: -- Use the g_dist_type_<> variables, which map to the distribution_type
2475: -- column, except for the following:
2476: -- REQUISITION for requisitions
2477: --Testing:

Line 2950: PO_DISTRIBUTIONS_ALL POD

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

Line 8167: UPDATE po_distributions_all POD

8163: WHERE DISTS.amount_changed_flag = 'Y'
8164: AND Nvl(DISTS.entered_amount,0) = 0;
8165: END IF;
8166:
8167: UPDATE po_distributions_all POD
8168: SET POD.amount_changed_flag = NULL
8169: WHERE po_distribution_id IN
8170: (SELECT distribution_id
8171: FROM PO_ENCUMBRANCE_GT DISTS