APPS.ASG_DEFER dependencies on DBMS_XMLQUERY

Line 42: l_ctx dbms_xmlquery.ctxType;

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

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

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

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

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