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 1372: p_qa_plan IN QA_PLANS_VAL_V.name%TYPE,

1368: PROCEDURE validate_qa_plan
1369: (
1370: x_return_status OUT NOCOPY VARCHAR2,
1371: x_msg_data OUT NOCOPY VARCHAR2,
1372: p_qa_plan IN QA_PLANS_VAL_V.name%TYPE,
1373: p_x_qa_plan_id IN OUT NOCOPY QA_PLANS_VAL_V.plan_id%TYPE
1374: )
1375: IS
1376:

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

1369: (
1370: x_return_status OUT NOCOPY VARCHAR2,
1371: x_msg_data OUT NOCOPY VARCHAR2,
1372: p_qa_plan IN QA_PLANS_VAL_V.name%TYPE,
1373: p_x_qa_plan_id IN OUT NOCOPY QA_PLANS_VAL_V.plan_id%TYPE
1374: )
1375: IS
1376:
1377: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;

Line 1377: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;

1373: p_x_qa_plan_id IN OUT NOCOPY QA_PLANS_VAL_V.plan_id%TYPE
1374: )
1375: IS
1376:
1377: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;
1378:
1379: CURSOR get_rec_from_value ( c_qa_plan QA_PLANS_VAL_V.name%TYPE )
1380: IS
1381: SELECT DISTINCT plan_id

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

1375: IS
1376:
1377: l_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE;
1378:
1379: CURSOR get_rec_from_value ( c_qa_plan QA_PLANS_VAL_V.name%TYPE )
1380: IS
1381: SELECT DISTINCT plan_id
1382: FROM QA_PLANS_VAL_V
1383: WHERE name = c_qa_plan;

Line 1382: FROM QA_PLANS_VAL_V

1378:
1379: CURSOR get_rec_from_value ( c_qa_plan QA_PLANS_VAL_V.name%TYPE )
1380: IS
1381: SELECT DISTINCT plan_id
1382: FROM QA_PLANS_VAL_V
1383: WHERE name = c_qa_plan;
1384:
1385: CURSOR get_rec_from_id ( c_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE )
1386: IS

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

1381: SELECT DISTINCT plan_id
1382: FROM QA_PLANS_VAL_V
1383: WHERE name = c_qa_plan;
1384:
1385: CURSOR get_rec_from_id ( c_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE )
1386: IS
1387: SELECT DISTINCT plan_id
1388: FROM QA_PLANS_VAL_V
1389: WHERE plan_id = c_qa_plan_id;

Line 1388: FROM QA_PLANS_VAL_V

1384:
1385: CURSOR get_rec_from_id ( c_qa_plan_id QA_PLANS_VAL_V.plan_id%TYPE )
1386: IS
1387: SELECT DISTINCT plan_id
1388: FROM QA_PLANS_VAL_V
1389: WHERE plan_id = c_qa_plan_id;
1390:
1391: BEGIN
1392: x_return_status := FND_API.G_RET_STS_SUCCESS;