167: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
168: UPDATE AHL_SCHEDULE_MATERIALS
169: SET requested_date = trunc(l_requested_date),
170: last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,
172: last_update_login = fnd_global.login_id
173: WHERE scheduled_material_id = l_scheduled_material_id;
174:
175: i := i + 1;
168: UPDATE AHL_SCHEDULE_MATERIALS
169: SET requested_date = trunc(l_requested_date),
170: last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,
172: last_update_login = fnd_global.login_id
173: WHERE scheduled_material_id = l_scheduled_material_id;
174:
175: i := i + 1;
176: END LOOP;