eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on AP_LOOKUP_CODES

Line 2206: l_release_reason ap_lookup_codes.description%type ; -- Bug 10176292

2202:
2203: -- Used by Negotiation
2204: PROCEDURE Release_Hold(p_hold_id IN NUMBER) IS
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:

Line 2212: -- Now deriving release reason from ap_lookup_codes.

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:
2214: SELECT DESCRIPTION
2215: INTO l_release_reason
2216: FROM ap_lookup_codes

Line 2216: FROM ap_lookup_codes

2212: -- Now deriving release reason from ap_lookup_codes.
2213:
2214: SELECT DESCRIPTION
2215: INTO l_release_reason
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