DBA Data[Home] [Help]

APPS.IES_SAVE_METADATA dependencies on IES_META_OBJECT_TYPES

Line 10: INSERT INTO IES_META_OBJECT_TYPES (type_id, type_name, parent_id, created_by)

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

Line 11: SELECT ies_meta_object_types_s.nextval, p_obj_name, parentId, 1

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);

Line 14: FROM ies_meta_object_types

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

Line 106: FROM ies_meta_object_types

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;