HDL Trans FF and broken Value Set not returning correctly

Summary

HDL Trans FF and broken Value Set not returning correctly

Content

Hi :

My two Value sets are not returning any TO_CHAR(number) values - Defined as Table & Character type:

1)   VS to return UDT user_column_id as char:

l_columnId_val    = get_value_set ('GET_COLUMNID_UDT_CHAR_VS',

'|=P_TABLE_NAME='''    ||UserTableCode||

'''|=P_COLUMN_NAME='''    ||UserColumnCode||''''

)

 

SELECT to_char( c_tl.USER_COLUMN_ID)

FROM ff_user_tables t, ff_user_rows_f r , ff_user_columns c , ff_user_columns_tl c_tl , ff_user_column_instances_f v

WHERE rownum <2

AND t.base_user_table_name = :{PARAMETER.P_TABLE_NAME}