APPS.ASG_APPLY dependencies on DBMS_XMLQUERY

Line 107: l_ctx dbms_xmlquery.ctxType;

103:
104: function raise_row_deferred(p_start_time date)
105: return boolean
106: is
107: l_ctx dbms_xmlquery.ctxType;
108: l_clob clob;
109: l_seq number;
110: l_qry varchar2(2048);
111: begin

Line 119: l_ctx := dbms_xmlquery.newContext(l_qry);

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

Line 121: l_clob := dbms_xmlquery.getXml(l_ctx);

117: ||''',''mm-dd-yyyy hh24:mi:ss'') ';
118: log('Query :'||l_qry,g_stmt_level);
119: l_ctx := dbms_xmlquery.newContext(l_qry);
120: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
121: l_clob := dbms_xmlquery.getXml(l_ctx);
122: log('Raising event oracle.apps.asg.upload.datadeferred',g_stmt_level);
123: select asg_events_s.nextval into l_seq from dual;
124: wf_event.raise(p_event_name=>'oracle.apps.asg.upload.datadeferred',
125: p_event_key=>l_seq,p_parameters=>null,