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.AHL_RM_ROUTE_UTIL dependencies on QA_PLANS_VAL_V

Line 1451: p_qa_plan IN QA_PLANS_VAL_V.name%TYPE,

1447: PROCEDURE validate_qa_plan
1448: (
1449: x_return_status OUT NOCOPY VARCHAR2,
1450: x_msg_data OUT NOCOPY VARCHAR2,
1451: p_qa_plan IN QA_PLANS_VAL_V.name%TYPE,
1452: p_x_qa_plan_id IN OUT NOCOPY QA_PLANS_VAL_V.plan_id%TYPE
1453: )
1454: IS
1455:

Line 1452: p_x_qa_plan_id IN OUT NOCOPY QA_PLANS_VAL_V.plan_id%TYPE

1448: (
1449: x_return_status OUT NOCOPY VARCHAR2,
1450: x_msg_data OUT NOCOPY VARCHAR2,
1451: p_qa_plan IN QA_PLANS_VAL_V.name%TYPE,
1452: p_x_qa_plan_id IN OUT NOCOPY QA_PLANS_VAL_V.plan_id%TYPE
1453: )
1454: IS
1455:
1456: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;

Line 1456: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;

1452: p_x_qa_plan_id IN OUT NOCOPY QA_PLANS_VAL_V.plan_id%TYPE
1453: )
1454: IS
1455:
1456: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;
1457:
1458: CURSOR get_rec_from_value ( c_qa_plan QA_PLANS_VAL_V.name%TYPE )
1459: IS
1460: SELECT DISTINCT plan_id

Line 1458: CURSOR get_rec_from_value ( c_qa_plan QA_PLANS_VAL_V.name%TYPE )

1454: IS
1455:
1456: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;
1457:
1458: CURSOR get_rec_from_value ( c_qa_plan QA_PLANS_VAL_V.name%TYPE )
1459: IS
1460: SELECT DISTINCT plan_id
1461: FROM QA_PLANS_VAL_V
1462: WHERE name = c_qa_plan;

Line 1461: FROM QA_PLANS_VAL_V

1457:
1458: CURSOR get_rec_from_value ( c_qa_plan QA_PLANS_VAL_V.name%TYPE )
1459: IS
1460: SELECT DISTINCT plan_id
1461: FROM QA_PLANS_VAL_V
1462: WHERE name = c_qa_plan;
1463:
1464: CURSOR get_rec_from_id ( c_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE )
1465: IS

Line 1464: CURSOR get_rec_from_id ( c_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE )

1460: SELECT DISTINCT plan_id
1461: FROM QA_PLANS_VAL_V
1462: WHERE name = c_qa_plan;
1463:
1464: CURSOR get_rec_from_id ( c_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE )
1465: IS
1466: SELECT DISTINCT plan_id
1467: FROM QA_PLANS_VAL_V
1468: WHERE plan_id = c_qa_plan_id;

Line 1467: FROM QA_PLANS_VAL_V

1463:
1464: CURSOR get_rec_from_id ( c_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE )
1465: IS
1466: SELECT DISTINCT plan_id
1467: FROM QA_PLANS_VAL_V
1468: WHERE plan_id = c_qa_plan_id;
1469:
1470: BEGIN
1471: x_return_status := FND_API.G_RET_STS_SUCCESS;