APPS.ECX_OUT_WF_QH dependencies on DBMS_LOB

Line 281: if dbms_lob.istemporary(l_out_clob) = 1 then

277: -- assign the encrpyted clob back to x_ecxmsg so it will insert the
278: -- encrpyted clob to ecx_doclogs later.
279: x_ecxmsg.payload := l_in_clob;
280:
281: if dbms_lob.istemporary(l_out_clob) = 1 then
282: dbms_lob.freetemporary(l_out_clob);
283: end if;
284:
285: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 282: dbms_lob.freetemporary(l_out_clob);

278: -- encrpyted clob to ecx_doclogs later.
279: x_ecxmsg.payload := l_in_clob;
280:
281: if dbms_lob.istemporary(l_out_clob) = 1 then
282: dbms_lob.freetemporary(l_out_clob);
283: end if;
284:
285: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
286: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 291: if dbms_lob.istemporary(l_out_clob) = 1 then

287: 'Enqueued Message: ' || x_msgid);
288: end if;
289: exception
290: when queue_handler_exit then
291: if dbms_lob.istemporary(l_out_clob) = 1 then
292: dbms_lob.freetemporary(l_out_clob);
293: end if;
294: raise queue_handler_exit;
295:

Line 292: dbms_lob.freetemporary(l_out_clob);

288: end if;
289: exception
290: when queue_handler_exit then
291: if dbms_lob.istemporary(l_out_clob) = 1 then
292: dbms_lob.freetemporary(l_out_clob);
293: end if;
294: raise queue_handler_exit;
295:
296: when others then

Line 297: if dbms_lob.istemporary(l_out_clob) = 1 then

293: end if;
294: raise queue_handler_exit;
295:
296: when others then
297: if dbms_lob.istemporary(l_out_clob) = 1 then
298: dbms_lob.freetemporary(l_out_clob);
299: end if;
300: ecx_out_wf_qh.retmsg := SQLERRM;
301: ecx_out_wf_qh.retcode := 2;

Line 298: dbms_lob.freetemporary(l_out_clob);

294: raise queue_handler_exit;
295:
296: when others then
297: if dbms_lob.istemporary(l_out_clob) = 1 then
298: dbms_lob.freetemporary(l_out_clob);
299: end if;
300: ecx_out_wf_qh.retmsg := SQLERRM;
301: ecx_out_wf_qh.retcode := 2;
302: raise queue_handler_exit;