DBA Data[Home] [Help]

APPS.IES_META_DATA_INSERTER dependencies on XMLDOM

Line 48: PROCEDURE insertPropertyValues(element IN xmldom.DOMElement, objId IN NUMBER) IS

44: -- later inserted into ies_meta_object_propvals table
45: -- **********************************************************************
46:
47:
48: PROCEDURE insertPropertyValues(element IN xmldom.DOMElement, objId IN NUMBER) IS
49: type props_type IS REF CURSOR;
50: props props_type;
51:
52: val VARCHAR2(256);

Line 71: START WITH type_name = :typeName)' USING xmldom.getAttribute(element, 'CLASS');

67: WHERE a.property_id = b.property_id
68: AND a.objtype_id IN ( SELECT type_id
69: FROM ies_meta_object_types
70: CONNECT BY PRIOR parent_id = type_id
71: START WITH type_name = :typeName)' USING xmldom.getAttribute(element, 'CLASS');
72:
73: LOOP
74: FETCH props INTO propName, propId;
75: EXIT WHEN props%NOTFOUND;

Line 120: FUNCTION insertMetaObject(element IN xmldom.DOMElement) return NUMBER IS

116: -- Function : This Function inserts meta object and returns the new
117: -- object_id for the inserted object.
118: -- **********************************************************************
119:
120: FUNCTION insertMetaObject(element IN xmldom.DOMElement) return NUMBER IS
121: objId NUMBER := -1;
122: x_name VARCHAR2(256);
123: x_uid VARCHAR2(256);
124: objTypeId NUMBER;

Line 134: objtypeId := IES_META_DATA_UTIL.getObjectTypeId(xmldom.getAttribute(element, 'CLASS'));

130: x_name := 'nullname';
131: end if;
132:
133: x_uid := IES_META_DATA_UTIL.getProperty(element, 'UID');
134: objtypeId := IES_META_DATA_UTIL.getObjectTypeId(xmldom.getAttribute(element, 'CLASS'));
135:
136: sqlStmt := 'INSERT INTO ies_meta_objects (object_id,
137: name,
138: object_uid,