DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_VALIDATION_TABLE_INFO_V

Line 3402: l_vs_table_name EGO_VALIDATION_TABLE_INFO_V.application_table_name%type; -- bug 14619994

3398: l_table_index IN NUMBER
3399: )
3400: RETURN varchar2
3401: IS
3402: l_vs_table_name EGO_VALIDATION_TABLE_INFO_V.application_table_name%type; -- bug 14619994
3403: l_vs_value_column EGO_VALIDATION_TABLE_INFO_V.value_column_name%type; -- bug 14619994
3404: l_vs_id_column EGO_VALIDATION_TABLE_INFO_V.id_column_name%type; -- bug 14619994
3405: l_dynamic_query VARCHAR2(2000);
3406: l_disp_value LOCAL_BIG_VARCHAR_TABLE;

Line 3403: l_vs_value_column EGO_VALIDATION_TABLE_INFO_V.value_column_name%type; -- bug 14619994

3399: )
3400: RETURN varchar2
3401: IS
3402: l_vs_table_name EGO_VALIDATION_TABLE_INFO_V.application_table_name%type; -- bug 14619994
3403: l_vs_value_column EGO_VALIDATION_TABLE_INFO_V.value_column_name%type; -- bug 14619994
3404: l_vs_id_column EGO_VALIDATION_TABLE_INFO_V.id_column_name%type; -- bug 14619994
3405: l_dynamic_query VARCHAR2(2000);
3406: l_disp_value LOCAL_BIG_VARCHAR_TABLE;
3407: l_attr_value_date VARCHAR2(50);

Line 3404: l_vs_id_column EGO_VALIDATION_TABLE_INFO_V.id_column_name%type; -- bug 14619994

3400: RETURN varchar2
3401: IS
3402: l_vs_table_name EGO_VALIDATION_TABLE_INFO_V.application_table_name%type; -- bug 14619994
3403: l_vs_value_column EGO_VALIDATION_TABLE_INFO_V.value_column_name%type; -- bug 14619994
3404: l_vs_id_column EGO_VALIDATION_TABLE_INFO_V.id_column_name%type; -- bug 14619994
3405: l_dynamic_query VARCHAR2(2000);
3406: l_disp_value LOCAL_BIG_VARCHAR_TABLE;
3407: l_attr_value_date VARCHAR2(50);
3408: l_validation_type VARCHAR2(10):= 'NULL';

Line 3428: FROM EGO_VALIDATION_TABLE_INFO_V

3424: l_vs_table_name,
3425: l_vs_value_column,
3426: l_vs_id_column,
3427: l_vs_where_clause
3428: FROM EGO_VALIDATION_TABLE_INFO_V
3429: WHERE id_column_name IS NOT NULL
3430: AND flex_value_set_id=p_attr_group_metadata_obj.attr_metadata_table(l_table_index).VALUE_SET_ID;
3431:
3432: ----bug 16073812