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

Line 5210: FROM bsc_kpi_periodicities

5206: l_count NUMBER;
5207:
5208: CURSOR c_reorder_periods IS
5209: SELECT rownum-1 newRow, periodicity_id
5210: FROM bsc_kpi_periodicities
5211: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5212:
5213: BEGIN
5214: -- Create the new periodicites

Line 5241: UPDATE bsc_kpi_periodicities

5237: END LOOP;
5238:
5239: -- Reorder the sequence.
5240: FOR cd_reorder IN c_reorder_periods LOOP
5241: UPDATE bsc_kpi_periodicities
5242: SET display_order = cd_reorder.newRow
5243: WHERE periodicity_id = cd_reorder.periodicity_id
5244: AND indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5245: END LOOP;

Line 5253: UPDATE bsc_kpi_periodicities

5249: ,periodicity_id = l_Dft_periodicity_id
5250: ,last_update_date = SYSDATE
5251: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5252:
5253: UPDATE bsc_kpi_periodicities
5254: SET user_level0 = C_DISABLE_FLAG
5255: ,user_level1 = C_DISABLE_FLAG
5256: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5257: AND periodicity_id = l_Dft_periodicity_id;

Line 5269: UPDATE bsc_kpi_periodicities

5265: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5266: AND property_code = 'DB_TRANSFORM'
5267: AND property_value = 2;
5268:
5269: UPDATE bsc_kpi_periodicities
5270: SET target_level = 1
5271: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5272: --AND target_level <> 1;
5273: END IF;

Line 5317: bsc_kpi_periodicities kp,

5313: kp. periodicity_id,
5314: p.periodicity_type,
5315: DECODE(p.periodicity_type, 1 , kp.num_of_years, p.num_of_periods) max_periods
5316: FROM
5317: bsc_kpi_periodicities kp,
5318: bsc_sys_periodicities_vl p
5319: WHERE
5320: kp.indicator = p_Indicator
5321: AND kp.periodicity_id = p.periodicity_id

Line 5485: l_Old_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;

5481: l_old_periodicities NUMBER;
5482: l_new_periodicities NUMBER;
5483: l_cur_prototype_flag NUMBER;
5484: l_is_prototype BOOLEAN;
5485: l_Old_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5486: l_Old_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5487: l_New_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5488: l_New_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5489:

Line 5486: l_Old_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;

5482: l_new_periodicities NUMBER;
5483: l_cur_prototype_flag NUMBER;
5484: l_is_prototype BOOLEAN;
5485: l_Old_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5486: l_Old_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5487: l_New_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5488: l_New_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5489:
5490:

Line 5487: l_New_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;

5483: l_cur_prototype_flag NUMBER;
5484: l_is_prototype BOOLEAN;
5485: l_Old_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5486: l_Old_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5487: l_New_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5488: l_New_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5489:
5490:
5491: CURSOR c_share_kpis IS

Line 5488: l_New_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;

5484: l_is_prototype BOOLEAN;
5485: l_Old_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5486: l_Old_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5487: l_New_Number_Years bsc_kpi_periodicities.num_of_years%TYPE := 0;
5488: l_New_Previous_Years bsc_kpi_periodicities.previous_years%TYPE := 0;
5489:
5490:
5491: CURSOR c_share_kpis IS
5492: SELECT indicator

Line 5502: bsc_kpi_periodicities kp,

5498: SELECT
5499: NVL(kp.num_of_years,0),
5500: NVL(kp.previous_years,0)
5501: FROM
5502: bsc_kpi_periodicities kp,
5503: bsc_sys_periodicities_vl p
5504: WHERE
5505: kp.indicator(+) = p_kpi_id
5506: AND kp.periodicity_id(+) = p.periodicity_id

Line 5575: SELECT periodicity_id FROM bsc_kpi_periodicities where indicator = :2

5571: , bsc_sys_calendars_b C
5572: WHERE C.calendar_id =:1
5573: AND P.calendar_id = C.calendar_id
5574: AND periodicity_id NOT IN (
5575: SELECT periodicity_id FROM bsc_kpi_periodicities where indicator = :2
5576: )';
5577: l_sql := l_sql || ' AND periodicity_id IN (' || l_periodicity_ids || ')';
5578:
5579: l_count := 0;

Line 5602: FROM bsc_kpi_periodicities

5598: l_is_prototype:= TRUE;
5599: ELSE
5600: SELECT COUNT(1)
5601: INTO l_old_periodicities
5602: FROM bsc_kpi_periodicities
5603: WHERE indicator = p_kpi_id;
5604: END IF;
5605:
5606: -- Delete the Periods which are Removed (from master and shared objectives).

Line 5608: DELETE bsc_kpi_periodicities

5604: END IF;
5605:
5606: -- Delete the Periods which are Removed (from master and shared objectives).
5607: l_sql :='
5608: DELETE bsc_kpi_periodicities
5609: WHERE indicator IN
5610: (SELECT indicator
5611: FROM bsc_kpis_b
5612: WHERE indicator = :1 OR source_indicator = :2)';

Line 5620: FROM bsc_kpi_periodicities

5616:
5617: IF (l_count = 0) THEN
5618: SELECT COUNT(1)
5619: INTO l_new_periodicities
5620: FROM bsc_kpi_periodicities
5621: WHERE indicator = p_kpi_id;
5622: IF (l_old_periodicities <> l_new_periodicities) THEN
5623: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5624: END IF;

Line 5651: FROM bsc_kpi_periodicities

5647: l_Dft_periodicity_id:= l_periodicities_tbl(1);
5648: ELSE
5649: SELECT periodicity_id
5650: INTO l_Dft_periodicity_id
5651: FROM bsc_kpi_periodicities
5652: WHERE indicator = p_kpi_id
5653: AND rownum = 1;
5654: END IF;
5655: END IF;

Line 5662: UPDATE bsc_kpi_periodicities

5658: IF (NOT l_is_prototype) THEN
5659: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color;
5660: END IF;
5661: -- Reset the default period to enable, it will be taken care in Update_Obj_Cal_properties
5662: UPDATE bsc_kpi_periodicities
5663: SET user_level0=C_ENABLE_FLAG, user_level1=C_ENABLE_FLAG
5664: WHERE user_level0=C_DISABLE_FLAG
5665: AND user_level1=C_DISABLE_FLAG
5666: AND periodicity_id = l_cur_periodicity_id

Line 5714: DELETE bsc_kpi_periodicities p

5710: END LOOP;
5711: CLOSE l_cursor;
5712:
5713: -- Remove all the Master/Shared Objective periodicities.
5714: DELETE bsc_kpi_periodicities p
5715: WHERE p.indicator in
5716: (SELECT k.indicator
5717: FROM bsc_kpis_b k
5718: WHERE k.indicator = p_kpi_id