APPS.MSD_DEM_DEMANTRA_UTILITIES dependencies on MSD_DEM_SOP

Line 1499: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_SOP TO ' || x_dem_schema;

1495: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_UPLOAD_FORECAST TO ' || x_dem_schema;
1496: EXECUTE IMMEDIATE x_grant_sql;
1497: log_message ('Execute privilege granted on package MSD_DEM_UPLOAD_FORECAST to ' || x_dem_schema || ' schema.');
1498:
1499: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_SOP TO ' || x_dem_schema;
1500: EXECUTE IMMEDIATE x_grant_sql;
1501: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
1502:
1503: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;

Line 1501: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');

1497: log_message ('Execute privilege granted on package MSD_DEM_UPLOAD_FORECAST to ' || x_dem_schema || ' schema.');
1498:
1499: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_SOP TO ' || x_dem_schema;
1500: EXECUTE IMMEDIATE x_grant_sql;
1501: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
1502:
1503: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;
1504: EXECUTE IMMEDIATE x_grant_sql;
1505: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');

Line 1578: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;

1574: /*Setting global parameter */
1575: C_MSD_DEM_SCHEMA := x_dem_schema ;
1576: log_message ('Global Parameter C_MSD_DEM_SCHEMA has been set to ' || x_dem_schema );
1577:
1578: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
1579:
1580: MSD_DEM_CTO.CS_DEM_SYSDATE := msd_dem_common_utilities.get_demantra_date(sysdate, 1);
1581: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
1582: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := msd_dem_common_utilities.get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);