387:
388: END GetCOAofSOB;
389:
390: FUNCTION GetDependentSegment(
391: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
392: p_chart_of_accounts_id IN NUMBER,
393: p_dependent_seg_num OUT NOCOPY NUMBER)
394: RETURN BOOLEAN IS
395: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
391: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
392: p_chart_of_accounts_id IN NUMBER,
393: p_dependent_seg_num OUT NOCOPY NUMBER)
394: RETURN BOOLEAN IS
395: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
396: BEGIN
397: select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
398: from fnd_flex_value_sets
399: where flex_value_set_name like p_value_set_name
394: RETURN BOOLEAN IS
395: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
396: BEGIN
397: select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
398: from fnd_flex_value_sets
399: where flex_value_set_name like p_value_set_name
400: and PARENT_FLEX_VALUE_SET_ID is not null;
401:
402: IF (l_parent_flex_value_set_id IS NOT NULL) THEN
445: L_CONCATENATED_SEGMENTS VARCHAR2(2000);
446: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;
447: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%TYPE;
448: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;
449: L_VALUE_SET_NAME FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE;
450: L_PARENT_FLEX_VALUE_SET_ID FND_FLEX_VALUE_SETS.PARENT_FLEX_VALUE_SET_ID%TYPE;
451: L_DEPENDENT_SEG_NUM NUMBER := 0;
452:
453: L_EMP_SET_OF_BOOKS_ID NUMBER;
446: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;
447: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%TYPE;
448: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;
449: L_VALUE_SET_NAME FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE;
450: L_PARENT_FLEX_VALUE_SET_ID FND_FLEX_VALUE_SETS.PARENT_FLEX_VALUE_SET_ID%TYPE;
451: L_DEPENDENT_SEG_NUM NUMBER := 0;
452:
453: L_EMP_SET_OF_BOOKS_ID NUMBER;
454: l_ou_chart_of_accounts_id NUMBER;