APPS.PER_RI_CONFIG_TECH_SUMMARY dependencies on DBMS_XMLQUERY

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

3425:
3426: BEGIN
3427: hr_utility.set_location('Entering ' || l_proc,10);
3428: if p_in_clob is not null then
3429: queryCtx := DBMS_XMLQuery.newContext(l_in_clob);
3430: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3431: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);
3432: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);
3433: end if;

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

3426: BEGIN
3427: hr_utility.set_location('Entering ' || l_proc,10);
3428: if p_in_clob is not null then
3429: queryCtx := DBMS_XMLQuery.newContext(l_in_clob);
3430: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3431: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);
3432: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);
3433: end if;
3434: hr_utility.set_location('Leaving ' || l_proc,20);

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

3427: hr_utility.set_location('Entering ' || l_proc,10);
3428: if p_in_clob is not null then
3429: queryCtx := DBMS_XMLQuery.newContext(l_in_clob);
3430: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3431: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);
3432: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);
3433: end if;
3434: hr_utility.set_location('Leaving ' || l_proc,20);
3435: return l_ret_in_clob;

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

3428: if p_in_clob is not null then
3429: queryCtx := DBMS_XMLQuery.newContext(l_in_clob);
3430: DBMS_XMLQuery.setRowtag(queryCtx,p_row_tag);
3431: DBMS_XMLQuery.setRowSettag(queryCtx,p_row_set_tag);
3432: l_ret_in_clob := DBMS_XMLQuery.getXML(queryCtx);
3433: end if;
3434: hr_utility.set_location('Leaving ' || l_proc,20);
3435: return l_ret_in_clob;
3436: END fetch_clob;