APPS.AME_UTILITY_PKG dependencies on FND_VSET

Line 861: l_v_r fnd_vset.valueset_r;

857: l_before_from varchar2(4000);
858: l_after_from varchar2(4000);
859: l_column1 varchar2(200);
860: l_column2 varchar2(200);
861: l_v_r fnd_vset.valueset_r;
862: l_v_dr fnd_vset.valueset_dr;
863: l_whr varchar2(4000);
864: l_valid_number_col varchar2(100);
865: l_format_type fnd_flex_value_sets.format_type%TYPE;

Line 862: l_v_dr fnd_vset.valueset_dr;

858: l_after_from varchar2(4000);
859: l_column1 varchar2(200);
860: l_column2 varchar2(200);
861: l_v_r fnd_vset.valueset_r;
862: l_v_dr fnd_vset.valueset_dr;
863: l_whr varchar2(4000);
864: l_valid_number_col varchar2(100);
865: l_format_type fnd_flex_value_sets.format_type%TYPE;
866: l_value BOOLEAN;

Line 920: fnd_vset.get_valueset(valueset_id => p_value_set_id ,

916: l_column2 := trim(substrb(l_before_from,1,instrb(l_before_from,',')-1));
917: end if;
918: p_select := 'select '||l_column1||' VALUE, '||l_column2||' MEANING from'||l_after_from;
919: elsif (l_validation_type = 'F') then
920: fnd_vset.get_valueset(valueset_id => p_value_set_id ,
921: valueset => l_v_r,
922: format => l_v_dr);
923: l_whr := trim(l_v_r.table_info.where_clause) ;
924: if(l_whr is not null and