DBA Data[Home] [Help]

APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on MSC_UTIL

Line 2920: x_category_set_id := MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID;

2916: BEGIN
2917: msd_dem_common_utilities.log_message('Begin - MSD_SPF_COLLECT_HISTORY_DATA.DERIVE_SPARE_SUPERSESSIONS');
2918:
2919: -- Bug#12675064
2920: x_category_set_id := MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID;
2921: x_sql := 'select to_number(parameter_value) from msd_dem_setup_parameters ' ||
2922: ' where parameter_name like ''MSD_SPF_MASTER_ORG''';
2923: execute immediate x_sql into x_spf_master_org;
2924: msd_dem_common_utilities.log_debug(x_sql);

Line 3400: x_category_set_id := MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID;

3396:
3397: BEGIN
3398: msd_dem_common_utilities.log_message('Begin - MSD_SPF_COLLECT_HISTORY_DATA.DERIVE_SERVICE_BOM');
3399:
3400: x_category_set_id := MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID;
3401: x_sql := 'select to_number(parameter_value) from msd_dem_setup_parameters ' ||
3402: ' where parameter_name like ''MSD_SPF_MASTER_ORG''';
3403: execute immediate x_sql into x_spf_master_org;
3404: msd_dem_common_utilities.log_debug(x_sql);

Line 4232: x_category_set_id := MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID;

4228: msd_dem_common_utilities.log_debug('Update Bad Rows Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
4229:
4230: msd_dem_common_utilities.log_message ('Checking for invalid spares ...');
4231:
4232: x_category_set_id := MSC_UTIL.GET_SERVICE_ITEMS_CATSET_ID;
4233: if x_category_set_id is null then
4234: raise_application_error(-20001, 'Profile ''MSC: Category Set for Serviceable Items'' not set. Cannot proceed with validation of spares.');
4235: end if;
4236: