APPS.MSD_DEM_UPLOAD_FORECAST dependencies on MSD_DEM_COMMON_UTILITIES

Line 83: x_group_table_id := to_number(msd_dem_common_utilities.get_lookup_value ('MSD_DEM_DEMANTRA_OBJECT_ID', x_level_id_lkup_code));

79: RETURN NULL;
80: END IF;
81:
82: --syenamar Bug#7197339
83: x_group_table_id := to_number(msd_dem_common_utilities.get_lookup_value ('MSD_DEM_DEMANTRA_OBJECT_ID', x_level_id_lkup_code));
84: /*
85: * Return NULL in case group_table_id is null, i.e. no value fetched from lookups.
86: * In case lookup contains invalid number exception block at end of function handles it and returns NULL.
87: */

Line 94: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_LEVELS');

90: RETURN NULL;
91: END IF;
92: --syenamar
93:
94: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_LEVELS');
95: x_sql := 'SELECT tql.lorder ' ||
96: ' FROM ' || x_table_name || ' tql, ';
97:
98: x_table_name := NULL;

Line 99: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'GROUP_TABLES');

95: x_sql := 'SELECT tql.lorder ' ||
96: ' FROM ' || x_table_name || ' tql, ';
97:
98: x_table_name := NULL;
99: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'GROUP_TABLES');
100: x_sql := x_sql || x_table_name || ' gt ' ||
101: ' WHERE gt.group_table_id = ' || x_group_table_id ||
102: ' AND gt.status = ''ACTIVE'' ' ||
103: ' AND gt.group_table_id = tql.level_id ' ||

Line 155: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_SERIES');

151: ELSE
152: RETURN NULL;
153: END IF;
154:
155: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY_SERIES');
156: x_sql := 'SELECT cf.computed_name ' ||
157: ' FROM ' || x_table_name || ' tqs, ';
158:
159: x_table_name := NULL;

Line 160: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'COMPUTED_FIELDS');

156: x_sql := 'SELECT cf.computed_name ' ||
157: ' FROM ' || x_table_name || ' tqs, ';
158:
159: x_table_name := NULL;
160: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'COMPUTED_FIELDS');
161: x_sql := x_sql || x_table_name || ' cf ' ||
162: ' WHERE tqs.id = ' || p_data_profile_id ||
163: ' AND cf.forecast_type_id = tqs.series_id ' ||
164: ' AND ( upper(cf.computed_name) like ''' || x_series_prefix || '%'' ' ||

Line 214: x_tgroup_res := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TGROUP_RES');

210: x_bucket_size NUMBER := NULL;
211:
212: BEGIN
213:
214: x_tgroup_res := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TGROUP_RES');
215:
216: IF (x_tgroup_res IS NULL)
217: THEN
218: RETURN;

Line 231: x_dm_wiz_dm_def := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');

227: x_months_number,
228: x_inputs_column,
229: x_is_default;
230:
231: x_dm_wiz_dm_def := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'DM_WIZ_DM_DEF');
232: IF (x_dm_wiz_dm_def IS NULL)
233: THEN
234: RETURN;
235: END IF;

Line 347: x_inputs := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');

343: RETURN;
344: END IF;
345:
346: /* Time Resolution Bucket Size is not fixed, availabe in INPUTS */
347: x_inputs := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'INPUTS');
348: IF (x_inputs IS NULL OR x_inputs_column IS NULL)
349: THEN
350: RETURN;
351: END IF;

Line 771: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');

767: x_export_data_profile := upper(p_export_data_profile);
768: END IF;
769:
770: /* Get the export data profile info */
771: x_table_name := msd_dem_common_utilities.get_lookup_value ('MSD_DEM_TABLES', 'TRANSFER_QUERY');
772: x_sql := 'SELECT id, presentation_type, view_name, ' ||
773: ' time_res_id, unit_id, index_id, data_scale, ' ||
774: ' integration_type, export_type, last_export_date ' ||
775: ' FROM ' || x_table_name ||

Line 973: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);

969: x_select_clause := x_select_clause || x_sr_demand_class || ' , ' ||
970: ' msi.inventory_item_id, ';
971:
972:
973: x_uom_code := msd_dem_common_utilities.get_uom_code (x_unit_id);
974: x_select_clause := x_select_clause || '''' || x_uom_code || ''', ' ||
975: ' msi.uom_code, ';
976:
977: /* SINCE AMOUNT IS NOT AVAILABLE USE ASCP's LIST PRICE VALUE */

Line 995: ' msd_dem_common_utilities.uom_convert(msi.inventory_item_id, ' ||

991: ELSE
992: x_quantity := ' round (exp.' || x_fcst_column ||
993: ' * ' || x_data_scale ||
994: ' * decode ( ''' || x_uom_code || ''', msi.uom_code, 1, ' ||
995: ' msd_dem_common_utilities.uom_convert(msi.inventory_item_id, ' ||
996: ' null, ' ||
997: '''' || x_uom_code || ''' , ' ||
998: ' msi.uom_code)), ' ||
999: C_ROUNDOFF_PLACES || ' ) ';