APPS.MSC_PROFILE_PRE_PROCESS dependencies on MSC_PROFILES

Line 30: select profile_option_name,profile_option_value,level_type,level_name,application_name from msc_profiles where preference_set_name=p_preference_set_name;

26: p_preference_set_name IN VARCHAR2,
27: p_upload_profile IN NUMBER) IS
28:
29: CURSOR c1 is
30: select profile_option_name,profile_option_value,level_type,level_name,application_name from msc_profiles where preference_set_name=p_preference_set_name;
31:
32: usr_flag_enabled varchar2(5);
33: appl_flag_enabled varchar2(5);
34: resp_flag_enabled varchar2(5);

Line 40: l_prof_name msc_profiles.profile_option_name%TYPE;

36: appl_id NUMBER;
37: resp_id NUMBER;
38: ret_value BOOLEAN;
39: x_prof_err EXCEPTION;
40: l_prof_name msc_profiles.profile_option_name%TYPE;
41: l_level_type msc_profiles.level_type%TYPE;
42: l_level_name msc_profiles.level_name%TYPE;
43:
44:

Line 41: l_level_type msc_profiles.level_type%TYPE;

37: resp_id NUMBER;
38: ret_value BOOLEAN;
39: x_prof_err EXCEPTION;
40: l_prof_name msc_profiles.profile_option_name%TYPE;
41: l_level_type msc_profiles.level_type%TYPE;
42: l_level_name msc_profiles.level_name%TYPE;
43:
44:
45: BEGIN

Line 42: l_level_name msc_profiles.level_name%TYPE;

38: ret_value BOOLEAN;
39: x_prof_err EXCEPTION;
40: l_prof_name msc_profiles.profile_option_name%TYPE;
41: l_level_type msc_profiles.level_type%TYPE;
42: l_level_name msc_profiles.level_name%TYPE;
43:
44:
45: BEGIN
46:

Line 170: DELETE FROM MSC_PROFILES

166:
167:
168: v_sql_stmt := 6;
169:
170: DELETE FROM MSC_PROFILES
171: WHERE PREFERENCE_SET_NAME = p_preference_set_name ;
172:
173: FOR c_rec in c2 LOOP
174:

Line 176: /* UPDATE MSC_PROFILES SET

172:
173: FOR c_rec in c2 LOOP
174:
175:
176: /* UPDATE MSC_PROFILES SET
177: PROFILE_OPTION_VALUE = c_rec.PROFILE_OPTION_VALUE
178: WHERE PREFERENCE_SET_NAME = c_rec.PREFERENCE_SET_NAME
179: AND nvl(level_name,'-27323') = nvl(c_rec.level_name,'-27323')
180: AND nvl(level_type,'-27323') = nvl(c_rec.level_type,'-27323')

Line 188: insert into msc_profiles

184:
185: IF SQL%NOTFOUND THEN */
186: IF c_rec.process_flag=1 THEN
187:
188: insert into msc_profiles
189: (
190: PREFERENCE_SET_NAME,
191: LEVEL_TYPE,
192: LEVEL_NAME,