APPS.BSC_CALENDAR_PVT dependencies on BSC_SYS_DIM_LEVELS_TL

Line 336: l_Dimobj_New_Name BSC_SYS_DIM_LEVELS_TL.NAME%TYPE;

332: AND BSCDIM.short_name = BISDIM.short_name
333: AND BSCPER.calendar_id = p_Calendar_Id;
334:
335:
336: l_Dimobj_New_Name BSC_SYS_DIM_LEVELS_TL.NAME%TYPE;
337:
338: BEGIN
339: FOR CD IN C_Period_Names LOOP
340: l_Dimobj_New_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period

Line 345: UPDATE bsc_sys_dim_levels_tl

341: ( p_Calendar_Id => p_Calendar_Id
342: , p_Periodicity_Name => CD.name
343: );
344:
345: UPDATE bsc_sys_dim_levels_tl
346: SET name = l_Dimobj_New_Name
347: ,SOURCE_LANG = userenv('LANG')
348: WHERE dim_level_id = CD.dim_level_id
349: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);