DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_REQUISITION_LINES_ALL

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 2538: UPDATE PO_REQUISITION_LINES_ALL PRL

2534: -- succeeded in GL
2535: --SQL Why: The Req line's encumbered_flag needs to be in synch with the
2536: -- update already done to the Req distribution's encumbered_flag
2537:
2538: UPDATE PO_REQUISITION_LINES_ALL PRL
2539: SET encumbered_flag
2540: =
2541: (
2542: -- Bug 3537764: Modified SET logic to handle the all distributions prevented case