APPS.MSD_DEM_COLLECT_LEVEL_TYPES dependencies on MSD_DEM_QUERY_UTILITIES

Line 163: msd_dem_query_utilities.get_query(retcode, l_stmt, 'LOCATION_GTT', p_instance_id, l_sales_staging_table);

159: end if;
160:
161: if p_collect_level_type = 1 then
162:
163: msd_dem_query_utilities.get_query(retcode, l_stmt, 'LOCATION_GTT', p_instance_id, l_sales_staging_table);
164:
165: if retcode = -1 then
166: return;
167: end if;

Line 171: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEM_GTT', p_instance_id, l_sales_staging_table);

167: end if;
168:
169: elsif p_collect_level_type = 2 then
170:
171: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEM_GTT', p_instance_id, l_sales_staging_table);
172:
173: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
174:
175: if retcode = -1 then

Line 243: msd_dem_query_utilities.get_query(retcode, l_stmt, 'LOCATIONS', p_instance_id, l_staging_table);

239:
240: if p_collect_level_type = 1 then
241: l_staging_table := msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','LOCATION_STAGING_TABLE');
242:
243: msd_dem_query_utilities.get_query(retcode, l_stmt, 'LOCATIONS', p_instance_id, l_staging_table);
244:
245: if retcode = -1 then
246: return;
247: end if;

Line 271: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEMS', p_instance_id, l_staging_table);

267: --bug 13716381 --kkhatri--12.3
268: --bug 14670484 --kkhatri--12.2.1
269: IF (x_dem_version = '7.2' or check_data_model(errbuf,retcode) = 'OLD')
270: THEN
271: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEMS', p_instance_id, l_staging_table);
272: ELSE
273: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEMS_730', p_instance_id, l_staging_table);
274: END IF;
275:

Line 273: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEMS_730', p_instance_id, l_staging_table);

269: IF (x_dem_version = '7.2' or check_data_model(errbuf,retcode) = 'OLD')
270: THEN
271: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEMS', p_instance_id, l_staging_table);
272: ELSE
273: msd_dem_query_utilities.get_query(retcode, l_stmt, 'ITEMS_730', p_instance_id, l_staging_table);
274: END IF;
275:
276: if retcode = -1 then
277: return;

Line 416: msd_dem_query_utilities.get_query(x_retcode, x_sql, 'NEW_ITEMS', p_sr_instance_id, x_item_staging_table);

412: msd_dem_common_utilities.log_message (errbuf);
413: RETURN;
414: END IF;
415:
416: msd_dem_query_utilities.get_query(x_retcode, x_sql, 'NEW_ITEMS', p_sr_instance_id, x_item_staging_table);
417:
418: IF (x_retcode = -1)
419: THEN
420: retcode := 1;