APPS.FND_GSM_UTIL dependencies on DBMS_LOB

Line 64: dbms_lob.createtemporary(ctx_file_clob, true, dbms_lob.session);

60: begin
61:
62: -- Create the temp clob if necessary
63: if ctx_file_clob is null then
64: dbms_lob.createtemporary(ctx_file_clob, true, dbms_lob.session);
65: end if;
66:
67: -- Append the buffer to the clob
68: buffer_length := lengthb(buffer);

Line 69: dbms_lob.writeappend (ctx_file_clob, buffer_length, buffer);

65: end if;
66:
67: -- Append the buffer to the clob
68: buffer_length := lengthb(buffer);
69: dbms_lob.writeappend (ctx_file_clob, buffer_length, buffer);
70: retcode := 0;
71:
72: exception
73: when others then

Line 202: -- dbms_lob.freetemporary(ctx_file_clob);

198:
199: /* Parse Context File */
200: my_parser := xmlparser.newParser;
201: xmlparser.parseClob(my_parser, ctx_file_clob);
202: -- dbms_lob.freetemporary(ctx_file_clob);
203: -- ctx_file_clob := null;
204: my_doc := xmlparser.getdocument(my_parser);
205:
206:

Line 225: dbms_lob.freetemporary(ctx_file_clob);

221: my_contextlist := xmldom.getElementsByTagName(my_doc,'oa_context_doc');
222: listlength := xmldom.getLength(my_contextlist);
223: if listlength < 1 then
224: element_name := 'oa_context/oa_context_doc';
225: dbms_lob.freetemporary(ctx_file_clob);
226: ctx_file_clob := null;
227: raise missing_elem;
228: end if;
229: end if;

Line 253: dbms_lob.freetemporary(ctx_file_clob);

249: else
250: my_node := xmldom.item(my_contextlist, 0);
251: my_node := xmldom.getFirstChild(my_node);
252: if xmldom.isNull(my_node) then
253: dbms_lob.freetemporary(ctx_file_clob);
254: ctx_file_clob := null;
255: raise null_context_name;
256: else
257: context_name := ltrim(rtrim(xmldom.getNodeValue(my_node)));

Line 278: dbms_lob.freetemporary(ctx_file_clob);

274: my_nodelist := xmldom.getElementsByTagName(my_doc, 'host');
275: listlength := xmldom.getLength(my_nodelist);
276: if listlength < 1 then
277: element_name := 'host';
278: dbms_lob.freetemporary(ctx_file_clob);
279: ctx_file_clob := null;
280: raise missing_elem;
281: end if;
282: my_node := xmldom.item(my_nodelist, 0);

Line 389: dbms_lob.freetemporary(ctx_file_clob);

385:
386: <>
387:
388: -- clear clob
389: dbms_lob.freetemporary(ctx_file_clob);
390: ctx_file_clob := null;
391: if ( context_name in ('METADATA', 'TEMPLATE')
392: or context_type = 'DATABASE') then
393: -- for metadata we don't need to register service definitions.