APPS.PSA_BC_XML_REPORT_PUB dependencies on DBMS_XMLQUERY

Line 2960: l_ctx DBMS_XMLQUERY.ctxtype;

2956: p_row_tag IN VARCHAR2 DEFAULT NULL,
2957: x_xml OUT NOCOPY CLOB
2958: ) IS
2959: l_api_name VARCHAR2(240);
2960: l_ctx DBMS_XMLQUERY.ctxtype;
2961: retcode NUMBER;
2962: l_len NUMBER;
2963: l_start NUMBER:=1;
2964: l_char_set VARCHAR2(120);

Line 2977: l_ctx := DBMS_XMLQUERY.newcontext(p_query);

2973:
2974: -- The value below is currently hard coded as a workaround. Hard coding should be removed later.
2975: -- l_char_set := 'UTF-8'; Removed for bug 6445210
2976:
2977: l_ctx := DBMS_XMLQUERY.newcontext(p_query);
2978: psa_utils.debug_other_string(g_state_level,l_api_name,'l_ctx type fetched successfully');
2979:
2980: -- DBMS_XMLQUERY.SetEncodingTag(l_ctx, l_char_set);
2981: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);

Line 2980: -- DBMS_XMLQUERY.SetEncodingTag(l_ctx, l_char_set);

2976:
2977: l_ctx := DBMS_XMLQUERY.newcontext(p_query);
2978: psa_utils.debug_other_string(g_state_level,l_api_name,'l_ctx type fetched successfully');
2979:
2980: -- DBMS_XMLQUERY.SetEncodingTag(l_ctx, l_char_set);
2981: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);
2982:
2983: -- change rowset tag
2984: IF p_rowset_tag IS NOT NULL THEN

Line 2985: DBMS_XMLQUERY.setRowSetTag(l_ctx, p_rowset_tag);

2981: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);
2982:
2983: -- change rowset tag
2984: IF p_rowset_tag IS NOT NULL THEN
2985: DBMS_XMLQUERY.setRowSetTag(l_ctx, p_rowset_tag);
2986: END IF;
2987:
2988: -- change row tag
2989: IF p_row_tag IS NOT NULL THEN

Line 2990: DBMS_XMLQUERY.setRowTag(l_ctx, p_row_tag);

2986: END IF;
2987:
2988: -- change row tag
2989: IF p_row_tag IS NOT NULL THEN
2990: DBMS_XMLQUERY.setRowTag(l_ctx, p_row_tag);
2991: END IF;
2992:
2993: psa_utils.debug_other_string(g_state_level,l_api_name,'p_rowset_tag' || ' = ' || p_rowset_tag);
2994: psa_utils.debug_other_string(g_state_level,l_api_name,'p_row_tag' || ' = ' || p_row_tag);

Line 3003: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);

2999: psa_utils.debug_other_string(g_state_level,l_api_name,'p_query' || ' = ' || substr(p_query,l_start,3500));
3000: l_start := l_start + 3500;
3001: end loop;
3002:
3003: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);
3004:
3005: x_xml := DBMS_XMLQUERY.getXML(l_ctx);
3006:
3007: DBMS_XMLQUERY.closecontext(l_ctx);

Line 3005: x_xml := DBMS_XMLQUERY.getXML(l_ctx);

3001: end loop;
3002:
3003: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);
3004:
3005: x_xml := DBMS_XMLQUERY.getXML(l_ctx);
3006:
3007: DBMS_XMLQUERY.closecontext(l_ctx);
3008: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure get_xml');
3009:

Line 3007: DBMS_XMLQUERY.closecontext(l_ctx);

3003: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);
3004:
3005: x_xml := DBMS_XMLQUERY.getXML(l_ctx);
3006:
3007: DBMS_XMLQUERY.closecontext(l_ctx);
3008: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure get_xml');
3009:
3010:
3011: EXCEPTION