DBA Data[Home] [Help]

APPS.BSC_TAB_TPLATE dependencies on BSC_SYS_PERIODS_TL

Line 512: -- Check records in BSC_SYS_PERIODS_TL for apps

508: l_user_options(3) :=6;
509: l_user_options(4) :=7;
510:
511:
512: -- Check records in BSC_SYS_PERIODS_TL for apps
513: Select count(*)
514: Into l_count
515: From BSC_SYS_PERIODS_TL;
516: if (l_count = 0) then

Line 515: From BSC_SYS_PERIODS_TL;

511:
512: -- Check records in BSC_SYS_PERIODS_TL for apps
513: Select count(*)
514: Into l_count
515: From BSC_SYS_PERIODS_TL;
516: if (l_count = 0) then
517: INSERT INTO BSC_SYS_PERIODS_TL
518: ( YEAR,
519: PERIODICITY_ID,

Line 517: INSERT INTO BSC_SYS_PERIODS_TL

513: Select count(*)
514: Into l_count
515: From BSC_SYS_PERIODS_TL;
516: if (l_count = 0) then
517: INSERT INTO BSC_SYS_PERIODS_TL
518: ( YEAR,
519: PERIODICITY_ID,
520: PERIOD_ID,
521: MONTH,

Line 663: -- finish inserting BSC_SYS_PERIODS_TL

659: FND_LANGUAGES L
660: WHERE
661: L.INSTALLED_FLAG <> 'D');
662: end if;
663: -- finish inserting BSC_SYS_PERIODS_TL
664:
665: -- create dimensions
666: --DBMS_OUTPUT.PUT_LINE('create dimensions------------------------------');
667: if (NOT BSC_DIM_TPLATE.Create_Dimensions) then