APPS.MSD_DEM_COLLECT_HISTORY_DATA dependencies on FND_PROFILE

Line 1446: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');

1442: /*
1443: *Order Realignment
1444: */
1445: Begin
1446: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1447:
1448: if (g_schema is not null)
1449: then
1450:

Line 1636: DEM_SCHEMA := fnd_profile.value('MSD_DEM_SCHEMA');

1632:
1633: BEGIN
1634: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_history_data.run_load - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1635:
1636: DEM_SCHEMA := fnd_profile.value('MSD_DEM_SCHEMA');
1637:
1638: IF (p_auto_run_download = G_YES)
1639: THEN
1640: if fnd_profile.value('MSD_DEM_SCHEMA') is not null then

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

1636: DEM_SCHEMA := fnd_profile.value('MSD_DEM_SCHEMA');
1637:
1638: IF (p_auto_run_download = G_YES)
1639: THEN
1640: if fnd_profile.value('MSD_DEM_SCHEMA') is not null then
1641:
1642:
1643:
1644: /*

Line 1706: l_url := fnd_profile.value('MSD_DEM_HOST_URL');

1702:
1703:
1704: if l_user_name is not null
1705: then
1706: l_url := fnd_profile.value('MSD_DEM_HOST_URL');
1707:
1708: l_sql := 'SELECT
1709: utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema=EBS%20Full%20Download&sync=no'') FROM dual';
1710: execute immediate l_sql into l_dummy;