APPS.EGO_PUB_WS_VS dependencies on EGO_FLEX_VALUESET_VERSION_B

Line 76: l_version ego_flex_valueset_version_b.version_seq_id%type;

72: FUNCTION Get_Current_Effective_Version ( p_vs_id IN NUMBER
73: )
74: RETURN NUMBER
75: IS
76: l_version ego_flex_valueset_version_b.version_seq_id%type;
77: l_proc_name VARCHAR2(50) := 'get_current_effective_version=>';
78: BEGIN
79: debug (1, l_proc_name||'Start');
80:

Line 83: FROM EGO_FLEX_VALUESET_VERSION_B efvvb

79: debug (1, l_proc_name||'Start');
80:
81: SELECT efvvb.version_seq_id
82: INTO l_version
83: FROM EGO_FLEX_VALUESET_VERSION_B efvvb
84: WHERE NVL(efvvb.end_active_date, sysdate) >= SYSDATE
85: AND efvvb.start_active_date <= SYSDATE
86: AND efvvb.FLEX_VALUE_SET_ID = p_vs_id
87: AND efvvb.version_seq_id > 0;

Line 243: FROM EGO_flex_VALUESET_VERSION_B efvvb

239: <>
240: BEGIN
241: SELECT efvvb.version_seq_id
242: INTO x_vs_version
243: FROM EGO_flex_VALUESET_VERSION_B efvvb
244: where efvvb.FLEX_VALUE_SET_ID = x_vs_id
245: AND efvvb.version_seq_id = l_vs_version;
246:
247: debug(1, l_proc_name||'version retrieved=>'||x_vs_version||'#VALID');

Line 947: l_vs_version ego_flex_valueset_version_b.version_seq_id%TYPE;

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);
951: l_temp_varchar1 VARCHAR2(150);

Line 948: x_vs_version ego_flex_valueset_version_b.version_seq_id%TYPE;

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);
951: l_temp_varchar1 VARCHAR2(150);
952: l_temp_varchar2 VARCHAR2(150);