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_TAB_TPLATE dependencies on BSC_KPI_PERIODICITIES

Line 1641: l_debug_stmt := 'Inserting BSC_KPI_PERIODICITIES' ||

1637: l_option_r := 0;
1638: level_per :=1;
1639: end if;
1640:
1641: l_debug_stmt := 'Inserting BSC_KPI_PERIODICITIES' ||
1642: ', k_indicator=' || to_char(k_indicator) ||
1643: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1644: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1645:

Line 1647: Insert Into BSC_KPI_PERIODICITIES (

1643: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1644: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1645:
1646:
1647: Insert Into BSC_KPI_PERIODICITIES (
1648: INDICATOR,
1649: PERIODICITY_ID,
1650: DISPLAY_ORDER,
1651: PREVIOUS_YEARS,

Line 1723: l_debug_stmt := 'Inserting BSC_KPI_PERIODICITIES' ||

1719: else -- Indicator.Detail_Flag = 'NO'
1720:
1721: -- the following codes should not be used
1722:
1723: l_debug_stmt := 'Inserting BSC_KPI_PERIODICITIES' ||
1724: ', k_indicator=' || to_char(k_indicator) ||
1725: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1726: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1727:

Line 1728: Insert Into BSC_KPI_PERIODICITIES (

1724: ', k_indicator=' || to_char(k_indicator) ||
1725: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1726: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1727:
1728: Insert Into BSC_KPI_PERIODICITIES (
1729: INDICATOR,
1730: PERIODICITY_ID,
1731: DISPLAY_ORDER,
1732: PREVIOUS_YEARS,

Line 1784: -- Fix BSC_KPI_PERIODICITIES. Current period for annual periodicities MUST be the current year.

1780: end Loop;
1781:
1782: End loop; -- indicator loop
1783:
1784: -- Fix BSC_KPI_PERIODICITIES. Current period for annual periodicities MUST be the current year.
1785: -- BUG 1949762
1786: update BSC_KPI_PERIODICITIES
1787: set CURRENT_PERIOD = (
1788: SELECT CURRENT_YEAR

Line 1786: update BSC_KPI_PERIODICITIES

1782: End loop; -- indicator loop
1783:
1784: -- Fix BSC_KPI_PERIODICITIES. Current period for annual periodicities MUST be the current year.
1785: -- BUG 1949762
1786: update BSC_KPI_PERIODICITIES
1787: set CURRENT_PERIOD = (
1788: SELECT CURRENT_YEAR
1789: FROM BSC_SYS_CALENDARS_B
1790: WHERE CALENDAR_ID=1