DBA Data[Home] [Help]

APPS.MSD_DEM_COMMON_UTILITIES dependencies on MSD_DEM_SOP

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

516: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_UPLOAD_FORECAST TO ' || x_dem_schema;
517: EXECUTE IMMEDIATE x_grant_sql;
518: log_message ('Execute privilege granted on package MSD_DEM_UPLOAD FORECAST to ' || x_dem_schema || ' schema.');
519:
520: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_SOP TO ' || x_dem_schema;
521: EXECUTE IMMEDIATE x_grant_sql;
522: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
523:
524: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;

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

518: log_message ('Execute privilege granted on package MSD_DEM_UPLOAD FORECAST to ' || x_dem_schema || ' schema.');
519:
520: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_SOP TO ' || x_dem_schema;
521: EXECUTE IMMEDIATE x_grant_sql;
522: log_message ('Execute privilege granted on package MSD_DEM_SOP to ' || x_dem_schema || ' schema.');
523:
524: x_grant_sql := 'GRANT EXECUTE ON MSD_DEM_COMMON_UTILITIES TO ' || x_dem_schema;
525: EXECUTE IMMEDIATE x_grant_sql;
526: log_message ('Execute privilege granted on package MSD_DEM_COMMON_UTILITIES to ' || x_dem_schema || ' schema.');

Line 599: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;

595: /*Setting global parameter */
596: C_MSD_DEM_SCHEMA := x_dem_schema ;
597: log_message ('Global Parameter C_MSD_DEM_SCHEMA has been set to ' || x_dem_schema );
598:
599: MSD_DEM_SOP.C_MSD_DEM_SCHEMA := x_dem_schema;
600:
601: MSD_DEM_CTO.CS_DEM_SYSDATE := get_demantra_date(sysdate, 1);
602: MSD_DEM_CTO.CS_DEM_CTO_BASE_MODEL := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 1);
603: MSD_DEM_CTO.CS_DEM_CTO_OPTION_CLASS := get_lookup_code ('T_EP_CTO_DEMAND_TYPE', 2);