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_REQ_DISTRIBUTIONS_ALL

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 754: FROM po_req_distributions_all prd,

750:
751: IF p_action = 'CANCEL' THEN
752:
753: SELECT prd.distribution_id BULK COLLECT INTO l_id_tbl
754: FROM po_req_distributions_all prd,
755: po_bc_distributions pbd1, -- for Backing
756: po_bc_distributions pbd2 -- For Main
757: WHERE pbd1.packet_id = x_packet_id
758: AND prd.distribution_id = pbd1.distribution_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 2049: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2045: -- distribution row was sent to and successful in the GL packet
2046: --SQL Why: If the distribution transaction succeeded, the distribution table
2047: -- fields must be updated to reflect the effect of the transaction
2048:
2049: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2050: SET
2051: (
2052: PRD.encumbered_flag
2053: , PRD.encumbered_amount

Line 2088: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2084: AND MAIN_REQ.send_to_gl_flag = 'Y' --bug 3568512: use new column
2085: );
2086:
2087: --funds liquidated: Line Type Changes: Liquidate iProcurement Requisition
2088: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2089: SET PRD.funds_liquidated
2090: =
2091: (
2092: SELECT

Line 2130: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2126: -- you can no longer act on it, so we set the prevent-enc
2127: -- flag on these lines -- as a marker to ignore them for
2128: -- future actions
2129:
2130: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2131: SET (
2132: PRD.encumbered_flag
2133: , PRD.prevent_encumbrance_flag
2134: )

Line 2256: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2252: --SQL Why: If the distribution transaction succeeded, the distribution
2253: -- table fields must be updated to reflect the effect of the
2254: -- transaction
2255:
2256: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2257: SET
2258: (
2259: PRD.encumbered_flag,
2260: PRD.encumbered_amount

Line 2488: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2484: The case 2: where there is no backing GBPA , the backing Requistion prevent encumbrance
2485: flag is not updated to 'Y' or 'N'. This is required so that if the backing req flag is
2486: explictly updated to 'Y' the code will not flip to 'N'.
2487:
2488: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2489: SET PRD.prevent_encumbrance_flag
2490: =
2491: (
2492: SELECT

Line 2517: update PO_REQ_DISTRIBUTIONS_ALL PRD

2513: AND EXEC_DOC.gl_status_code = 'A'
2514: AND EXEC_DOC.send_to_gl_flag = 'Y' --bug 3568512
2515: ); */
2516:
2517: update PO_REQ_DISTRIBUTIONS_ALL PRD
2518: set PRD.prevent_encumbrance_flag = 'Y'
2519: where PRD.distribution_id IN
2520: (
2521: SELECT EXEC_DOC.req_distribution_id

Line 2581: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2577: END IF;
2578: -- Also set the Encumbered Flag and the unencumbered Amount for clmBacking Reqs
2579: -- Need to set Encumbered Flag to N, if Enc Amt is Zero. This is required to pick only the Backing REQs with Act.Enc for CLM POs
2580: --Bug 15871378 commented out the update on encumbered_flag = 'N' when encumbered_amount = 0
2581: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2582: SET /*PRD.Encumbered_Flag = DECODE(GREATEST(NVL(PRD.Encumbered_Amount,0), 0),
2583: 0,'N',
2584: 'Y')
2585: ,*/

Line 2610: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2606: IF g_debug_stmt THEN
2607: PO_DEBUG.debug_stmt(l_log_head,l_progress,'CLM is Installed and Reserve Action is on REQ');
2608: END IF;
2609: --Bug 15871378 commented out the update on encumbered_flag = 'N' when encumbered_amount = 0
2610: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2611: SET /* PRD.ENCUMBERED_FLAG = DECODE(GREATEST(NVL(PRD.ENCUMBERED_AMOUNT,0), 0),
2612: 0,'N',
2613: 'Y'),*/
2614: PRD.CHANGE_IN_FUNDED_VALUE = 0

Line 2730: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD

2726: -- distributions from this transaction
2727: --SQL Where: Only updates the distributions if the distribution transaction
2728: -- failed in GL
2729:
2730: UPDATE PO_REQ_DISTRIBUTIONS_ALL PRD
2731: SET PRD.failed_funds_lookup_code
2732: =
2733: (
2734: SELECT TEMP.gl_result_code

Line 2866: FROM PO_REQ_DISTRIBUTIONS_ALL PRD

2862: =
2863: (
2864: -- Bug 3537764: Modified SET logic to handle the all distributions prevented case
2865: SELECT NVL(min(prd.encumbered_flag), 'N')
2866: FROM PO_REQ_DISTRIBUTIONS_ALL PRD
2867: WHERE PRD.requisition_line_id = PRL.requisition_line_id
2868: AND NVL(PRD.prevent_encumbrance_flag, 'N') = 'N'
2869:
2870: ), /* Updating these cols also for bug#13930578 */