APPS.MSC_IMPORT_UTIL dependencies on MSC_ITEM_SIMULATION_SETS_S

Line 743: SELECT msc_item_simulation_sets_s.nextval

739: end sim_set;
740:
741: procedure attach_simset_toplan(p_plan_id number, p_simset varchar2) is
742: cursor c_nextval is
743: SELECT msc_item_simulation_sets_s.nextval
744: FROM dual;
745:
746: cursor c_simset_id is
747: select simulation_set_id from msc_item_simulation_sets where simulation_set_name = p_simset;

Line 762: insert into msc_item_simulation_sets(simulation_set_name,simulation_set_id,last_update_date,last_updated_by,last_update_login,created_by,creation_date) values (p_simset,l_simset_id,sysdate,1,1,1,sysdate);

758: open c_nextval;
759: fetch c_nextval into l_simset_id;
760: close c_nextval;
761:
762: insert into msc_item_simulation_sets(simulation_set_name,simulation_set_id,last_update_date,last_updated_by,last_update_login,created_by,creation_date) values (p_simset,l_simset_id,sysdate,1,1,1,sysdate);
763: commit;
764: end if;
765:
766: if sim_set(p_plan_id) is null or sim_set(p_plan_id)<>p_simset then