APPS.MSD_DEM_CTO dependencies on FND_PROFILE

Line 46: x_dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');

42: WHERE entity_name = p_entity_name;
43:
44:
45: msd_dem_common_utilities.log_debug('Get the Demantra Schema Name');
46: x_dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');
47: IF (x_dem_schema IS NULL)
48: THEN
49: msd_dem_common_utilities.log_message ('Error(1) in msd_dem_cto.populate_staging_table - '
50: || 'Unable to get value for Profile MSD_DEM: Schema');

Line 61: x_include_dependent_demand := fnd_profile.value ('MSD_DEM_INCLUDE_DEPENDENT_DEMAND');

57: THEN
58:
59: /* If the query is exclusively meant for CTO, then the query should be run only if
60: the profile MSD_DEM: Include Dependent Demand is set to Yes */
61: x_include_dependent_demand := fnd_profile.value ('MSD_DEM_INCLUDE_DEPENDENT_DEMAND');
62:
63: IF (x_include_dependent_demand = 2) /* Profile is set to No */
64: THEN
65: msd_dem_common_utilities.log_message ('In msd_dem_cto.populate_staging_table - '

Line 263: x_include_dependent_demand := fnd_profile.value ('MSD_DEM_INCLUDE_DEPENDENT_DEMAND');

259: ELSE
260:
261: /* If the query is exclusively meant for NON-CTO, then the query should be run only if
262: the profile MSD_DEM: Include Dependent Demand is set to No */
263: x_include_dependent_demand := fnd_profile.value ('MSD_DEM_INCLUDE_DEPENDENT_DEMAND');
264:
265: IF (x_include_dependent_demand = 1) /* Profile is set to Yes */
266: THEN
267: msd_dem_common_utilities.log_message ('In msd_dem_cto.populate_staging_table - '

Line 359: x_is_local NUMBER := to_number(fnd_profile.value('MSD_DEM_EXPLODE_DEMAND_METHOD'));

355: p_sr_instance_id IN NUMBER,
356: p_flat_file_load IN NUMBER DEFAULT 2 )
357: IS
358:
359: x_is_local NUMBER := to_number(fnd_profile.value('MSD_DEM_EXPLODE_DEMAND_METHOD'));
360: x_cpp NUMBER := to_number(fnd_profile.value('MSD_DEM_PLANNING_PERCENTAGE'));
361: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
362: x_curr_user VARCHAR2(100) := NULL;
363: x_is_seq_present NUMBER := NULL;

Line 360: x_cpp NUMBER := to_number(fnd_profile.value('MSD_DEM_PLANNING_PERCENTAGE'));

356: p_flat_file_load IN NUMBER DEFAULT 2 )
357: IS
358:
359: x_is_local NUMBER := to_number(fnd_profile.value('MSD_DEM_EXPLODE_DEMAND_METHOD'));
360: x_cpp NUMBER := to_number(fnd_profile.value('MSD_DEM_PLANNING_PERCENTAGE'));
361: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
362: x_curr_user VARCHAR2(100) := NULL;
363: x_is_seq_present NUMBER := NULL;
364: x_validation_org_id NUMBER := NULL;

Line 361: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');

357: IS
358:
359: x_is_local NUMBER := to_number(fnd_profile.value('MSD_DEM_EXPLODE_DEMAND_METHOD'));
360: x_cpp NUMBER := to_number(fnd_profile.value('MSD_DEM_PLANNING_PERCENTAGE'));
361: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
362: x_curr_user VARCHAR2(100) := NULL;
363: x_is_seq_present NUMBER := NULL;
364: x_validation_org_id NUMBER := NULL;
365: x_sql VARCHAR2(32000) := NULL;

Line 386: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 2)

382: /* Log the parameters */
383: msd_dem_common_utilities.log_debug (' Instance ID - ' || to_char(p_sr_instance_id));
384:
385: /* The procedure should only execute if profile MSD_DEM: Include Dependent Demand is set to yes. */
386: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 2)
387: THEN
388: msd_dem_common_utilities.log_message ('In msd_dem_cto.collect_model_bom_components - '
389: || 'Profile MSD_DEM: Include Dependent Demand is set to No. '
390: || 'Hence no action taken. Exiting Normally.');

Line 1019: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');

1015:
1016: IF (p_complete_refresh = 1)
1017: THEN
1018:
1019: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1020:
1021: /*Deleting records from T_EP_CTO table */
1022: x_sql := 'DELETE FROM ' || x_schema || '.' || 'T_EP_CTO' || ' WHERE t_ep_cto_id <> 0 ';
1023: msd_dem_common_utilities.log_message ('The SQL is - ' || x_sql);