APPS.CSM_HA_EVENT_PKG dependencies on DBMS_XMLGEN

Line 19: qrycontext DBMS_XMLGEN.ctxHandle;

15: )
16: AS
17: l_QUERY_TEXT1 VARCHAR2(4000);
18: l_xml CLOB;
19: qrycontext DBMS_XMLGEN.ctxHandle;
20:
21: BEGIN
22: CSM_UTIL_PKG.LOG
23: ( 'Entering GET_XML_PAYLOAD for TAble Name : ' || p_TABLE_NAME ,

Line 41: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;

37: END IF;
38: END LOOP;
39:
40: --Execute the SQL query
41: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
42:
43: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
44: l_xml := DBMS_XMLGEN.getxml (qrycontext);
45: dbms_xmlgen.closeContext(qrycontext);

Line 43: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);

39:
40: --Execute the SQL query
41: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
42:
43: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
44: l_xml := DBMS_XMLGEN.getxml (qrycontext);
45: dbms_xmlgen.closeContext(qrycontext);
46: x_XML_PAYLOAD := l_xml;
47:

Line 44: l_xml := DBMS_XMLGEN.getxml (qrycontext);

40: --Execute the SQL query
41: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
42:
43: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
44: l_xml := DBMS_XMLGEN.getxml (qrycontext);
45: dbms_xmlgen.closeContext(qrycontext);
46: x_XML_PAYLOAD := l_xml;
47:
48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;

Line 45: dbms_xmlgen.closeContext(qrycontext);

41: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
42:
43: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
44: l_xml := DBMS_XMLGEN.getxml (qrycontext);
45: dbms_xmlgen.closeContext(qrycontext);
46: x_XML_PAYLOAD := l_xml;
47:
48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;
49: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);

Line 48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;

44: l_xml := DBMS_XMLGEN.getxml (qrycontext);
45: dbms_xmlgen.closeContext(qrycontext);
46: x_XML_PAYLOAD := l_xml;
47:
48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;
49: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
50: l_xml := DBMS_XMLGEN.getxml (qrycontext);
51: dbms_xmlgen.closeContext(qrycontext);
52:

Line 49: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);

45: dbms_xmlgen.closeContext(qrycontext);
46: x_XML_PAYLOAD := l_xml;
47:
48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;
49: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
50: l_xml := DBMS_XMLGEN.getxml (qrycontext);
51: dbms_xmlgen.closeContext(qrycontext);
52:
53: x_XML_CONTEXT := l_xml;

Line 50: l_xml := DBMS_XMLGEN.getxml (qrycontext);

46: x_XML_PAYLOAD := l_xml;
47:
48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;
49: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
50: l_xml := DBMS_XMLGEN.getxml (qrycontext);
51: dbms_xmlgen.closeContext(qrycontext);
52:
53: x_XML_CONTEXT := l_xml;
54:

Line 51: dbms_xmlgen.closeContext(qrycontext);

47:
48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;
49: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
50: l_xml := DBMS_XMLGEN.getxml (qrycontext);
51: dbms_xmlgen.closeContext(qrycontext);
52:
53: x_XML_CONTEXT := l_xml;
54:
55: x_return_status := FND_API.G_RET_STS_SUCCESS;