DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on FND_PROFILE_OPTIONS

Line 166: FROM FND_PROFILE_OPTIONS FPO, FND_PROFILE_OPTIONS_TL FPOT

162: prof_opt_id NUMBER;
163: BEGIN
164: SELECT FPO.PROFILE_OPTION_ID
165: INTO prof_opt_id
166: FROM FND_PROFILE_OPTIONS FPO, FND_PROFILE_OPTIONS_TL FPOT
167: WHERE FPO.PROFILE_OPTION_NAME = FPOT.PROFILE_OPTION_NAME
168: AND FPOT.LANGUAGE=USERENV('LANG')
169: AND FPOT.PROFILE_OPTION_NAME LIKE prof_opt_name;
170: RETURN prof_opt_id;

Line 183: FROM FND_PROFILE_OPTIONS_TL FPOT

179: user_prof_opt_name VARCHAR2(255);
180: BEGIN
181: SELECT FPOT.USER_PROFILE_OPTION_NAME
182: INTO user_prof_opt_name
183: FROM FND_PROFILE_OPTIONS_TL FPOT
184: WHERE FPOT.LANGUAGE=USERENV('LANG')
185: AND FPOT.PROFILE_OPTION_NAME LIKE prof_opt_name;
186: RETURN user_prof_opt_name;
187: EXCEPTION