APPS.MSD_DEM_COLLECT_HISTORY_DATA dependencies on MSD_DEM_QUERY_UTILITIES

Line 286: msd_dem_query_utilities.get_query(

282:
283: p_order_type_flag := l_order_type_flag;
284: l_order_type_ids := l_order_types;
285: /*Get the sql query */
286: msd_dem_query_utilities.get_query(
287: x_retcode ,
288: p_order_type_ids, --query
289: l_order_type_ids, --p_entity_name
290: p_sr_instance_id );

Line 646: msd_dem_query_utilities.get_query2 (

642: x_dquery_identifier := l_identifier || '_730';
643: END IF;
644:
645: /* Get the query */
646: msd_dem_query_utilities.get_query2 (
647: x_retcode1,
648: x_large_sql,
649: x_dquery_identifier,
650: p_sr_instance_id,

Line 771: msd_dem_query_utilities.get_query2 (

767:
768: END IF;
769:
770: /* Get the query */
771: msd_dem_query_utilities.get_query2 (
772: x_retcode1,
773: x_large_sql,
774: x_pquery_identifier,
775: p_sr_instance_id,

Line 868: msd_dem_query_utilities.get_query(

864: IF (x_new_items_present = 1)
865: THEN
866: msd_dem_common_utilities.log_message ('Found new items for processing');
867:
868: msd_dem_query_utilities.get_query(
869: x_retcode,
870: x_sql,
871: 'DUMMY_ROWS_FOR_NEW_ITEMS',
872: p_sr_instance_id,