59:
60: if (xmldom.getTagName(e) = 'CCTPropertyList' OR xmldom.getTagName(e) = 'CCTPropertyMapList')
61: AND (typeName = retTypeName) then
62: e := getPropertiesElement(e);
63: relUID := IES_META_DATA_UTIL.getProperty(e, 'UID');
64:
65: if (relUID IS NOT NULL AND relUID = object_uid) then
66: result := true;
67: end if;
65: if (relUID IS NOT NULL AND relUID = object_uid) then
66: result := true;
67: end if;
68: elsif (xmldom.getTagName(e) = 'ChildObject') AND (typeName = retTypeName) then
69: relUID := IES_META_DATA_UTIL.getProperty(e, 'UID');
70:
71: if (relUID IS NOT NULL AND relUID = object_uid) then
72: result := true;
73: end if;
137: lookupId NUMBER;
138: sqlStmt VARCHAR2(256);
139: BEGIN
140: for i in getPropertiesForObject loop
141: val := IES_META_DATA_UTIL.getProperty(element, i.name);
142:
143: lookupId := IES_META_DATA_UTIL.getLookupId(i.property_id, val);
144: if (lookupId = -1) then
145: sqlStmt := 'UPDATE ies_meta_property_values
139: BEGIN
140: for i in getPropertiesForObject loop
141: val := IES_META_DATA_UTIL.getProperty(element, i.name);
142:
143: lookupId := IES_META_DATA_UTIL.getLookupId(i.property_id, val);
144: if (lookupId = -1) then
145: sqlStmt := 'UPDATE ies_meta_property_values
146: SET string_val = :value,
147: last_update_date = sysdate
240: LOOP
241: FETCH props INTO propName, propId;
242: EXIT WHEN props%NOTFOUND;
243:
244: val := IES_META_DATA_UTIL.getProperty(element, propName);
245:
246: lookupId := IES_META_DATA_UTIL.getLookupId(propId, val);
247: select ies_meta_property_values_s.nextval into propValue_id from dual;
248:
242: EXIT WHEN props%NOTFOUND;
243:
244: val := IES_META_DATA_UTIL.getProperty(element, propName);
245:
246: lookupId := IES_META_DATA_UTIL.getLookupId(propId, val);
247: select ies_meta_property_values_s.nextval into propValue_id from dual;
248:
249: if (lookupId = -1) then
250: sqlStmt := 'INSERT INTO ies_meta_property_values (propval_id,
292: objname VARCHAR2(256);
293: uid VARCHAR2(256);
294: objTypeId NUMBER;
295: BEGIN
296: objname := IES_META_DATA_UTIL.getProperty(element, 'name');
297:
298: if (objname is null) then
299: objname := 'nullname';
300: end if;
298: if (objname is null) then
299: objname := 'nullname';
300: end if;
301:
302: uid := IES_META_DATA_UTIL.getProperty(element, 'UID');
303: objtypeId := IES_META_DATA_UTIL.getObjectTypeId(xmldom.getAttribute(element, 'CLASS'));
304: objId := to_number(IES_META_DATA_UTIL.getProperty(element, 'objectId'));
305:
306:
299: objname := 'nullname';
300: end if;
301:
302: uid := IES_META_DATA_UTIL.getProperty(element, 'UID');
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
300: end if;
301:
302: uid := IES_META_DATA_UTIL.getProperty(element, 'UID');
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,