DBA Data[Home] [Help]

APPS.AP_CARD_UTILITY_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 405: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,

401:
402: IF (l_parent_flex_value_set_id IS NOT NULL) THEN
403:
404: SELECT s.segment_num into p_dependent_seg_num
405: FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
406: fnd_segment_attribute_types sat
407: WHERE s.application_id = 101
408: AND s.id_flex_code = 'GL#'
409: AND s.id_flex_num = p_chart_of_accounts_id

Line 446: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;

442: L_FLEX_SEGMENT_NUMBER NUMBER;
443: L_NUM_SEGMENTS NUMBER;
444: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;
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;

Line 447: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%TYPE;

443: L_NUM_SEGMENTS NUMBER;
444: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;
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;

Line 448: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;

444: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;
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: