APPS.PO_SIGNATURE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 762: -- PO_LINE_LOCATIONS_ALL

758: -- None.
759: --Modifies:
760: -- PO_ACCEPTANCES
761: -- PO_HEADERS_ALL
762: -- PO_LINE_LOCATIONS_ALL
763: -- PO_ACTION_HISTORY
764: --Locks:
765: -- None.
766: --Function:

Line 2398: -- SQL What:Updates PO_LINE_LOCATIONS_ALL table and sets the Approved_Flag to Y

2394: l_approved_flag := 'F';
2395: ELSIF (p_status = 'APPROVED') THEN
2396: l_approved_flag := 'Y';
2397:
2398: -- SQL What:Updates PO_LINE_LOCATIONS_ALL table and sets the Approved_Flag to Y
2399: -- SQL Why :To indicate that the shipments are now available for execution
2400:
2401: -- Bug 7494807 START
2402: /*Added NVL condition for approved_flag to update the value after buyer signed the

Line 2405: UPDATE PO_LINE_LOCATIONS_ALL

2401: -- Bug 7494807 START
2402: /*Added NVL condition for approved_flag to update the value after buyer signed the
2403: document.*/
2404:
2405: UPDATE PO_LINE_LOCATIONS_ALL
2406: SET approved_flag = 'Y',
2407: approved_date = sysdate,
2408: last_updated_by = fnd_global.user_id,
2409: last_update_login = fnd_global.login_id,

Line 2941: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY

2937: --Name: Post_Forms_Commit
2938: --Pre-reqs:
2939: -- None.
2940: --Modifies:
2941: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY
2942: --Locks:
2943: -- None.
2944: --Function:
2945: -- Checks the logic for completion of signatures and updates PO tables