APPS.IGS_AD_GEN_016 dependencies on DUAL

Line 42: SELECT USERENV('LANG') INTO l_language FROM DUAL;

38: lr_fetched_lkcode c_lookup%ROWTYPE;
39:
40: BEGIN
41: IF l_language IS NULL THEN
42: SELECT USERENV('LANG') INTO l_language FROM DUAL;
43: END IF;
44:
45: -- If parameters are not valid return
46: IF (p_lookup_code IS NULL OR p_lookup_type IS NULL OR p_application_id IS NULL) THEN

Line 148: SELECT USERENV('LANG') INTO l_language FROM DUAL;

144: lr_fetched_lkcode c_lookup%ROWTYPE;
145:
146: BEGIN
147: IF l_language IS NULL THEN
148: SELECT USERENV('LANG') INTO l_language FROM DUAL;
149: END IF;
150:
151: -- If parameters are not valid return
152: IF (p_lookup_code IS NULL OR p_lookup_type IS NULL OR p_application_id IS NULL) THEN

Line 201: SELECT USERENV('LANG') INTO l_language FROM DUAL;

197: lr_fetched_msg_type c_msg_type%ROWTYPE;
198:
199: BEGIN
200: IF l_language IS NULL THEN
201: SELECT USERENV('LANG') INTO l_language FROM DUAL;
202: END IF;
203:
204: OPEN c_appl_id (p_application_short_name);
205: FETCH c_appl_id INTO ln_application_id;