APPS.IES_SAVE_METADATA dependencies on DUAL

Line 12: FROM dual

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);
16: end insert_meta_object_types;

Line 28: FROM dual

24:
25: INSERT INTO IES_META_OBJ_TYPE_PROPERTIES
26: (typeprop_id, created_by, objtype_id, property_id)
27: SELECT ies_meta_obj_type_properties_s.nextval, 1, objId, propId
28: FROM dual
29: WHERE NOT EXISTS (SELECT 1
30: FROM IES_META_OBJ_TYPE_PROPERTIES
31: WHERE objType_id = objId
32: AND property_id = propId);

Line 43: FROM dual

39:
40: INSERT INTO IES_META_PROPERTY_LOOKUPS
41: (prop_lookup_id, property_id, lookup_key, lookup_value, created_by)
42: SELECT ies_meta_property_lookups_s.nextval, propId, p_prop_key, p_prop_val, 1
43: FROM dual
44: WHERE NOT EXISTS (SELECT 1
45: FROM IES_META_PROPERTY_LOOKUPS
46: WHERE lookup_key = p_prop_key
47: AND lookup_value = p_prop_val

Line 58: FROM dual

54: begin
55: dataTypeId := get_prop_datatype_id(p_datatype);
56: INSERT INTO IES_META_PROPERTIES (property_id, name, datatype_id, created_by)
57: SELECT ies_meta_properties_s.nextval, p_prop_name, datatypeId, 1
58: FROM dual
59: WHERE NOT EXISTS (SELECT 1
60: FROM IES_META_PROPERTIES
61: WHERE name = p_prop_name
62: AND datatype_id = datatypeId);

Line 69: FROM dual

65: Procedure insert_meta_prop_datatypes(p_datatype IN VARCHAR2) IS
66: begin
67: INSERT INTO IES_META_PROP_DATATYPES (type_id, type_name, created_by)
68: SELECT ies_meta_prop_datatypes_s.nextval, p_datatype, 1
69: FROM dual
70: WHERE NOT EXISTS (SELECT 1
71: FROM IES_META_PROP_DATATYPES
72: WHERE type_name = p_datatype);
73: end insert_meta_prop_datatypes;

Line 84: FROM dual

80: Procedure insert_meta_relationship_types(p_type_name IN VARCHAR2, list_relationship IN NUMBER) IS
81: begin
82: INSERT INTO IES_META_RELATIONSHIP_TYPES (type_id, type_name, created_by, list_relationship)
83: SELECT ies_meta_relationship_types_s.nextval, p_type_name, 1 , list_relationship
84: FROM dual
85: WHERE NOT EXISTS (SELECT 1
86: FROM IES_META_RELATIONSHIP_TYPES
87: WHERE type_name = p_type_name);
88: end insert_meta_relationship_types;