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 134: execute immediate l_stmt using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');

130: || ' and tq.transfer_id = tl.id) and tqs.series_id = ' || l_series_id;
131:
132: msd_dem_common_utilities.log_debug(l_stmt);
133:
134: execute immediate l_stmt using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');
135:
136: <>
137:
138: null;

Line 244: || ' where tl.name = ''' || fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE') || ''''

240: close get_new_prl_display_unit;
241:
242: l_stmt_get_profile_table := 'select tq.table_name from ' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_LIST') || ' tl '
243: || ' ,' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
244: || ' where tl.name = ''' || fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE') || ''''
245: || ' and tq.transfer_id = tl.id';
246:
247:
248: open get_profile_table for l_stmt_get_profile_table;

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

401: || ' and tq.transfer_id = tl.id)';
402:
403: msd_dem_common_utilities.log_debug(l_stmt);
404:
405: execute immediate l_stmt using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');
406:
407:
408: l_stmt := null;
409: l_stmt := 'select distinct price_list_name price_list_name

Line 754: || ' WHERE tl.name = ''' || fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE') || ''''

750: /* Bug# 6459467 - Refresh the price list data profile */
751: BEGIN
752: x_stmt:= 'SELECT tq.id FROM ' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_LIST') || ' tl '
753: || ' ,' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
754: || ' WHERE tl.name = ''' || fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE') || ''''
755: || ' AND tq.transfer_id = tl.id';
756:
757: msd_dem_common_utilities.log_debug ('Get data profile id stmt : ' || x_stmt);
758: EXECUTE IMMEDIATE x_stmt INTO x_profile_id;

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

757: msd_dem_common_utilities.log_debug ('Get data profile id stmt : ' || x_stmt);
758: EXECUTE IMMEDIATE x_stmt INTO x_profile_id;
759:
760: x_stmt := 'BEGIN '
761: || fnd_profile.value('MSD_DEM_SCHEMA') || '.'
762: || 'API_NOTIFY_APS_INTEGRATION('
763: || x_profile_id
764: ||'); end;';
765: