APPS.IES_META_DATA_UPDATER dependencies on IES_META_OBJ_RELATIONSHIPS

Line 93: ies_meta_obj_relationships b,

89: PROCEDURE deleteOldRelationships(element IN xmldom.DOMElement, objUID IN VARCHAR2) IS
90: CURSOR getRelationships IS
91: SELECT b.objrel_id, b.secondary_obj_id, a.object_uid, c.type_name
92: FROM ies_meta_objects a,
93: ies_meta_obj_relationships b,
94: ies_meta_objects p,
95: ies_meta_relationship_types c
96: WHERE p.object_uid = objUID
97: AND a.object_id = b.secondary_obj_id

Line 106: sqlStmt := 'DELETE FROM ies_meta_obj_relationships

102: sqlStmt VARCHAR2(256);
103: BEGIN
104: for i in getRelationships loop
105: if NOT childExists(element, i.object_uid, i.type_name) then
106: sqlStmt := 'DELETE FROM ies_meta_obj_relationships
107: WHERE objrel_id = :objectrel_id';
108: EXECUTE IMMEDIATE sqlStmt USING i.objrel_id;
109: sqlStmt := 'DELETE FROM ies_meta_obj_relationships
110: WHERE primary_obj_id = :objId

Line 109: sqlStmt := 'DELETE FROM ies_meta_obj_relationships

105: if NOT childExists(element, i.object_uid, i.type_name) then
106: sqlStmt := 'DELETE FROM ies_meta_obj_relationships
107: WHERE objrel_id = :objectrel_id';
108: EXECUTE IMMEDIATE sqlStmt USING i.objrel_id;
109: sqlStmt := 'DELETE FROM ies_meta_obj_relationships
110: WHERE primary_obj_id = :objId
111: AND secondary_obj_id = :secObjId';
112: EXECUTE IMMEDIATE sqlStmt USING i.secondary_obj_id, i.secondary_obj_id;
113: end if;