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.PO_EDA_DATATEMPLATE_PKG dependencies on FND_FLEX_VALIDATION_TABLES

Line 2027: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

2023: x_sys_var_value_tbl OKC_TERMS_UTIL_GRP.sys_var_value_tbl_type;
2024:
2025: l_variable_value VARCHAR2(4000);
2026: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
2027: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
2028: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
2029: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
2030: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
2031: l_sql_stmt LONG;

Line 2028: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

2024:
2025: l_variable_value VARCHAR2(4000);
2026: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
2027: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
2028: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
2029: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
2030: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
2031: l_sql_stmt LONG;
2032: TYPE cur_typ IS REF CURSOR;

Line 2029: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

2025: l_variable_value VARCHAR2(4000);
2026: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
2027: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
2028: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
2029: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
2030: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
2031: l_sql_stmt LONG;
2032: TYPE cur_typ IS REF CURSOR;
2033: c_cursor cur_typ;

Line 2030: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

2026: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
2027: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
2028: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
2029: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
2030: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
2031: l_sql_stmt LONG;
2032: TYPE cur_typ IS REF CURSOR;
2033: c_cursor cur_typ;
2034:

Line 2047: FROM fnd_flex_validation_tables

2043: SELECT application_table_name,
2044: value_column_name,
2045: id_column_name,
2046: additional_where_clause
2047: FROM fnd_flex_validation_tables
2048: WHERE flex_value_set_id = p_value_set_id;
2049:
2050:
2051: PROCEDURE Get_System_Variables (