[Home] [Help]
376: procedure update_record_to_db(stg_rec_rowid VARCHAR2) is
377:
378: cursor c_get_simset_id(l_simset_name varchar2) is
379: select simulation_set_id
380: from msc_item_simulation_sets
381: where simulation_set_name = l_simset_name;
382:
383: cursor c_get_item_id(l_item_name varchar2,l_org_id number,l_inst_id number) is
384: select distinct inventory_item_id
724: function sim_set(p_plan_id number) return varchar2 is
725:
726: cursor c_sim_set(l_plan_id number) is
727: select simulation_set_name from
728: msc_item_simulation_sets ms,
729: msc_plans mp
730: where mp.plan_id=l_plan_id and ms.simulation_set_id = mp.item_simulation_set_id;
731:
732: l_sim_set varchar2(80);
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;
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;
748:
749: l_count number;
750: l_simset_id number;
751: begin
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