APPS.BSC_DATASETS_PVT dependencies on BSC_BIS_MEASURE_PUB

Line 416: /*IF (BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_old_formula)=FND_API.G_TRUE AND BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_new_formula)=FND_API.G_TRUE) THEN

412: l_Structure_Change := TRUE;
413: END IF;
414:
415: -- Actual fix for Bug #Bug #4860106 (Pending for Bug #4941403)- Don't remove it.- ppandey
416: /*IF (BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_old_formula)=FND_API.G_TRUE AND BSC_BIS_MEASURE_PUB.Is_Formula_Type(p_new_formula)=FND_API.G_TRUE) THEN
417: l_Old_Formula_Table := get_Formula_Table(p_old_formula, l_Old_Measure_Count);
418: l_New_Formula_Table := get_Formula_Table(p_new_formula, l_New_Measure_Count);
419: IF (l_Old_Measure_Count <> l_New_Measure_Count) THEN
420: l_Structure_Change := TRUE;

Line 587: IF (p_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_PMF AND l_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_BSC) THEN

583: if p_Dataset_Rec.Bsc_Measure_Col is not null then
584: l_Dataset_Rec.Bsc_Measure_Col := p_Dataset_Rec.Bsc_Measure_Col;
585: end if;
586:
587: IF (p_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_PMF AND l_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_BSC) THEN
588: l_Dataset_Rec.Bsc_Source := p_Dataset_Rec.Bsc_Source;
589: END IF;
590:
591: if p_Dataset_Rec.Bsc_Measure_Short_Name is not null then

Line 786: WHERE SOURCE = BSC_BIS_MEASURE_PUB.c_BSC

782: -- mdamle 04/23/2003 - PMD - Measure Definer - Delete db column if not being used by any other measure
783: -- Delete column if no other dataset is using it.
784: SELECT COUNT(1) INTO l_count
785: FROM BSC_SYS_MEASURES
786: WHERE SOURCE = BSC_BIS_MEASURE_PUB.c_BSC
787: AND MEASURE_COL LIKE '%' || l_Measure_Col || '%';
788:
789: IF l_Count = 0 THEN
790: SELECT COUNT(1) INTO l_count

Line 829: WHERE SOURCE = BSC_BIS_MEASURE_PUB.c_BSC

825:
826: -- Delete column if no other dataset is using it.
827: SELECT COUNT(1) INTO l_Count
828: FROM BSC_SYS_MEASURES
829: WHERE SOURCE = BSC_BIS_MEASURE_PUB.c_BSC
830: AND MEASURE_COL LIKE '%' || l_Measure_Col || '%';
831:
832: IF l_Count = 0 THEN
833: SELECT COUNT(1) INTO l_count

Line 1372: IF (p_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_PMF AND l_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_BSC) THEN

1368: if p_Dataset_Rec.Bsc_Dataset_Last_Update_Login is null then
1369: l_Dataset_Rec.Bsc_Dataset_Last_Update_Login := fnd_global.LOGIN_ID;
1370: end if;
1371:
1372: IF (p_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_PMF AND l_Dataset_Rec.Bsc_Source = BSC_BIS_MEASURE_PUB.c_BSC) THEN
1373: l_Dataset_Rec.Bsc_Source := p_Dataset_Rec.Bsc_Source;
1374: END IF;
1375:
1376: -- PMD

Line 1571: ,p_level => BSC_BIS_MEASURE_PUB.c_LEVEL

1567: -- mdamle 04/23/2003 - PMD - Measure Definer - Delete Cause and Effect relationships
1568: BSC_CAUSE_EFFECT_REL_PUB.Delete_All_Cause_Effect_Rels(
1569: p_commit => p_commit
1570: ,p_indicator => p_Dataset_Rec.Bsc_Dataset_Id
1571: ,p_level => BSC_BIS_MEASURE_PUB.c_LEVEL
1572: ,x_return_status => x_return_status
1573: ,x_msg_count => x_msg_count
1574: ,x_msg_data => x_msg_data);
1575: