create FUNCTION get_acct_ccid(p_coa_id IN NUMBER,
p_conca_segments IN VARCHAR2) RETURN NUMBER IS
l_ccid NUMBER;
l_create_result BOOLEAN;
BEGIN
BEGIN
l_create_result := fnd_flex_keyval.validate_segs(
operation => 'CREATE_COMBINATION',
appl_short_name => 'SQLGL',
key_flex_code => 'GL#',
structure_number => p_coa_id,
concat_segments => p_conca_segments);
fnd_message.debug(fnd_flex_keyval.error_message); --输出报错信息
IF (l_create_result) THEN
l_ccid := fnd_flex_keyval.combination_id;
ELSE
l_ccid := NULL;
END IF;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
RETURN(l_ccid);
END get_acct_ccid;
EBS调用交叉验证规则校验外围系统导入凭证
最新推荐文章于 2021-06-18 11:32:51 发布