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_POSTPROCESSING dependencies on PO_DISTRIBUTIONS_ALL

Line 123: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

119:
120: -- distribution types
121:
122: g_dist_type_STANDARD CONSTANT
123: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
124: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD;
125:
126: g_dist_type_PLANNED CONSTANT
127: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 127: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

123: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
124: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD;
125:
126: g_dist_type_PLANNED CONSTANT
127: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED;
129:
130: g_dist_type_SCHEDULED CONSTANT
131: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 131: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

127: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED;
129:
130: g_dist_type_SCHEDULED CONSTANT
131: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
132: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED;
133:
134: g_dist_type_BLANKET CONSTANT
135: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 135: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

131: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
132: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED;
133:
134: g_dist_type_BLANKET CONSTANT
135: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
136: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET;
137:
138: g_dist_type_AGREEMENT CONSTANT
139: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 139: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

135: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
136: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET;
137:
138: g_dist_type_AGREEMENT CONSTANT
139: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
140: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT;
141:
142: g_dist_type_REQUISITION CONSTANT
143: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 143: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

139: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
140: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT;
141:
142: g_dist_type_REQUISITION CONSTANT
143: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
144: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION;
145:
146: g_dist_type_MIXED_PO_RELEASE CONSTANT
147: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

Line 147: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE

143: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
144: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION;
145:
146: g_dist_type_MIXED_PO_RELEASE CONSTANT
147: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
148: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE;
149:
150: -- parameter values
151:

Line 650: DECODE(DIST.DISTRIBUTION_TYPE,'REQUISITION','PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') DIST_LINK_TYPE,

646: segment1 = dist.reference4)
647: ELSE dist.reference4
648: END ) reference_number,
649: l_appl_id,
650: DECODE(DIST.DISTRIBUTION_TYPE,'REQUISITION','PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') DIST_LINK_TYPE,
651: DIST.PROJECT_ID,
652: DIST.AWARD_NUM,
653: DIST.TASK_ID,
654: DIST.EXPENDITURE_ORGANIZATION_ID,

Line 1509: 'PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') = xld.source_distribution_type

1505: AND GLBC.SOURCE_DISTRIBUTION_ID_NUM_1 =
1506: xld.SOURCE_DISTRIBUTION_ID_NUM_1
1507: AND pbd.distribution_id = xld.SOURCE_DISTRIBUTION_ID_NUM_1
1508: AND decode(pbd.distribution_type,g_dist_type_REQUISITION,
1509: 'PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') = xld.source_distribution_type
1510: AND pbd.ae_event_id = xld.event_id
1511: AND NVL(PBD.applied_to_dist_id_2, pbd.distribution_id) =
1512: XLD.ALLOC_TO_DIST_ID_NUM_1
1513: AND xld.application_id = 201

Line 1545: 'PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') = xld.source_distribution_type

1541: AND GLBCH.SOURCE_DISTRIBUTION_ID_NUM_1 =
1542: xld.SOURCE_DISTRIBUTION_ID_NUM_1
1543: AND pbd.distribution_id = xld.SOURCE_DISTRIBUTION_ID_NUM_1
1544: AND decode(pbd.distribution_type,g_dist_type_REQUISITION,
1545: 'PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') = xld.source_distribution_type
1546: AND pbd.ae_event_id = xld.event_id
1547: AND NVL(PBD.applied_to_dist_id_2, pbd.distribution_id) =
1548: XLD.ALLOC_TO_DIST_ID_NUM_1
1549: AND xld.application_id = 201

Line 1808: -- PO_REQ_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_REQUISITION_LINES_ALL,

1804: --Pre-reqs:
1805: -- PO_ENCUMBRANCE_GT has all necessary information populated after
1806: -- making a call to the GL Funds Checker
1807: --Modifies:
1808: -- PO_REQ_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_REQUISITION_LINES_ALL,
1809: -- PO_LINE_LOCATIONS_ALL
1810: --Locks:
1811: -- None.
1812: --Function:

Line 2189: UPDATE PO_DISTRIBUTIONS_ALL POD

2185: -- Null out the amount_changed_flag for the successful encumbrance
2186: -- transactions
2187:
2188:
2189: UPDATE PO_DISTRIBUTIONS_ALL POD
2190: SET
2191: (
2192: POD.encumbered_flag,
2193: POD.encumbered_amount,

Line 2321: UPDATE PO_DISTRIBUTIONS_ALL POD

2317: --SQL Why: If the distribution transaction succeeded, the distribution
2318: -- table fields must be updated to reflect the effect of the
2319: -- transaction
2320:
2321: UPDATE PO_DISTRIBUTIONS_ALL POD
2322: SET
2323: (
2324: POD.encumbered_amount,
2325: POD.unencumbered_amount

Line 2393: UPDATE PO_DISTRIBUTIONS_ALL POD

2389: -- Bug 3292870: Modified the query to make it compatible with 8i DB
2390: -- Changes: Moved all the GREATEST/NVL/DECODE logic to be inside
2391: -- the select statement.
2392:
2393: UPDATE PO_DISTRIBUTIONS_ALL POD
2394: SET
2395: POD.unencumbered_quantity =
2396: (SELECT
2397: GREATEST

Line 2558: UPDATE PO_DISTRIBUTIONS_ALL POD

2554: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on a Standard PO');
2555: END IF;
2556: -- Update the Encumbered Flag for the Main Document and Set the Change In funded Value to Zero for successful rows
2557: --Bug 15871378 commented out the update on encumbered_flag = 'N' when encumbered_amount = 0
2558: UPDATE PO_DISTRIBUTIONS_ALL POD
2559: SET /*POD.ENCUMBERED_FLAG = DECODE(GREATEST(NVL(POD.ENCUMBERED_AMOUNT,0), 0),
2560: 0,'N',
2561: 'Y'),*/
2562: POD.CHANGE_IN_FUNDED_VALUE = 0

Line 2765: UPDATE PO_DISTRIBUTIONS_ALL POD

2761: -- distributions from this transaction
2762: --SQL Where: Only updates the distributions if the distribution transaction
2763: -- failed in GL
2764:
2765: UPDATE PO_DISTRIBUTIONS_ALL POD
2766: SET POD.failed_funds_lookup_code
2767: =
2768: (
2769: SELECT TEMP.gl_result_code

Line 2913: FROM PO_DISTRIBUTIONS_ALL POD

2909: =
2910: (
2911: -- Bug 3537764: Modified SET logic to handle the all distributions prevented case
2912: SELECT NVL(min(pod.encumbered_flag), 'N')
2913: FROM PO_DISTRIBUTIONS_ALL POD
2914: WHERE POD.line_location_id = POLL.line_location_id
2915: AND NVL(POD.prevent_encumbrance_flag, 'N') = 'N'
2916: ), /* Updating these cols also for bug#13930578 */
2917: POLL.last_update_date = sysdate,