DBA Data[Home] [Help]

APPS.IES_SAVE_METADATA dependencies on IES_META_OBJ_TYPE_PROPERTIES

Line 25: INSERT INTO IES_META_OBJ_TYPE_PROPERTIES

21: begin
22: objId := get_obj_id(p_obj_name);
23: propId := get_prop_id(p_prop_name);
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

Line 27: SELECT ies_meta_obj_type_properties_s.nextval, 1, objId, propId

23: propId := get_prop_id(p_prop_name);
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

Line 30: FROM 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);
33: end insert_meta_obj_type_props;
34: