DBA Data[Home] [Help]

APPS.BSC_AW_LOAD_KPI dependencies on BSC_AW_CALENDAR

Line 3427: if bsc_aw_calendar.check_calendar_loaded(l_calendar)='N' then

3423: l_lock_name:='lock_aw_calendar_'||l_calendar;
3424: if l_calendar is not null then
3425: --serialize access
3426: bsc_aw_utility.get_db_lock(l_lock_name);
3427: if bsc_aw_calendar.check_calendar_loaded(l_calendar)='N' then
3428: --get lock for calendar
3429: bsc_aw_calendar.lock_calendar_objects(l_calendar);
3430: bsc_aw_calendar.load_calendar(l_calendar);
3431: bsc_aw_management.commit_aw;

Line 3429: bsc_aw_calendar.lock_calendar_objects(l_calendar);

3425: --serialize access
3426: bsc_aw_utility.get_db_lock(l_lock_name);
3427: if bsc_aw_calendar.check_calendar_loaded(l_calendar)='N' then
3428: --get lock for calendar
3429: bsc_aw_calendar.lock_calendar_objects(l_calendar);
3430: bsc_aw_calendar.load_calendar(l_calendar);
3431: bsc_aw_management.commit_aw;
3432: commit;
3433: end if;

Line 3430: bsc_aw_calendar.load_calendar(l_calendar);

3426: bsc_aw_utility.get_db_lock(l_lock_name);
3427: if bsc_aw_calendar.check_calendar_loaded(l_calendar)='N' then
3428: --get lock for calendar
3429: bsc_aw_calendar.lock_calendar_objects(l_calendar);
3430: bsc_aw_calendar.load_calendar(l_calendar);
3431: bsc_aw_management.commit_aw;
3432: commit;
3433: end if;
3434: bsc_aw_utility.release_db_lock(l_lock_name);