DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_DESIGNER_PVT

Line 387: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_B', p_kpi_id, l_kpi_id);

383: exit when dc_value%NOTFOUND;
384:
385: l_kpi_id := l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id;
386:
387: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_B', p_kpi_id, l_kpi_id);
388: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_TL', p_kpi_id, l_kpi_id);
389: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_GROUPS', p_kpi_id, l_kpi_id);
390: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_SETS_TL', p_kpi_id, l_kpi_id);
391: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVEL_PROPERTIES', p_kpi_id, l_kpi_id);

Line 388: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_TL', p_kpi_id, l_kpi_id);

384:
385: l_kpi_id := l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id;
386:
387: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_B', p_kpi_id, l_kpi_id);
388: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_TL', p_kpi_id, l_kpi_id);
389: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_GROUPS', p_kpi_id, l_kpi_id);
390: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_SETS_TL', p_kpi_id, l_kpi_id);
391: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVEL_PROPERTIES', p_kpi_id, l_kpi_id);
392:

Line 389: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_GROUPS', p_kpi_id, l_kpi_id);

385: l_kpi_id := l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id;
386:
387: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_B', p_kpi_id, l_kpi_id);
388: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_TL', p_kpi_id, l_kpi_id);
389: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_GROUPS', p_kpi_id, l_kpi_id);
390: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_SETS_TL', p_kpi_id, l_kpi_id);
391: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVEL_PROPERTIES', p_kpi_id, l_kpi_id);
392:
393: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE

Line 390: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_SETS_TL', p_kpi_id, l_kpi_id);

386:
387: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_B', p_kpi_id, l_kpi_id);
388: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_TL', p_kpi_id, l_kpi_id);
389: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_GROUPS', p_kpi_id, l_kpi_id);
390: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_SETS_TL', p_kpi_id, l_kpi_id);
391: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVEL_PROPERTIES', p_kpi_id, l_kpi_id);
392:
393: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE
394: ,l_Bsc_Kpi_Entity_Rec

Line 391: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVEL_PROPERTIES', p_kpi_id, l_kpi_id);

387: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_B', p_kpi_id, l_kpi_id);
388: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVELS_TL', p_kpi_id, l_kpi_id);
389: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_GROUPS', p_kpi_id, l_kpi_id);
390: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_SETS_TL', p_kpi_id, l_kpi_id);
391: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVEL_PROPERTIES', p_kpi_id, l_kpi_id);
392:
393: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE
394: ,l_Bsc_Kpi_Entity_Rec
395: ,x_return_status

Line 5262: IF (l_action_flag = BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN

5258:
5259: IF (l_action_flag IS NOT NULL) THEN
5260: --Reset the db_transform
5261: --ppandey 'DB_TRANSFORM' is Objective Type 0->Precalculated, 1->normal, 2->Target at differet Benchmarks.
5262: IF (l_action_flag = BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN
5263: UPDATE bsc_kpi_properties
5264: SET property_value = 1
5265: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5266: AND property_code = 'DB_TRANSFORM'

Line 5275: BSC_DESIGNER_PVT.ActionFlag_Change

5271: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5272: --AND target_level <> 1;
5273: END IF;
5274:
5275: BSC_DESIGNER_PVT.ActionFlag_Change
5276: ( x_indicator => l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5277: , x_newflag => l_action_flag
5278: );
5279: END IF;

Line 5590: IF (l_cur_prototype_flag = BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN

5586: l_current_periods (l_count) := l_current_period;
5587: END LOOP;
5588: CLOSE l_cursor;
5589:
5590: IF (l_cur_prototype_flag = BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN
5591: l_is_prototype := TRUE;
5592: ELSE
5593: l_is_prototype := FALSE;
5594: END IF;

Line 5597: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;

5593: l_is_prototype := FALSE;
5594: END IF;
5595:
5596: IF (NOT l_is_prototype AND l_count > 0) THEN
5597: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5598: l_is_prototype:= TRUE;
5599: ELSE
5600: SELECT COUNT(1)
5601: INTO l_old_periodicities

Line 5623: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;

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;
5625: END IF;
5626:
5627: -- p_Dft_periodicity_id is null in case of Report Designer Create flow Bug #5629309

Line 5659: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color;

5655: END IF;
5656:
5657: IF (l_Dft_periodicity_id <> l_cur_periodicity_id) THEN
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

Line 5678: /*IF (l_cur_prototype_flag <> BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN

5674: ELSE -- calendar is changed for the objective
5675: --We don't need to check if the current prototype_flag is not equal to
5676: --prototype_flag,because changing the calendar always result in
5677: --structural changes.so we will pass the prototype_flag
5678: /*IF (l_cur_prototype_flag <> BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN
5679: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5680: END IF;*/
5681: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5682:

Line 5679: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;

5675: --We don't need to check if the current prototype_flag is not equal to
5676: --prototype_flag,because changing the calendar always result in
5677: --structural changes.so we will pass the prototype_flag
5678: /*IF (l_cur_prototype_flag <> BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN
5679: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5680: END IF;*/
5681: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5682:
5683: l_sql :='

Line 5681: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;

5677: --structural changes.so we will pass the prototype_flag
5678: /*IF (l_cur_prototype_flag <> BSC_DESIGNER_PVT.G_ActionFlag.Prototype) THEN
5679: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5680: END IF;*/
5681: l_action_flag := BSC_DESIGNER_PVT.G_ActionFlag.Prototype;
5682:
5683: l_sql :='
5684: SELECT P.periodicity_id
5685: ,DECODE (P.yearly_flag, 1, C.fiscal_year, 1 )

Line 5850: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update);

5846: CLOSE c_Yearly_Periodicity;
5847:
5848: IF l_Old_Number_Years <> l_New_Number_Years OR
5849: l_Old_Previous_Years <> l_New_Previous_Years THEN
5850: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update);
5851: FOR cd IN c_share_kpis LOOP
5852: BSC_DESIGNER_PVT.ActionFlag_Change(cd.indicator , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update);
5853: END LOOP;
5854: END IF;

Line 5852: BSC_DESIGNER_PVT.ActionFlag_Change(cd.indicator , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update);

5848: IF l_Old_Number_Years <> l_New_Number_Years OR
5849: l_Old_Previous_Years <> l_New_Previous_Years THEN
5850: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update);
5851: FOR cd IN c_share_kpis LOOP
5852: BSC_DESIGNER_PVT.ActionFlag_Change(cd.indicator , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update);
5853: END LOOP;
5854: END IF;
5855:
5856: IF p_commit = FND_API.G_TRUE then