76:
77: LOOP
78: FETCH obj_prop INTO key, str_value, type_name;
79: EXIT WHEN obj_prop%NOTFOUND;
80: appendXMLClob('
81: END LOOP;
82: CLOSE obj_prop;
83: END convertObjPropertiesToXML;
84:
137: LOOP
138: FETCH obj INTO objectId, objName, objType, uid;
139: EXIT WHEN obj%NOTFOUND;
140:
141: appendXMLClob('
143: appendXMLClob('
144: appendXMLClob('
145: appendXMLClob('
138: FETCH obj INTO objectId, objName, objType, uid;
139: EXIT WHEN obj%NOTFOUND;
140:
141: appendXMLClob('
142: appendXMLClob('
144: appendXMLClob('
145: appendXMLClob('
146: END LOOP;
139: EXIT WHEN obj%NOTFOUND;
140:
141: appendXMLClob('
142: appendXMLClob('
143: appendXMLClob('
144: appendXMLClob('
145: appendXMLClob('
146: END LOOP;
147: CLOSE obj;
140:
141: appendXMLClob('
142: appendXMLClob('
143: appendXMLClob('
144: appendXMLClob('
145: appendXMLClob('
146: END LOOP;
147: CLOSE obj;
148:
141: appendXMLClob('
142: appendXMLClob('
143: appendXMLClob('
144: appendXMLClob('
145: appendXMLClob('
146: END LOOP;
147: CLOSE obj;
148:
149:
150: IF (objectid IS NOT null) THEN
151: convertObjPropertiesToXML(objectId);
152: convertChildObjectsToXML(objectId);
153:
154: appendXMLClob(''|| fnd_global.local_chr(10));
155: appendXMLClob(''|| fnd_global.local_chr(10));
156: ELSE
157: appendXMLClob('
158: END IF;
151: convertObjPropertiesToXML(objectId);
152: convertChildObjectsToXML(objectId);
153:
154: appendXMLClob(''|| fnd_global.local_chr(10));
155: appendXMLClob(''|| fnd_global.local_chr(10));
156: ELSE
157: appendXMLClob('
158: END IF;
159: END convertObjectToXML;
190: FETCH child_obj INTO secObjId, type_name, relId;
191: EXIT WHEN child_obj%NOTFOUND;
192:
193: if (relId = 1) then
194: appendXMLClob('
196: appendXMLClob('
197: end if;
198:
192:
193: if (relId = 1) then
194: appendXMLClob('
195: elsif (relId = 2) then
196: appendXMLClob('
198:
199: appendXMLClob('
200: convertObjectToXML(secObjid);
195: elsif (relId = 2) then
196: appendXMLClob('
197: end if;
198:
199: appendXMLClob('
201: appendXMLClob(''||fnd_global.local_chr(10));
202:
203: if (relId = 1) then
197: end if;
198:
199: appendXMLClob('
200: convertObjectToXML(secObjid);
201: appendXMLClob('
202:
203: if (relId = 1) then
204: appendXMLClob(''|| fnd_global.local_chr(10));
205: elsif (relId = 2) then
200: convertObjectToXML(secObjid);
201: appendXMLClob(''||fnd_global.local_chr(10));
202:
203: if (relId = 1) then
204: appendXMLClob(''|| fnd_global.local_chr(10));
205: elsif (relId = 2) then
206: appendXMLClob(''|| fnd_global.local_chr(10));
207: end if;
208:
202:
203: if (relId = 1) then
204: appendXMLClob(''|| fnd_global.local_chr(10));
205: elsif (relId = 2) then
206: appendXMLClob(''|| fnd_global.local_chr(10));
207: end if;
208:
209: END LOOP;
210: CLOSE child_obj;