[Home] [Help]
37: -- 27-Mar-2002 dmvincen Added dialog and component validiation.
38: -- 17-May-2002 choang bug 2224836: changed get_sytem_timezone and get_user_timezone
39: -- to use HZ timezone profiles.
40: -- 06-Jun-2002 sveerave Added overloaded check_lookup_exists
41: -- which accepts view_application_id, query from fnd_lookups
42: -- 06-Jun-2002 sveerave Modified previous check_lookup_exists to call
43: -- newly created procedure.
44: -- 17-Jun-2002 sveerave Modified cursor in check_lookup_exists to have p_view_app_id
45: -- as NUMBER
338: ---------------------------------------------------------------------
339: -- FUNCTION
340: -- overloaded check_lookup_exists
341: -- PURPOSE
342: -- This function checks if a lookup_code is valid from fnd_lookups when
343: -- view_application_id is passed in.
344: -- HISTORY
345: -- 07-jun-2002 sveerave created.
346: -- 17-Jun-2002 sveerave Modified cursor to have p_view_app_id as NUMBER
3256:
3257: FUNCTION get_fnd_lookup_meaning(p_lookup_type IN VARCHAR2,p_lookup_code IN VARCHAR2) RETURN VARCHAR2
3258: IS
3259: CURSOR c_lookup_meaning(p_lookup_type VARCHAR2,p_lookup_code VARCHAR2) IS
3260: SELECT meaning FROM fnd_lookups WHERE lookup_type = p_lookup_type
3261: AND lookup_code = p_lookup_code;
3262:
3263: l_lookup_meaning fnd_lookups.meaning%type;
3264: BEGIN
3259: CURSOR c_lookup_meaning(p_lookup_type VARCHAR2,p_lookup_code VARCHAR2) IS
3260: SELECT meaning FROM fnd_lookups WHERE lookup_type = p_lookup_type
3261: AND lookup_code = p_lookup_code;
3262:
3263: l_lookup_meaning fnd_lookups.meaning%type;
3264: BEGIN
3265: OPEN c_lookup_meaning(p_lookup_type,p_lookup_code);
3266: FETCH c_lookup_meaning INTO l_lookup_meaning;
3267: CLOSE c_lookup_meaning;