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_XPRT_UTIL_PVT dependencies on FND_FLEX_VALIDATION_TABLES

Line 5181: FROM fnd_flex_validation_tables

5177: SELECT application_table_name,
5178: value_column_name,
5179: id_column_name,
5180: additional_where_clause
5181: FROM fnd_flex_validation_tables
5182: WHERE flex_value_set_id = p_value_set_id;
5183:
5184: -- cursor to find datatype of a question
5185: CURSOR csr_get_qst_datatype is

Line 5203: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

5199: l_variable_value varchar2(1000) := null;
5200: l_variable_translated_value varchar2(1000) := null;
5201: l_question_value varchar2(1000) := null;
5202: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5203: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5204: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5205: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5206: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5207: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

Line 5204: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

5200: l_variable_translated_value varchar2(1000) := null;
5201: l_question_value varchar2(1000) := null;
5202: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5203: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5204: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5205: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5206: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5207: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5208: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

Line 5205: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

5201: l_question_value varchar2(1000) := null;
5202: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5203: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5204: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5205: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5206: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5207: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5208: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5209: l_sql_stmt LONG;

Line 5206: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

5202: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5203: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5204: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5205: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5206: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5207: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5208: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5209: l_sql_stmt LONG;
5210: l_config_header_id number;

Line 5207: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

5203: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5204: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5205: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5206: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5207: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5208: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5209: l_sql_stmt LONG;
5210: l_config_header_id number;
5211: l_config_rev_nbr number;

Line 5208: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

5204: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5205: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5206: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5207: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5208: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5209: l_sql_stmt LONG;
5210: l_config_header_id number;
5211: l_config_rev_nbr number;
5212: l_is_rule_line_level varchar2(1);

Line 5680: from fnd_flex_validation_tables val_tab

5676: val_tab.value_column_name,
5677: val_tab.id_column_name,
5678: val_tab.additional_where_clause,
5679: val_tab.meaning_column_name
5680: from fnd_flex_validation_tables val_tab
5681: where val_tab.FLEX_VALUE_SET_ID = p_object_value_set_id ;
5682:
5683: l_value VARCHAR2(1000) := null;
5684:

Line 5790: from fnd_flex_validation_tables val_tab

5786: val_tab.value_column_name,
5787: val_tab.id_column_name,
5788: val_tab.additional_where_clause,
5789: val_tab.meaning_column_name
5790: from fnd_flex_validation_tables val_tab
5791: where val_tab.FLEX_VALUE_SET_ID = p_object_value_set_id ;
5792:
5793: l_value VARCHAR2(1000) := null;
5794: