APPS.MSD_DEM_COLLECT_RETURN_HISTORY dependencies on FND_PROFILE

Line 156: || '$C_SCHEMANAME#' || fnd_profile.value('MSD_DEM_SCHEMA')

152:
153: IF(p_dm_time_level = 1) then
154:
155: x_key_values := '$C_DEST_TABLE#' || p_dest_table
156: || '$C_SCHEMANAME#' || fnd_profile.value('MSD_DEM_SCHEMA')
157: || '$C_DEST_DATE_GROUP#' || 'MDBR.SDATE'
158: || '$C_DEST_DATE#' || 'MDBR.SDATE'
159: || '$C_SOURCE_DATE#' || ' nvl( ' || substr(l_msd_source_date_col, 0, instr(upper(l_msd_source_date_col), 'SDATE')-1) || ', to_date(''01/01/1000'', ''DD/MM/YYYY'')) ' || ' SDATE'
160: || '$C_ADD_WHERE_CLAUSE#' || x_add_where_clause

Line 188: || '$C_SCHEMANAME#' || fnd_profile.value('MSD_DEM_SCHEMA')

184:
185: ELSE
186:
187: x_key_values := '$C_DEST_TABLE#' || p_dest_table
188: || '$C_SCHEMANAME#' || fnd_profile.value('MSD_DEM_SCHEMA')
189: || '$C_DEST_DATE_GROUP#' || 'INP.DATET'
190: || '$C_DEST_DATE#' || 'INP.DATET SDATE'
191: || '$C_SOURCE_DATE#' || SUBSTR(L_MSD_SOURCE_DATE_COL, 1, instr(L_MSD_SOURCE_DATE_COL, 'SDATE')-1)||' PDATE'
192: || '$C_ADD_WHERE_CLAUSE#' || x_add_where_clause

Line 591: x_dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');

587: CLOSE c_get_dm_schema;
588:
589: if (x_dem_schema is not null)
590: then
591: x_dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');
592: end if;
593:
594: IF (x_dest_table is NULL)
595: THEN

Line 639: IF (nvl( fnd_profile.value( 'MSD_DEM_TRUNCATE_STG_TABLE'), 'N') = 'Y')

635: THEN
636: if p_collection_method = 1 then
637: x_sql := 'TRUNCATE TABLE ' || x_dest_table;
638: else
639: IF (nvl( fnd_profile.value( 'MSD_DEM_TRUNCATE_STG_TABLE'), 'N') = 'Y')
640: THEN
641: x_sql := 'TRUNCATE TABLE ' || x_dest_table;
642: ELSE
643: x_sql := 'DELETE FROM '|| x_dest_table || ' where sdate between ''' || x_from_date || ''' AND ''' || x_to_date || '''';