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.

APPS.BSC_DBI_CALENDAR dependencies on BSC_SYS_CALENDARS_TL

Line 649: --bsc_sys_calendars_b,bsc_sys_calendars_tl,bsc_sys_periods,bsc_sys_periods_tl,bsc_sys_periodicities

645: --
646: l_error varchar2(4000);
647: --
648: Begin
649: --bsc_sys_calendars_b,bsc_sys_calendars_tl,bsc_sys_periods,bsc_sys_periods_tl,bsc_sys_periodicities
650: if g_debug then
651: write_to_log_file_n('In load_dbi_cal_into_bsc_full '||get_time);
652: end if;
653: --get the dbi cal info into memory

Line 701: --bsc_sys_calendars_b,bsc_sys_calendars_tl,bsc_sys_periods,bsc_sys_periods_tl,bsc_sys_periodicities

697: procedure load_dbi_cal_into_bsc_inc is
698: --
699: --
700: Begin
701: --bsc_sys_calendars_b,bsc_sys_calendars_tl,bsc_sys_periods,bsc_sys_periods_tl,bsc_sys_periodicities
702: if g_debug then
703: write_to_log_file_n('In load_dbi_cal_into_bsc_inc '||get_time);
704: end if;
705: --get the dbi cal info into memory

Line 1602: insert into bsc_sys_calendars_tl(CALENDAR_ID,LANGUAGE,SOURCE_LANG,NAME,HELP,

1598: write_to_log_file_n('cal name='||l_cal_name);
1599: end if;
1600: for i in 1..g_num_lang loop
1601: l_cal_name:=get_lookup_value('BSC_DBI_CAL_NAME','ENT_CALENDAR_NAME',g_lang(i),l_source_lang); --BugFix#4043934
1602: insert into bsc_sys_calendars_tl(CALENDAR_ID,LANGUAGE,SOURCE_LANG,NAME,HELP,
1603: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1604: values(g_ent_cal_id,g_lang(i),l_source_lang,l_cal_name,l_cal_name,g_who,sysdate,g_who,sysdate,g_who);
1605: end loop;
1606: /*

Line 1971: insert into bsc_sys_calendars_tl(CALENDAR_ID,LANGUAGE,SOURCE_LANG,NAME,HELP,

1967: write_to_log_file_n('cal name='||l_cal_name);
1968: end if;
1969: for i in 1..g_num_lang loop
1970: l_cal_name:=get_lookup_value('BSC_DBI_CAL_NAME','P445_CALENDAR_NAME',g_lang(i),l_source_lang);
1971: insert into bsc_sys_calendars_tl(CALENDAR_ID,LANGUAGE,SOURCE_LANG,NAME,HELP,
1972: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1973: values(g_445_cal_id,g_lang(i),l_source_lang,l_cal_name,l_cal_name,g_who,sysdate,g_who,sysdate,g_who);
1974: end loop;
1975: /*

Line 2260: insert into bsc_sys_calendars_tl(CALENDAR_ID,LANGUAGE,SOURCE_LANG,NAME,HELP,

2256: write_to_log_file_n('cal name='||l_cal_name);
2257: end if;
2258: for i in 1..g_num_lang loop
2259: l_cal_name:=get_lookup_value('BSC_DBI_CAL_NAME','GREG_CALENDAR_NAME',g_lang(i),l_source_lang);
2260: insert into bsc_sys_calendars_tl(CALENDAR_ID,LANGUAGE,SOURCE_LANG,NAME,HELP,
2261: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2262: values(g_greg_cal_id,g_lang(i),l_source_lang,l_cal_name,l_cal_name,g_who,sysdate,g_who,sysdate,g_who);
2263: end loop;
2264: /*

Line 2482: write_to_log_file_n('delete bsc_sys_calendars_tl where calendar_id='||l_calendar_id||');'||get_time);

2478: if g_debug then
2479: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);
2480: end if;
2481: if g_debug then
2482: write_to_log_file_n('delete bsc_sys_calendars_tl where calendar_id='||l_calendar_id||');'||get_time);
2483: end if;
2484: delete bsc_sys_calendars_tl where calendar_id=l_calendar_id;
2485: if g_debug then
2486: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);

Line 2484: delete bsc_sys_calendars_tl where calendar_id=l_calendar_id;

2480: end if;
2481: if g_debug then
2482: write_to_log_file_n('delete bsc_sys_calendars_tl where calendar_id='||l_calendar_id||');'||get_time);
2483: end if;
2484: delete bsc_sys_calendars_tl where calendar_id=l_calendar_id;
2485: if g_debug then
2486: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);
2487: end if;
2488: if g_debug then