APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on MSD_DEM_QUERY_UTILITIES

Line 165: msd_dem_query_utilities.get_query2 (

161:
162: x_key_values := x_key_values || '$';
163:
164: /* Get the query */
165: msd_dem_query_utilities.get_query2 (
166: x_retcode1,
167: x_large_sql,
168: l_identifier,
169: p_sr_instance_id,

Line 2781: msd_dem_query_utilities.get_query3 (

2777: var_key_values := var_key_values || 'C_DEM_SCHEMA#' || g_schema
2778: || '$C_SR_INSTANCE_ID#' || to_char(p_sr_instance_id) || '$';
2779:
2780: /* Get the query */
2781: msd_dem_query_utilities.get_query3 (
2782: var_retcode,
2783: var_large_sql,
2784: var_identifier,
2785: null,

Line 2794: errbuf := 'Error in call to msd_dem_query_utilities.get_query3';

2790: var_ps_view_name);
2791: IF (var_retcode = -1)
2792: THEN
2793: retcode := -1;
2794: errbuf := 'Error in call to msd_dem_query_utilities.get_query3';
2795: msd_dem_common_utilities.log_message ('msd_spf_collect_history_data.collect_install_base_uc_data - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2796: msd_dem_common_utilities.log_message (errbuf);
2797: RETURN;
2798: END IF;

Line 2868: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');

2864:
2865: /* Pre-Process End */
2866:
2867: /* Execute the query */
2868: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');
2869: msd_dem_query_utilities.execute_query (
2870: errbuf,
2871: retcode,
2872: p_entity_name,

Line 2869: msd_dem_query_utilities.execute_query (

2865: /* Pre-Process End */
2866:
2867: /* Execute the query */
2868: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');
2869: msd_dem_query_utilities.execute_query (
2870: errbuf,
2871: retcode,
2872: p_entity_name,
2873: p_sr_instance_id,

Line 2878: || 'Error in call to msd_dem_query_utilities.execute_query');

2874: p_key_value_pairs );
2875: IF (retcode = -1)
2876: THEN
2877: msd_dem_common_utilities.log_message ('Error(3) in msd_spf_collect_history_data.populate_staging_table - '
2878: || 'Error in call to msd_dem_query_utilities.execute_query');
2879: msd_dem_common_utilities.log_message(errbuf);
2880: RETURN;
2881: ELSE
2882: msd_dem_common_utilities.log_message ('Query ' || p_entity_name || ' executed successfully.');

Line 6461: msd_dem_query_utilities.execute_query ( errbuf, retcode, 'EQ_SALES_TMPL_ITEM', p_sr_instance_id, null);

6457: msd_dem_common_utilities.log_debug ('Update stmt - ' || l_sql);
6458: msd_dem_common_utilities.log_debug (' ');
6459:
6460: msd_dem_common_utilities.log_message ('Updating DM_ITEM_CODE column in T_SRC_SALES_TMPL table.');
6461: msd_dem_query_utilities.execute_query ( errbuf, retcode, 'EQ_SALES_TMPL_ITEM', p_sr_instance_id, null);
6462:
6463: /*------- END - updates to t_src_sales_tmpl table -------*/
6464:
6465: