APPS.MSD_DEM_COLLECT_PRICE_LISTS dependencies on FND_PROFILE

Line 20: select fnd_profile.value('MSD_DEM_SCHEMA')

16: and lookup_code = p_lookup_code
17: and language = 'US';
18:
19: cursor get_schema_name is
20: select fnd_profile.value('MSD_DEM_SCHEMA')
21: from dual;
22:
23: l_lookup_value varchar2(200);
24: l_schema_name varchar2(200);

Line 92: if fnd_profile.value('MSD_DEM_SCHEMA') is not null then

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);
94: l_stmt := replace(l_stmt, 'SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
95: else
96: l_stmt := replace(l_stmt, 'TABLENAME', l_table_name);

Line 93: l_stmt := replace(l_stmt, 'TABLENAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.' || l_table_name);

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);
94: l_stmt := replace(l_stmt, 'SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
95: else
96: l_stmt := replace(l_stmt, 'TABLENAME', l_table_name);
97: end if;

Line 94: l_stmt := replace(l_stmt, 'SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

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);
94: l_stmt := replace(l_stmt, 'SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
95: else
96: l_stmt := replace(l_stmt, 'TABLENAME', l_table_name);
97: end if;
98:

Line 430: execute immediate l_stmt;-- using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');

426: || ')';
427:
428: msd_dem_common_utilities.log_debug(l_stmt);
429:
430: execute immediate l_stmt;-- using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');
431: -- syenamar
432:
433: l_stmt := null;
434: l_stmt := 'select distinct price_list_name price_list_name

Line 823: || fnd_profile.value('MSD_DEM_SCHEMA') || '.'

819: EXECUTE IMMEDIATE x_stmt INTO x_profile_id;
820: -- syenamar
821:
822: x_stmt := 'BEGIN '
823: || fnd_profile.value('MSD_DEM_SCHEMA') || '.'
824: || 'API_NOTIFY_APS_INTEGRATION('
825: || x_profile_id
826: ||'); end;';
827:

Line 858: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 1)

854: RETURN;
855: END IF;
856:
857: /* CTO - One of the EBS Price List should also be loaded into CTO Data */
858: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 1)
859: THEN
860:
861: msd_dem_common_utilities.log_debug('Begin - CTO Price');
862:

Line 865: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');

861: msd_dem_common_utilities.log_debug('Begin - CTO Price');
862:
863: /* Get the price list column that should be used to copy from MSD_DEM_PRICE_LIST */
864:
865: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
866: IF (x_schema IS NULL)
867: THEN
868: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
869: || ' Unable to get Demantra schema name ');

Line 950: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');

946: /* Populate Scenario Price Staging Table if present */
947:
948: x_num_rows := NULL;
949: x_price_list_col := NULL;
950: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
951: IF (x_schema IS NULL)
952: THEN
953: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR(2) - '
954: || ' Unable to get Demantra schema name ');