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 1057: FROM FND_FLEX_VALUE_SETS

1053:
1054: CURSOR csr_value_set_dtls(p_value_set_name IN VARCHAR2) IS
1055: SELECT validation_type,
1056: flex_value_set_id
1057: FROM FND_FLEX_VALUE_SETS
1058: WHERE flex_value_set_name = p_value_set_name;
1059:
1060: -- Create Dynamic sql for the valueset for Table
1061: CURSOR csr_value_set_tab(p_value_set_id IN NUMBER) IS

Line 1082: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

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;
1084: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1085: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1086:

Line 1083: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

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

Line 1460: FROM FND_FLEX_VALUE_SETS

1456:
1457: CURSOR csr_value_set_dtls(p_value_set_name IN VARCHAR2) IS
1458: SELECT validation_type,
1459: flex_value_set_id
1460: FROM FND_FLEX_VALUE_SETS
1461: WHERE flex_value_set_name = p_value_set_name;
1462:
1463: -- Create Dynamic sql for the valueset for Table
1464: CURSOR csr_value_set_tab(p_value_set_id IN NUMBER) IS

Line 1498: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

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;
1500: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1501: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1502:

Line 1499: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;

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