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 666: /*msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PRICE_LIST_FROM_SOURCE', p_instance_id, null, l_add_where_clause ); */

662: if l_add_where_clause is null then
663: l_add_where_clause := ' and 1=1 ';
664: end if;
665:
666: /*msd_dem_query_utilities.get_query(retcode, l_stmt, 'MSD_DEM_PRICE_LIST_FROM_SOURCE', p_instance_id, null, l_add_where_clause ); */
667:
668: l_key_values := '$C_INSTANCE#' || p_instance_id ||
669: '$C_ADD_WHERE_CLAUSE#' || l_add_where_clause || '$';
670:

Line 671: msd_dem_query_utilities.get_query2 (

667:
668: l_key_values := '$C_INSTANCE#' || p_instance_id ||
669: '$C_ADD_WHERE_CLAUSE#' || l_add_where_clause || '$';
670:
671: msd_dem_query_utilities.get_query2 (
672: l_retcode,
673: l_stmt,
674: 'MSD_DEM_PRL_FROM_SOURCE',
675: p_instance_id,

Line 890: msd_dem_query_utilities.truncate_table (

886: RETURN;
887: END IF;
888:
889: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_CTO_OPTION_PRICE ');
890: msd_dem_query_utilities.truncate_table (
891: x_errbuf,
892: x_retcode,
893: 'BIIO_CTO_OPTION_PRICE',
894: 1,

Line 906: msd_dem_query_utilities.truncate_table (

902: RETURN;
903: END IF;
904:
905: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_CTO_OPTION_PRICE_ERR ');
906: msd_dem_query_utilities.truncate_table (
907: x_errbuf,
908: x_retcode,
909: 'BIIO_CTO_OPTION_PRICE_ERR',
910: 1,

Line 985: msd_dem_query_utilities.truncate_table (

981: RETURN;
982: END IF;
983:
984: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_SCENARIO_PRICE ');
985: msd_dem_query_utilities.truncate_table (
986: x_errbuf,
987: x_retcode,
988: 'BIIO_SCENARIO_PRICE',
989: 1,

Line 1001: msd_dem_query_utilities.truncate_table (

997: RETURN;
998: END IF;
999:
1000: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_SCENARIO_PRICE_ERR ');
1001: msd_dem_query_utilities.truncate_table (
1002: x_errbuf,
1003: x_retcode,
1004: 'BIIO_SCENARIO_PRICE_ERR',
1005: 1,