会计科目API CCID

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;