APPS.CSM_EMAIL_QUERY_PKG dependencies on DBMS_XMLGEN

Line 675: qrycontext DBMS_XMLGEN.ctxHandle;

671: --AND rb.ROLE_CODE = 'CSF_THIRD_PARTY_ADMINISTRATOR';
672:
673:
674: l_query_text VARCHAR2(32767);
675: qrycontext DBMS_XMLGEN.ctxHandle;
676: l_user_id NUMBER;
677: l_group_id NUMBER;
678: r_groups c_groups%ROWTYPE;
679: r_group_members c_group_members%ROWTYPE;

Line 904: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;

900: ORDER BY task_number ';
901: END IF;
902:
903:
904: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
905: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
906: p_result := DBMS_XMLGEN.getxml (qrycontext);
907:
908: CSM_UTIL_PKG.LOG('Leaving GET_TASKS for EMAIL Id: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

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

901: END IF;
902:
903:
904: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
905: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
906: p_result := DBMS_XMLGEN.getxml (qrycontext);
907:
908: CSM_UTIL_PKG.LOG('Leaving GET_TASKS for EMAIL Id: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
909:

Line 906: p_result := DBMS_XMLGEN.getxml (qrycontext);

902:
903:
904: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
905: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
906: p_result := DBMS_XMLGEN.getxml (qrycontext);
907:
908: CSM_UTIL_PKG.LOG('Leaving GET_TASKS for EMAIL Id: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
909:
910: EXCEPTION

Line 1535: l_qrycontext DBMS_XMLGEN.ctxHandle;

1531: l_item mtl_system_items_b.segment1%TYPE;
1532: l_serial_number csi_item_instances.serial_number%TYPE;
1533: l_task_access_flag VARCHAR2(1);
1534: l_query_text VARCHAR2(4000);
1535: l_qrycontext DBMS_XMLGEN.ctxHandle;
1536: l_email_format VARCHAR2(240);
1537: l_xml_result LONG;
1538:
1539: BEGIN

Line 1734: qrycontext DBMS_XMLGEN.ctxHandle;

1730: l_description fnd_lookup_values.description%TYPE;
1731: r_sr_notes c_sr_notes%ROWTYPE;
1732: l_incident_id NUMBER;
1733: l_query_text VARCHAR2(4000);
1734: qrycontext DBMS_XMLGEN.ctxHandle;
1735: l_email_format VARCHAR2(240);
1736: l_xml_result CLOB;
1737: l_resource_id NUMBER;
1738: l_task_access_flag VARCHAR2(1) := 'N';

Line 2017: qrycontext DBMS_XMLGEN.ctxHandle;

2013: x_error_message OUT nocopy VARCHAR2
2014: )
2015: AS
2016: l_query_text VARCHAR2(4000);
2017: qrycontext DBMS_XMLGEN.ctxHandle;
2018:
2019: BEGIN
2020: CSM_UTIL_PKG.LOG('Entering HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2021:

Line 2032: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;

2028: AND NVL(qb.disabled_flag,''N'') = ''N''
2029: AND qtl.language = userenv(''LANG'')
2030: AND qb.query_id = qtl.query_id';
2031:
2032: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
2033: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
2034: p_result := DBMS_XMLGEN.getxml (qrycontext);
2035:
2036: CSM_UTIL_PKG.LOG('Leaving HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

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

2029: AND qtl.language = userenv(''LANG'')
2030: AND qb.query_id = qtl.query_id';
2031:
2032: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
2033: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
2034: p_result := DBMS_XMLGEN.getxml (qrycontext);
2035:
2036: CSM_UTIL_PKG.LOG('Leaving HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2037:

Line 2034: p_result := DBMS_XMLGEN.getxml (qrycontext);

2030: AND qb.query_id = qtl.query_id';
2031:
2032: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
2033: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
2034: p_result := DBMS_XMLGEN.getxml (qrycontext);
2035:
2036: CSM_UTIL_PKG.LOG('Leaving HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2037:
2038: EXCEPTION