APPS.ASG_DOWNLOAD dependencies on DBMS_XMLQUERY

Line 53: l_ctx dbms_xmlquery.ctxType;

49: function raise_data_downloaded
50: return boolean
51: is
52: l_qry varchar2(4000);
53: l_ctx dbms_xmlquery.ctxType;
54: l_clob clob;
55: l_ct number;
56: l_seq number;
57: begin

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

86:
87: if(l_ct <> 0 )
88: then
89: log('Query :'||l_qry);
90: l_ctx := dbms_xmlquery.newContext(l_qry);
91: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
92: l_clob := dbms_xmlquery.getXml(l_ctx);
93: log('Finished building clob. Num of records :'||l_ct);
94: log('Raising event oracle.apps.asg.download.datasynched');

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

88: then
89: log('Query :'||l_qry);
90: l_ctx := dbms_xmlquery.newContext(l_qry);
91: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
92: l_clob := dbms_xmlquery.getXml(l_ctx);
93: log('Finished building clob. Num of records :'||l_ct);
94: log('Raising event oracle.apps.asg.download.datasynched');
95: select asg_events_s.nextval into l_seq from dual;
96: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynched',

Line 117: l_ctx dbms_xmlquery.ctxType;

113: return boolean
114: is
115: l_seq number;
116: l_qry varchar2(4000);
117: l_ctx dbms_xmlquery.ctxType;
118: l_clob clob;
119: l_ct number;
120: begin
121: log('Start raise_data_download_confirmed');

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

151:
152: if(l_ct <> 0)
153: then
154: log('Query :'||l_qry);
155: l_ctx := dbms_xmlquery.newContext(l_qry);
156: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
157: l_clob := dbms_xmlquery.getXml(l_ctx);
158: log('Finished building clob. Num of records :'||l_ct);
159: log('Raising event oracle.apps.asg.download.datasynchconfirmed');

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

153: then
154: log('Query :'||l_qry);
155: l_ctx := dbms_xmlquery.newContext(l_qry);
156: dbms_lob.createtemporary(l_clob,true,dbms_lob.session);
157: l_clob := dbms_xmlquery.getXml(l_ctx);
158: log('Finished building clob. Num of records :'||l_ct);
159: log('Raising event oracle.apps.asg.download.datasynchconfirmed');
160: select asg_events_s.nextval into l_seq from dual;
161: wf_event.raise(p_event_name=>'oracle.apps.asg.download.datasynchconfirmed',