APPS.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on FND_VSET

Line 414: l_v_r fnd_vset.valueset_r;

410: -- ----------------------------------------------------------------------------
411: --
412: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
413: --
414: l_v_r fnd_vset.valueset_r;
415: l_v_dr fnd_vset.valueset_dr;
416: l_str varchar2(4000);
417: l_whr varchar2(4000);
418: l_proc varchar2(72);

Line 415: l_v_dr fnd_vset.valueset_dr;

411: --
412: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
413: --
414: l_v_r fnd_vset.valueset_r;
415: l_v_dr fnd_vset.valueset_dr;
416: l_str varchar2(4000);
417: l_whr varchar2(4000);
418: l_proc varchar2(72);
419: --

Line 427: fnd_vset.get_valueset(valueset_id => p_vset_id ,

423: if g_debug then
424: l_proc := g_package||'get_sql_from_vset_id';
425: hr_utility.set_location('Entering:'||l_proc, 10);
426: end if;
427: fnd_vset.get_valueset(valueset_id => p_vset_id ,
428: valueset => l_v_r,
429: format => l_v_dr);
430: --
431: if g_debug then

Line 1929: l_v_r fnd_vset.valueset_r;

1925: --
1926: --
1927: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
1928: --
1929: l_v_r fnd_vset.valueset_r;
1930: l_v_dr fnd_vset.valueset_dr;
1931: l_str varchar2(4000);
1932: l_whr varchar2(4000);
1933: --

Line 1930: l_v_dr fnd_vset.valueset_dr;

1926: --
1927: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
1928: --
1929: l_v_r fnd_vset.valueset_r;
1930: l_v_dr fnd_vset.valueset_dr;
1931: l_str varchar2(4000);
1932: l_whr varchar2(4000);
1933: --
1934: BEGIN

Line 1936: fnd_vset.get_valueset(valueset_id => p_vset_id ,

1932: l_whr varchar2(4000);
1933: --
1934: BEGIN
1935: --
1936: fnd_vset.get_valueset(valueset_id => p_vset_id ,
1937: valueset => l_v_r,
1938: format => l_v_dr);
1939: --
1940: l_whr := l_v_r.table_info.where_clause ;