APPS.MSC_GANTT_UTILS dependencies on DUAL

Line 1435: from dual;*/

1431: 15,to_char(p_trx_id),
1432: 16,to_char(p_trx_id),
1433: 28,to_char(p_trx_id),
1434: p_order_number)
1435: from dual;*/
1436:
1437: l_order_number varchar2(300);
1438: l_temp varchar2(300);
1439: begin

Line 5050: from dual;

5046: end if;
5047:
5048: select msc_form_query_s.nextval
5049: into l_query_id
5050: from dual;
5051: return l_query_id;
5052:
5053: end getMFQSequence;
5054:

Line 5064: from dual;

5060: return p_query_id;
5061: end if;
5062: select msc_gantt_query_s.nextval
5063: into l_query_id
5064: from dual;
5065: return l_query_id;
5066:
5067: end getGanttSequence;
5068:

Line 6074: from dual;

6070: begin
6071: put_line(' insertReqInstFromAlt plan inst trx '|| p_plan_id ||' '|| p_inst_id||' '|| p_simu_res_inst_trx);
6072: select msc_resource_instance_reqs_s.nextval
6073: into l_trx_id
6074: from dual;
6075:
6076: open c_equipment;
6077: fetch c_equipment into l_equip_item_id;
6078: close c_equipment;

Line 6165: from dual;

6161: l_trx_id number;
6162: begin
6163: select msc_resource_instance_reqs_s.nextval
6164: into l_trx_id
6165: from dual;
6166:
6167: insert into msc_resource_requirements(
6168: TRANSACTION_ID, PLAN_ID, SUPPLY_ID, ORGANIZATION_ID, SR_INSTANCE_ID,
6169: ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM, RESOURCE_ID,