375: END IF;
376:
377: --Get the sequence number
378: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id 379: FROM DUAL; 380: --Check for record exists
381: OPEN check_matrl_cur(p_visit_id,p_visit_task_id,p_rt_oper_material_id);
382: FETCH check_matrl_cur INTO l_dummy;
383: CLOSE check_matrl_cur;