APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 702: -- Update of ahl_schedule_materials added by surrkuma on 15-JUl-2010 for Bug 9901811

698: X_return_status := Fnd_Api.G_RET_STS_ERROR;
699: RAISE Fnd_Api.G_EXC_ERROR;
700: END IF;
701:
702: -- Update of ahl_schedule_materials added by surrkuma on 15-JUl-2010 for Bug 9901811
703: -- Materials were created with the type of PLANNED. Need to change to UNPLANNED
704: UPDATE ahl_schedule_materials SET material_request_type = 'UNPLANNED'
705: WHERE visit_id = l_visit_id
706: AND visit_task_id IN

Line 704: UPDATE ahl_schedule_materials SET material_request_type = 'UNPLANNED'

700: END IF;
701:
702: -- Update of ahl_schedule_materials added by surrkuma on 15-JUl-2010 for Bug 9901811
703: -- Materials were created with the type of PLANNED. Need to change to UNPLANNED
704: UPDATE ahl_schedule_materials SET material_request_type = 'UNPLANNED'
705: WHERE visit_id = l_visit_id
706: AND visit_task_id IN
707: (
708: SELECT visit_task_id

Line 718: fnd_log.string(fnd_log.level_statement, l_full_name, 'Number of ahl_schedule_materials records updated: ' || SQL%ROWCOUNT);

714: )
715: AND material_request_type = 'PLANNED';
716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement, l_full_name, 'Number of ahl_schedule_materials records updated: ' || SQL%ROWCOUNT);
719: END IF;
720: UPDATE ahl_visit_tasks_b SET task_type_code = 'UNPLANNED'
721: WHERE visit_id = l_visit_id
722: AND visit_task_id IN