DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on BSC_DB_MEASURE_COLS_PKG

Line 348: BSC_DB_MEASURE_COLS_PKG.INSERT_ROW (

344: END IF;
345: -- added for Enhancement#4239216
346: BEGIN
347: IF (l_Measure_Col IS NOT NULL) THEN
348: BSC_DB_MEASURE_COLS_PKG.INSERT_ROW (
349: x_Measure_Col => l_Measure_Col
350: , x_Measure_Group_Id => l_Measure_Group_Id
351: , x_Projection_Id => l_Projection_Id
352: , x_Measure_Type => l_Measure_Type

Line 360: , x_source => 'BSC_DB_MEASURE_COLS_PKG.INSERT_ROW'

356: EXCEPTION
357: WHEN OTHERS THEN
358: BSC_MESSAGE.Add (
359: x_message => SQLERRM || ' - ERROR ADDING COL : ' || l_Measure_Col
360: , x_source => 'BSC_DB_MEASURE_COLS_PKG.INSERT_ROW'
361: , x_mode => 'I'
362: );
363: END;
364: UPDATE bis_indicators

Line 2687: l_Count := 0; -- BSC_DB_MEASURE_COLS_PKG

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
2689: l_Measure_Group_Id := -1; -- default group
2690: l_Projection_Id := 0; -- Indicates no projection
2691: l_Measure_Type := 1; -- activity type by default

Line 2699: BSC_DB_MEASURE_COLS_PKG.INSERT_ROW (

2695: WHERE UPPER(B.MEASURE_COL) = UPPER(cPMFM.MEASURE_COL);
2696: -- need to create a new MEASURE COULIMN
2697: IF(l_Count = 0) THEN
2698: BEGIN
2699: BSC_DB_MEASURE_COLS_PKG.INSERT_ROW (
2700: x_Measure_Col => cPMFM.MEASURE_COL
2701: , x_Measure_Group_Id => l_Measure_Group_Id
2702: , x_Projection_Id => l_Projection_Id
2703: , x_Measure_Type => l_Measure_Type

Line 2710: , x_source => 'BSC_DB_MEASURE_COLS_PKG.INSERT_ROW'

2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: BSC_MESSAGE.Add (
2709: x_message => SQLERRM || ' - ERROR ADDING COL : ' || cPMFM.MEASURE_COL
2710: , x_source => 'BSC_DB_MEASURE_COLS_PKG.INSERT_ROW'
2711: , x_mode => 'I'
2712: );
2713: END;
2714: END IF;