APPS.FV_INSTALL_EXTN dependencies on FND_PROFILE

Line 37: FROM fnd_profile_options

33:
34: -- Check if profile is enabled at User/Responsibility level.
35: CURSOR c_prof_enabled IS
36: SELECT resp_enabled_flag, user_enabled_flag
37: FROM fnd_profile_options
38: WHERE profile_option_name = 'FV_ENABLED';
39:
40: l_resp_flag fnd_profile_options.resp_enabled_flag%TYPE;
41: l_user_flag fnd_profile_options.user_enabled_flag%TYPE;

Line 40: l_resp_flag fnd_profile_options.resp_enabled_flag%TYPE;

36: SELECT resp_enabled_flag, user_enabled_flag
37: FROM fnd_profile_options
38: WHERE profile_option_name = 'FV_ENABLED';
39:
40: l_resp_flag fnd_profile_options.resp_enabled_flag%TYPE;
41: l_user_flag fnd_profile_options.user_enabled_flag%TYPE;
42:
43: BEGIN
44: g_module_name := 'fv.plsql.fv_install_extn.';

Line 41: l_user_flag fnd_profile_options.user_enabled_flag%TYPE;

37: FROM fnd_profile_options
38: WHERE profile_option_name = 'FV_ENABLED';
39:
40: l_resp_flag fnd_profile_options.resp_enabled_flag%TYPE;
41: l_user_flag fnd_profile_options.user_enabled_flag%TYPE;
42:
43: BEGIN
44: g_module_name := 'fv.plsql.fv_install_extn.';
45: l_module_name := g_module_name || 'run_process';

Line 68: l_retval := fnd_profile.save ('FV_ENABLED', 'Y', 'SITE');

64: -- Bug#4533611
65: -- The following line is added to enable the profile
66: -- FV_ENABLED to Y as this process will be run only
67: -- by federal customers
68: l_retval := fnd_profile.save ('FV_ENABLED', 'Y', 'SITE');
69:
70: END IF;
71:
72: --