DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_REL_PUB dependencies on BIS_UTIL

Line 2380: IF(BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_TRUE) THEN

2376: the PL/SQL procedure "BSC_PMA_APIS_PUB.sync_dimension_table" dynamic so that
2377: the package gets complied on the pure BIS409 enviornments.
2378: /****************************************************/
2379:
2380: IF(BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_TRUE) THEN
2381: l_is_denorm_deleted := FND_API.G_TRUE;
2382:
2383: SELECT short_name
2384: INTO l_dim_short_name

Line 2390: EXECUTE IMMEDIATE l_Sql USING IN l_dim_short_name,IN BIS_UTIL.G_ALTER_TABLE,OUT x_msg_data,OUT l_is_denorm_deleted;

2386: WHERE dim_level_id = p_dim_obj_id;
2387:
2388: BEGIN
2389: l_Sql := 'BEGIN IF(BSC_PMA_APIS_PUB.sync_dimension_table (:2,:3,:4)) THEN :1 :=FND_API.G_TRUE; ELSE :1:=FND_API.G_FALSE; END IF;END;';
2390: EXECUTE IMMEDIATE l_Sql USING IN l_dim_short_name,IN BIS_UTIL.G_ALTER_TABLE,OUT x_msg_data,OUT l_is_denorm_deleted;
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: NULL;
2394: END;