APPS.BSC_TAB_TPLATE dependencies on BSC_SYS_USER_OPTIONS

Line 1763: l_debug_stmt := 'Inserting BSC_SYS_USER_OPTIONS at System Level' ||

1759: );
1760: end if; -- Indicator.Detail_Flag
1761:
1762: -- User Options
1763: l_debug_stmt := 'Inserting BSC_SYS_USER_OPTIONS at System Level' ||
1764: ', Indicator= ' || to_char(G_Ind_Tbl(k_indicator).Indicator);
1765:
1766: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1767: For l_variable In 0 .. (G_Ind_Tbl(k_indicator).User_Options -1) Loop

Line 1769: Insert Into BSC_SYS_USER_OPTIONS(

1765:
1766: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1767: For l_variable In 0 .. (G_Ind_Tbl(k_indicator).User_Options -1) Loop
1768:
1769: Insert Into BSC_SYS_USER_OPTIONS(
1770: SOURCE_TYPE,
1771: SOURCE_CODE,
1772: USER_OPT_ID,
1773: ENABLED_FLAG,

Line 1795: l_debug_stmt := 'Inserting BSC_SYS_USER_OPTIONS at System Level';

1791: )
1792: where PERIODICITY_ID = 1;
1793:
1794: -- General
1795: l_debug_stmt := 'Inserting BSC_SYS_USER_OPTIONS at System Level';
1796: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1797: Insert Into BSC_SYS_USER_OPTIONS(
1798: SOURCE_TYPE,SOURCE_CODE,USER_OPT_ID,ENABLED_FLAG,DISPLAY_FLAG)
1799: Values (0,0,1,0,1);

Line 1797: Insert Into BSC_SYS_USER_OPTIONS(

1793:
1794: -- General
1795: l_debug_stmt := 'Inserting BSC_SYS_USER_OPTIONS at System Level';
1796: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1797: Insert Into BSC_SYS_USER_OPTIONS(
1798: SOURCE_TYPE,SOURCE_CODE,USER_OPT_ID,ENABLED_FLAG,DISPLAY_FLAG)
1799: Values (0,0,1,0,1);
1800: Insert Into BSC_SYS_USER_OPTIONS(
1801: SOURCE_TYPE,SOURCE_CODE,USER_OPT_ID,ENABLED_FLAG,DISPLAY_FLAG)

Line 1800: Insert Into BSC_SYS_USER_OPTIONS(

1796: --DBMS_OUTPUT.PUT_LINE(l_debug_stmt);
1797: Insert Into BSC_SYS_USER_OPTIONS(
1798: SOURCE_TYPE,SOURCE_CODE,USER_OPT_ID,ENABLED_FLAG,DISPLAY_FLAG)
1799: Values (0,0,1,0,1);
1800: Insert Into BSC_SYS_USER_OPTIONS(
1801: SOURCE_TYPE,SOURCE_CODE,USER_OPT_ID,ENABLED_FLAG,DISPLAY_FLAG)
1802: Values (0,0,2,0,1);
1803:
1804: /* -- ---------------------------------------------------------