413:
414: IF (l_parent_flex_value_set_id IS NOT NULL) THEN
415:
416: SELECT s.segment_num into p_dependent_seg_num
417: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
418: fnd_segment_attribute_types sat
419: WHERE s.application_id = 101
420: AND s.id_flex_code = 'GL#'
421: AND s.id_flex_num = p_chart_of_accounts_id
455: L_FLEX_SEGMENT_NUMBER NUMBER;
456: L_NUM_SEGMENTS NUMBER;
457: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;
458: L_CONCATENATED_SEGMENTS VARCHAR2(2000);
459: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;
460: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%TYPE;
461: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;
462: L_VALUE_SET_NAME FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE;
463: L_PARENT_FLEX_VALUE_SET_ID FND_FLEX_VALUE_SETS.PARENT_FLEX_VALUE_SET_ID%TYPE;
456: L_NUM_SEGMENTS NUMBER;
457: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;
458: L_CONCATENATED_SEGMENTS VARCHAR2(2000);
459: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;
460: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%TYPE;
461: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;
462: L_VALUE_SET_NAME FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE;
463: L_PARENT_FLEX_VALUE_SET_ID FND_FLEX_VALUE_SETS.PARENT_FLEX_VALUE_SET_ID%TYPE;
464: L_DEPENDENT_SEG_NUM NUMBER := 0;
457: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;
458: L_CONCATENATED_SEGMENTS VARCHAR2(2000);
459: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;
460: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%TYPE;
461: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;
462: L_VALUE_SET_NAME FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE;
463: L_PARENT_FLEX_VALUE_SET_ID FND_FLEX_VALUE_SETS.PARENT_FLEX_VALUE_SET_ID%TYPE;
464: L_DEPENDENT_SEG_NUM NUMBER := 0;
465: