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 658: DECODE(DIST.DISTRIBUTION_TYPE,'REQUISITION','PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') DIST_LINK_TYPE,

654: DIST.SEQUENCE_NUM,
655: DIST.SEGMENT1,
656: DIST.SEGMENT1,
657: l_appl_id,
658: DECODE(DIST.DISTRIBUTION_TYPE,'REQUISITION','PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') DIST_LINK_TYPE,
659: DIST.PROJECT_ID,
660: DIST.AWARD_NUM,
661: DIST.TASK_ID,
662: DIST.EXPENDITURE_ORGANIZATION_ID,

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

1415: AND GLBC.SOURCE_DISTRIBUTION_ID_NUM_1 =
1416: xld.SOURCE_DISTRIBUTION_ID_NUM_1
1417: AND pbd.distribution_id = xld.SOURCE_DISTRIBUTION_ID_NUM_1
1418: AND decode(pbd.distribution_type,g_dist_type_REQUISITION,
1419: 'PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') = xld.source_distribution_type
1420: AND pbd.ae_event_id = xld.event_id
1421: AND NVL(PBD.applied_to_dist_id_2, pbd.distribution_id) =
1422: XLD.ALLOC_TO_DIST_ID_NUM_1
1423: AND xld.application_id = 201

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

1451: AND GLBCH.SOURCE_DISTRIBUTION_ID_NUM_1 =
1452: xld.SOURCE_DISTRIBUTION_ID_NUM_1
1453: AND pbd.distribution_id = xld.SOURCE_DISTRIBUTION_ID_NUM_1
1454: AND decode(pbd.distribution_type,g_dist_type_REQUISITION,
1455: 'PO_REQ_DISTRIBUTIONS_ALL','PO_DISTRIBUTIONS_ALL') = xld.source_distribution_type
1456: AND pbd.ae_event_id = xld.event_id
1457: AND NVL(PBD.applied_to_dist_id_2, pbd.distribution_id) =
1458: XLD.ALLOC_TO_DIST_ID_NUM_1
1459: AND xld.application_id = 201

Line 1649: -- PO_REQ_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_REQUISITION_LINES_ALL,

1645: --Pre-reqs:
1646: -- PO_ENCUMBRANCE_GT has all necessary information populated after
1647: -- making a call to the GL Funds Checker
1648: --Modifies:
1649: -- PO_REQ_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_REQUISITION_LINES_ALL,
1650: -- PO_LINE_LOCATIONS_ALL
1651: --Locks:
1652: -- None.
1653: --Function:

Line 1997: UPDATE PO_DISTRIBUTIONS_ALL POD

1993: -- row was sent to and successful in the GL packet
1994: --SQL Why: If the distribution transaction succeeded, the distribution table
1995: -- fields must be updated to reflect the effect of the transaction
1996:
1997: UPDATE PO_DISTRIBUTIONS_ALL POD
1998: SET
1999: (
2000: POD.encumbered_flag,
2001: POD.encumbered_amount

Line 2121: UPDATE PO_DISTRIBUTIONS_ALL POD

2117: --SQL Why: If the distribution transaction succeeded, the distribution
2118: -- table fields must be updated to reflect the effect of the
2119: -- transaction
2120:
2121: UPDATE PO_DISTRIBUTIONS_ALL POD
2122: SET
2123: (
2124: POD.encumbered_amount,
2125: POD.unencumbered_amount

Line 2193: UPDATE PO_DISTRIBUTIONS_ALL POD

2189: -- Bug 3292870: Modified the query to make it compatible with 8i DB
2190: -- Changes: Moved all the GREATEST/NVL/DECODE logic to be inside
2191: -- the select statement.
2192:
2193: UPDATE PO_DISTRIBUTIONS_ALL POD
2194: SET
2195: POD.unencumbered_quantity =
2196: (SELECT
2197: GREATEST

Line 2443: UPDATE PO_DISTRIBUTIONS_ALL POD

2439: -- distributions from this transaction
2440: --SQL Where: Only updates the distributions if the distribution transaction
2441: -- failed in GL
2442:
2443: UPDATE PO_DISTRIBUTIONS_ALL POD
2444: SET POD.failed_funds_lookup_code
2445: =
2446: (
2447: SELECT TEMP.gl_result_code

Line 2587: FROM PO_DISTRIBUTIONS_ALL POD

2583: =
2584: (
2585: -- Bug 3537764: Modified SET logic to handle the all distributions prevented case
2586: SELECT NVL(min(pod.encumbered_flag), 'N')
2587: FROM PO_DISTRIBUTIONS_ALL POD
2588: WHERE POD.line_location_id = POLL.line_location_id
2589: AND NVL(POD.prevent_encumbrance_flag, 'N') = 'N'
2590: )
2591: WHERE POLL.line_location_id IN