DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on DUAL

Line 1434: from dual;*/

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

Line 5045: from dual;

5041: end if;
5042:
5043: select msc_form_query_s.nextval
5044: into l_query_id
5045: from dual;
5046: return l_query_id;
5047:
5048: end getMFQSequence;
5049:

Line 5059: from dual;

5055: return p_query_id;
5056: end if;
5057: select msc_gantt_query_s.nextval
5058: into l_query_id
5059: from dual;
5060: return l_query_id;
5061:
5062: end getGanttSequence;
5063:

Line 6069: from dual;

6065: begin
6066: put_line(' insertReqInstFromAlt plan inst trx '|| p_plan_id ||' '|| p_inst_id||' '|| p_simu_res_inst_trx);
6067: select msc_resource_instance_reqs_s.nextval
6068: into l_trx_id
6069: from dual;
6070:
6071: open c_equipment;
6072: fetch c_equipment into l_equip_item_id;
6073: close c_equipment;

Line 6160: from dual;

6156: l_trx_id number;
6157: begin
6158: select msc_resource_instance_reqs_s.nextval
6159: into l_trx_id
6160: from dual;
6161:
6162: insert into msc_resource_requirements(
6163: TRANSACTION_ID, PLAN_ID, SUPPLY_ID, ORGANIZATION_ID, SR_INSTANCE_ID,
6164: ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM, RESOURCE_ID,