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_BIS_KPI_MEAS_PUB dependencies on BSC_ANALYSIS_OPTION_PUB

Line 370: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

366: END Get_Valid_Analysis_Option_Ids;
367: /************************************************************************************/
368: PROCEDURE store_kpi_anal_group
369: ( p_kpi_id IN NUMBER
370: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
371: ) IS
372: CURSOR c_kpi_anal_group IS
373: SELECT Analysis_Group_Id
374: , Num_Of_Options

Line 4078: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

4074: , x_return_status OUT NOCOPY VARCHAR2
4075: , x_msg_count OUT NOCOPY NUMBER
4076: , x_msg_data OUT NOCOPY VARCHAR2
4077: ) IS
4078: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
4079: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
4080: l_measure_short_name BSC_SYS_MEASURES.Short_Name%TYPE;
4081: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE := 'DGRP_';
4082: l_temp_var VARCHAR2(32000);

Line 4604: BSC_ANALYSIS_OPTION_PUB.delete_extra_series(

4600: */
4601: IF(l_indic_type = 10 AND l_config_type = 1) THEN -- Multibar indicator
4602: FOR CD IN C_OPTIONZERO_SOURCE LOOP
4603: IF(cd.dataset_id = -1 OR cd.source ='PMF') THEN
4604: BSC_ANALYSIS_OPTION_PUB.delete_extra_series(
4605: p_Bsc_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4606: , x_return_status => x_return_status
4607: , x_msg_count => x_msg_count
4608: , x_msg_data => x_msg_data

Line 4652: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4648: , x_msg_count => x_msg_count
4649: , x_msg_data => x_msg_data
4650: );
4651: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4652: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4654: END IF;
4655: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4656: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);

Line 4659: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options

4655: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4656: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);
4657: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id);
4658: -- END Granular Locking
4659: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options
4660: ( p_commit => FND_API.G_FALSE
4661: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4662: , x_return_status => x_return_status
4663: , x_msg_count => x_msg_count

Line 4667: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4663: , x_msg_count => x_msg_count
4664: , x_msg_data => x_msg_data
4665: );
4666: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4667: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4669: END IF;
4670: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4671: FOR cd IN c_kpi_ids LOOP

Line 4699: BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options

4695: END IF;
4696: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN
4697: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name;
4698: END IF;
4699: BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options
4700: ( p_commit => FND_API.G_FALSE
4701: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4702: , x_return_status => x_return_status
4703: , x_msg_count => x_msg_count

Line 4707: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options');

4703: , x_msg_count => x_msg_count
4704: , x_msg_data => x_msg_data
4705: );
4706: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4707: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options');
4708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4709: END IF;
4710: END IF;
4711: -- START Granular Locking added by Aditya

Line 4741: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options '||p_option0_Name);

4737: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := p_analysis_option_id0;
4738: l_Bsc_Anal_Opt_Rec.Bsc_Parent_Option_Id := NULL;
4739: l_Bsc_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := NULL;
4740: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := p_option0_Name;
4741: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options '||p_option0_Name);
4742: -- START Granular Locking
4743: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id IS NOT NULL) THEN
4744: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
4745: ( p_Kpi_Id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id

Line 4768: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4764: , x_msg_count => x_msg_count
4765: , x_msg_data => x_msg_data
4766: );
4767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4768: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4770: END IF;
4771: END IF;
4772: -- END Granular Locking

Line 4773: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options

4769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4770: END IF;
4771: END IF;
4772: -- END Granular Locking
4773: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options
4774: ( p_commit => FND_API.G_FALSE
4775: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4776: , p_data_Source => l_data_source
4777: , x_return_status => x_return_status

Line 4782: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4778: , x_msg_count => x_msg_count
4779: , x_msg_data => x_msg_data
4780: );
4781: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4782: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4784: END IF;
4785: IF (p_option1_Name IS NOT NULL) THEN
4786: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := p_analysis_option_id1;

Line 4806: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options1 '||p_option1_Name);

4802: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_KPI_MEAS_PUB.Get_Valid_Analysis_Option_Ids');
4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4804: END IF;
4805: l_Bsc_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := NULL;
4806: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options1 '||p_option1_Name);
4807: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options
4808: ( p_commit => FND_API.G_FALSE
4809: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4810: , p_data_Source => l_data_source

Line 4807: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options

4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4804: END IF;
4805: l_Bsc_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := NULL;
4806: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options1 '||p_option1_Name);
4807: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options
4808: ( p_commit => FND_API.G_FALSE
4809: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4810: , p_data_Source => l_data_source
4811: , x_return_status => x_return_status

Line 4816: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4812: , x_msg_count => x_msg_count
4813: , x_msg_data => x_msg_data
4814: );
4815: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4816: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4818: END IF;
4819: END IF;
4820: IF (p_option2_Name IS NOT NULL) THEN

Line 4840: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options2 '||p_option2_Name);

4836: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4837: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_KPI_MEAS_PUB.Get_Valid_Analysis_Option_Ids');
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: END IF;
4840: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options2 '||p_option2_Name);
4841: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options
4842: ( p_commit => FND_API.G_FALSE
4843: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4844: , p_data_Source => l_data_source

Line 4841: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options

4837: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_KPI_MEAS_PUB.Get_Valid_Analysis_Option_Ids');
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: END IF;
4840: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options2 '||p_option2_Name);
4841: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options
4842: ( p_commit => FND_API.G_FALSE
4843: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
4844: , p_data_Source => l_data_source
4845: , x_return_status => x_return_status

Line 4850: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4846: , x_msg_count => x_msg_count
4847: , x_msg_data => x_msg_data
4848: );
4849: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4850: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4852: END IF;
4853: END IF;
4854: END IF;

Line 4993: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

4989: , x_return_status OUT NOCOPY VARCHAR2
4990: , x_msg_count OUT NOCOPY NUMBER
4991: , x_msg_data OUT NOCOPY VARCHAR2
4992: ) IS
4993: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
4994: l_count NUMBER;
4995: l_datasource BSC_SYS_DATASETS_B.Source%TYPE;
4996: l_meaning VARCHAR(60);
4997: l_DimObj_ViewBy_Tbl BSC_BIS_KPI_MEAS_PUB.DimObj_Viewby_Tbl_Type;

Line 5189: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

5185: , x_msg_count => x_msg_count
5186: , x_msg_data => x_msg_data
5187: );
5188: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5189: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: END IF;
5192: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5193: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);

Line 5196: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options

5192: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5193: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);
5194: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id);
5195: -- END Granular Locking
5196: BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options
5197: ( p_commit => FND_API.G_FALSE
5198: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
5199: , x_return_status => x_return_status
5200: , x_msg_count => x_msg_count

Line 5204: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

5200: , x_msg_count => x_msg_count
5201: , x_msg_data => x_msg_data
5202: );
5203: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5204: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
5205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5206: END IF;
5207: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5208: FOR cd IN c_kpi_ids LOOP

Line 5220: BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options

5216: WHERE Indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5217: AND Analysis_Group_Id = l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
5218:
5219: -- START Granular Locking added by Aditya
5220: BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options
5221: ( p_commit => FND_API.G_FALSE
5222: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
5223: , x_return_status => x_return_status
5224: , x_msg_count => x_msg_count

Line 5228: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options');

5224: , x_msg_count => x_msg_count
5225: , x_msg_data => x_msg_data
5226: );
5227: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5228: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options');
5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET
5232: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id

Line 5347: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

5343: l_new_count NUMBER;
5344: l_tab_id NUMBER;
5345: l_dim_set_id NUMBER;
5346:
5347: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
5348: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5349: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
5350: BEGIN
5351: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Analysis_Options procedure');

Line 5463: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options

5459: FROM BSC_KPI_ANALYSIS_MEASURES_B
5460: WHERE INDICATOR = p_kpi_id;
5461:
5462: -- END Granular Locking - Lock the KPI Under consideration
5463: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options
5464: ( p_commit => FND_API.G_FALSE
5465: , p_Anal_Opt_Rec => l_Bsc_Anal_Opt_Rec
5466: , x_return_status => x_return_status
5467: , x_msg_count => x_msg_count

Line 5471: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');

5467: , x_msg_count => x_msg_count
5468: , x_msg_data => x_msg_data
5469: );
5470: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5471: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');
5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5473: END IF;
5474: --Determine number of distinct dataset_id after delete.
5475: SELECT COUNT (DISTINCT dataset_id) INTO l_new_count

Line 5580: ( p_Bsc_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

5576: /************************************************************************************
5577: DELETE_KPI_ANALYSIS_OPTIONS
5578: ************************************************************************************/
5579: PROCEDURE Delete_KPI_Analysis_Options
5580: ( p_Bsc_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
5581: , p_data_source IN VARCHAR2
5582: , x_return_status OUT NOCOPY VARCHAR2
5583: , x_msg_count OUT NOCOPY NUMBER
5584: , x_msg_data OUT NOCOPY VARCHAR2

Line 5619: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options

5615: -- we also need to normalize the values for column ANALYSYS_OPTION0,
5616: -- ANALYSYS_OPTION1, ANALYSYS_OPTION2 based on group id.
5617:
5618: -- END Granular Locking - Lock the KPI Under consideration
5619: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options
5620: ( p_commit => FND_API.G_FALSE
5621: , p_Anal_Opt_Rec => p_Bsc_Anal_Opt_Rec
5622: , x_return_status => x_return_status
5623: , x_msg_count => x_msg_count

Line 5627: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');

5623: , x_msg_count => x_msg_count
5624: , x_msg_data => x_msg_data
5625: );
5626: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5627: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');
5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: END IF;
5630: -- Determine if the dimension set is being used by other options.
5631: IF (p_data_source = 'PMF') THEN

Line 5772: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;

5768: l_tab_name BSC_TABS_TL.name%TYPE;
5769: l_count NUMBER;
5770: l_max_group_count NUMBER;
5771: l_anal_grp_id NUMBER;
5772: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5773: l_Old_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5774:
5775: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
5776: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;

Line 5773: l_Old_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;

5769: l_count NUMBER;
5770: l_max_group_count NUMBER;
5771: l_anal_grp_id NUMBER;
5772: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5773: l_Old_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5774:
5775: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
5776: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
5777: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;

Line 5834: l_anal_grp_id := BSC_ANALYSIS_OPTION_PUB.get_Analysis_Group_Id

5830: l_Anal_Num_Tbl(0) := p_Anal_opt0;
5831: l_Anal_Num_Tbl(1) := p_Anal_opt1;
5832: l_Anal_Num_Tbl(2) := p_Anal_opt2;
5833:
5834: l_anal_grp_id := BSC_ANALYSIS_OPTION_PUB.get_Analysis_Group_Id
5835: (
5836: p_Anal_Opt_Comb_Tbl => l_Anal_Num_Tbl
5837: , p_obj_id => p_kpi_id
5838: );

Line 5916: IF(BSC_ANALYSIS_OPTION_PUB.Default_Anal_Option_Changed(l_Anal_Num_Tbl,l_Old_Anal_Num_Tbl))THEN

5912: END IF;
5913:
5914: -- Fixed Bug#3663301, Called ActionFlag_Change with a Color Flag
5915: IF (l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value IS NOT NULL) THEN
5916: IF(BSC_ANALYSIS_OPTION_PUB.Default_Anal_Option_Changed(l_Anal_Num_Tbl,l_Old_Anal_Num_Tbl))THEN
5917:
5918: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5919:
5920: SELECT kpi_measure_id

Line 7439: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;

7435: , x_return_status OUT NOCOPY VARCHAR2
7436: , x_msg_count OUT NOCOPY NUMBER
7437: , x_msg_data OUT NOCOPY VARCHAR2
7438: ) IS
7439: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
7440: l_old_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7441: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7442: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7443: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

Line 7440: l_old_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

7436: , x_msg_count OUT NOCOPY NUMBER
7437: , x_msg_data OUT NOCOPY VARCHAR2
7438: ) IS
7439: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
7440: l_old_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7441: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7442: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7443: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7444: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

Line 7441: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

7437: , x_msg_data OUT NOCOPY VARCHAR2
7438: ) IS
7439: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
7440: l_old_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7441: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7442: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7443: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7444: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
7445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

Line 7442: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

7438: ) IS
7439: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
7440: l_old_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7441: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7442: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7443: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7444: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
7445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
7446: l_count NUMBER;

Line 7443: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

7439: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
7440: l_old_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7441: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7442: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
7443: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
7444: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
7445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
7446: l_count NUMBER;
7447: l_Default_Delete BOOLEAN := FALSE;

Line 7570: BSC_ANALYSIS_OPTION_PUB.store_anal_opt_grp_count(p_kpi_id,l_old_Anal_Opt_Tbl);

7566:
7567: l_count := get_Struct_Meas_Count(p_kpi_id);
7568:
7569: BSC_BIS_KPI_MEAS_PUB.store_kpi_anal_group(p_kpi_id, l_Anal_Opt_Tbl);
7570: BSC_ANALYSIS_OPTION_PUB.store_anal_opt_grp_count(p_kpi_id,l_old_Anal_Opt_Tbl);
7571:
7572:
7573: l_Anal_Opt_Rec.Bsc_Kpi_Id := p_kpi_id;
7574: l_Anal_Opt_Rec.Bsc_Option_Group0 := p_Option_0;

Line 7596: BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups

7592: l_Anal_Num_Tbl(1) := p_Option_1;
7593: l_Anal_Num_Tbl(2) := p_Option_2;
7594:
7595: IF (l_max_group_count > 1) THEN
7596: BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups
7597: ( p_commit => FND_API.G_FALSE
7598: , p_Kpi_id => p_kpi_id
7599: , p_Anal_Opt_Tbl => l_Anal_Opt_Tbl
7600: , p_max_group_count => l_max_group_count

Line 7608: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Ana_Opt_Mult_Groups Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');

7604: , x_msg_count => x_msg_count
7605: , x_msg_data => x_msg_data
7606: );
7607: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7608: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Ana_Opt_Mult_Groups Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');
7609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7610: END IF;
7611: ELSE
7612: l_Default_Delete := TRUE;

Line 7624: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Ana_Opt_Mult_Groups Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');

7620: , x_msg_count => x_msg_count
7621: , x_msg_data => x_msg_data
7622: );
7623: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7624: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Ana_Opt_Mult_Groups Failed: at BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Options');
7625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7626: END IF;
7627: END IF;
7628:

Line 7654: BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group

7650: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Multi_Groups_Opts Failed: at BSC_KPI_PUB.Update_Kpi_Time_Stamp');
7651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7652: END IF;
7653:
7654: BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group
7655: ( p_commit => FND_API.G_FALSE
7656: , p_Kpi_Id => p_kpi_id
7657: , p_Anal_Opt_Tbl => l_Anal_Opt_Tbl
7658: , x_return_status => x_return_status

Line 7680: BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group

7676: BSC_DESIGNER_PVT.Deflt_RefreshKpi(p_kpi_id);
7677:
7678: FOR cd IN c_kpi_ids LOOP
7679: l_kpi_id := cd.indicator;
7680: BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group
7681: ( p_commit => FND_API.G_FALSE
7682: , p_Kpi_Id => l_kpi_id
7683: , p_Anal_Opt_Tbl => l_Anal_Opt_Tbl
7684: , x_return_status => x_return_status