FND_FLEX_EXT.GET_COMBINATION_ID

By | January 11, 2012
This API FND_FLEX_EXT.GET_COMBINATION_ID is used to get the code combination id based on the segment data. Returns NULL if structure not found.

set serveroutput on;DECLARE application_short_name VARCHAR2(200); key_flex_code VARCHAR2(200); structure_number NUMBER; validation_date DATE; n_segments NUMBER; segments APPS.FND_FLEX_EXT.SEGMENTARRAY; combination_id NUMBER; data_set NUMBER; v_return BOOLEAN;BEGIN application_short_name := ‘SQLGL’; key_flex_code := ‘GL#’; structure_number := 60408; validation_date := SYSDATE; n_segments := 7; segments(1) := ‘210’; segments(2) := ‘7001499’; segments(3) := ‘40460’; segments(4) := ‘81010’; segments(5) := ‘02000’; segments(6) := ‘010’; segments(7) := ‘00000’; DATA_SET := NULL;

v_Return := FND_FLEX_EXT.GET_COMBINATION_ID( APPLICATION_SHORT_NAME => application_short_name, KEY_FLEX_CODE => key_flex_code, STRUCTURE_NUMBER => structure_number, VALIDATION_DATE => validation_date, N_SEGMENTS => n_segments, SEGMENTS => segments, COMBINATION_ID => combination_id, DATA_SET => data_set ); DBMS_OUTPUT.PUT_LINE(‘COMBINATION_ID = ‘ || combination_id); IF v_return THEN DBMS_OUTPUT.PUT_LINE(‘v_Return = TRUE’); ELSE DBMS_OUTPUT.PUT_LINE(‘v_Return = FLASE’); END IF;END;

Note: If you find information on this page useful and you want to encourage me to do more, click on any ad on this page.