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: if buffer IS NULL then

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

70: return;
71: else
72: buffer_length := length(buffer);
73: if (buffer_length > 0) then
74: dbms_lob.writeappend (ctx_file_clob, buffer_length, buffer);
75: retcode := 0;
76: return;
77: else
78: retcode := 0;

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

212:
213: /* Parse Context File */
214: my_parser := xmlparser.newParser;
215: xmlparser.parseClob(my_parser, ctx_file_clob);
216: -- dbms_lob.freetemporary(ctx_file_clob);
217: -- ctx_file_clob := null;
218: my_doc := xmlparser.getdocument(my_parser);
219:
220:

Line 239: dbms_lob.freetemporary(ctx_file_clob);

235: my_contextlist := xmldom.getElementsByTagName(my_doc,'oa_context_doc');
236: listlength := xmldom.getLength(my_contextlist);
237: if listlength < 1 then
238: element_name := 'oa_context/oa_context_doc';
239: dbms_lob.freetemporary(ctx_file_clob);
240: ctx_file_clob := null;
241: raise missing_elem;
242: end if;
243: end if;

Line 267: dbms_lob.freetemporary(ctx_file_clob);

263: else
264: my_node := xmldom.item(my_contextlist, 0);
265: my_node := xmldom.getFirstChild(my_node);
266: if xmldom.isNull(my_node) then
267: dbms_lob.freetemporary(ctx_file_clob);
268: ctx_file_clob := null;
269: raise null_context_name;
270: else
271: context_name := ltrim(rtrim(xmldom.getNodeValue(my_node)));

Line 292: dbms_lob.freetemporary(ctx_file_clob);

288: my_nodelist := xmldom.getElementsByTagName(my_doc, 'host');
289: listlength := xmldom.getLength(my_nodelist);
290: if listlength < 1 then
291: element_name := 'host';
292: dbms_lob.freetemporary(ctx_file_clob);
293: ctx_file_clob := null;
294: raise missing_elem;
295: end if;
296: my_node := xmldom.item(my_nodelist, 0);

Line 403: dbms_lob.freetemporary(ctx_file_clob);

399:
400: <>
401:
402: -- clear clob
403: dbms_lob.freetemporary(ctx_file_clob);
404: ctx_file_clob := null;
405: if ( context_name in ('METADATA', 'TEMPLATE')
406: or context_type = 'DATABASE') then
407: -- for metadata we don't need to register service definitions.