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.MSC_BAL_UTILS dependencies on DUAL

Line 193: from dual;

189: IF PG_DEBUG in ('Y', 'C') THEN
190: msc_sch_wb.atp_debug('MSC_BAL_UTILS.populate_temp_table ' );
191: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
192: into l_time
193: from dual;
194: msc_sch_wb.atp_debug( 'POPULATE_TEMP_TABLE: BEGIN ' || l_time);
195: END IF;
196:
197: open check_oe('PLANNING_PRIORITY');

Line 614: from dual;

610: IF PG_DEBUG in ('Y', 'C') THEN
611: msc_sch_wb.atp_debug('MSC_BAL_UTILS.populate_temp_table ' );
612: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
613: into l_time
614: from dual;
615: msc_sch_wb.atp_debug( 'POPULATE_TEMP_TABLE: END ' || l_time);
616:
617: msc_sch_wb.atp_debug(' Calculate supply/demand profile_value is ' || l_profile_value );
618:

Line 916: from dual;

912: IF PG_DEBUG in ('Y', 'C') THEN
913: msc_sch_wb.atp_debug('MSC_BAL_UTILS.reschedule ' );
914: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
915: into l_time
916: from dual;
917: msc_sch_wb.atp_debug( 'RESCHEDULE: BEGIN ' || l_time);
918: END IF;
919:
920:

Line 934: from dual;

930: IF PG_DEBUG in ('Y', 'C') THEN
931: msc_sch_wb.atp_debug('MSC_BAL_UTILS.reschedule ' );
932: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
933: into l_time
934: from dual;
935: msc_sch_wb.atp_debug( 'RESCHEDULE: b4 undemand_orders ' || l_time);
936: END IF;
937:
938: undemand_orders(p_session_id, x_msg_count, x_msg_data, x_return_status);

Line 944: from dual;

940: IF PG_DEBUG in ('Y', 'C') THEN
941: msc_sch_wb.atp_debug('MSC_BAL_UTILS.reschedule ' );
942: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
943: into l_time
944: from dual;
945: msc_sch_wb.atp_debug( 'RESCHEDULE: after undemand_orders ' || l_time);
946: END IF;
947: update_schedule_qties(p_atp_qty_ordered_temp,
948: l_return_status,

Line 956: from dual;

952: IF PG_DEBUG in ('Y', 'C') THEN
953: msc_sch_wb.atp_debug('MSC_BAL_UTILS.reschedule ' );
954: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
955: into l_time
956: from dual;
957: msc_sch_wb.atp_debug( 'RESCHEDULE: b4 schedule_orders ' || l_time);
958: END IF;
959:
960: schedule_orders(p_session_id, x_msg_count, x_msg_data, x_return_status);

Line 966: from dual;

962: IF PG_DEBUG in ('Y', 'C') THEN
963: msc_sch_wb.atp_debug('MSC_BAL_UTILS.reschedule ' );
964: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
965: into l_time
966: from dual;
967: msc_sch_wb.atp_debug( 'RESCHEDULE: after schedule_orders ' || l_time);
968: END IF;
969: ELSE
970: IF PG_DEBUG in ('Y', 'C') THEN

Line 1074: from dual;

1070: || p_session_id);
1071: msc_sch_wb.atp_debug('MSC_BAL_UTILS.cmt_schedule ' );
1072: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1073: into l_time
1074: from dual;
1075: msc_sch_wb.atp_debug( 'cmt_schedule begin ' || l_time);
1076: END IF;
1077: open records_exist;
1078: fetch records_exist into l_records_exist;

Line 1133: from dual;

1129: IF PG_DEBUG in ('Y', 'C') THEN
1130: msc_sch_wb.atp_debug('MSC_BAL_UTILS.cmt_schedule ' );
1131: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1132: into l_time
1133: from dual;
1134: msc_sch_wb.atp_debug( 'cmt_schedule: after call to atp ' || l_time);
1135: END IF;
1136: IF x_return_status <>'S' THEN
1137: IF PG_DEBUG in ('Y', 'C') THEN

Line 1156: from dual;

1152: IF PG_DEBUG in ('Y', 'C') THEN
1153: msc_sch_wb.atp_debug('MSC_BAL_UTILS.cmt_schedule: calling OE ' );
1154: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1155: into l_time
1156: from dual;
1157: msc_sch_wb.atp_debug( 'cmt_schedule: calling OM BEGIN ' || l_time);
1158: END IF;
1159: msc_bal_utils.call_oe_api(p_session_id ,
1160: x_msg_count ,

Line 1168: from dual;

1164: IF PG_DEBUG in ('Y', 'C') THEN
1165: msc_sch_wb.atp_debug('MSC_BAL_UTILS.cmt_schedule: calling OE ' );
1166: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1167: into l_time
1168: from dual;
1169: msc_sch_wb.atp_debug( 'cmt_schedule: calling OM DONE ' || l_time);
1170: msc_sch_wb.atp_debug( ' cmt_schedule : x_msg_data ' || x_msg_data);
1171: END IF;
1172: IF x_return_status <>'S' THEN -- from call_oe_api

Line 1271: from dual;

1267: x_return_status);
1268: IF PG_DEBUG in ('Y', 'C') THEN
1269: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1270: into l_time
1271: from dual;
1272: msc_sch_wb.atp_debug( ' MSC_BAL_UTILS.schedule_orders atp engine call END ' || l_time);
1273: msc_sch_wb.atp_debug( ' x_return_status ' || x_return_status);
1274: END IF;
1275:

Line 1297: from dual;

1293: ' tcf is used ');
1294:
1295: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1296: into l_time
1297: from dual;
1298: msc_sch_wb.atp_debug( ' MSC_BAL_UTILS.schedule_orders b4 call to populate_mrp_atp_temp_tables ' || l_time);
1299: END IF;
1300: MSC_ATPUI_UTIL.populate_mrp_atp_temp_tables(p_session_id,
1301: l_return_status,

Line 1306: from dual;

1302: l_error_message);
1303: IF PG_DEBUG in ('Y', 'C') THEN
1304: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1305: into l_time
1306: from dual;
1307: msc_sch_wb.atp_debug( ' MSC_BAL_UTILS.schedule_orders after call to populate_mrp_atp_temp_tables ' || l_time);
1308: END IF;
1309:
1310: IF l_return_status <> 'S' THEN

Line 1323: from dual;

1319:
1320: IF PG_DEBUG in ('Y', 'C') THEN
1321: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1322: into l_time
1323: from dual;
1324: msc_sch_wb.atp_debug( ' MSC_BAL_UTILS.schedule_orders b4 call to calc_exceptions ' || l_time);
1325: END IF;
1326: msc_sch_wb.calc_exceptions(p_session_id,
1327: x_return_status,

Line 1337: from dual;

1333:
1334: IF PG_DEBUG in ('Y', 'C') THEN
1335: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
1336: into l_time
1337: from dual;
1338: msc_sch_wb.atp_debug( ' MSC_BAL_UTILS.schedule_orders after call to calc_exceptions ' || l_time);
1339: END IF;
1340:
1341: IF x_return_status <> 'S' THEN

Line 1540: FROM dual;

1536: END;
1537:
1538: SELECT oe_msg_request_id_s.nextval
1539: INTO l_request_id
1540: FROM dual;
1541:
1542: OE_SCHEDULE_GRP.Update_Scheduling_Results(
1543: p_so_table,
1544: l_request_id,