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.IGS_UC_UTILS dependencies on FND_PROFILE_OPTION_VALUES

Line 68: CURSOR c_country_code(p_level_id fnd_profile_option_values.level_id%TYPE

64: l_responsibility_id NUMBER := FND_GLOBAL.Resp_Id;
65: l_application_id NUMBER := FND_GLOBAL.Resp_Appl_Id;
66: l_site_id NUMBER := 0;
67:
68: CURSOR c_country_code(p_level_id fnd_profile_option_values.level_id%TYPE
69: ,p_level_value fnd_profile_option_values.level_value%TYPE) IS
70: SELECT profile_option_value
71: FROM fnd_profile_option_values fpov
72: ,fnd_profile_options fpo

Line 69: ,p_level_value fnd_profile_option_values.level_value%TYPE) IS

65: l_application_id NUMBER := FND_GLOBAL.Resp_Appl_Id;
66: l_site_id NUMBER := 0;
67:
68: CURSOR c_country_code(p_level_id fnd_profile_option_values.level_id%TYPE
69: ,p_level_value fnd_profile_option_values.level_value%TYPE) IS
70: SELECT profile_option_value
71: FROM fnd_profile_option_values fpov
72: ,fnd_profile_options fpo
73: WHERE fpo.profile_option_name = 'OSS_COUNTRY_CODE'

Line 71: FROM fnd_profile_option_values fpov

67:
68: CURSOR c_country_code(p_level_id fnd_profile_option_values.level_id%TYPE
69: ,p_level_value fnd_profile_option_values.level_value%TYPE) IS
70: SELECT profile_option_value
71: FROM fnd_profile_option_values fpov
72: ,fnd_profile_options fpo
73: WHERE fpo.profile_option_name = 'OSS_COUNTRY_CODE'
74: AND fpov.profile_option_id = fpo.profile_option_id
75: AND fpov.level_id = p_level_id