APPS.AP_CARD_UTILITY_PKG dependencies on FND_FLEX_VALUE_SETS

Line 403: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,

399:
400: END GetCOAofSOB;
401:
402: FUNCTION GetDependentSegment(
403: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
404: p_chart_of_accounts_id IN NUMBER,
405: p_dependent_seg_num OUT NOCOPY NUMBER)
406: RETURN BOOLEAN IS
407: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;

Line 407: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;

403: p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%type,
404: p_chart_of_accounts_id IN NUMBER,
405: p_dependent_seg_num OUT NOCOPY NUMBER)
406: RETURN BOOLEAN IS
407: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
408: BEGIN
409: select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
410: from fnd_flex_value_sets
411: where flex_value_set_name like p_value_set_name

Line 410: from fnd_flex_value_sets

406: RETURN BOOLEAN IS
407: l_parent_flex_value_set_id fnd_flex_value_sets.parent_flex_value_set_id%type;
408: BEGIN
409: select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
410: from fnd_flex_value_sets
411: where flex_value_set_name like p_value_set_name
412: and PARENT_FLEX_VALUE_SET_ID is not null;
413:
414: IF (l_parent_flex_value_set_id IS NOT NULL) THEN

Line 462: L_VALUE_SET_NAME FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE;

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:
466: L_EMP_SET_OF_BOOKS_ID NUMBER;

Line 463: L_PARENT_FLEX_VALUE_SET_ID FND_FLEX_VALUE_SETS.PARENT_FLEX_VALUE_SET_ID%TYPE;

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:
466: L_EMP_SET_OF_BOOKS_ID NUMBER;
467: l_ou_chart_of_accounts_id NUMBER;