APPS.PO_SIGNATURE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 890: -- PO_LINE_LOCATIONS_ALL

886: -- None.
887: --Modifies:
888: -- PO_ACCEPTANCES
889: -- PO_HEADERS_ALL
890: -- PO_LINE_LOCATIONS_ALL
891: -- PO_ACTION_HISTORY
892: --Locks:
893: -- None.
894: --Function:

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

2955: l_approved_flag := 'F';
2956: ELSIF (p_status = 'APPROVED') THEN
2957: l_approved_flag := 'Y';
2958:
2959: -- SQL What:Updates PO_LINE_LOCATIONS_ALL table and sets the Approved_Flag to Y
2960: -- SQL Why :To indicate that the shipments are now available for execution
2961:
2962: -- Bug 7494807 START
2963: /*Added NVL condition for approved_flag to update the value after buyer signed the

Line 2966: UPDATE PO_LINE_LOCATIONS_ALL

2962: -- Bug 7494807 START
2963: /*Added NVL condition for approved_flag to update the value after buyer signed the
2964: document.*/
2965:
2966: UPDATE PO_LINE_LOCATIONS_ALL
2967: SET approved_flag = 'Y',
2968: approved_date = sysdate,
2969: last_updated_by = fnd_global.user_id,
2970: last_update_login = fnd_global.login_id,

Line 3684: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY

3680: --Name: Post_Forms_Commit
3681: --Pre-reqs:
3682: -- None.
3683: --Modifies:
3684: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY
3685: --Locks:
3686: -- None.
3687: --Function:
3688: -- Checks the logic for completion of signatures and updates PO tables