eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on MSD_DEM_SETUP_PARAMETERS

Line 2921: x_sql := 'select to_number(parameter_value) from msd_dem_setup_parameters ' ||

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);
2925:

Line 3401: x_sql := 'select to_number(parameter_value) from msd_dem_setup_parameters ' ||

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);
3405:

Line 4116: FROM msd_dem_setup_parameters

4112:
4113: /* Get the SPF Master Organization for SPF Base Model validation */ -- Bug#12675064
4114: SELECT to_number(parameter_value)
4115: INTO var_spf_master_org
4116: FROM msd_dem_setup_parameters
4117: WHERE parameter_name = 'MSD_SPF_MASTER_ORG';
4118:
4119: IF (var_spf_master_org IS NULL)
4120: THEN

Line 5022: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name = ''MSD_DEM_MASTER_ORG''';

5018:
5019: msd_dem_common_utilities.log_message ('');
5020: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_ITEM_TMPL');
5021: BEGIN
5022: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name = ''MSD_DEM_MASTER_ORG''';
5023: execute immediate x_sql into var_param_value;
5024: var_key_value_pairs := '$C_MASTER_ORG_STRING#' || var_param_value ;
5025:
5026: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name = ''MSD_DEM_CATEGORY_SET_NAME''';

Line 5026: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name = ''MSD_DEM_CATEGORY_SET_NAME''';

5022: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name = ''MSD_DEM_MASTER_ORG''';
5023: execute immediate x_sql into var_param_value;
5024: var_key_value_pairs := '$C_MASTER_ORG_STRING#' || var_param_value ;
5025:
5026: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name = ''MSD_DEM_CATEGORY_SET_NAME''';
5027: execute immediate x_sql into var_param_value;
5028: var_key_value_pairs := var_key_value_pairs || '$C_CATEGORY_STRING#' || var_param_value;
5029:
5030: -- BUG#14694463 kkhatri

Line 6086: x_sql := 'select PARAMETER_VALUE from MSD_DEM_SETUP_PARAMETERS where PARAMETER_NAME = ''MSD_DEM_CATEGORY_SET_NAME''';

6082:
6083: /*------- START - Submit "SPF Populate Staging Tables" conc program to load T_SRC_ITEM_TMPL -------*/
6084: msd_dem_common_utilities.log_message ('Submitting "MSDSPFPST" request for populating T_SRC_ITEM_TMPL');
6085:
6086: x_sql := 'select PARAMETER_VALUE from MSD_DEM_SETUP_PARAMETERS where PARAMETER_NAME = ''MSD_DEM_CATEGORY_SET_NAME''';
6087: EXECUTE IMMEDIATE x_sql INTO x_category_set_id ;
6088: x_key_values := '$C_CATEGORY_STRING#' || x_category_set_id;
6089: -- BUG#14694463 kkhatri
6090: x_key_values := x_key_values || '$C_MATERIAL#' || CS_DEM_MATERIAL;

Line 6093: x_sql := 'select PARAMETER_VALUE from MSD_DEM_SETUP_PARAMETERS where PARAMETER_NAME = ''MSD_DEM_MASTER_ORG''';

6089: -- BUG#14694463 kkhatri
6090: x_key_values := x_key_values || '$C_MATERIAL#' || CS_DEM_MATERIAL;
6091: x_key_values := x_key_values || '$C_RESOURCE#' || CS_DEM_RESOURCE || '$';
6092:
6093: x_sql := 'select PARAMETER_VALUE from MSD_DEM_SETUP_PARAMETERS where PARAMETER_NAME = ''MSD_DEM_MASTER_ORG''';
6094: EXECUTE IMMEDIATE x_sql INTO x_master_org_id ;
6095: x_key_values := x_key_values || 'C_ORG_STRING#' || x_master_org_id || '$' ;
6096:
6097:

Line 6733: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name like ''MSD_DEM_SCHEMA''';

6729: END IF;
6730:
6731: /*----- END - Submit Push Setup Parameters conc progam on destination -----*/
6732:
6733: x_sql := 'select parameter_value from msd_dem_setup_parameters where parameter_name like ''MSD_DEM_SCHEMA''';
6734: execute immediate x_sql into x_dest_dem_schema;
6735:
6736: /*----- Perform the following to collect data regarding eAM -----*/
6737: IF (p_collect_product = 'EAM') THEN