eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IES_META_DATA_UPDATER dependencies on XMLDOM

Line 13: FUNCTION getPropertiesElement(element IN xmldom.DOMElement) RETURN xmldom.DOMElement IS

9: -- Function : This Function returns the xml element starting after
10: -- 11: -- **********************************************************************
12:
13: FUNCTION getPropertiesElement(element IN xmldom.DOMElement) RETURN xmldom.DOMElement IS
14: nl xmldom.DOMNodeList;
15: len NUMBER;
16: n xmldom.DOMNode;
17: e xmldom.DOMElement;

Line 14: nl xmldom.DOMNodeList;

10: -- 11: -- **********************************************************************
12:
13: FUNCTION getPropertiesElement(element IN xmldom.DOMElement) RETURN xmldom.DOMElement IS
14: nl xmldom.DOMNodeList;
15: len NUMBER;
16: n xmldom.DOMNode;
17: e xmldom.DOMElement;
18: retElement xmldom.DOMElement;

Line 16: n xmldom.DOMNode;

12:
13: FUNCTION getPropertiesElement(element IN xmldom.DOMElement) RETURN xmldom.DOMElement IS
14: nl xmldom.DOMNodeList;
15: len NUMBER;
16: n xmldom.DOMNode;
17: e xmldom.DOMElement;
18: retElement xmldom.DOMElement;
19: BEGIN
20: n := xmldom.getFirstChild(xmldom.makeNode(element));

Line 17: e xmldom.DOMElement;

13: FUNCTION getPropertiesElement(element IN xmldom.DOMElement) RETURN xmldom.DOMElement IS
14: nl xmldom.DOMNodeList;
15: len NUMBER;
16: n xmldom.DOMNode;
17: e xmldom.DOMElement;
18: retElement xmldom.DOMElement;
19: BEGIN
20: n := xmldom.getFirstChild(xmldom.makeNode(element));
21: e := xmldom.makeElement(n);

Line 18: retElement xmldom.DOMElement;

14: nl xmldom.DOMNodeList;
15: len NUMBER;
16: n xmldom.DOMNode;
17: e xmldom.DOMElement;
18: retElement xmldom.DOMElement;
19: BEGIN
20: n := xmldom.getFirstChild(xmldom.makeNode(element));
21: e := xmldom.makeElement(n);
22: if (xmldom.getTagName(e) <> 'Properties') then

Line 20: n := xmldom.getFirstChild(xmldom.makeNode(element));

16: n xmldom.DOMNode;
17: e xmldom.DOMElement;
18: retElement xmldom.DOMElement;
19: BEGIN
20: n := xmldom.getFirstChild(xmldom.makeNode(element));
21: e := xmldom.makeElement(n);
22: if (xmldom.getTagName(e) <> 'Properties') then
23: retElement := getPropertiesElement(e);
24: else

Line 21: e := xmldom.makeElement(n);

17: e xmldom.DOMElement;
18: retElement xmldom.DOMElement;
19: BEGIN
20: n := xmldom.getFirstChild(xmldom.makeNode(element));
21: e := xmldom.makeElement(n);
22: if (xmldom.getTagName(e) <> 'Properties') then
23: retElement := getPropertiesElement(e);
24: else
25: retElement := e;

Line 22: if (xmldom.getTagName(e) <> 'Properties') then

18: retElement xmldom.DOMElement;
19: BEGIN
20: n := xmldom.getFirstChild(xmldom.makeNode(element));
21: e := xmldom.makeElement(n);
22: if (xmldom.getTagName(e) <> 'Properties') then
23: retElement := getPropertiesElement(e);
24: else
25: retElement := e;
26: end if;

Line 38: FUNCTION childExists(element IN xmldom.DOMElement, object_uid IN VARCHAR2, typeName IN VARCHAR2) RETURN BOOLEAN IS

34: -- Function : This Function returns true if an object (child) exists
35: -- in the XML tree for a given object_uid and type
36: -- **********************************************************************
37:
38: FUNCTION childExists(element IN xmldom.DOMElement, object_uid IN VARCHAR2, typeName IN VARCHAR2) RETURN BOOLEAN IS
39: nl xmldom.DOMNodeList;
40: len number;
41: n xmldom.DOMNode;
42: e xmldom.DOMElement;

Line 39: nl xmldom.DOMNodeList;

35: -- in the XML tree for a given object_uid and type
36: -- **********************************************************************
37:
38: FUNCTION childExists(element IN xmldom.DOMElement, object_uid IN VARCHAR2, typeName IN VARCHAR2) RETURN BOOLEAN IS
39: nl xmldom.DOMNodeList;
40: len number;
41: n xmldom.DOMNode;
42: e xmldom.DOMElement;
43: result boolean := false;

Line 41: n xmldom.DOMNode;

37:
38: FUNCTION childExists(element IN xmldom.DOMElement, object_uid IN VARCHAR2, typeName IN VARCHAR2) RETURN BOOLEAN IS
39: nl xmldom.DOMNodeList;
40: len number;
41: n xmldom.DOMNode;
42: e xmldom.DOMElement;
43: result boolean := false;
44: relUID VARCHAR2(256);
45: retTypeName VARCHAR2(256);

Line 42: e xmldom.DOMElement;

38: FUNCTION childExists(element IN xmldom.DOMElement, object_uid IN VARCHAR2, typeName IN VARCHAR2) RETURN BOOLEAN IS
39: nl xmldom.DOMNodeList;
40: len number;
41: n xmldom.DOMNode;
42: e xmldom.DOMElement;
43: result boolean := false;
44: relUID VARCHAR2(256);
45: retTypeName VARCHAR2(256);
46: BEGIN

Line 47: nl := xmldom.getChildNodes(xmldom.makeNode(element));

43: result boolean := false;
44: relUID VARCHAR2(256);
45: retTypeName VARCHAR2(256);
46: BEGIN
47: nl := xmldom.getChildNodes(xmldom.makeNode(element));
48: len := xmldom.getLength(nl);
49:
50: for i in 0..len-1 loop
51: n := xmldom.item(nl, i);

Line 48: len := xmldom.getLength(nl);

44: relUID VARCHAR2(256);
45: retTypeName VARCHAR2(256);
46: BEGIN
47: nl := xmldom.getChildNodes(xmldom.makeNode(element));
48: len := xmldom.getLength(nl);
49:
50: for i in 0..len-1 loop
51: n := xmldom.item(nl, i);
52: e := xmldom.makeElement(n);

Line 51: n := xmldom.item(nl, i);

47: nl := xmldom.getChildNodes(xmldom.makeNode(element));
48: len := xmldom.getLength(nl);
49:
50: for i in 0..len-1 loop
51: n := xmldom.item(nl, i);
52: e := xmldom.makeElement(n);
53:
54: if (xmldom.getTagName(e) = 'Properties') then
55: result := childExists(e, object_uid, typeName);

Line 52: e := xmldom.makeElement(n);

48: len := xmldom.getLength(nl);
49:
50: for i in 0..len-1 loop
51: n := xmldom.item(nl, i);
52: e := xmldom.makeElement(n);
53:
54: if (xmldom.getTagName(e) = 'Properties') then
55: result := childExists(e, object_uid, typeName);
56: end if;

Line 54: if (xmldom.getTagName(e) = 'Properties') then

50: for i in 0..len-1 loop
51: n := xmldom.item(nl, i);
52: e := xmldom.makeElement(n);
53:
54: if (xmldom.getTagName(e) = 'Properties') then
55: result := childExists(e, object_uid, typeName);
56: end if;
57:
58: retTypeName := xmldom.getAttribute(e, 'NAME');

Line 58: retTypeName := xmldom.getAttribute(e, 'NAME');

54: if (xmldom.getTagName(e) = 'Properties') then
55: result := childExists(e, object_uid, typeName);
56: end if;
57:
58: retTypeName := xmldom.getAttribute(e, 'NAME');
59:
60: if (xmldom.getTagName(e) = 'CCTPropertyList' OR xmldom.getTagName(e) = 'CCTPropertyMapList')
61: AND (typeName = retTypeName) then
62: e := getPropertiesElement(e);

Line 60: if (xmldom.getTagName(e) = 'CCTPropertyList' OR xmldom.getTagName(e) = 'CCTPropertyMapList')

56: end if;
57:
58: retTypeName := xmldom.getAttribute(e, 'NAME');
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:

Line 68: elsif (xmldom.getTagName(e) = 'ChildObject') AND (typeName = retTypeName) then

64:
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;

Line 89: PROCEDURE deleteOldRelationships(element IN xmldom.DOMElement, objUID IN VARCHAR2) IS

85: -- childExists function first checks if the record exists,
86: -- if false, it deletes the record.
87: -- **********************************************************************
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,

Line 123: PROCEDURE updatePropertyValues(element IN xmldom.DOMElement, uid IN varchar2) IS

119: -- Type : private
120: -- Function : This procedure updates the meta object prop values
121: -- **********************************************************************
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,

Line 204: PROCEDURE insertNewProperties(element IN xmldom.DOMElement, objUID IN VARCHAR2) IS

200: -- records which already have been inserted.
201: -- **********************************************************************
202:
203:
204: PROCEDURE insertNewProperties(element IN xmldom.DOMElement, objUID IN VARCHAR2) IS
205: type props_type IS REF CURSOR;
206: props props_type;
207:
208: val VARCHAR2(256);

Line 290: FUNCTION updateMetaObject(element IN xmldom.DOMElement) return NUMBER IS

286: -- Function : This function updates the meta object and its properties,
287: -- returns object id.
288: -- **********************************************************************
289:
290: FUNCTION updateMetaObject(element IN xmldom.DOMElement) return NUMBER IS
291: objId NUMBER := -1;
292: objname VARCHAR2(256);
293: uid VARCHAR2(256);
294: objTypeId NUMBER;

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

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