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_PERIODICITIES_TL

Line 1625: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

1621: write_to_log_file_n('periodicity name DBI ent day='||l_name);
1622: end if;
1623: for i in 1..g_num_lang loop
1624: l_name:=get_bis_dim_long_name('FII_TIME_DAY',g_lang(i),l_source_lang);
1625: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
1626: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1627: values(g_ent_day_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
1628: end loop;
1629: --

Line 1646: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

1642: write_to_log_file_n('periodicity name DBI ent week='||l_name);
1643: end if;
1644: for i in 1..g_num_lang loop
1645: l_name:=get_bis_dim_long_name('FII_TIME_WEEK',g_lang(i),l_source_lang);
1646: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
1647: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1648: values(g_ent_week_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
1649: end loop;
1650: --

Line 1667: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

1663: write_to_log_file_n('periodicity name DBI ent period='||l_name);
1664: end if;
1665: for i in 1..g_num_lang loop
1666: l_name:=get_bis_dim_long_name('FII_TIME_ENT_PERIOD',g_lang(i),l_source_lang);
1667: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
1668: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1669: values(g_ent_period_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
1670: end loop;
1671: --

Line 1687: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

1683: write_to_log_file_n('periodicity name DBI ent qtr='||l_name);
1684: end if;
1685: for i in 1..g_num_lang loop
1686: l_name:=get_bis_dim_long_name('FII_TIME_ENT_QTR',g_lang(i),l_source_lang);
1687: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
1688: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1689: values(g_ent_qtr_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
1690: end loop;
1691: --

Line 1707: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

1703: write_to_log_file_n('periodicity name DBI ent year='||l_name);
1704: end if;
1705: for i in 1..g_num_lang loop
1706: l_name:=get_bis_dim_long_name('FII_TIME_ENT_YEAR',g_lang(i),l_source_lang);
1707: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
1708: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1709: values(g_ent_year_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
1710: end loop;
1711: --

Line 1995: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

1991: write_to_log_file_n('periodicity name DBI 445 day='||l_name);
1992: end if;
1993: for i in 1..g_num_lang loop
1994: l_name:=get_bis_dim_long_name('FII_TIME_DAY',g_lang(i),l_source_lang);
1995: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
1996: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
1997: values(g_445_day_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
1998: end loop;
1999: --

Line 2014: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

2010: write_to_log_file_n('periodicity name DBI 445 week='||l_name);
2011: end if;
2012: for i in 1..g_num_lang loop
2013: l_name:=get_bis_dim_long_name('FII_TIME_WEEK',g_lang(i),l_source_lang);
2014: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
2015: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2016: values(g_445_week_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
2017: end loop;
2018: --

Line 2033: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

2029: write_to_log_file_n('periodicity name DBI 445 p445='||l_name);
2030: end if;
2031: for i in 1..g_num_lang loop
2032: l_name:=get_bis_dim_long_name('FII_TIME_P445',g_lang(i),l_source_lang);
2033: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
2034: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2035: values(g_445_p445_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
2036: end loop;
2037: --

Line 2051: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

2047: write_to_log_file_n('periodicity name DBI 445 year='||l_name);
2048: end if;
2049: for i in 1..g_num_lang loop
2050: l_name:=get_bis_dim_long_name('FII_TIME_YEAR445',g_lang(i),l_source_lang);
2051: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
2052: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2053: values(g_445_year_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
2054: end loop;
2055: -----

Line 2284: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

2280: write_to_log_file_n('periodicity name DBI greg day='||l_name);
2281: end if;
2282: for i in 1..g_num_lang loop
2283: l_name:=get_bis_dim_long_name('FII_TIME_DAY',g_lang(i),l_source_lang);
2284: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
2285: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2286: values(g_greg_day_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
2287: end loop;
2288: --

Line 2305: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

2301: write_to_log_file_n('periodicity name DBI greg period='||l_name);
2302: end if;
2303: for i in 1..g_num_lang loop
2304: l_name:=get_bis_dim_long_name('FII_TIME_MONTH',g_lang(i),l_source_lang);
2305: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
2306: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2307: values(g_greg_period_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
2308: end loop;
2309: --

Line 2326: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

2322: write_to_log_file_n('periodicity name DBI greg qtr='||l_name);
2323: end if;
2324: for i in 1..g_num_lang loop
2325: l_name:=get_bis_dim_long_name('FII_TIME_QTR',g_lang(i),l_source_lang);
2326: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
2327: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2328: values(g_greg_qtr_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
2329: end loop;
2330: --

Line 2347: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,

2343: write_to_log_file_n('periodicity name DBI greg year='||l_name);
2344: end if;
2345: for i in 1..g_num_lang loop
2346: l_name:=get_bis_dim_long_name('FII_TIME_YEAR', g_lang(i),l_source_lang);
2347: insert into bsc_sys_periodicities_tl(PERIODICITY_ID,LANGUAGE,SOURCE_LANG,NAME,CREATED_BY,
2348: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2349: values(g_greg_year_per_id,g_lang(i),l_source_lang,l_name,g_who,sysdate,g_who,sysdate,g_who);
2350: end loop;
2351:

Line 2466: write_to_log_file_n('delete bsc_sys_periodicities_tl where periodicity_id in '||

2462: loop
2463: fetch c1 into l_calendar_id;
2464: exit when c1%notfound;
2465: if g_debug then
2466: write_to_log_file_n('delete bsc_sys_periodicities_tl where periodicity_id in '||
2467: '(select periodicity_id from bsc_sys_periodicities where calendar_id='||l_calendar_id||')'||get_time);
2468: end if;
2469: delete bsc_sys_periodicities_tl where periodicity_id in
2470: (select periodicity_id from bsc_sys_periodicities where calendar_id=l_calendar_id);

Line 2469: delete bsc_sys_periodicities_tl where periodicity_id in

2465: if g_debug then
2466: write_to_log_file_n('delete bsc_sys_periodicities_tl where periodicity_id in '||
2467: '(select periodicity_id from bsc_sys_periodicities where calendar_id='||l_calendar_id||')'||get_time);
2468: end if;
2469: delete bsc_sys_periodicities_tl where periodicity_id in
2470: (select periodicity_id from bsc_sys_periodicities where calendar_id=l_calendar_id);
2471: if g_debug then
2472: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);
2473: end if;