DECLARE
i NUMBER ;
v VARCHAR2 ( 200 );
l_result BOOLEAN;
l_seg_type fnd_flex_ext.segmentarray;
BEGIN
l_seg_type( 1 ) : = ' 101..9001... ' ;
l_result : = fnd_flex_ext.get_combination_id(application_short_name => ' SQLGL ' ,
key_flex_code => ' GL ' ,
structure_number => 50288 ,
validation_date => SYSDATE,
n_segments => 1 ,
segments => l_seg_type,
combination_id => i);
dbms_output.put_line(i);
v : = fnd_flex_ext.get_segs(application_short_name => ' SQLGL ' ,
key_flex_code => ' GL ' ,
structure_number => 50288 ,
combination_id => i);
dbms_output.put_line(v);
END ;