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 5338: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

5334: l_procedure_body_status ALL_OBJECTS.status%TYPE;
5335: l_dummy VARCHAR2(1);
5336:
5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5338: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5339: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5340: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5341: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5342: l_sql_stmt LONG;

Line 5339: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

5335: l_dummy VARCHAR2(1);
5336:
5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5338: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5339: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5340: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5341: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5342: l_sql_stmt LONG;
5343: TYPE cur_typ IS REF CURSOR;

Line 5340: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

5336:
5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5338: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5339: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5340: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5341: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5342: l_sql_stmt LONG;
5343: TYPE cur_typ IS REF CURSOR;
5344: c_cursor cur_typ;

Line 5341: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

5337: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
5338: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5339: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5340: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5341: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5342: l_sql_stmt LONG;
5343: TYPE cur_typ IS REF CURSOR;
5344: c_cursor cur_typ;
5345:

Line 5367: FROM fnd_flex_validation_tables

5363: SELECT application_table_name,
5364: value_column_name,
5365: id_column_name,
5366: additional_where_clause
5367: FROM fnd_flex_validation_tables
5368: WHERE flex_value_set_id = p_value_set_id;
5369:
5370: --Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
5371: