APPS.BSC_UTILITY dependencies on BSC_BIS_DIM_OBJ_PUB

Line 1321: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_OBJ_PUB.isBscInProductionMode Function');

1317: SELECT Property_Value
1318: FROM BSC_SYS_INIT
1319: WHERE PROPERTY_CODE ='SYSTEM_STAGE';
1320: BEGIN
1321: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_OBJ_PUB.isBscInProductionMode Function');
1322: IF (c_isBscInProductionMode%ISOPEN) THEN
1323: CLOSE c_isBscInProductionMode;
1324: END IF;
1325: OPEN c_isBscInProductionMode;

Line 1330: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_OBJ_PUB.isBscInProductionMode Function');

1326: FETCH c_isBscInProductionMode
1327: INTO l_property_value;
1328:
1329: CLOSE c_isBscInProductionMode;
1330: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_OBJ_PUB.isBscInProductionMode Function');
1331: IF (l_property_value = '2') THEN
1332: RETURN TRUE;
1333: ELSE
1334: RETURN FALSE;

Line 1790: l_ret_val := bsc_bis_dim_obj_pub.c_BSC_DIM_OBJ || l_next;

1786: ELSIF (l_type = bsc_utility.c_BSC_DIM_OBJ) THEN
1787: SELECT NVL(MAX(dim_level_id) + 1, 0)
1788: INTO l_next
1789: FROM BSC_SYS_DIM_LEVELS_B;
1790: l_ret_val := bsc_bis_dim_obj_pub.c_BSC_DIM_OBJ || l_next;
1791: END IF;
1792:
1793: RETURN l_ret_val;
1794: