APPS.IES_META_DATA_UPDATER dependencies on IES_META_OBJECTS

Line 92: FROM ies_meta_objects a,

88:
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

Line 94: ies_meta_objects p,

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
98: AND p.object_id = b.primary_obj_id

Line 126: FROM ies_meta_objects o,

122:
123: PROCEDURE updatePropertyValues(element IN xmldom.DOMElement, uid IN varchar2) IS
124: CURSOR getPropertiesForObject IS
125: SELECT b.name, c.propval_id , b.property_id
126: FROM ies_meta_objects o,
127: ies_meta_object_propvals a,
128: ies_meta_properties b,
129: ies_meta_property_values c
130: WHERE o.object_uid = uid

Line 187: 1 from ies_meta_objects where object_uid = :objuid';

183: propval_id,
184: created_by) SELECT :seq,
185: object_id,
186: :propValId,
187: 1 from ies_meta_objects where object_uid = :objuid';
188:
189: execute immediate sqlStmt using seqval, propValId, objUID;
190: end loop;
191: END insertObjPropertyValues;

Line 228: FROM ies_meta_objects

224: AND a.objtype_id IN (SELECT type_id
225: FROM ies_meta_object_types
226: CONNECT BY PRIOR parent_id = type_id
227: START WITH type_id IN (SELECT type_id
228: FROM ies_meta_objects
229: WHERE object_uid = :aUID))
230: AND b.property_id NOT IN (SELECT b.property_id
231: FROM ies_meta_objects o,
232: ies_meta_object_propvals a,

Line 231: FROM ies_meta_objects o,

227: START WITH type_id IN (SELECT type_id
228: FROM ies_meta_objects
229: WHERE object_uid = :aUID))
230: AND b.property_id NOT IN (SELECT b.property_id
231: FROM ies_meta_objects o,
232: ies_meta_object_propvals a,
233: ies_meta_properties b,
234: ies_meta_property_values c
235: WHERE o.object_uid = :bUID

Line 307: execute immediate' UPDATE ies_meta_objects

303: objtypeId := IES_META_DATA_UTIL.getObjectTypeId(xmldom.getAttribute(element, 'CLASS'));
304: objId := to_number(IES_META_DATA_UTIL.getProperty(element, 'objectId'));
305:
306:
307: execute immediate' UPDATE ies_meta_objects
308: SET name = :1,
309: last_update_date = :2,
310: type_id = :3
311: WHERE object_uid = :4 returning object_id INTO :5' using objname, sysdate, objTypeId, uid returning INTO objId;