APPS.MSD_DEM_COLLECT_PRICE_LISTS dependencies on MSD_DEM_QUERY_UTILITIES

Line 89: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PRICE_LIST_INTO_DEMANTRA', p_instance_id);

85: end if;
86:
87: close get_prl_metadata;
88:
89: msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PRICE_LIST_INTO_DEMANTRA', p_instance_id);
90:
91:
92: if fnd_profile.value('MSD_DEM_SCHEMA') is not null then
93: l_stmt := replace(l_stmt, 'TABLENAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.' || l_table_name);

Line 640: /*msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PRICE_LIST_FROM_SOURCE', p_instance_id, null, l_add_where_clause ); */

636: if l_add_where_clause is null then
637: l_add_where_clause := ' and 1=1 ';
638: end if;
639:
640: /*msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PRICE_LIST_FROM_SOURCE', p_instance_id, null, l_add_where_clause ); */
641:
642: l_key_values := '$C_INSTANCE#' || p_instance_id ||
643: '$C_ADD_WHERE_CLAUSE#' || l_add_where_clause || '$';
644:

Line 645: msd_dem_query_utilities.get_query2 (

641:
642: l_key_values := '$C_INSTANCE#' || p_instance_id ||
643: '$C_ADD_WHERE_CLAUSE#' || l_add_where_clause || '$';
644:
645: msd_dem_query_utilities.get_query2 (
646: l_retcode,
647: l_stmt,
648: 'MSD_DEM_PRL_FROM_SOURCE',
649: p_instance_id,