APPS.ASG_DEFER dependencies on DBMS_XMLQUERY

Line 39: l_ctx dbms_xmlquery.ctxType;

35: p_sequence NUMBER,
36: p_error_msg VARCHAR2)
37: return boolean
38: is
39: l_ctx dbms_xmlquery.ctxType;
40: l_clob clob;
41: l_seq number;
42: l_qry varchar2(2048);
43: begin

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

57: if(asg_helper.check_is_log_enabled(g_stmt_level))
58: then
59: asg_helper.log('Query :'||l_qry,'asg_defer',g_stmt_level);
60: end if;
61: l_ctx := dbms_xmlquery.newContext(l_qry);
62: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
63: l_clob := dbms_xmlquery.getXml(l_ctx);
64: if(asg_helper.check_is_log_enabled(g_stmt_level))
65: then

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

59: asg_helper.log('Query :'||l_qry,'asg_defer',g_stmt_level);
60: end if;
61: l_ctx := dbms_xmlquery.newContext(l_qry);
62: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
63: l_clob := dbms_xmlquery.getXml(l_ctx);
64: if(asg_helper.check_is_log_enabled(g_stmt_level))
65: then
66: asg_helper.log('Raising event oracle.apps.asg.upload.datadeferred',
67: 'asg_defer',g_stmt_level);