DBA Data[Home] [Help]

APPS.AP_CARD_UTILITY_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 417: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

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

Line 459: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;

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;

Line 460: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%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;

Line 461: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;

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: