-- Created on 7/20/2007 by Zeeno
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;