APPS.AHL_RM_ROUTE_UTIL dependencies on QA_CHAR_VALUE_LOOKUPS_V

Line 1359: p_qa_inspection_type_desc IN QA_CHAR_VALUE_LOOKUPS_V.description%TYPE,

1355: PROCEDURE validate_qa_inspection_type
1356: (
1357: x_return_status OUT NOCOPY VARCHAR2,
1358: x_msg_data OUT NOCOPY VARCHAR2,
1359: p_qa_inspection_type_desc IN QA_CHAR_VALUE_LOOKUPS_V.description%TYPE,
1360: p_x_qa_inspection_type IN OUT NOCOPY QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE
1361: )
1362: IS
1363:

Line 1360: p_x_qa_inspection_type IN OUT NOCOPY QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE

1356: (
1357: x_return_status OUT NOCOPY VARCHAR2,
1358: x_msg_data OUT NOCOPY VARCHAR2,
1359: p_qa_inspection_type_desc IN QA_CHAR_VALUE_LOOKUPS_V.description%TYPE,
1360: p_x_qa_inspection_type IN OUT NOCOPY QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE
1361: )
1362: IS
1363:
1364: l_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE;

Line 1364: l_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE;

1360: p_x_qa_inspection_type IN OUT NOCOPY QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE
1361: )
1362: IS
1363:
1364: l_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE;
1365:
1366: CURSOR get_rec_from_value ( c_qa_inspection_type_desc QA_CHAR_VALUE_LOOKUPS_V.description%TYPE )
1367: IS
1368: SELECT DISTINCT short_code

Line 1366: CURSOR get_rec_from_value ( c_qa_inspection_type_desc QA_CHAR_VALUE_LOOKUPS_V.description%TYPE )

1362: IS
1363:
1364: l_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE;
1365:
1366: CURSOR get_rec_from_value ( c_qa_inspection_type_desc QA_CHAR_VALUE_LOOKUPS_V.description%TYPE )
1367: IS
1368: SELECT DISTINCT short_code
1369: FROM QA_CHAR_VALUE_LOOKUPS_V
1370: --WHERE description = c_qa_inspection_type_desc; fix for the bug 9397756

Line 1369: FROM QA_CHAR_VALUE_LOOKUPS_V

1365:
1366: CURSOR get_rec_from_value ( c_qa_inspection_type_desc QA_CHAR_VALUE_LOOKUPS_V.description%TYPE )
1367: IS
1368: SELECT DISTINCT short_code
1369: FROM QA_CHAR_VALUE_LOOKUPS_V
1370: --WHERE description = c_qa_inspection_type_desc; fix for the bug 9397756
1371: WHERE char_id=87 AND description = c_qa_inspection_type_desc;
1372:
1373: CURSOR get_rec_from_id ( c_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE )

Line 1373: CURSOR get_rec_from_id ( c_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE )

1369: FROM QA_CHAR_VALUE_LOOKUPS_V
1370: --WHERE description = c_qa_inspection_type_desc; fix for the bug 9397756
1371: WHERE char_id=87 AND description = c_qa_inspection_type_desc;
1372:
1373: CURSOR get_rec_from_id ( c_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE )
1374: IS
1375: SELECT DISTINCT short_code
1376: FROM QA_CHAR_VALUE_LOOKUPS_V
1377: WHERE short_code = c_qa_inspection_type;

Line 1376: FROM QA_CHAR_VALUE_LOOKUPS_V

1372:
1373: CURSOR get_rec_from_id ( c_qa_inspection_type QA_CHAR_VALUE_LOOKUPS_V.short_code%TYPE )
1374: IS
1375: SELECT DISTINCT short_code
1376: FROM QA_CHAR_VALUE_LOOKUPS_V
1377: WHERE short_code = c_qa_inspection_type;
1378:
1379: BEGIN
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;