DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on AP_HOLDS_ALL

Line 2209: l_debug_info := 'update ap_holds_all to release hold';

2205: l_debug_info varchar2(100);
2206: l_release_reason ap_lookup_codes.description%type ; -- Bug 10176292
2207: BEGIN
2208:
2209: l_debug_info := 'update ap_holds_all to release hold';
2210:
2211: -- Bug 10176292.
2212: -- Now deriving release reason from ap_lookup_codes.
2213:

Line 2220: UPDATE ap_holds_all h

2216: FROM ap_lookup_codes
2217: WHERE LOOKUP_TYPE = 'HOLD CODE'
2218: AND LOOKUP_CODE = 'SUP/MGR RELEASE' ;
2219:
2220: UPDATE ap_holds_all h
2221: SET release_lookup_code = 'SUP/MGR RELEASE',
2222: release_reason = l_release_reason, -- Bug 10176292.
2223: last_updated_by = FND_GLOBAL.user_id,
2224: last_update_date = SYSDATE,