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 5379: FROM fnd_flex_validation_tables

5375: SELECT application_table_name,
5376: value_column_name,
5377: id_column_name,
5378: additional_where_clause
5379: FROM fnd_flex_validation_tables
5380: WHERE flex_value_set_id = p_value_set_id;
5381:
5382: -- cursor to find datatype of a question
5383: CURSOR csr_get_qst_datatype is

Line 5401: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

5397: l_variable_value varchar2(1000) := null;
5398: l_variable_translated_value varchar2(1000) := null;
5399: l_question_value varchar2(1000) := null;
5400: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5401: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5402: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5403: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5404: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5405: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

Line 5402: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

5398: l_variable_translated_value varchar2(1000) := null;
5399: l_question_value varchar2(1000) := null;
5400: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5401: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5402: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5403: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5404: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5405: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5406: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

Line 5403: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

5399: l_question_value varchar2(1000) := null;
5400: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5401: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5402: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5403: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5404: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5405: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5406: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5407: l_sql_stmt LONG;

Line 5404: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

5400: l_final_document_value varchar2(1000) := null; --contains final document value to be returned
5401: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5402: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5403: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5404: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5405: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5406: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5407: l_sql_stmt LONG;
5408: l_config_header_id number;

Line 5405: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

5401: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
5402: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5403: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5404: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5405: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5406: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5407: l_sql_stmt LONG;
5408: l_config_header_id number;
5409: l_config_rev_nbr number;

Line 5406: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

5402: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
5403: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
5404: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
5405: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
5406: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
5407: l_sql_stmt LONG;
5408: l_config_header_id number;
5409: l_config_rev_nbr number;
5410: l_is_rule_line_level varchar2(1);

Line 5878: from fnd_flex_validation_tables val_tab

5874: val_tab.value_column_name,
5875: val_tab.id_column_name,
5876: val_tab.additional_where_clause,
5877: val_tab.meaning_column_name
5878: from fnd_flex_validation_tables val_tab
5879: where val_tab.FLEX_VALUE_SET_ID = p_object_value_set_id ;
5880:
5881: l_value VARCHAR2(1000) := null;
5882:

Line 5988: from fnd_flex_validation_tables val_tab

5984: val_tab.value_column_name,
5985: val_tab.id_column_name,
5986: val_tab.additional_where_clause,
5987: val_tab.meaning_column_name
5988: from fnd_flex_validation_tables val_tab
5989: where val_tab.FLEX_VALUE_SET_ID = p_object_value_set_id ;
5990:
5991: l_value VARCHAR2(1000) := null;
5992: