APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_LINE_LOCATIONS_ALL

Line 1809: -- PO_LINE_LOCATIONS_ALL

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:
1813: -- This procedure calls helpers to update the distributions appropriately based

Line 2907: UPDATE PO_LINE_LOCATIONS_ALL POLL

2903: -- succeeded in GL
2904: --SQL Why: The shipment's encumbered_flag needs to be in synch with the
2905: -- update already done to the distribution's encumbered_flag
2906:
2907: UPDATE PO_LINE_LOCATIONS_ALL POLL
2908: SET encumbered_flag
2909: =
2910: (
2911: -- Bug 3537764: Modified SET logic to handle the all distributions prevented case

Line 3400: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL

3396: --Name: set_status_requires_reapproval
3397: --Pre-reqs:
3398: -- Unreserve action completed successfully.
3399: --Modifies:
3400: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL
3401: --Locks:
3402: -- None.
3403: --Function:
3404: -- This procedure updates the 'Approved' Shipments to 'REQUIRES REAPPROVAL'

Line 3485: UPDATE PO_LINE_LOCATIONS_ALL POLL

3481: -- is unreserved.
3482:
3483: l_progress := '020';
3484:
3485: UPDATE PO_LINE_LOCATIONS_ALL POLL
3486: SET POLL.approved_flag = 'R',
3487: POLL.last_update_date = sysdate,
3488: POLL.last_updated_by = fnd_global.user_id,
3489: POLL.last_update_login = fnd_global.login_id

Line 3592: UPDATE PO_LINE_LOCATIONS_ALL POLL

3588: -- succeeded in GL and shipment is approved.
3589: --SQL Why: The shipment should be unapproved if one of its distribution
3590: -- is unreserved.
3591:
3592: UPDATE PO_LINE_LOCATIONS_ALL POLL
3593: SET POLL.approved_flag = 'R',
3594: POLL.last_update_date = sysdate,
3595: POLL.last_updated_by = fnd_global.user_id,
3596: POLL.last_update_login = fnd_global.login_id