APPS.ASG_APPLY dependencies on DBMS_LOB

Line 116: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);

112: ||to_char(p_start_time,'mm-dd-yyyy hh24:mi:ss')
113: ||''',''mm-dd-yyyy hh24:mi:ss'') ';
114: log('Query :'||l_qry,g_stmt_level);
115: l_ctx := dbms_xmlquery.newContext(l_qry);
116: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
117: l_clob := dbms_xmlquery.getXml(l_ctx);
118: log('Raising event oracle.apps.asg.upload.datadeferred',g_stmt_level);
119: select asg_events_s.nextval into l_seq from dual;
120: wf_event.raise(p_event_name=>'oracle.apps.asg.upload.datadeferred',