Wednesday, December 1, 2010
API to get the segment delimiter for the specified key flex field structure (FND_FLEX_EXT.GET_DELIMITER)
This API FND_FLEX_EXT.GET_DELIMITER is used to get the character which is used as the segment delimiter for the specified key flex field structure. Returns NULL if structure not found.
Script:
SET SERVEROUTPUT ON;
DECLARE
v_application_short_name VARCHAR2(200);
v_key_flex_code VARCHAR2(200);
v_structure_number NUMBER; -- Chart of Accounts id
v_Return VARCHAR2(200);
BEGIN
v_application_short_name := 'SQLGL';
v_key_flex_code := 'GL#';
v_structure_number := 50408;
v_Return := FND_FLEX_EXT.GET_DELIMITER
(
APPLICATION_SHORT_NAME => v_application_short_name,
KEY_FLEX_CODE => v_key_flex_code,
STRUCTURE_NUMBER => v_structure_number
);
DBMS_OUTPUT.PUT_LINE('v_return = ' || v_return);
END;
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “API to get the segment delimiter for the specified key flex field structure (FND_FLEX_EXT.GET_DELIMITER)”
Post a Comment