APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISIT_TASKS_B_S

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 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);