eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_UTIL_PVT dependencies on FND_FLEX_VALIDATION_TABLES

Line 5387: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

5383: l_procedure_body_status ALL_OBJECTS.status%TYPE;
5384: l_dummy VARCHAR2(1);
5385:
5386: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5387: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5388: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5389: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5390: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5391: l_sql_stmt LONG;

Line 5388: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

5384: l_dummy VARCHAR2(1);
5385:
5386: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5387: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5388: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5389: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5390: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5391: l_sql_stmt LONG;
5392: TYPE cur_typ IS REF CURSOR;

Line 5389: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

5385:
5386: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5387: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5388: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5389: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5390: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5391: l_sql_stmt LONG;
5392: TYPE cur_typ IS REF CURSOR;
5393: c_cursor cur_typ;

Line 5390: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

5386: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5387: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5388: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5389: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5390: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5391: l_sql_stmt LONG;
5392: TYPE cur_typ IS REF CURSOR;
5393: c_cursor cur_typ;
5394:

Line 5416: FROM fnd_flex_validation_tables

5412: SELECT application_table_name,
5413: value_column_name,
5414: id_column_name,
5415: additional_where_clause
5416: FROM fnd_flex_validation_tables
5417: WHERE flex_value_set_id = p_value_set_id;
5418:
5419: --Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
5420: