534: from dual;
535:
536: l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER:=1;
537: l_vwp_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
538: l_vwp_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
539: l_vwp_deptshift_rec.CREATION_DATE:=sysdate;
540: l_vwp_deptshift_rec.CREATED_BY:=fnd_global.user_id;
541: l_vwp_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
542: l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
536: l_vwp_deptshift_rec.OBJECT_VERSION_NUMBER:=1;
537: l_vwp_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
538: l_vwp_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
539: l_vwp_deptshift_rec.CREATION_DATE:=sysdate;
540: l_vwp_deptshift_rec.CREATED_BY:=fnd_global.user_id;
541: l_vwp_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
542: l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
543:
544: INSERT INTO AHL_DEPARTMENT_SHIFTS
537: l_vwp_deptshift_rec.LAST_UPDATE_DATE:=sysdate;
538: l_vwp_deptshift_rec.LAST_UPDATED_BY:=fnd_global.user_id;
539: l_vwp_deptshift_rec.CREATION_DATE:=sysdate;
540: l_vwp_deptshift_rec.CREATED_BY:=fnd_global.user_id;
541: l_vwp_deptshift_rec.LAST_UPDATE_LOGIN:=fnd_global.user_id;
542: l_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID:=l_department_shifts_id;
543:
544: INSERT INTO AHL_DEPARTMENT_SHIFTS
545: (