DBA Data[Home] [Help]

APPS.PER_CAGR_UTILITY_PKG dependencies on FND_VSET

Line 569: l_v_r fnd_vset.valueset_r;

565: -- ----------------------------------------------------------------------------
566: --
567: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
568: --
569: l_v_r fnd_vset.valueset_r;
570: l_v_dr fnd_vset.valueset_dr;
571: l_str varchar2(4000);
572: l_whr varchar2(4000);
573: l_ord varchar2(4000);

Line 570: l_v_dr fnd_vset.valueset_dr;

566: --
567: FUNCTION get_sql_from_vset_id(p_vset_id IN NUMBER) RETURN VARCHAR2 IS
568: --
569: l_v_r fnd_vset.valueset_r;
570: l_v_dr fnd_vset.valueset_dr;
571: l_str varchar2(4000);
572: l_whr varchar2(4000);
573: l_ord varchar2(4000);
574: l_col varchar2(4000);

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

574: l_col varchar2(4000);
575: --
576: BEGIN
577: --
578: fnd_vset.get_valueset(valueset_id => p_vset_id ,
579: valueset => l_v_r,
580: format => l_v_dr);
581: --
582: IF l_v_r.table_info.table_name IS NULL THEN