APPS.MSC_UPDATE_RESOURCE dependencies on DUAL

Line 340: from dual;

336: begin
337:
338: select msc_undo_summary_s.nextval
339: into v_undo_id
340: from dual;
341:
342: if undo_type = 2 then -- update
343:
344: i := 1;

Line 411: from dual;

407: x_msg_data varchar2(200);
408: begin
409: select msc_undo_summary_s.nextval
410: into v_undo_id
411: from dual;
412:
413: if undo_type = 2 then -- update
414:
415: i := 1;

Line 948: from dual;

944: v_trx_id NUMBER;
945: BEGIN
946: select msc_net_res_inst_avail_s.nextval
947: into v_trx_id
948: from dual;
949: return v_trx_id;
950: END;
951: ------------------------------------------------------------------------
952: --to update msc_net_resource_avail table

Line 1230: from dual;

1226: v_transaction_id NUMBER;
1227: BEGIN
1228: select msc_net_resource_avail_s.nextval
1229: into v_transaction_id
1230: from dual;
1231:
1232: return v_transaction_id;
1233: END;
1234:

Line 1557: from dual;

1553: -- if nvl(v_new_capacity_units,0) <>0 then
1554:
1555: select msc_net_resource_avail_s.nextval
1556: into v_transaction_id
1557: from dual;
1558:
1559: -- insert parent record
1560:
1561: insert into msc_net_resource_avail