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_UPGRADES dependencies on BSC_DB_MEASURE_COLS_TL

Line 84: BSC_DB_MEASURE_COLS_TL table, which will be used by Generate Database to

80:
81:
82: /*******************************************************************************
83: This PL/SQL API has been designer to generate new DB Column entries in
84: BSC_DB_MEASURE_COLS_TL table, which will be used by Generate Database to
85: directly run on exisitng type of measures.
86:
87: This API should not be called without calling Refresh_Measure_Col_Names,
88: Though this API can run independently, it will generate column that are

Line 279: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;

275: i NUMBER;
276: l_err VARCHAR2(2000);
277:
278: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
279: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;
280: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
281: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
282: CURSOR bsc_indicators_cursor IS
283: SELECT d.dataset_id, i.name as measure_name, i.description, i.short_name as measure_short_name, i.indicator_id measure_id, i.created_by created_by, i.last_updated_by last_updated_by, i.last_update_login last_update_login

Line 280: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;

276: l_err VARCHAR2(2000);
277:
278: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
279: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;
280: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
281: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
282: CURSOR bsc_indicators_cursor IS
283: SELECT d.dataset_id, i.name as measure_name, i.description, i.short_name as measure_short_name, i.indicator_id measure_id, i.created_by created_by, i.last_updated_by last_updated_by, i.last_update_login last_update_login
284: FROM bsc_sys_datasets_vl d, bis_indicators_vl i, bsc_sys_measures m

Line 281: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;

277:
278: l_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
279: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;
280: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
281: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
282: CURSOR bsc_indicators_cursor IS
283: SELECT d.dataset_id, i.name as measure_name, i.description, i.short_name as measure_short_name, i.indicator_id measure_id, i.created_by created_by, i.last_updated_by last_updated_by, i.last_update_login last_update_login
284: FROM bsc_sys_datasets_vl d, bis_indicators_vl i, bsc_sys_measures m
285: WHERE i.short_name = m.short_name (+)

Line 2655: BSC_DB_MEASURE_COLS_TL table, which will be used by Generate Database to

2651: );
2652: END Refresh_Measure_Col_Names;
2653: /*******************************************************************************
2654: This PL/SQL API has been designer to generate new DB Column entries in
2655: BSC_DB_MEASURE_COLS_TL table, which will be used by Generate Database to
2656: directly run on exisitng type of measures.
2657: This API should not be called without calling Refresh_Measure_Col_Names,
2658: Though this API can run independently, it will generate column that are
2659: available directly in BSC_SYS_MEASURES.MEASURE_COL (which ideally may not

Line 2682: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;

2678: l_Return_Status VARCHAR2(1);
2679: l_Msg_Count NUMBER;
2680: l_Msg_Data VARCHAR2(2000);
2681: l_Count NUMBER;
2682: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;
2683: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
2684: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
2685: BEGIN
2686: SAVEPOINT SP_GEN_EXISTING;

Line 2683: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;

2679: l_Msg_Count NUMBER;
2680: l_Msg_Data VARCHAR2(2000);
2681: l_Count NUMBER;
2682: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;
2683: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
2684: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
2685: BEGIN
2686: SAVEPOINT SP_GEN_EXISTING;
2687: l_Count := 0; -- BSC_DB_MEASURE_COLS_PKG

Line 2684: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;

2680: l_Msg_Data VARCHAR2(2000);
2681: l_Count NUMBER;
2682: l_Measure_Group_Id BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID%TYPE;
2683: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
2684: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
2685: BEGIN
2686: SAVEPOINT SP_GEN_EXISTING;
2687: l_Count := 0; -- BSC_DB_MEASURE_COLS_PKG
2688: -- setup defaults