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 1533: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b

1529:
1530: -- To find the coresponding task id in the new visit
1531: CURSOR c_new_task_ID(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
1532: SELECT b.VISIT_TASK_ID
1533: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b
1534: WHERE a.visit_task_id = x_visit_task_id
1535: AND a.visit_task_number = b.visit_task_number
1536: AND b.visit_id = x_new_visit_id;
1537:

Line 1561: FROM AHL_VISIT_TASKS_B

1557: ATTRIBUTE14,
1558: ATTRIBUTE15
1559: FROM AHL_TASK_LINKS
1560: WHERE visit_task_id in (SELECT VISIT_TASK_ID
1561: FROM AHL_VISIT_TASKS_B
1562: WHERE visit_id = x_visit_id);
1563:
1564: --To get the stages from a visit
1565: CURSOR Get_stages_cur(c_visit_id IN NUMBER) IS

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

1592:
1593: -- Added by mpothuku on 01/20/05 To find if this Unit has been planned in other visits already
1594: CURSOR chk_unit_effectivities (c_unit_id IN NUMBER, c_plan_id IN NUMBER,c_visit_id IN NUMBER) IS
1595: SELECT VISIT_NUMBER,ASSO_PRIMARY_VISIT_ID FROM AHL_VISITS_B WHERE
1596: VISIT_ID IN (SELECT DISTINCT VISIT_ID FROM AHL_VISIT_TASKS_B WHERE
1597: Unit_Effectivity_Id = c_unit_id)
1598: --The following condition is necessary since the summary task may already have been
1599: --added to the current visit which will have the same UE as the planned task
1600: and visit_id <> c_visit_id

Line 2018: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO

2014: END IF;
2015: FETCH get_visit_task_cur INTO l_visit_task_rec;
2016: EXIT WHEN get_visit_task_cur%NOTFOUND;
2017: -- Get visit task id
2018: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO
2019: l_visit_task_id FROM dual;
2020: --
2021: IF G_DEBUG='Y' THEN
2022: AHL_DEBUG_PUB.debug( 'visit call insert task:'||l_visit_task_id);

Line 2211: UPDATE AHL_VISIT_TASKS_B SET

2207: FETCH c_new_stage_id INTO l_stage_id;
2208: CLOSE c_new_stage_id;
2209: END IF;
2210:
2211: UPDATE AHL_VISIT_TASKS_B SET
2212: cost_parent_id = l_cost_parent_id,
2213: originating_task_id = l_originating_task_id,
2214: stage_id = l_stage_id
2215: where visit_task_id = l_new_task_id;

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

2488: WHERE visit_id = c_visit_id;
2489: --
2490: -- Added by mpothuku on 12/27/04 to find any task links for a task
2491: CURSOR c_links (x_id IN NUMBER) IS
2492: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
2493: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
2494: AND T.VISIT_TASK_ID = x_id;
2495:
2496: --To check if the unplanned tasks UE is associated with any other visits other than itself before its deletion.

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

2494: AND T.VISIT_TASK_ID = x_id;
2495:
2496: --To check if the unplanned tasks UE is associated with any other visits other than itself before its deletion.
2497: CURSOR check_unplanned_ue_assoc(c_ue_id IN NUMBER, c_visit_id IN NUMBER) IS
2498: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id
2499: AND visit_id <> c_visit_id;
2500:
2501: CURSOR check_summary_task_unplanned(c_originating_task_id IN NUMBER) IS
2502: SELECT 'X' from ahl_visit_tasks_b where

Line 2502: SELECT 'X' from ahl_visit_tasks_b where

2498: SELECT 'X' from ahl_visit_tasks_b where unit_effectivity_id = c_ue_id
2499: AND visit_id <> c_visit_id;
2500:
2501: CURSOR check_summary_task_unplanned(c_originating_task_id IN NUMBER) IS
2502: SELECT 'X' from ahl_visit_tasks_b where
2503: originating_task_id = c_originating_task_id and task_type_code = 'UNPLANNED';
2504:
2505:
2506: --

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

3397: --
3398: -- Added by mpothuku on 12/27/04
3399: -- To find any task links for a task
3400: CURSOR c_links (x_id IN NUMBER) IS
3401: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
3402: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
3403: AND T.VISIT_TASK_ID = x_id;
3404:
3405: -- To find task link related information for a visit

Line 3428: FROM AHL_VISIT_TASKS_B

3424: ATTRIBUTE14,
3425: ATTRIBUTE15
3426: FROM AHL_TASK_LINKS
3427: WHERE visit_task_id in ( SELECT VISIT_TASK_ID
3428: FROM AHL_VISIT_TASKS_B
3429: WHERE visit_id = x_visit_id);
3430: -- To find the coresponding task id in the new visit
3431: CURSOR c_new_task(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
3432: SELECT b.VISIT_TASK_ID,b.VISIT_TASK_NUMBER

Line 3433: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b

3429: WHERE visit_id = x_visit_id);
3430: -- To find the coresponding task id in the new visit
3431: CURSOR c_new_task(x_visit_task_id IN NUMBER, x_new_visit_id IN NUMBER) IS
3432: SELECT b.VISIT_TASK_ID,b.VISIT_TASK_NUMBER
3433: FROM AHL_VISIT_TASKS_B a, AHL_VISIT_TASKS_B b
3434: WHERE a.visit_task_id = x_visit_task_id
3435: AND a.visit_task_number = b.visit_task_number
3436: AND b.visit_id = x_new_visit_id;
3437:

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

3475:
3476: -- Added by mpothuku on 01/20/05 To find if this Unit has been planned in other visits already
3477: CURSOR chk_unit_effectivities (c_unit_id IN NUMBER,c_visit_id IN NUMBER) IS
3478: SELECT VISIT_NUMBER FROM AHL_VISITS_B ahlv ,AHL_SIMULATION_PLANS_B ahlp WHERE
3479: VISIT_ID IN (SELECT DISTINCT VISIT_ID FROM AHL_VISIT_TASKS_B WHERE
3480: Unit_Effectivity_Id = c_unit_id)
3481: and visit_id <> c_visit_id
3482: and ahlv.simulation_plan_id = ahlp.simulation_plan_id
3483: and ahlp.primary_plan_flag = 'Y'

Line 3548: ahl_visit_tasks_b prim, ahl_visit_tasks_b sim

3544: WHERE visit_task_id = c_task_id;
3545:
3546: CURSOR c_new_primary_task (c_simulation_task_id IN NUMBER) IS
3547: SELECT prim.visit_task_id, prim.visit_task_number FROM
3548: ahl_visit_tasks_b prim, ahl_visit_tasks_b sim
3549: WHERE
3550: sim.visit_task_id = c_simulation_task_id and
3551: prim.visit_task_id = sim.primary_visit_task_id;
3552:

Line 4135: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO

4131: 2. The task is created in the Simulation visit.
4132: */
4133: THEN
4134: /* Added by mpothuku on 01/11/04 to insert new row into the PrimaryVisit */
4135: SELECT Ahl_Visit_Tasks_B_S.NEXTVAL INTO
4136: l_visit_task_id FROM dual;
4137:
4138: IF G_DEBUG='Y' THEN
4139: AHL_DEBUG_PUB.debug( 'visit call insert new task created in simulation:'||l_simul_visit_task_rec.visit_task_number);

Line 4208: UPDATE ahl_visit_tasks_b

4204: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4205: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID
4206: );
4207: /* Need to update the simulation_visit's primary_visit_task_id with the Id thats generated here */
4208: UPDATE ahl_visit_tasks_b
4209: SET primary_visit_task_id = l_visit_task_id
4210: WHERE visit_task_id = l_simul_visit_task_rec.visit_task_id;
4211:
4212: END IF;