APPS.HR_CAL_ENTRY_VALUE_API dependencies on FND_VSET

Line 417: l_v_r fnd_vset.valueset_r;

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

Line 418: l_v_dr fnd_vset.valueset_dr;

414: --
415: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
416: --
417: l_v_r fnd_vset.valueset_r;
418: l_v_dr fnd_vset.valueset_dr;
419: l_str varchar2(4000);
420: l_whr varchar2(4000);
421: l_ord varchar2(4000);
422: l_col varchar2(4000);

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

422: l_col varchar2(4000);
423: --
424: BEGIN
425: --
426: fnd_vset.get_valueset(valueset_id => p_vset_id ,
427: valueset => l_v_r,
428: format => l_v_dr);
429: --
430: IF l_v_r.table_info.table_name IS NULL THEN

Line 672: l_v_r fnd_vset.valueset_r;

668: -- ----------------------------------------------------------------------------
669: --
670: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
671: --
672: l_v_r fnd_vset.valueset_r;
673: l_v_dr fnd_vset.valueset_dr;
674: l_str varchar2(4000);
675: l_whr varchar2(4000);
676: l_ord varchar2(4000);

Line 673: l_v_dr fnd_vset.valueset_dr;

669: --
670: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
671: --
672: l_v_r fnd_vset.valueset_r;
673: l_v_dr fnd_vset.valueset_dr;
674: l_str varchar2(4000);
675: l_whr varchar2(4000);
676: l_ord varchar2(4000);
677: l_col varchar2(4000);

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

677: l_col varchar2(4000);
678: --
679: BEGIN
680: --
681: fnd_vset.get_valueset(valueset_id => p_vset_id ,
682: valueset => l_v_r,
683: format => l_v_dr);
684: --
685: IF l_v_r.table_info.table_name IS NULL THEN