eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_DEM_SOP dependencies on FND_PROFILE

Line 488: x_key_values := x_key_values || 'C_SIM_SET_ID#' || nvl(fnd_profile.value('MSD_DEM_SIMULATION_SET_NAME'), -1) || '$' ;

484: else
485: x_key_values := x_key_values || 'C_ORG_FILTER# = ' || p_filter_org_id || ' $';
486: end if;
487:
488: x_key_values := x_key_values || 'C_SIM_SET_ID#' || nvl(fnd_profile.value('MSD_DEM_SIMULATION_SET_NAME'), -1) || '$' ;
489:
490: /* Get the query */
491: msd_dem_query_utilities.get_query3 (
492: x_retcode,

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

610: CLOSE c_plan_start_date;
611:
612:
613:
614: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
615:
616: if (g_schema is not null)
617: then
618:

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

755: || ' WHERE ';
756:
757:
758:
759: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 1)
760: THEN
761: x_sql := x_sql || ' NOT EXISTS '
762: || ' (SELECT 1 from '
763: || g_schema || '.t_ep_item tei, '

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

1024: close c_dem_sched;
1025:
1026: x_dem_sched := substr(x_dem_sched, 2, 200);
1027:
1028: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1029: IF (g_schema IS NULL)
1030: THEN
1031: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
1032: END IF;

Line 1279: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans');

1275: if l_plan_name is not null then
1276:
1277: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1278:
1279: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans');
1280:
1281: execute immediate l_stmt;
1282:
1283: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);

Line 1285: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans_pop');

1281: execute immediate l_stmt;
1282:
1283: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1284:
1285: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans_pop');
1286:
1287: execute immediate l_stmt;
1288:
1289: -- bug 14693176 kkhatri

Line 1319: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1315: if l_stmt is null then
1316: return;
1317: end if;
1318:
1319: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1320:
1321: -- BUG#9211268 syenamar
1322: --Enable download of RP plans into demantra (7.3 only)
1323: IF (l_plan_type in (101, 102, 103, 105)) THEN

Line 1340: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1336: if l_stmt is null then
1337: return;
1338: end if;
1339:
1340: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1341:
1342: execute immediate l_stmt using l_plan_name, l_start_date, l_end_date, p_plan_id, p_plan_id, p_plan_id, p_plan_id, p_plan_id, p_plan_id;
1343: end if;
1344:

Line 1358: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1354: if l_stmt is null then
1355: return;
1356: end if;
1357:
1358: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1359:
1360: execute immediate l_stmt using l_plan_name, l_plan_name, 'SNO', 2, l_start_date, l_end_date, p_plan_id, substr(x_dem_sched,1,200);
1361:
1362: if p_populate = 1 then

Line 1370: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1366: if l_stmt is null then
1367: return;
1368: end if;
1369:
1370: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1371:
1372: execute immediate l_stmt using l_plan_name, l_start_date, l_end_date, p_plan_id, p_plan_id;
1373:
1374: end if;

Line 1428: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1424: end if;
1425:
1426: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1427: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1428: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1429:
1430: execute immediate l_stmt;
1431:
1432: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_EBS', l_instance_id);

Line 1441: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1437:
1438: l_stmt := replace(l_stmt, 'C_RESOURCE_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1439: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1440: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1441: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1442:
1443: execute immediate l_stmt;
1444:
1445: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_EBS', l_instance_id);

Line 1451: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1447: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1448: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1449: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1450: l_stmt := replace(l_stmt, 'C_PLAN_END_DATE', 'to_date(''' || to_char(l_end_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1451: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1452:
1453: execute immediate l_stmt;
1454:
1455: end if;

Line 1470: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1466: end if;
1467:
1468: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1469: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1470: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1471:
1472: execute immediate l_stmt;
1473:
1474: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_SNO', l_instance_id);

Line 1482: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1478: end if;
1479:
1480: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1481: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1482: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1483:
1484: execute immediate l_stmt;
1485:
1486: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_SNO', l_instance_id);

Line 1494: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));

1490: end if;
1491:
1492: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1493: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1494: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1495: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1496: l_stmt := replace(l_stmt, 'C_PLAN_END_DATE', 'to_date(''' || to_char(l_end_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1497:
1498: execute immediate l_stmt;

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

2428: /* Alter session to APPS */
2429: x_small_sql := 'alter session set current_schema = APPS';
2430: EXECUTE IMMEDIATE x_small_sql;
2431:
2432: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2433: IF (g_schema IS NULL)
2434: THEN
2435: log_message ('Error: msd_dem_sop.set_plan_attributes - Unable to find schema name');
2436: END IF;

Line 2518: /*g_schema := fnd_profile.value('MSD_DEM_SCHEMA');

2514: /* Alter session to APPS */
2515: x_small_sql := 'alter session set current_schema = APPS';
2516: EXECUTE IMMEDIATE x_small_sql;
2517:
2518: /*g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2519: IF (g_schema IS NULL)
2520: THEN
2521: x_errbuf := 'Error(1): msd_dem_sop.load_plan_data - Unable to find schema name';
2522: EXECUTE IMMEDIATE x_small_sql;

Line 2563: if ( nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 1 ) then

2559: EXECUTE IMMEDIATE x_small_sql;
2560: raise_application_error(-20004, x_errbuf);
2561: END IF;
2562:
2563: if ( nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 1 ) then
2564: --truncate wo staging tables
2565: truncate_wo_staging_tables(
2566: x_errbuf,
2567: x_retcode);

Line 2576: IF (nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 1) THEN -- profile set to YES

2572: END IF;
2573: end if;
2574:
2575: -- bug#12546892
2576: IF (nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 1) THEN -- profile set to YES
2577:
2578: log_message ('INFO: Setting "No load" option and "No Purge" option for series under "other plan data" dp.' );
2579:
2580: -- set to "No load" option and "No Purge" option for the series in the data profile

Line 2588: ELSIF (nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 2) THEN -- profile set to NO

2584: msd_dem_common_utilities.set_series_options(x_errbuf,x_retcode,g_schema,x_opd_dp,x_series_04,2,0);
2585: msd_dem_common_utilities.set_series_options(x_errbuf,x_retcode,g_schema,x_opd_dp,x_series_05,2,0);
2586: msd_dem_common_utilities.set_series_options(x_errbuf,x_retcode,g_schema,x_opd_dp,x_series_06,2,0,1);
2587:
2588: ELSIF (nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 2) THEN -- profile set to NO
2589:
2590: log_message ('INFO: Setting "OVERRIDE" option and "No Purge" option for series under "other plan data" dp.' );
2591:
2592: -- set to "OVERRIDE" option and "No Purge" option for the series in the data profile

Line 2616: if ( (x_plan_type = 0 or x_plan_type = 2) and nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 1 ) then

2612: raise_application_error(-20006, x_errbuf);
2613: END IF;
2614:
2615: -- for ASCP or RP plan, load data with workorder attributes if the profile 'MSD_DEM: Enable Supply Plan Download for work orders' is set
2616: if ( (x_plan_type = 0 or x_plan_type = 2) and nvl(fnd_profile.value('MSD_DEM_ENABLE_SUPPLY_PLAN_WO'), 2) = 1 ) then
2617: -- call procedure to load data with WO attributes
2618: load_plan_data_wo(x_errbuf, x_retcode, x_plan_id,p_use_jobs,p_split_batch_by_org,p_job_check_interval,p_jobs_timeout);
2619:
2620: if (p_delete_dc_site_sc_pop = 1) then

Line 2743: /*g_schema := fnd_profile.value('MSD_DEM_SCHEMA');

2739: /* Alter session to APPS */
2740: x_small_sql := 'alter session set current_schema = APPS';
2741: EXECUTE IMMEDIATE x_small_sql;
2742:
2743: /*g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2744: IF (g_schema IS NULL)
2745: THEN
2746: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
2747: END IF;*/

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

2811: /* Alter session to APPS */
2812: x_small_sql := 'alter session set current_schema = APPS';
2813: EXECUTE IMMEDIATE x_small_sql;
2814:
2815: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2816: IF (g_schema IS NULL)
2817: THEN
2818: log_message ('Error(1): msd_dem_sop.load_item_cost - Unable to find schema name');
2819: END IF;

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

2898: g_schema varchar2(30) := null;
2899: BEGIN
2900: -- syenamar
2901: -- this code will be executed with definer(apps) rights due to 'AUTHID DEFINER' clause in package spec, so need to specify demantra schema for demantra tables
2902: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2903: IF (g_schema IS NULL)
2904: THEN
2905: log_message ('Error: msd_dem_sop.set_plan_attributes - Unable to find schema name');
2906: END IF;

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

2998: FETCH c_get_dm_schema INTO g_schema;
2999: CLOSE c_get_dm_schema;
3000:
3001: if (g_schema is not null) then
3002: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3003: end if;
3004:
3005: if (g_schema is not null)
3006: then

Line 3381: x_dest_table := fnd_profile.value('MSD_DEM_SCHEMA')||'.BIIO_SCI_BACKLOG ';

3377:
3378: /* Demantra is Installed */
3379: IF (x_dem_schema IS NOT NULL)
3380: THEN
3381: x_dest_table := fnd_profile.value('MSD_DEM_SCHEMA')||'.BIIO_SCI_BACKLOG ';
3382: END IF;
3383:
3384: -- bug#7419035, syenamar
3385: -- update level3(customer), replace customer name with the unique partner_id from ASCP

Line 3552: var_schema := fnd_profile.value('MSD_DEM_SCHEMA');

3548: BEGIN
3549:
3550: msd_dem_common_utilities.log_debug ('Entering: msd_dem_sop.load_cost - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
3551:
3552: var_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3553: IF (var_schema IS NULL) THEN
3554: retcode:= -1;
3555: msd_dem_common_utilities.log_message ('Error(1): msd_dem_sop.load_cost - Unable to find schema name');
3556: RETURN;

Line 3575: var_sim_set_id := fnd_profile.value('MSD_DEM_SIMULATION_SET_NAME');

3571: /* Get master organization */
3572: x_master_org := to_number(msd_dem_common_utilities.get_parameter_value(p_sr_instance_id, 'MSD_DEM_MASTER_ORG'));
3573: msd_dem_common_utilities.log_debug ('Source Master Organization from which list price is collected - ' || to_char(x_master_org));
3574:
3575: var_sim_set_id := fnd_profile.value('MSD_DEM_SIMULATION_SET_NAME');
3576: IF (var_sim_set_id IS NULL) THEN
3577: var_sim_set_id := nvl(var_sim_set_id,-999);
3578: retcode:= 1;
3579: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_sop.load_cost - Unable to find simulation set name name. Repair Cost will not be loaded.');