APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_LINE_LOCATIONS_ALL

Line 1650: -- PO_LINE_LOCATIONS_ALL

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

Line 2581: UPDATE PO_LINE_LOCATIONS_ALL POLL

2577: -- succeeded in GL
2578: --SQL Why: The shipment's encumbered_flag needs to be in synch with the
2579: -- update already done to the distribution's encumbered_flag
2580:
2581: UPDATE PO_LINE_LOCATIONS_ALL POLL
2582: SET encumbered_flag
2583: =
2584: (
2585: -- Bug 3537764: Modified SET logic to handle the all distributions prevented case

Line 3070: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL

3066: --Name: set_status_requires_reapproval
3067: --Pre-reqs:
3068: -- Unreserve action completed successfully.
3069: --Modifies:
3070: -- PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINE_LOCATIONS_ALL
3071: --Locks:
3072: -- None.
3073: --Function:
3074: -- This procedure updates the 'Approved' Shipments to 'REQUIRES REAPPROVAL'

Line 3155: UPDATE PO_LINE_LOCATIONS_ALL POLL

3151: -- is unreserved.
3152:
3153: l_progress := '020';
3154:
3155: UPDATE PO_LINE_LOCATIONS_ALL POLL
3156: SET POLL.approved_flag = 'R',
3157: POLL.last_update_date = sysdate,
3158: POLL.last_updated_by = fnd_global.user_id,
3159: POLL.last_update_login = fnd_global.login_id

Line 3262: UPDATE PO_LINE_LOCATIONS_ALL POLL

3258: -- succeeded in GL and shipment is approved.
3259: --SQL Why: The shipment should be unapproved if one of its distribution
3260: -- is unreserved.
3261:
3262: UPDATE PO_LINE_LOCATIONS_ALL POLL
3263: SET POLL.approved_flag = 'R',
3264: POLL.last_update_date = sysdate,
3265: POLL.last_updated_by = fnd_global.user_id,
3266: POLL.last_update_login = fnd_global.login_id