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_VALUE_SETS

Line 1128: FROM FND_FLEX_VALUE_SETS

1124:
1125: CURSOR csr_value_set_dtls(p_value_set_name IN VARCHAR2) IS
1126: SELECT validation_type,
1127: flex_value_set_id
1128: FROM FND_FLEX_VALUE_SETS
1129: WHERE flex_value_set_name = p_value_set_name;
1130:
1131: -- Create Dynamic sql for the valueset for Table
1132: CURSOR csr_value_set_tab(p_value_set_id IN NUMBER) IS

Line 1153: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

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;
1155: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1156: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1157:

Line 1154: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

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;
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;

Line 1531: FROM FND_FLEX_VALUE_SETS

1527:
1528: CURSOR csr_value_set_dtls(p_value_set_name IN VARCHAR2) IS
1529: SELECT validation_type,
1530: flex_value_set_id
1531: FROM FND_FLEX_VALUE_SETS
1532: WHERE flex_value_set_name = p_value_set_name;
1533:
1534: -- Create Dynamic sql for the valueset for Table
1535: CURSOR csr_value_set_tab(p_value_set_id IN NUMBER) IS

Line 1569: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

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;
1571: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1572: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1573:

Line 1570: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

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;
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;