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_DESIGNER_PVT dependencies on BSC_APPS

Line 416: AND owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)

412: CURSOR c_column IS
413: SELECT column_name
414: FROM all_tab_columns
415: WHERE table_name = p_table_name
416: AND owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)
417: ORDER BY column_name;
418:
419: h_Trg_kpi_neg NUMBER;
420:

Line 492: -- Initialize BSC/APPS global variables

488: h_aOG NUMBER;
489: h_usl NUMBER;
490: h_count NUMBER := 0;
491: BEGIN
492: -- Initialize BSC/APPS global variables
493: BSC_APPS.Init_Bsc_Apps;
494:
495: h_key_name := 'INDICATOR';
496: IF( p_table_column = C_SOURCE_CODE )THEN

Line 493: BSC_APPS.Init_Bsc_Apps;

489: h_usl NUMBER;
490: h_count NUMBER := 0;
491: BEGIN
492: -- Initialize BSC/APPS global variables
493: BSC_APPS.Init_Bsc_Apps;
494:
495: h_key_name := 'INDICATOR';
496: IF( p_table_column = C_SOURCE_CODE )THEN
497: h_key_name := 'SOURCE_CODE';

Line 667: BSC_APPS.Init_Bsc_Apps;

663: h_msg VARCHAR2(1000);
664:
665: BEGIN
666: --Need to initiliaze in order to Do_DDL works fine
667: BSC_APPS.Init_Bsc_Apps;
668:
669: IF l_indicator = x_indicator THEN
670: --h_msg := 'Loaded';
671: --DBMS_OUTPUT.PUT_LINE(h_msg);

Line 733: BSC_APPS.Init_Bsc_Apps;

729: WHERE (TAB_ID,INDICATOR) NOT IN
730: (SELECT TAB_ID,INDICATOR FROM BSC_TAB_INDICATORS));
731:
732: --Need to initiliaze in order to Do_DDL works fine
733: BSC_APPS.Init_Bsc_Apps;
734: --Get indicator configuration and type
735: OPEN c_kpi_invalid;
736: FETCH c_kpi_invalid INTO h_indicator;
737: WHILE c_kpi_invalid%FOUND LOOP

Line 1753: AND OWNER = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)

1749:
1750: CURSOR c_column IS
1751: SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS
1752: WHERE TABLE_NAME = x_table_name
1753: AND OWNER = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)
1754: ORDER BY COLUMN_NAME;
1755:
1756: h_Trg_kpi_neg NUMBER;
1757: CURSOR c_userwizard IS

Line 1787: -- Initialize BSC/APPS global variables

1783: h_aOP NUMBER;
1784: h_aOG NUMBER;
1785: h_usl NUMBER;
1786: BEGIN
1787: -- Initialize BSC/APPS global variables
1788: BSC_APPS.Init_Bsc_Apps;
1789:
1790: h_key_name := 'INDICATOR';
1791: IF SUBSTR(x_table_name, 1, 7) = 'BSC_SYS' THEN

Line 1788: BSC_APPS.Init_Bsc_Apps;

1784: h_aOG NUMBER;
1785: h_usl NUMBER;
1786: BEGIN
1787: -- Initialize BSC/APPS global variables
1788: BSC_APPS.Init_Bsc_Apps;
1789:
1790: h_key_name := 'INDICATOR';
1791: IF SUBSTR(x_table_name, 1, 7) = 'BSC_SYS' THEN
1792: h_key_name := 'SOURCE_CODE';

Line 1900: AND owner = DECODE(USER, BSC_APPS.get_user_schema('APPS'), BSC_APPS.get_user_schema, USER)

1896: CURSOR c_column IS
1897: SELECT column_name
1898: FROM all_tab_columns
1899: WHERE table_name = p_table_name
1900: AND owner = DECODE(USER, BSC_APPS.get_user_schema('APPS'), BSC_APPS.get_user_schema, USER)
1901: AND UPPER(column_name) <> 'KPI_MEASURE_ID'
1902: AND UPPER(column_name) <> 'INDICATOR'
1903: ORDER BY column_name;
1904:

Line 1911: -- Initialize BSC/APPS global variables

1907: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1908: x_num_columns NUMBER;
1909:
1910: BEGIN
1911: -- Initialize BSC/APPS global variables
1912: BSC_APPS.Init_Bsc_Apps;
1913:
1914: --Open COLUMNS by table cursor
1915: x_num_columns := 0;

Line 1912: BSC_APPS.Init_Bsc_Apps;

1908: x_num_columns NUMBER;
1909:
1910: BEGIN
1911: -- Initialize BSC/APPS global variables
1912: BSC_APPS.Init_Bsc_Apps;
1913:
1914: --Open COLUMNS by table cursor
1915: x_num_columns := 0;
1916: IF c_column%ISOPEN THEN

Line 2054: -- Initialize BSC/APPS global variables

2050: c_src_ao_comb c_cur_type;
2051: l_src_kpi_measure_id NUMBER;
2052: l_Count NUMBER := 0;
2053: BEGIN
2054: -- Initialize BSC/APPS global variables
2055: BSC_APPS.Init_Bsc_Apps;
2056: Init_Kpi_Metadata_Tables_Array();
2057:
2058: -- Delete all the existing rows for the Target Objective (if any)

Line 2055: BSC_APPS.Init_Bsc_Apps;

2051: l_src_kpi_measure_id NUMBER;
2052: l_Count NUMBER := 0;
2053: BEGIN
2054: -- Initialize BSC/APPS global variables
2055: BSC_APPS.Init_Bsc_Apps;
2056: Init_Kpi_Metadata_Tables_Array();
2057:
2058: -- Delete all the existing rows for the Target Objective (if any)
2059: FOR i IN 1 .. g_num_obj_kpi_metadata_tables LOOP

Line 2170: -- Initialize BSC/APPS global variables

2166: h_Trg_kpi_neg NUMBER;
2167:
2168: h_TRG_Flag NUMBER;
2169: BEGIN
2170: -- Initialize BSC/APPS global variables
2171: BSC_APPS.Init_Bsc_Apps;
2172: Init_Kpi_Metadata_Tables_Array();
2173:
2174: SELECT NVL(CSF_ID,1)

Line 2171: BSC_APPS.Init_Bsc_Apps;

2167:
2168: h_TRG_Flag NUMBER;
2169: BEGIN
2170: -- Initialize BSC/APPS global variables
2171: BSC_APPS.Init_Bsc_Apps;
2172: Init_Kpi_Metadata_Tables_Array();
2173:
2174: SELECT NVL(CSF_ID,1)
2175: INTO h_CSF_id

Line 2953: owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)

2949: all_tab_columns
2950: WHERE
2951: table_name = p_table_name
2952: AND
2953: owner = DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema,USER)
2954: ORDER BY column_name;
2955:
2956: l_colum VARCHAR2(100);
2957: l_key_name VARCHAR2(30);

Line 2964: -- Initialize BSC/APPS global variables

2960: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
2961: l_num_columns NUMBER;
2962: i NUMBER;
2963: BEGIN
2964: -- Initialize BSC/APPS global variables
2965: BSC_APPS.Init_Bsc_Apps;
2966: SAVEPOINT BscCopyObjRecordPub;
2967:
2968: l_key_name := p_Table_column;

Line 2965: BSC_APPS.Init_Bsc_Apps;

2961: l_num_columns NUMBER;
2962: i NUMBER;
2963: BEGIN
2964: -- Initialize BSC/APPS global variables
2965: BSC_APPS.Init_Bsc_Apps;
2966: SAVEPOINT BscCopyObjRecordPub;
2967:
2968: l_key_name := p_Table_column;
2969: IF( p_table_column = C_SOURCE_CODE )THEN

Line 3140: -- Initialize BSC/APPS global variables

3136: l_num_columns NUMBER;
3137: i NUMBER;
3138: l_Count NUMBER := 0;
3139: BEGIN
3140: -- Initialize BSC/APPS global variables
3141: BSC_APPS.Init_Bsc_Apps;
3142: SAVEPOINT BscProcessTLTableInfo;
3143:
3144: IF(INSTR(p_table_name,'BSC') = 1)THEN

Line 3141: BSC_APPS.Init_Bsc_Apps;

3137: i NUMBER;
3138: l_Count NUMBER := 0;
3139: BEGIN
3140: -- Initialize BSC/APPS global variables
3141: BSC_APPS.Init_Bsc_Apps;
3142: SAVEPOINT BscProcessTLTableInfo;
3143:
3144: IF(INSTR(p_table_name,'BSC') = 1)THEN
3145: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BSC'),USER)

Line 3145: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BSC'),USER)

3141: BSC_APPS.Init_Bsc_Apps;
3142: SAVEPOINT BscProcessTLTableInfo;
3143:
3144: IF(INSTR(p_table_name,'BSC') = 1)THEN
3145: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BSC'),USER)
3146: INTO l_owner FROM DUAL;
3147: ELSIF(INSTR(p_table_name,'BIS') = 1)THEN
3148: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
3149: INTO l_owner FROM DUAL;

Line 3148: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)

3144: IF(INSTR(p_table_name,'BSC') = 1)THEN
3145: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BSC'),USER)
3146: INTO l_owner FROM DUAL;
3147: ELSIF(INSTR(p_table_name,'BIS') = 1)THEN
3148: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
3149: INTO l_owner FROM DUAL;
3150: ELSIF(INSTR(p_table_name,'FND') = 1) THEN
3151: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
3152: INTO l_owner FROM DUAL;

Line 3151: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)

3147: ELSIF(INSTR(p_table_name,'BIS') = 1)THEN
3148: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
3149: INTO l_owner FROM DUAL;
3150: ELSIF(INSTR(p_table_name,'FND') = 1) THEN
3151: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
3152: INTO l_owner FROM DUAL;
3153: ELSE
3154: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
3155: INTO l_owner FROM DUAL;

Line 3154: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)

3150: ELSIF(INSTR(p_table_name,'FND') = 1) THEN
3151: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
3152: INTO l_owner FROM DUAL;
3153: ELSE
3154: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
3155: INTO l_owner FROM DUAL;
3156: END IF;
3157:
3158: -- Get supported languages in source system

Line 3333: BSC_APPS.Init_Bsc_Apps;

3329: x_return_status := FND_API.G_RET_STS_SUCCESS;
3330:
3331: SAVEPOINT BscCopyKpiMetadataPub;
3332:
3333: BSC_APPS.Init_Bsc_Apps;
3334: Init_Kpi_Metadata_Tables_Array();
3335:
3336: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT DECODE(share_flag, 2, 3, 5) FROM bsc_kpis_vl');
3337: l_sql := l_sql || 'WHERE indicator = :1';