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

1133: SELECT application_table_name,
1134: value_column_name,
1135: id_column_name,
1136: additional_where_clause
1137: FROM fnd_flex_validation_tables
1138: WHERE flex_value_set_id = p_value_set_id;
1139:
1140: -- SQL for Valueset type Independent
1141: CURSOR csr_value_set_ind(p_flex_value_id IN NUMBER) IS

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

1145: AND enabled_flag = 'Y'
1146: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1147:
1148:
1149: TYPE NameList IS TABLE OF fnd_flex_validation_tables.value_column_name%TYPE INDEX BY BINARY_INTEGER;
1150: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1151:
1152: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_qst';
1153: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

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

1146: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1147:
1148:
1149: TYPE NameList IS TABLE OF fnd_flex_validation_tables.value_column_name%TYPE INDEX BY BINARY_INTEGER;
1150: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1151:
1152: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_qst';
1153: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1154: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

Line 1158: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

1154: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1155: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1156: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1157:
1158: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1159: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1160: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1161: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1162: l_sql_stmt LONG;

Line 1159: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

1155: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1156: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1157:
1158: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1159: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1160: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1161: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1162: l_sql_stmt LONG;
1163: l_error_message VARCHAR2(4000);

Line 1160: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

1156: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1157:
1158: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1159: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1160: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1161: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1162: l_sql_stmt LONG;
1163: l_error_message VARCHAR2(4000);
1164: l_found VARCHAR2(1);

Line 1161: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

1157:
1158: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1159: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1160: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1161: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1162: l_sql_stmt LONG;
1163: l_error_message VARCHAR2(4000);
1164: l_found VARCHAR2(1);
1165: l_dummy VARCHAR2(1);

Line 1175: tempName fnd_flex_validation_tables.value_column_name%TYPE ;

1171: c_cursor cur_typ;
1172:
1173: i number;
1174:
1175: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
1176: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1177:
1178:
1179: BEGIN

Line 1176: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

1172:
1173: i number;
1174:
1175: tempName fnd_flex_validation_tables.value_column_name%TYPE ;
1176: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1177:
1178:
1179: BEGIN
1180:

Line 1540: FROM fnd_flex_validation_tables

1536: SELECT application_table_name,
1537: value_column_name,
1538: id_column_name,
1539: additional_where_clause
1540: FROM fnd_flex_validation_tables
1541: WHERE flex_value_set_id = p_value_set_id;
1542:
1543: -- SQL for Valueset type Independent
1544: CURSOR csr_value_set_ind(p_flex_value_id IN NUMBER) IS

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

1560: AND concatenated_segments = p_concatenated_segments
1561: order by 1;
1562:
1563:
1564: --Bug 4691106 replaced fnd_flex_validation_tables.value_column_name%TYPE with VARCHAR2(1000)
1565: TYPE NameList IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
1566: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1567:
1568: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_var';

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

1562:
1563:
1564: --Bug 4691106 replaced fnd_flex_validation_tables.value_column_name%TYPE with VARCHAR2(1000)
1565: TYPE NameList IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
1566: TYPE IdList IS TABLE OF fnd_flex_validation_tables.id_column_name%TYPE INDEX BY BINARY_INTEGER;
1567:
1568: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_var';
1569: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1570: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

Line 1574: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;

1570: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1571: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1572: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1573:
1574: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1575: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1576: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1577: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1578: l_sql_stmt LONG;

Line 1575: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

1571: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1572: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1573:
1574: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1575: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1576: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1577: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1578: l_sql_stmt LONG;
1579: l_error_message VARCHAR2(4000);

Line 1576: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

1572: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1573:
1574: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1575: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1576: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1577: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1578: l_sql_stmt LONG;
1579: l_error_message VARCHAR2(4000);
1580: l_found VARCHAR2(1);

Line 1577: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

1573:
1574: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1575: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;
1576: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;
1577: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1578: l_sql_stmt LONG;
1579: l_error_message VARCHAR2(4000);
1580: l_found VARCHAR2(1);
1581: l_dummy VARCHAR2(1);

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

1587: c_cursor cur_typ;
1588:
1589: i number;
1590:
1591: --Bug 4691106 replaced tempName fnd_flex_validation_tables.value_column_name%TYPE ; with below stmt
1592: tempName VARCHAR2(1000) ;
1593: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1594:
1595: BEGIN

Line 1593: tempId fnd_flex_validation_tables.id_column_name%TYPE ;

1589: i number;
1590:
1591: --Bug 4691106 replaced tempName fnd_flex_validation_tables.value_column_name%TYPE ; with below stmt
1592: tempName VARCHAR2(1000) ;
1593: tempId fnd_flex_validation_tables.id_column_name%TYPE ;
1594:
1595: BEGIN
1596:
1597: -- start debug log