APPS.AHL_VWP_TIMES_PVT dependencies on AHL_VISIT_TASKS_B

Line 306: FROM AHL_VISIT_TASKS_B

302: -- already since scheduling will be taken care of by PS if the task has a WO :: START
303: --Cursor for fetching task ids for all the tasks in a visit
304: /*CURSOR get_visit_tasks(x_visit_id IN NUMBER) IS
305: SELECT visit_task_id, stage_id
306: FROM AHL_VISIT_TASKS_B
307: WHERE visit_id = x_visit_id
308: AND status_code = 'PLANNING';*/
309: CURSOR get_visit_tasks(x_visit_id IN NUMBER) IS
310: SELECT tsk.visit_task_id visit_task_id, tsk.stage_id stage_id

Line 311: FROM AHL_VISIT_TASKS_B tsk

307: WHERE visit_id = x_visit_id
308: AND status_code = 'PLANNING';*/
309: CURSOR get_visit_tasks(x_visit_id IN NUMBER) IS
310: SELECT tsk.visit_task_id visit_task_id, tsk.stage_id stage_id
311: FROM AHL_VISIT_TASKS_B tsk
312: , ahl_workorders wo
313: WHERE tsk.visit_id = x_visit_id
314: AND tsk.status_code = 'PLANNING'
315: AND tsk.visit_task_id = wo.visit_task_id(+)

Line 420: UPDATE AHL_VISIT_TASKS_B

416: fnd_log.string(l_log_statement,
417: L_DEBUG_KEY , 'l_task_end_date = ' || to_char(l_task_end_date,'DD-MON-YY hh24:mi:ss'));
418: END IF;
419:
420: UPDATE AHL_VISIT_TASKS_B
421: SET START_DATE_TIME = l_task_start_date,
422: END_DATE_TIME = l_task_end_date
423: WHERE visit_task_id = l_task_rec.visit_task_id
424: AND PAST_TASK_START_DATE IS NULL;--Line Added by jrotich for fixing bug #13518519

Line 511: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt

507: -- PRAKKUM :: BUG Internal (also fixed #13595460):: 19/01/2012 :: Task Time Adjustments Not Required For Tasks those that have workorders
508: -- already since scheduling will be taken care of by PS if the task has a WO :: START
509: /*CURSOR get_visit_dets(p_task_id IN NUMBER) IS
510: SELECT v.visit_id, v.past_dated_visit_flag, v.status_code, v.start_date_time, v.close_date_time
511: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt
512: WHERE v.visit_id = vt.visit_id
513: AND vt.visit_task_id = p_task_id;*/
514: CURSOR get_visit_dets(p_task_id IN NUMBER) IS
515: SELECT v.visit_id, v.past_dated_visit_flag, v.status_code, v.start_date_time, v.close_date_time

Line 516: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt

512: WHERE v.visit_id = vt.visit_id
513: AND vt.visit_task_id = p_task_id;*/
514: CURSOR get_visit_dets(p_task_id IN NUMBER) IS
515: SELECT v.visit_id, v.past_dated_visit_flag, v.status_code, v.start_date_time, v.close_date_time
516: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt
517: , ahl_workorders wo
518: WHERE v.visit_id = vt.visit_id
519: AND vt.visit_task_id = p_task_id
520: AND vt.visit_task_id = wo.visit_task_id(+)

Line 534: from ahl_vwp_stages_b st, ahl_visit_tasks_b vt

530: --Cursor for deriving all the stage dates
531: CURSOR get_stage_dates(p_task_ID IN number)
532: IS
533: SELECT st.planned_start_date, st.planned_end_date
534: from ahl_vwp_stages_b st, ahl_visit_tasks_b vt
535: where st.stage_id = vt.stage_id
536: AND vt.visit_task_id = p_task_id;
537:
538: -- Define local variables

Line 611: UPDATE AHL_VISIT_TASKS_B

607: IF (p_task_start_date IS NOT NULL) THEN
608: l_task_start_date := p_task_start_date;
609: END IF;
610:
611: UPDATE AHL_VISIT_TASKS_B
612: SET START_DATE_TIME = l_task_start_date,
613: END_DATE_TIME = l_task_end_date
614: WHERE visit_task_id = p_task_id;
615:

Line 682: FROM AHL_VISIT_TASKS_B vt, AHL_VISITS_B v,

678: nvl(vt.department_id, v.department_id),
679: nvl(vt.duration, NVL(Get_task_duration(vt.quantity, routes.route_id), 0)) duration,
680: vt.stage_id,
681: nvl(vt.start_from_hour, 0)
682: FROM AHL_VISIT_TASKS_B vt, AHL_VISITS_B v,
683: ahl_routes_app_v routes, ahl_mr_routes_app_v mr
684: WHERE vt.visit_id = v.visit_id
685: AND routes.route_id (+) = mr.route_id
686: AND mr.mr_route_id (+)= vt.mr_route_id

Line 695: FROM AHL_VISIT_TASKS_B vt, AHL_TASK_LINKS tl

691: --This cursor uses the technical dependencies and finds the parent task
692: -- that finishes last.
693: CURSOR get_tech_dependency_csr(p_task_id IN NUMBER) IS
694: SELECT max(vt.end_date_time)
695: FROM AHL_VISIT_TASKS_B vt, AHL_TASK_LINKS tl
696: WHERE vt.visit_task_id = tl.parent_task_id
697: AND tl.visit_task_id = p_task_id;
698: --
699: --Cursor which fetches all child technical dependent tasks

Line 790: UPDATE AHL_VISIT_TASKS_B

786: l_start_date <> l_old_task_start OR
787: l_end_date <> l_old_task_end) THEN
788:
789: --3d Update the tasks table with the new dates and times.
790: UPDATE AHL_VISIT_TASKS_B
791: SET START_DATE_TIME = l_start_date,
792: END_DATE_TIME = l_end_date
793: WHERE visit_task_id = p_task_id;
794:

Line 859: FROM AHL_VISIT_TASKS_B

855: FROM AHL_VISITS_B
856: WHERE DEPARTMENT_ID = p_dept_id
857: UNION
858: SELECT visit_id
859: FROM AHL_VISIT_TASKS_B
860: WHERE department_id = p_dept_id;
861: --
862: -- Define local variables
863: l_api_version CONSTANT NUMBER := 1.0;