11: lv_coa_id := TO_NUMBER(p_coa_id);
12: select TO_NUMBER(TRANSLATE(p_segment, 'SEGMENT', '0'))
13: into lv_seg_num
14: from dual;
15: lv_return := FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', lv_coa_id, lv_ccid_num);
16: description := FND_FLEX_KEYVAL.segment_description(lv_seg_num);
17: End;
18:
19: Function Get_Flex_Seg_Desc return varchar2 IS
12: select TO_NUMBER(TRANSLATE(p_segment, 'SEGMENT', '0'))
13: into lv_seg_num
14: from dual;
15: lv_return := FND_FLEX_KEYVAL.validate_ccid('SQLGL', 'GL#', lv_coa_id, lv_ccid_num);
16: description := FND_FLEX_KEYVAL.segment_description(lv_seg_num);
17: End;
18:
19: Function Get_Flex_Seg_Desc return varchar2 IS
20: lv_return_text varchar2(150);