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_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISIT_TASKS_B

Line 86: FROM Ahl_Visit_Tasks_B

82: IS
83: -- To find out the maximum task number value in the visit
84: CURSOR c_task_number IS
85: SELECT visit_task_number
86: FROM Ahl_Visit_Tasks_B
87: WHERE Visit_Id = p_visit_id
88: and visit_task_number = p_task_number;
89:
90: CURSOR gen_task_number IS

Line 92: FROM Ahl_Visit_Tasks_B

88: and visit_task_number = p_task_number;
89:
90: CURSOR gen_task_number IS
91: SELECT MAX(visit_task_number)
92: FROM Ahl_Visit_Tasks_B
93: WHERE Visit_Id = p_visit_id;
94:
95: x_Visit_Task_Number NUMBER;
96: BEGIN

Line 1517: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b

1513:
1514: -- To find the coresponding task id in the new visit
1515: CURSOR c_new_task_ID(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
1516: SELECT b.VISIT_TASK_ID
1517: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b
1518: WHERE a.visit_task_id = x_visit_task_id
1519: AND a.visit_task_number = b.visit_task_number
1520: AND b.visit_id = x_new_visit_id;
1521:

Line 1545: FROM AHL_VISIT_TASKS_B

1541: ATTRIBUTE14,
1542: ATTRIBUTE15
1543: FROM AHL_TASK_LINKS
1544: WHERE visit_task_id in (SELECT VISIT_TASK_ID
1545: FROM AHL_VISIT_TASKS_B
1546: WHERE visit_id = x_visit_id);
1547:
1548: --To get the stages from a visit
1549: CURSOR Get_stages_cur(c_visit_id IN NUMBER) IS

Line 1580: VISIT_ID IN (SELECT DISTINCT VISIT_ID FROM AHL_VISIT_TASKS_B WHERE

1576:
1577: -- Added by mpothuku on 01/20/05 To find if this Unit has been planned in other visits already
1578: CURSOR chk_unit_effectivities (c_unit_id IN NUMBER, c_plan_id IN NUMBER,c_visit_id IN NUMBER) IS
1579: SELECT VISIT_NUMBER,ASSO_PRIMARY_VISIT_ID FROM AHL_VISITS_B WHERE
1580: VISIT_ID IN (SELECT DISTINCT VISIT_ID FROM AHL_VISIT_TASKS_B WHERE
1581: Unit_Effectivity_Id = c_unit_id)
1582: --The following condition is necessary since the summary task may already have been
1583: --added to the current visit which will have the same UE as the planned task
1584: and visit_id <> c_visit_id

Line 1986: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO

1982: END IF;
1983: FETCH get_visit_task_cur INTO l_visit_task_rec;
1984: EXIT WHEN get_visit_task_cur%NOTFOUND;
1985: -- Get visit task id
1986: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO
1987: l_visit_task_id FROM dual;
1988: --
1989: IF G_DEBUG='Y' THEN
1990: AHL_DEBUG_PUB.debug( 'visit call insert task:'||l_visit_task_id);

Line 2172: UPDATE AHL_VISIT_TASKS_B SET

2168: FETCH c_new_stage_id INTO l_stage_id;
2169: CLOSE c_new_stage_id;
2170: END IF;
2171:
2172: UPDATE AHL_VISIT_TASKS_B SET
2173: cost_parent_id = l_cost_parent_id,
2174: originating_task_id = l_originating_task_id,
2175: stage_id = l_stage_id
2176: where visit_task_id = l_new_task_id;

Line 2453: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

2449: WHERE visit_id = c_visit_id;
2450: --
2451: -- Added by mpothuku on 12/27/04 to find any task links for a task
2452: CURSOR c_links (x_id IN NUMBER) IS
2453: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
2454: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
2455: AND T.VISIT_TASK_ID = x_id;
2456:
2457: --To check if the unplanned tasks UE is associated with any other visits other than itself before its deletion.

Line 2459: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id

2455: AND T.VISIT_TASK_ID = x_id;
2456:
2457: --To check if the unplanned tasks UE is associated with any other visits other than itself before its deletion.
2458: CURSOR check_unplanned_ue_assoc(c_ue_id IN NUMBER, c_visit_id IN NUMBER) IS
2459: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id
2460: AND visit_id <> c_visit_id;
2461:
2462: CURSOR check_summary_task_unplanned(c_originating_task_id IN NUMBER) IS
2463: SELECT 'X' from ahl_visit_tasks_b where

Line 2463: SELECT 'X' from ahl_visit_tasks_b where

2459: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id
2460: AND visit_id <> c_visit_id;
2461:
2462: CURSOR check_summary_task_unplanned(c_originating_task_id IN NUMBER) IS
2463: SELECT 'X' from ahl_visit_tasks_b where
2464: originating_task_id = c_originating_task_id and task_type_code = 'UNPLANNED';
2465:
2466:
2467: --

Line 3355: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

3351: --
3352: -- Added by mpothuku on 12/27/04
3353: -- To find any task links for a task
3354: CURSOR c_links (x_id IN NUMBER) IS
3355: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
3356: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
3357: AND T.VISIT_TASK_ID = x_id;
3358:
3359: -- To find task link related information for a visit

Line 3382: FROM AHL_VISIT_TASKS_B

3378: ATTRIBUTE14,
3379: ATTRIBUTE15
3380: FROM AHL_TASK_LINKS
3381: WHERE visit_task_id in ( SELECT VISIT_TASK_ID
3382: FROM AHL_VISIT_TASKS_B
3383: WHERE visit_id = x_visit_id);
3384: -- To find the coresponding task id in the new visit
3385: CURSOR c_new_task(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
3386: SELECT b.VISIT_TASK_ID,b.VISIT_TASK_NUMBER

Line 3387: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b

3383: WHERE visit_id = x_visit_id);
3384: -- To find the coresponding task id in the new visit
3385: CURSOR c_new_task(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
3386: SELECT b.VISIT_TASK_ID,b.VISIT_TASK_NUMBER
3387: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b
3388: WHERE a.visit_task_id = x_visit_task_id
3389: AND a.visit_task_number = b.visit_task_number
3390: AND b.visit_id = x_new_visit_id;
3391:

Line 3433: VISIT_ID IN (SELECT DISTINCT VISIT_ID FROM AHL_VISIT_TASKS_B WHERE

3429:
3430: -- Added by mpothuku on 01/20/05 To find if this Unit has been planned in other visits already
3431: CURSOR chk_unit_effectivities (c_unit_id IN NUMBER,c_visit_id IN NUMBER) IS
3432: SELECT VISIT_NUMBER FROM AHL_VISITS_B ahlv ,AHL_SIMULATION_PLANS_B ahlp WHERE
3433: VISIT_ID IN (SELECT DISTINCT VISIT_ID FROM AHL_VISIT_TASKS_B WHERE
3434: Unit_Effectivity_Id = c_unit_id)
3435: and visit_id <> c_visit_id
3436: and ahlv.simulation_plan_id = ahlp.simulation_plan_id
3437: and ahlp.primary_plan_flag = 'Y'

Line 3502: ahl_visit_tasks_b prim, ahl_visit_tasks_b sim

3498: WHERE visit_task_id = c_task_id;
3499:
3500: CURSOR c_new_primary_task (c_simulation_task_id IN NUMBER) IS
3501: SELECT prim.visit_task_id, prim.visit_task_number FROM
3502: ahl_visit_tasks_b prim, ahl_visit_tasks_b sim
3503: WHERE
3504: sim.visit_task_id = c_simulation_task_id and
3505: prim.visit_task_id = sim.primary_visit_task_id;
3506:

Line 4082: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO

4078: 2. The task is created in the Simulation visit.
4079: */
4080: THEN
4081: /* Added by mpothuku on 01/11/04 to insert new row into the PrimaryVisit */
4082: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO
4083: l_visit_task_id FROM dual;
4084:
4085: IF G_DEBUG='Y' THEN
4086: AHL_DEBUG_PUB.debug( 'visit call insert new task created in simulation:'||l_simul_visit_task_rec.visit_task_number);

Line 4148: UPDATE ahl_visit_tasks_b

4144: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4145: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4146: );
4147: /* Need to update the simulation_visit's primary_visit_task_id with the Id thats generated here */
4148: UPDATE ahl_visit_tasks_b
4149: SET primary_visit_task_id = l_visit_task_id
4150: WHERE visit_task_id = l_simul_visit_task_rec.visit_task_id;
4151:
4152: END IF;