1859: IS
1860: L_Valueset_R FND_VSET.VALUESET_R;
1861: X_VALUESETID NUMBER;
1862: L_valueset_dr FND_VSET.VALUESET_DR;
1863: v_dflex_r fnd_dflex.dflex_r;
1864: v_segments_dr fnd_dflex.segments_dr;
1865: v_context_r fnd_dflex.context_r;
1866: BEGIN
1867: v_dflex_r.application_id := 660;
1860: L_Valueset_R FND_VSET.VALUESET_R;
1861: X_VALUESETID NUMBER;
1862: L_valueset_dr FND_VSET.VALUESET_DR;
1863: v_dflex_r fnd_dflex.dflex_r;
1864: v_segments_dr fnd_dflex.segments_dr;
1865: v_context_r fnd_dflex.context_r;
1866: BEGIN
1867: v_dflex_r.application_id := 660;
1868: v_dflex_r.flexfield_name := p_flexfield_name;
1861: X_VALUESETID NUMBER;
1862: L_valueset_dr FND_VSET.VALUESET_DR;
1863: v_dflex_r fnd_dflex.dflex_r;
1864: v_segments_dr fnd_dflex.segments_dr;
1865: v_context_r fnd_dflex.context_r;
1866: BEGIN
1867: v_dflex_r.application_id := 660;
1868: v_dflex_r.flexfield_name := p_flexfield_name;
1869: v_context_r.flexfield := v_dflex_r;
1868: v_dflex_r.flexfield_name := p_flexfield_name;
1869: v_context_r.flexfield := v_dflex_r;
1870: v_context_r.context_code := p_context;
1871: -- Get the enabled segments for the context selected.
1872: fnd_dflex.get_segments(v_context_r,v_segments_dr,TRUE);
1873:
1874: FOR i IN 1..v_segments_dr.nsegments LOOP
1875: IF (v_segments_dr.application_column_name(i) = p_seg) THEN
1876: X_VALUESETID := v_SEGMENTS_dr.VALUE_SET(i);