6: begin
7: if (p_parent_name IS NOT NULL) then
8: parentId := get_obj_id(p_parent_name);
9: end if;
10: INSERT INTO IES_META_OBJECT_TYPES (type_id, type_name, parent_id, created_by)
11: SELECT ies_meta_object_types_s.nextval, p_obj_name, parentId, 1
12: FROM dual
13: WHERE NOT EXISTS (SELECT 1
14: FROM ies_meta_object_types
7: if (p_parent_name IS NOT NULL) then
8: parentId := get_obj_id(p_parent_name);
9: end if;
10: INSERT INTO IES_META_OBJECT_TYPES (type_id, type_name, parent_id, created_by)
11: SELECT ies_meta_object_types_s.nextval, p_obj_name, parentId, 1
12: FROM dual
13: WHERE NOT EXISTS (SELECT 1
14: FROM ies_meta_object_types
15: WHERE type_name = p_obj_name);
10: INSERT INTO IES_META_OBJECT_TYPES (type_id, type_name, parent_id, created_by)
11: SELECT ies_meta_object_types_s.nextval, p_obj_name, parentId, 1
12: FROM dual
13: WHERE NOT EXISTS (SELECT 1
14: FROM ies_meta_object_types
15: WHERE type_name = p_obj_name);
16: end insert_meta_object_types;
17:
18: Procedure insert_meta_obj_type_props(p_obj_name IN VARCHAR2, p_prop_name IN VARCHAR2) IS
102: objId NUMBER;
103: begin
104: SELECT type_id
105: INTO objId
106: FROM ies_meta_object_types
107: WHERE type_name = p_obj_name;
108:
109: RETURN objId;
110: end get_obj_id;