APPS.FND_SYSTEM_ALERT_INTG_UTIL dependencies on DBMS_XMLQUERY

Line 62: queryCtx DBMS_XMLquery.ctxType;

58: function GET_EXCPETION_DETAILS(p_event_name in varchar2
59: , p_event_key in varchar2
60: , p_parameter_list in wf_parameter_list_t default null) return clob
61: is
62: queryCtx DBMS_XMLquery.ctxType;
63: result CLOB;
64: lSQL VARCHAR2(5000);
65: begin
66: -- set up the query context...!

Line 68: queryCtx := DBMS_XMLQuery.newContext(lSQL);

64: lSQL VARCHAR2(5000);
65: begin
66: -- set up the query context...!
67: lSQL := GET_SQL(p_event_key);
68: queryCtx := DBMS_XMLQuery.newContext(lSQL);
69: DBMS_XMLQuery.setRowTag(queryCtx,'OCCURANCE'); -- sets the row tag name
70: DBMS_XMLQuery.setRowSetTag(queryCtx,'ALERT'); -- sets rowset tag name
71:
72: -- get the result..!

Line 69: DBMS_XMLQuery.setRowTag(queryCtx,'OCCURANCE'); -- sets the row tag name

65: begin
66: -- set up the query context...!
67: lSQL := GET_SQL(p_event_key);
68: queryCtx := DBMS_XMLQuery.newContext(lSQL);
69: DBMS_XMLQuery.setRowTag(queryCtx,'OCCURANCE'); -- sets the row tag name
70: DBMS_XMLQuery.setRowSetTag(queryCtx,'ALERT'); -- sets rowset tag name
71:
72: -- get the result..!
73: result := DBMS_XMLQuery.getXML(queryCtx);

Line 70: DBMS_XMLQuery.setRowSetTag(queryCtx,'ALERT'); -- sets rowset tag name

66: -- set up the query context...!
67: lSQL := GET_SQL(p_event_key);
68: queryCtx := DBMS_XMLQuery.newContext(lSQL);
69: DBMS_XMLQuery.setRowTag(queryCtx,'OCCURANCE'); -- sets the row tag name
70: DBMS_XMLQuery.setRowSetTag(queryCtx,'ALERT'); -- sets rowset tag name
71:
72: -- get the result..!
73: result := DBMS_XMLQuery.getXML(queryCtx);
74: DBMS_XMLQuery.closeContext(queryCtx); -- you must close the query handle..

Line 73: result := DBMS_XMLQuery.getXML(queryCtx);

69: DBMS_XMLQuery.setRowTag(queryCtx,'OCCURANCE'); -- sets the row tag name
70: DBMS_XMLQuery.setRowSetTag(queryCtx,'ALERT'); -- sets rowset tag name
71:
72: -- get the result..!
73: result := DBMS_XMLQuery.getXML(queryCtx);
74: DBMS_XMLQuery.closeContext(queryCtx); -- you must close the query handle..
75:
76: return result;
77: end GET_EXCPETION_DETAILS;

Line 74: DBMS_XMLQuery.closeContext(queryCtx); -- you must close the query handle..

70: DBMS_XMLQuery.setRowSetTag(queryCtx,'ALERT'); -- sets rowset tag name
71:
72: -- get the result..!
73: result := DBMS_XMLQuery.getXML(queryCtx);
74: DBMS_XMLQuery.closeContext(queryCtx); -- you must close the query handle..
75:
76: return result;
77: end GET_EXCPETION_DETAILS;
78: