APPS.PER_RI_CONFIG_TECH_SUMMARY dependencies on DBMS_XMLQUERY

Line 3445: queryCtx := DBMS_XMLQuery.newContext(l_in_clob);

3441: WHEN OTHERS THEN
3442: hr_utility.raise_error;
3443: END;
3444:
3445: queryCtx := DBMS_XMLQuery.newContext(l_in_clob);
3446:
3447: IF l_encoding_tag IS NOT null THEN
3448: DBMS_XMLQUERY.setEncodingTag(queryCtx, l_encoding_tag);
3449: END IF;

Line 3448: DBMS_XMLQUERY.setEncodingTag(queryCtx, l_encoding_tag);

3444:
3445: queryCtx := DBMS_XMLQuery.newContext(l_in_clob);
3446:
3447: IF l_encoding_tag IS NOT null THEN
3448: DBMS_XMLQUERY.setEncodingTag(queryCtx, l_encoding_tag);
3449: END IF;
3450:
3451: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3452: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);

Line 3451: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);

3447: IF l_encoding_tag IS NOT null THEN
3448: DBMS_XMLQUERY.setEncodingTag(queryCtx, l_encoding_tag);
3449: END IF;
3450:
3451: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3452: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);
3453: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);
3454: end if;
3455: hr_utility.set_location('Leaving ' || l_proc,20);

Line 3452: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);

3448: DBMS_XMLQUERY.setEncodingTag(queryCtx, l_encoding_tag);
3449: END IF;
3450:
3451: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3452: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);
3453: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);
3454: end if;
3455: hr_utility.set_location('Leaving ' || l_proc,20);
3456: return l_ret_in_clob;

Line 3453: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);

3449: END IF;
3450:
3451: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3452: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);
3453: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);
3454: end if;
3455: hr_utility.set_location('Leaving ' || l_proc,20);
3456: return l_ret_in_clob;
3457: END fetch_clob;