APPS.EGO_PUB_WS_VS dependencies on FND_FLEX_VALUE_SETS

Line 405: ,FND_FLEX_VALUE_SETS FFVS

401: ,VS_REL.value_set_id child_vs_id
402: ,FFVS.flex_value_set_name child_vs_name
403: FROM EGO_PUB_WS_ENTITIES EPWE
404: ,EGO_VALUE_SET_EXT VS_REL
405: ,FND_FLEX_VALUE_SETS FFVS
406: WHERE EPWE.session_id = p_session_id
407: AND EPWE.entity_type = G_ENTITY_TYPE_VS
408: AND EPWE.parent_sequence_id IS NULL
409: AND EPWE.pk1_value = VS_REL.parent_value_set_id

Line 945: l_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;

941: IS
942:
943: l_mode VARCHAR(100);
944: l_batch_id NUMBER;
945: l_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;
946: x_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;
947: l_vs_version ego_flex_valueset_version_b.version_seq_id%TYPE;
948: x_vs_version ego_flex_valueset_version_b.version_seq_id%TYPE;
949: l_seq_id NUMBER;

Line 946: x_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;

942:
943: l_mode VARCHAR(100);
944: l_batch_id NUMBER;
945: l_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;
946: x_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;
947: l_vs_version ego_flex_valueset_version_b.version_seq_id%TYPE;
948: x_vs_version ego_flex_valueset_version_b.version_seq_id%TYPE;
949: l_seq_id NUMBER;
950: l_comma_separated_str VARCHAR2(2000);

Line 957: l_valueset_id fnd_flex_value_sets.flex_value_set_id%TYPE;

953: l_temp_varchar3 VARCHAR2(150);
954: l_validate_vs BOOLEAN := TRUE; --tells if ag name has to be validated
955: l_is_vs_id_valid BOOLEAN := TRUE; --tells if ag id has to be validated
956: l_is_valid BOOLEAN := FALSE;
957: l_valueset_id fnd_flex_value_sets.flex_value_set_id%TYPE;
958: l_derived_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;
959: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
960:
961:

Line 958: l_derived_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;

954: l_validate_vs BOOLEAN := TRUE; --tells if ag name has to be validated
955: l_is_vs_id_valid BOOLEAN := TRUE; --tells if ag id has to be validated
956: l_is_valid BOOLEAN := FALSE;
957: l_valueset_id fnd_flex_value_sets.flex_value_set_id%TYPE;
958: l_derived_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;
959: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
960:
961:
962:

Line 959: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

955: l_is_vs_id_valid BOOLEAN := TRUE; --tells if ag id has to be validated
956: l_is_valid BOOLEAN := FALSE;
957: l_valueset_id fnd_flex_value_sets.flex_value_set_id%TYPE;
958: l_derived_vs_id fnd_flex_value_sets.flex_value_set_id%TYPE;
959: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
960:
961:
962:
963: --tables for LIST mode