DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_REQUISITION_LINES_ALL

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

2856: -- succeeded in GL
2857: --SQL Why: The Req line's encumbered_flag needs to be in synch with the
2858: -- update already done to the Req distribution's encumbered_flag
2859:
2860: UPDATE PO_REQUISITION_LINES_ALL PRL
2861: SET encumbered_flag
2862: =
2863: (
2864: -- Bug 3537764: Modified SET logic to handle the all distributions prevented case