APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISIT_TASKS_B_S

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