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 462: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');

458: CLOSE c_plan_start_date;
459:
460:
461:
462: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
463:
464: if (g_schema is not null)
465: then
466:

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

826: close c_dem_sched;
827:
828: x_dem_sched := substr(x_dem_sched, 2, 200);
829:
830: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
831: IF (g_schema IS NULL)
832: THEN
833: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
834: END IF;

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

1050: if l_plan_name is not null then
1051:
1052: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1053:
1054: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans');
1055:
1056: execute immediate l_stmt;
1057:
1058: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);

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

1056: execute immediate l_stmt;
1057:
1058: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_DELETE_STMT', l_instance_id);
1059:
1060: l_stmt := replace(l_stmt, 'C_TABLE_NAME', fnd_profile.value('MSD_DEM_SCHEMA') || '.biio_supply_plans_pop');
1061:
1062: execute immediate l_stmt;
1063:
1064: l_stmt := 'select input_name from msc_plan_sched_v where plan_id= ' ||p_plan_id ;

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

1088: if l_stmt is null then
1089: return;
1090: end if;
1091:
1092: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1093:
1094: execute immediate l_stmt using l_plan_name, l_plan_name, 'ASCP', 2, l_start_date, l_end_date, p_plan_id, substr(x_dem_sched,1,200);
1095:
1096: if p_populate = 1 then

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

1100: if l_stmt is null then
1101: return;
1102: end if;
1103:
1104: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1105:
1106: 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;
1107: end if;
1108:

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

1118: if l_stmt is null then
1119: return;
1120: end if;
1121:
1122: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1123:
1124: 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);
1125:
1126: if p_populate = 1 then

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

1130: if l_stmt is null then
1131: return;
1132: end if;
1133:
1134: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1135:
1136: execute immediate l_stmt using l_plan_name, l_start_date, l_end_date, p_plan_id, p_plan_id;
1137:
1138: end if;

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

1188: end if;
1189:
1190: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1191: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1192: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1193:
1194: execute immediate l_stmt;
1195:
1196: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_EBS', l_instance_id);

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

1201:
1202: l_stmt := replace(l_stmt, 'C_RESOURCE_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1203: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1204: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1205: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1206:
1207: execute immediate l_stmt;
1208:
1209: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_EBS', l_instance_id);

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

1211: l_stmt := replace(l_stmt, 'C_PLAN_NAME', '''' || l_plan_name || '''');
1212: l_stmt := replace(l_stmt, 'C_PLAN_ID', p_plan_id);
1213: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1214: l_stmt := replace(l_stmt, 'C_PLAN_END_DATE', 'to_date(''' || to_char(l_end_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1215: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1216:
1217: execute immediate l_stmt;
1218:
1219: end if;

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

1230: end if;
1231:
1232: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1233: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1234: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1235:
1236: execute immediate l_stmt;
1237:
1238: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCES_SNO', l_instance_id);

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

1242: end if;
1243:
1244: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1245: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1246: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1247:
1248: execute immediate l_stmt;
1249:
1250: msd_dem_query_utilities.get_query(l_retcode, l_stmt, 'MSD_DEM_RESOURCE_POP_SNO', l_instance_id);

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

1254: end if;
1255:
1256: l_stmt := replace(l_stmt, 'C_TARGET_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCES'));
1257: l_stmt := replace(l_stmt, 'C_SRC_TABLE', msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'BIIO_RESOURCE_CAPACITY'));
1258: l_stmt := replace(l_stmt, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
1259: l_stmt := replace(l_stmt, 'C_PLAN_START_DATE', 'to_date(''' || to_char(l_start_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1260: l_stmt := replace(l_stmt, 'C_PLAN_END_DATE', 'to_date(''' || to_char(l_end_date, 'dd-mm-yyyy') || ''',''dd-mm-yyyy'')');
1261:
1262: execute immediate l_stmt;

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

1351: /* Alter session to APPS */
1352: x_small_sql := 'alter session set current_schema = APPS';
1353: EXECUTE IMMEDIATE x_small_sql;
1354:
1355: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1356: IF (g_schema IS NULL)
1357: THEN
1358: log_message ('Error: msd_dem_sop.set_plan_attributes - Unable to find schema name');
1359: END IF;

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

1398: /* Alter session to APPS */
1399: x_small_sql := 'alter session set current_schema = APPS';
1400: EXECUTE IMMEDIATE x_small_sql;
1401:
1402: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1403: IF (g_schema IS NULL)
1404: THEN
1405: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
1406: RETURN;

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

1541: /* Alter session to APPS */
1542: x_small_sql := 'alter session set current_schema = APPS';
1543: EXECUTE IMMEDIATE x_small_sql;
1544:
1545: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1546: IF (g_schema IS NULL)
1547: THEN
1548: log_message ('Error(1): msd_dem_sop.load_plan_data - Unable to find schema name');
1549: END IF;

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

1613: /* Alter session to APPS */
1614: x_small_sql := 'alter session set current_schema = APPS';
1615: EXECUTE IMMEDIATE x_small_sql;
1616:
1617: g_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1618: IF (g_schema IS NULL)
1619: THEN
1620: log_message ('Error(1): msd_dem_sop.load_item_cost - Unable to find schema name');
1621: END IF;

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

1954:
1955: /* Demantra is Installed */
1956: IF (x_dem_schema IS NOT NULL)
1957: THEN
1958: x_dest_table := fnd_profile.value('MSD_DEM_SCHEMA')||'.BIIO_SCI_BACKLOG ';
1959: END IF;
1960:
1961: l_sql_stmnt := ' update '||x_dest_table||' bsb '
1962: ||' set level3 = ( select mtp.partner_name '