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

Line 1066: FROM fnd_flex_validation_tables

1062: SELECT application_table_name,
1063: value_column_name,
1064: id_column_name,
1065: additional_where_clause
1066: FROM fnd_flex_validation_tables
1067: WHERE flex_value_set_id = p_value_set_id;
1068:
1069: -- SQL for Valueset type Independent
1070: CURSOR csr_value_set_ind(p_flex_value_id IN NUMBER) IS

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

1074: AND enabled_flag = 'Y'
1075: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1076:
1077:
1078: TYPE NameList IS TABLE OF fnd_flex_validation_tables.value_column_name%TYPE INDEX BY BINARY_INTEGER;
1079: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1080:
1081: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_qst';
1082: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

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

1075: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1076:
1077:
1078: TYPE NameList IS TABLE OF fnd_flex_validation_tables.value_column_name%TYPE INDEX BY BINARY_INTEGER;
1079: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1080:
1081: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_qst';
1082: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1083: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

Line 1087: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

1083: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1084: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1085: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1086:
1087: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1088: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1089: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1090: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1091: l_sql_stmt LONG;

Line 1088: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

1084: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1085: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1086:
1087: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1088: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1089: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1090: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1091: l_sql_stmt LONG;
1092: l_error_message VARCHAR2(4000);

Line 1089: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

1085: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1086:
1087: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1088: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1089: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1090: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1091: l_sql_stmt LONG;
1092: l_error_message VARCHAR2(4000);
1093: l_found VARCHAR2(1);

Line 1090: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

1086:
1087: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1088: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1089: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1090: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1091: l_sql_stmt LONG;
1092: l_error_message VARCHAR2(4000);
1093: l_found VARCHAR2(1);
1094: l_dummy VARCHAR2(1);

Line 1104: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

1100: c_cursor cur_typ;
1101:
1102: i number;
1103:
1104: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
1105: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1106:
1107:
1108: BEGIN

Line 1105: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

1101:
1102: i number;
1103:
1104: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
1105: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1106:
1107:
1108: BEGIN
1109:

Line 1469: FROM fnd_flex_validation_tables

1465: SELECT application_table_name,
1466: value_column_name,
1467: id_column_name,
1468: additional_where_clause
1469: FROM fnd_flex_validation_tables
1470: WHERE flex_value_set_id = p_value_set_id;
1471:
1472: -- SQL for Valueset type Independent
1473: CURSOR csr_value_set_ind(p_flex_value_id IN NUMBER) IS

Line 1493: --Bug 4691106 replaced fnd_flex_validation_tables.value_column_name%TYPE with VARCHAR2(1000)

1489: AND concatenated_segments = p_concatenated_segments
1490: order by 1;
1491:
1492:
1493: --Bug 4691106 replaced fnd_flex_validation_tables.value_column_name%TYPE with VARCHAR2(1000)
1494: TYPE NameList IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
1495: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1496:
1497: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_var';

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

1491:
1492:
1493: --Bug 4691106 replaced fnd_flex_validation_tables.value_column_name%TYPE with VARCHAR2(1000)
1494: TYPE NameList IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
1495: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1496:
1497: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_var';
1498: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1499: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

Line 1503: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

1499: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1500: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1501: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1502:
1503: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1504: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1505: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1506: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1507: l_sql_stmt LONG;

Line 1504: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

1500: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1501: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1502:
1503: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1504: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1505: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1506: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1507: l_sql_stmt LONG;
1508: l_error_message VARCHAR2(4000);

Line 1505: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

1501: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1502:
1503: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1504: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1505: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1506: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1507: l_sql_stmt LONG;
1508: l_error_message VARCHAR2(4000);
1509: l_found VARCHAR2(1);

Line 1506: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

1502:
1503: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1504: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1505: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1506: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1507: l_sql_stmt LONG;
1508: l_error_message VARCHAR2(4000);
1509: l_found VARCHAR2(1);
1510: l_dummy VARCHAR2(1);

Line 1520: --Bug 4691106 replaced tempName fnd_flex_validation_tables.value_column_name%TYPE ; with below stmt

1516: c_cursor cur_typ;
1517:
1518: i number;
1519:
1520: --Bug 4691106 replaced tempName fnd_flex_validation_tables.value_column_name%TYPE ; with below stmt
1521: tempName VARCHAR2(1000) ;
1522: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1523:
1524: BEGIN

Line 1522: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

1518: i number;
1519:
1520: --Bug 4691106 replaced tempName fnd_flex_validation_tables.value_column_name%TYPE ; with below stmt
1521: tempName VARCHAR2(1000) ;
1522: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1523:
1524: BEGIN
1525:
1526: -- start debug log