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

Line 1337: FROM fnd_flex_validation_tables

1333: SELECT application_table_name,
1334: value_column_name,
1335: id_column_name,
1336: additional_where_clause
1337: FROM fnd_flex_validation_tables
1338: WHERE flex_value_set_id = p_value_set_id;
1339:
1340: -- SQL for Valueset type Independent
1341: CURSOR csr_value_set_ind IS

Line 1369: TYPE NameList IS TABLE OF fnd_flex_validation_tables.value_column_name%TYPE INDEX BY BINARY_INTEGER;

1365:
1366: l_api_name CONSTANT VARCHAR2(30) := 'create_template_options';
1367:
1368: TYPE SeqNoList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1369: TYPE NameList IS TABLE OF fnd_flex_validation_tables.value_column_name%TYPE INDEX BY BINARY_INTEGER;
1370: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1371:
1372: i number;
1373: tempSeqNo NUMBER;

Line 1370: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;

1366: l_api_name CONSTANT VARCHAR2(30) := 'create_template_options';
1367:
1368: TYPE SeqNoList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1369: TYPE NameList IS TABLE OF fnd_flex_validation_tables.value_column_name%TYPE INDEX BY BINARY_INTEGER;
1370: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1371:
1372: i number;
1373: tempSeqNo NUMBER;
1374: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

Line 1374: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

1370: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1371:
1372: i number;
1373: tempSeqNo NUMBER;
1374: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
1375: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1376:
1377: SeqNoList_tbl SeqNoList;
1378: NameList_tbl NameList;

Line 1375: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

1371:
1372: i number;
1373: tempSeqNo NUMBER;
1374: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
1375: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1376:
1377: SeqNoList_tbl SeqNoList;
1378: NameList_tbl NameList;
1379: IdList_tbl IdList;

Line 1382: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

1378: NameList_tbl NameList;
1379: IdList_tbl IdList;
1380:
1381:
1382: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1383: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1384: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1385: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1386: l_sql_stmt LONG;

Line 1383: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

1379: IdList_tbl IdList;
1380:
1381:
1382: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1383: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1384: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1385: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1386: l_sql_stmt LONG;
1387: l_sequence_sql_stmt LONG;

Line 1384: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

1380:
1381:
1382: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1383: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1384: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1385: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1386: l_sql_stmt LONG;
1387: l_sequence_sql_stmt LONG;
1388: l_error_message VARCHAR2(4000);

Line 1385: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

1381:
1382: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1383: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1384: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1385: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1386: l_sql_stmt LONG;
1387: l_sequence_sql_stmt LONG;
1388: l_error_message VARCHAR2(4000);
1389: l_valueset_type fnd_flex_value_sets.validation_type%TYPE;