APPS.PSA_BC_XML_REPORT_PUB dependencies on DBMS_XMLQUERY

Line 3047: l_ctx DBMS_XMLQUERY.ctxtype;

3043: p_row_tag IN VARCHAR2 DEFAULT NULL,
3044: x_xml OUT NOCOPY CLOB
3045: ) IS
3046: l_api_name VARCHAR2(240);
3047: l_ctx DBMS_XMLQUERY.ctxtype;
3048: retcode NUMBER;
3049: l_len NUMBER;
3050: l_start NUMBER:=1;
3051: l_char_set VARCHAR2(120);

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

3060:
3061: -- The value below is currently hard coded as a workaround. Hard coding should be removed later.
3062: -- l_char_set := 'UTF-8'; Removed for bug 6445210
3063:
3064: l_ctx := DBMS_XMLQUERY.newcontext(p_query);
3065: psa_utils.debug_other_string(g_state_level,l_api_name,'l_ctx type fetched successfully');
3066:
3067: -- DBMS_XMLQUERY.SetEncodingTag(l_ctx, l_char_set);
3068: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);

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

3063:
3064: l_ctx := DBMS_XMLQUERY.newcontext(p_query);
3065: psa_utils.debug_other_string(g_state_level,l_api_name,'l_ctx type fetched successfully');
3066:
3067: -- DBMS_XMLQUERY.SetEncodingTag(l_ctx, l_char_set);
3068: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);
3069:
3070: -- change rowset tag
3071: IF p_rowset_tag IS NOT NULL THEN

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

3068: -- psa_utils.debug_other_string(g_state_level,l_api_name,'Encoding set to '||l_char_set);
3069:
3070: -- change rowset tag
3071: IF p_rowset_tag IS NOT NULL THEN
3072: DBMS_XMLQUERY.setRowSetTag(l_ctx, p_rowset_tag);
3073: END IF;
3074:
3075: -- change row tag
3076: IF p_row_tag IS NOT NULL THEN

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

3073: END IF;
3074:
3075: -- change row tag
3076: IF p_row_tag IS NOT NULL THEN
3077: DBMS_XMLQUERY.setRowTag(l_ctx, p_row_tag);
3078: END IF;
3079:
3080: psa_utils.debug_other_string(g_state_level,l_api_name,'p_rowset_tag' || ' = ' || p_rowset_tag);
3081: psa_utils.debug_other_string(g_state_level,l_api_name,'p_row_tag' || ' = ' || p_row_tag);

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

3086: psa_utils.debug_other_string(g_state_level,l_api_name,'p_query' || ' = ' || substr(p_query,l_start,3500));
3087: l_start := l_start + 3500;
3088: end loop;
3089:
3090: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);
3091:
3092: x_xml := DBMS_XMLQUERY.getXML(l_ctx);
3093:
3094: DBMS_XMLQUERY.closecontext(l_ctx);

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

3088: end loop;
3089:
3090: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);
3091:
3092: x_xml := DBMS_XMLQUERY.getXML(l_ctx);
3093:
3094: DBMS_XMLQUERY.closecontext(l_ctx);
3095: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure get_xml');
3096:

Line 3094: DBMS_XMLQUERY.closecontext(l_ctx);

3090: DBMS_XMLQUERY.UseNullAttributeIndicator(l_ctx, TRUE);
3091:
3092: x_xml := DBMS_XMLQUERY.getXML(l_ctx);
3093:
3094: DBMS_XMLQUERY.closecontext(l_ctx);
3095: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure get_xml');
3096:
3097:
3098: EXCEPTION