APPS.MSC_PROFILE_PRE_PROCESS dependencies on MSC_ST_PROFILES

Line 144: FROM MSC_ST_PROFILES

140: profile_option_name,
141: profile_option_value,
142: application_name,
143: process_flag
144: FROM MSC_ST_PROFILES
145: WHERE preference_set_name = p_preference_set_name
146: AND process_flag=1;
147:
148:

Line 153: UPDATE MSC_ST_PROFILES msp1

149: BEGIN
150:
151: v_sql_stmt := 5;
152:
153: UPDATE MSC_ST_PROFILES msp1
154: SET PROCESS_FLAG = 3
155: WHERE EXISTS (select 1 from msc_st_profiles msp2
156: where msp2.preference_set_name=msp1.preference_set_name
157: and nvl(msp2.level_name,'-27323')=nvl(msp1.level_name,'-27323')

Line 155: WHERE EXISTS (select 1 from msc_st_profiles msp2

151: v_sql_stmt := 5;
152:
153: UPDATE MSC_ST_PROFILES msp1
154: SET PROCESS_FLAG = 3
155: WHERE EXISTS (select 1 from msc_st_profiles msp2
156: where msp2.preference_set_name=msp1.preference_set_name
157: and nvl(msp2.level_name,'-27323')=nvl(msp1.level_name,'-27323')
158: and nvl(msp2.level_type,'-27323')=nvl(msp1.level_type,'-27323')
159: and msp2.profile_option_name = msp1.profile_option_name

Line 219: UPDATE msc_st_profiles set process_flag = 5

215: );
216:
217: END IF;
218:
219: UPDATE msc_st_profiles set process_flag = 5
220: WHERE PREFERENCE_SET_NAME = c_rec.PREFERENCE_SET_NAME
221: AND nvl(LEVEL_NAME,'-27223') = nvl(c_rec.LEVEL_NAME,'-27223')
222: AND nvl(level_type,'-27323') = nvl(c_rec.level_type,'-27323')
223: AND PROFILE_OPTION_NAME = c_rec.PROFILE_OPTION_NAME

Line 233: DELETE from msc_st_profiles where process_flag=5;

229: END LOOP;
230:
231: v_sql_stmt := 7;
232:
233: DELETE from msc_st_profiles where process_flag=5;
234:
235: setprofile(ERRBUF => ERRBUF,
236: RETCODE => RETCODE,
237: p_preference_set_name => p_preference_set_name,