APPS.BSC_UTILITY dependencies on BSC_BIS_MEASURE_PUB

Line 1778: l_ret_val := bsc_bis_measure_pub.c_PMD || l_next;

1774: IF (l_type = bsc_utility.c_BSC_MEASURE) THEN
1775: SELECT NVL(MAX(dataset_id) + 1, 0)
1776: INTO l_next
1777: FROM BSC_SYS_DATASETS_TL;
1778: l_ret_val := bsc_bis_measure_pub.c_PMD || l_next;
1779:
1780: ELSIF (l_type = bsc_utility.c_BSC_DIMENSION) THEN
1781: SELECT NVL(MAX(dim_group_id) + 1, 0)
1782: INTO l_next

Line 3787: -- Wrapper over BSC_BIS_MEASURE_PUB.Is_Src_Col_In_Formulas to return a VARCHAR so that it can be used in a SQL query.

3783: END IF;
3784: RETURN FND_API.G_FALSE;
3785: END is_attached_to_objective;
3786:
3787: -- Wrapper over BSC_BIS_MEASURE_PUB.Is_Src_Col_In_Formulas to return a VARCHAR so that it can be used in a SQL query.
3788: FUNCTION Is_Src_Col_In_Formulas (
3789: p_Source_Col IN VARCHAR2
3790: ) RETURN VARCHAR2
3791: IS

Line 3793: IF (BSC_BIS_MEASURE_PUB.Is_Src_Col_In_Formulas(p_Source_Col)) THEN

3789: p_Source_Col IN VARCHAR2
3790: ) RETURN VARCHAR2
3791: IS
3792: BEGIN
3793: IF (BSC_BIS_MEASURE_PUB.Is_Src_Col_In_Formulas(p_Source_Col)) THEN
3794: RETURN FND_API.G_TRUE;
3795: END IF;
3796: RETURN FND_API.G_FALSE;
3797: EXCEPTION

Line 3815: AND ((BSC_BIS_MEASURE_PUB.Is_Formula_Type(m.measure_Col) = 'T') OR

3811: SELECT COUNT(1)
3812: FROM bsc_sys_datasets_b d, bsc_sys_measures m
3813: WHERE d.dataset_id = p_dataset_id
3814: AND m.measure_id = d.measure_id1
3815: AND ((BSC_BIS_MEASURE_PUB.Is_Formula_Type(m.measure_Col) = 'T') OR
3816: (d.measure_id2 IS NOT NULL) OR
3817: (BSC_UTILITY.Is_Src_Col_In_Formulas(m.measure_Col) = 'T') OR
3818: ((SELECT COUNT(1) FROM bsc_sys_datasets_b
3819: WHERE dataset_id <> d.dataset_id