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

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 669: /*5461356 . we were deleting the metadata first. this means bsc_sys_periodicities got cleaned. then when we did

665: if g_debug then
666: dmp_g_dbi_cal_record;
667: end if;
668: -----------
669: /*5461356 . we were deleting the metadata first. this means bsc_sys_periodicities got cleaned. then when we did
670: delete bsc_sys_periods where periodicity_id in bsc_sys_periodicities, it did not clean bsc_sys_periods and so there was unique
671: constraint error. soln-> first delete bsc_sys_periods and db calendar (delete_dbi_calendars), then periodicities and sys calendar */
672: delete_dbi_calendars;
673: delete_dbi_calendar_metadata;

Line 670: delete bsc_sys_periods where periodicity_id in bsc_sys_periodicities, it did not clean bsc_sys_periods and so there was unique

666: dmp_g_dbi_cal_record;
667: end if;
668: -----------
669: /*5461356 . we were deleting the metadata first. this means bsc_sys_periodicities got cleaned. then when we did
670: delete bsc_sys_periods where periodicity_id in bsc_sys_periodicities, it did not clean bsc_sys_periods and so there was unique
671: constraint error. soln-> first delete bsc_sys_periods and db calendar (delete_dbi_calendars), then periodicities and sys calendar */
672: delete_dbi_calendars;
673: delete_dbi_calendar_metadata;
674: load_dbi_ent_cal;

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 785: cursor c1(p_cal_id number) is select bsc_sys_periodicities.calendar_id,

781: End;
782:
783: procedure init_cal_per_ids is
784: --
785: cursor c1(p_cal_id number) is select bsc_sys_periodicities.calendar_id,
786: bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id ,
787: bsc_sys_calendars_b.short_name, bsc_sys_periodicities.short_name,bsc_sys_calendars_b.fiscal_change
788: from bsc_sys_periodicities ,bsc_sys_calendars_b
789: where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id

Line 786: bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id ,

782:
783: procedure init_cal_per_ids is
784: --
785: cursor c1(p_cal_id number) is select bsc_sys_periodicities.calendar_id,
786: bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id ,
787: bsc_sys_calendars_b.short_name, bsc_sys_periodicities.short_name,bsc_sys_calendars_b.fiscal_change
788: from bsc_sys_periodicities ,bsc_sys_calendars_b
789: where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id
790: and bsc_sys_calendars_b.edw_calendar_type_id=1 and bsc_sys_calendars_b.edw_calendar_id=p_cal_id;

Line 787: bsc_sys_calendars_b.short_name, bsc_sys_periodicities.short_name,bsc_sys_calendars_b.fiscal_change

783: procedure init_cal_per_ids is
784: --
785: cursor c1(p_cal_id number) is select bsc_sys_periodicities.calendar_id,
786: bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id ,
787: bsc_sys_calendars_b.short_name, bsc_sys_periodicities.short_name,bsc_sys_calendars_b.fiscal_change
788: from bsc_sys_periodicities ,bsc_sys_calendars_b
789: where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id
790: and bsc_sys_calendars_b.edw_calendar_type_id=1 and bsc_sys_calendars_b.edw_calendar_id=p_cal_id;
791: --

Line 788: from bsc_sys_periodicities ,bsc_sys_calendars_b

784: --
785: cursor c1(p_cal_id number) is select bsc_sys_periodicities.calendar_id,
786: bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id ,
787: bsc_sys_calendars_b.short_name, bsc_sys_periodicities.short_name,bsc_sys_calendars_b.fiscal_change
788: from bsc_sys_periodicities ,bsc_sys_calendars_b
789: where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id
790: and bsc_sys_calendars_b.edw_calendar_type_id=1 and bsc_sys_calendars_b.edw_calendar_id=p_cal_id;
791: --
792: l_cal_id number;

Line 789: where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id

785: cursor c1(p_cal_id number) is select bsc_sys_periodicities.calendar_id,
786: bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id ,
787: bsc_sys_calendars_b.short_name, bsc_sys_periodicities.short_name,bsc_sys_calendars_b.fiscal_change
788: from bsc_sys_periodicities ,bsc_sys_calendars_b
789: where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id
790: and bsc_sys_calendars_b.edw_calendar_type_id=1 and bsc_sys_calendars_b.edw_calendar_id=p_cal_id;
791: --
792: l_cal_id number;
793: l_cal_short_name varchar2(100);

Line 801: write_to_log_file_n('select bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id '||

797: l_fiscal_change number;
798: --
799: Begin
800: if g_debug then
801: write_to_log_file_n('select bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id '||
802: 'from bsc_sys_periodicities ,bsc_sys_calendars_b '||
803: 'where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id '||
804: 'and bsc_sys_calendars_b.edw_calendar_type_id=1 and bsc_sys_calendars_b.edw_calendar_id=1001/1002/1003 ');
805: end if;

Line 802: 'from bsc_sys_periodicities ,bsc_sys_calendars_b '||

798: --
799: Begin
800: if g_debug then
801: write_to_log_file_n('select bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id '||
802: 'from bsc_sys_periodicities ,bsc_sys_calendars_b '||
803: 'where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id '||
804: 'and bsc_sys_calendars_b.edw_calendar_type_id=1 and bsc_sys_calendars_b.edw_calendar_id=1001/1002/1003 ');
805: end if;
806: open c1(1001);

Line 803: 'where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id '||

799: Begin
800: if g_debug then
801: write_to_log_file_n('select bsc_sys_periodicities.periodicity_id,bsc_sys_periodicities.period_type_id '||
802: 'from bsc_sys_periodicities ,bsc_sys_calendars_b '||
803: 'where bsc_sys_periodicities.calendar_id=bsc_sys_calendars_b.calendar_id '||
804: 'and bsc_sys_calendars_b.edw_calendar_type_id=1 and bsc_sys_calendars_b.edw_calendar_id=1001/1002/1003 ');
805: end if;
806: open c1(1001);
807: loop

Line 1614: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

1610: l_xtd_pattern:=','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1611: g_ent_day_per_id||',:225;';
1612: l_xtd_pattern:=l_xtd_pattern||','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1613: g_ent_week_per_id||','||g_ent_day_per_id||',:1143;';
1614: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
1615: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
1616: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
1617: g_ent_day_per_id,365,null,0,'PERIOD',null,0,0,g_ent_cal_id,0,1,'DAY365',9,1,1,l_xtd_pattern, 'FII_TIME_DAY');
1618: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_ENT_DAY_NAME');

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 1635: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

1631: l_xtd_pattern:=','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1632: g_ent_day_per_id||',:1;';
1633: l_xtd_pattern:=l_xtd_pattern||','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1634: g_ent_week_per_id||','||g_ent_day_per_id||',:11;';
1635: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
1636: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
1637: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
1638: g_ent_week_per_id,52,g_ent_day_per_id,0,'PERIOD',null,0,0,g_ent_cal_id,0,2,'WEEK52',7,16,16,l_xtd_pattern, 'FII_TIME_WEEK');
1639: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_ENT_WEEK_NAME');

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 1656: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

1652: l_xtd_pattern:=','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1653: g_ent_day_per_id||',:1;';
1654: l_xtd_pattern:=l_xtd_pattern||','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1655: g_ent_week_per_id||','||g_ent_day_per_id||',:23;';
1656: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
1657: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
1658: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
1659: g_ent_period_per_id,12,g_ent_day_per_id,0,'PERIOD',null,0,0,g_ent_cal_id,0,2,'MONTH',5,32,32,l_xtd_pattern, 'FII_TIME_ENT_PERIOD');
1660: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_ENT_PERIOD_NAME');

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 1676: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

1672: l_xtd_pattern:=','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1673: g_ent_day_per_id||',:33;';
1674: l_xtd_pattern:=l_xtd_pattern||','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1675: g_ent_week_per_id||','||g_ent_day_per_id||',:55;';
1676: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
1677: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
1678: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
1679: g_ent_qtr_per_id,4,g_ent_period_per_id,0,'PERIOD',null,0,0,g_ent_cal_id,0,2,'QUARTER',3,64,64,l_xtd_pattern, 'FII_TIME_ENT_QTR');
1680: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_ENT_QTR_NAME');

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 1696: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

1692: l_xtd_pattern:=','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1693: g_ent_day_per_id||',:97;';
1694: l_xtd_pattern:=l_xtd_pattern||','||g_ent_year_per_id||','||g_ent_qtr_per_id||','||g_ent_period_per_id||','||
1695: g_ent_week_per_id||','||g_ent_day_per_id||',:119;';
1696: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
1697: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
1698: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
1699: g_ent_year_per_id,1,g_ent_qtr_per_id,0,'PERIOD',null,1,0,g_ent_cal_id,0,2,'YEAR',1,128,128,l_xtd_pattern, 'FII_TIME_ENT_YEAR');
1700: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_ENT_YEAR_NAME');

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 1984: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

1980: g_445_day_per_id||',:177;';
1981:
1982: /* INSERT 445 DAY PERIODICITY */
1983:
1984: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
1985: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
1986: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
1987: g_445_day_per_id,365,null,0,'PERIOD',null,0,0,g_445_cal_id,0,1,'CUSTOM_1',9,1,1,l_xtd_pattern, g_445_day_short_name);
1988: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_445_DAY_NAME');

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 2003: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

1999: --
2000: l_xtd_pattern:=','||g_445_year_per_id||','||g_445_p445_per_id||','||g_445_week_per_id||','||
2001: g_445_day_per_id||',:1;';
2002:
2003: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
2004: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
2005: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
2006: g_445_week_per_id,52,g_445_day_per_id,0,'PERIOD',null,0,0,g_445_cal_id,0,2,'CUSTOM_2',0,16,16,l_xtd_pattern, g_445_week_short_name);
2007: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_445_WEEK_NAME');

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 2022: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

2018: --
2019: l_xtd_pattern:=','||g_445_year_per_id||','||g_445_p445_per_id||','||g_445_week_per_id||','||
2020: g_445_day_per_id||',:17;';
2021:
2022: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
2023: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
2024: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
2025: g_445_p445_per_id,12,g_445_week_per_id,0,'PERIOD',null,0,0,g_445_cal_id,0,2,'CUSTOM_3',0,32,32,l_xtd_pattern, g_445_p445_short_name);
2026:

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 2041: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

2037: --
2038: l_xtd_pattern:=','||g_445_year_per_id||','||g_445_p445_per_id||','||g_445_week_per_id||','||
2039: g_445_day_per_id||',:49;';
2040:
2041: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
2042: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
2043: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
2044: g_445_year_per_id,1,g_445_p445_per_id,0,'PERIOD',null,1,0,g_445_cal_id,0,2,'YEAR',1,128,128,l_xtd_pattern, g_445_year_short_name);
2045: l_name:=get_bis_dim_long_name('FII_TIME_YEAR445',g_src_lang,l_source_lang);

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 2273: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

2269: g_greg_day_per_id||',:225;';
2270:
2271: /* INSERT GREGORIAN DAY PERIODICITY */
2272:
2273: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
2274: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
2275: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
2276: g_greg_day_per_id,365,null,0,'PERIOD',null,0,0,g_greg_cal_id,0,1,'CUSTOM_1',9,1,1,l_xtd_pattern, g_greg_day_short_name);
2277: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_GREG_DAY_NAME');

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 2294: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

2290: g_greg_day_per_id||',:1;';
2291:
2292: /* INSERT GREGORIAN MONTH PERIODICITY */
2293:
2294: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
2295: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
2296: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
2297: g_greg_period_per_id,12,g_greg_day_per_id,0,'PERIOD',null,0,0,g_greg_cal_id,0,2,'CUSTOM_2',0,32,32,l_xtd_pattern, g_greg_period_short_name);
2298: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_GREG_PERIOD_NAME');

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 2315: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

2311: g_greg_day_per_id||',:33;';
2312:
2313: /* INSERT GREGORIAN QUARTER PERIODICITY */
2314:
2315: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
2316: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
2317: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
2318: g_greg_qtr_per_id,4,g_greg_period_per_id,0,'PERIOD',null,0,0,g_greg_cal_id,0,2,'CUSTOM_3',0,64,64,l_xtd_pattern, g_greg_qtr_short_name);
2319: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_GREG_QTR_NAME');

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 2336: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,

2332: g_greg_day_per_id||',:97;';
2333:
2334: /* INSERT GREGORIAN YEAR PERIODICITY */
2335:
2336: insert into bsc_sys_periodicities(PERIODICITY_ID,NUM_OF_PERIODS,SOURCE,NUM_OF_SUBPERIODS,
2337: PERIOD_COL_NAME,SUBPERIOD_COL_NAME,YEARLY_FLAG,EDW_FLAG,CALENDAR_ID,EDW_PERIODICITY_ID,
2338: CUSTOM_CODE,DB_COLUMN_NAME,PERIODICITY_TYPE,PERIOD_TYPE_ID,RECORD_TYPE_ID,XTD_PATTERN, short_name) values (
2339: g_greg_year_per_id,1,g_greg_qtr_per_id,0,'PERIOD',null,1,0,g_greg_cal_id,0,2,'YEAR',1,128,128,l_xtd_pattern, g_greg_year_short_name);
2340: --FND_MESSAGE.SET_NAME('BSC','BSC_DBI_GREG_YEAR_NAME');

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 2467: '(select periodicity_id from bsc_sys_periodicities where calendar_id='||l_calendar_id||')'||get_time);

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);
2471: if g_debug then

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;

Line 2470: (select periodicity_id from bsc_sys_periodicities where calendar_id=l_calendar_id);

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;
2474: if g_debug then

Line 2475: write_to_log_file_n('delete bsc_sys_periodicities where calendar_id='||l_calendar_id||';'||get_time);

2471: if g_debug then
2472: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);
2473: end if;
2474: if g_debug then
2475: write_to_log_file_n('delete bsc_sys_periodicities where calendar_id='||l_calendar_id||';'||get_time);
2476: end if;
2477: delete bsc_sys_periodicities where calendar_id=l_calendar_id;
2478: if g_debug then
2479: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);

Line 2477: delete bsc_sys_periodicities where calendar_id=l_calendar_id;

2473: end if;
2474: if g_debug then
2475: write_to_log_file_n('delete bsc_sys_periodicities where calendar_id='||l_calendar_id||';'||get_time);
2476: end if;
2477: delete bsc_sys_periodicities where calendar_id=l_calendar_id;
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

Line 2523: 'from bsc_sys_periodicities where calendar_id='||l_calendar_id||');'||get_time);

2519: fetch c1 into l_calendar_id;
2520: exit when c1%notfound;
2521: if g_debug then
2522: write_to_log_file_n('delete bsc_sys_periods where periodicity_id in (select periodicity_id '||
2523: 'from bsc_sys_periodicities where calendar_id='||l_calendar_id||');'||get_time);
2524: end if;
2525: delete bsc_sys_periods where periodicity_id in (select periodicity_id from bsc_sys_periodicities
2526: where calendar_id=l_calendar_id);
2527: if g_debug then

Line 2525: delete bsc_sys_periods where periodicity_id in (select periodicity_id from bsc_sys_periodicities

2521: if g_debug then
2522: write_to_log_file_n('delete bsc_sys_periods where periodicity_id in (select periodicity_id '||
2523: 'from bsc_sys_periodicities where calendar_id='||l_calendar_id||');'||get_time);
2524: end if;
2525: delete bsc_sys_periods where periodicity_id in (select periodicity_id from bsc_sys_periodicities
2526: where calendar_id=l_calendar_id);
2527: if g_debug then
2528: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);
2529: end if;

Line 2532: 'from bsc_sys_periodicities where calendar_id='||l_calendar_id||');'||get_time);

2528: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);
2529: end if;
2530: if g_debug then
2531: write_to_log_file_n('delete bsc_sys_periods_tl where periodicity_id in (select periodicity_id '||
2532: 'from bsc_sys_periodicities where calendar_id='||l_calendar_id||');'||get_time);
2533: end if;
2534: delete bsc_sys_periods_tl where periodicity_id in (select periodicity_id from bsc_sys_periodicities
2535: where calendar_id=l_calendar_id);
2536: if g_debug then

Line 2534: delete bsc_sys_periods_tl where periodicity_id in (select periodicity_id from bsc_sys_periodicities

2530: if g_debug then
2531: write_to_log_file_n('delete bsc_sys_periods_tl where periodicity_id in (select periodicity_id '||
2532: 'from bsc_sys_periodicities where calendar_id='||l_calendar_id||');'||get_time);
2533: end if;
2534: delete bsc_sys_periods_tl where periodicity_id in (select periodicity_id from bsc_sys_periodicities
2535: where calendar_id=l_calendar_id);
2536: if g_debug then
2537: write_to_log_file_n('Deleted '||sql%rowcount||' rows '||get_time);
2538: end if;

Line 3174: select periodicity_id, calendar_id from bsc_sys_periodicities where short_name= p_time_level_name;

3170: x_message out nocopy varchar2
3171: )return boolean is
3172: --
3173: cursor c1 is
3174: select periodicity_id, calendar_id from bsc_sys_periodicities where short_name= p_time_level_name;
3175: --
3176: Begin
3177:
3178: open c1;