1486: l_space_assign_rec.attribute13,
1487: l_space_assign_rec.attribute14,
1488: l_space_assign_rec.attribute15,
1489: SYSDATE,
1490: Fnd_Global.user_id,
1491: SYSDATE,
1492: Fnd_Global.user_id,
1493: Fnd_Global.login_id,
1494: l_space_assign_rec.start_from, -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1488: l_space_assign_rec.attribute15,
1489: SYSDATE,
1490: Fnd_Global.user_id,
1491: SYSDATE,
1492: Fnd_Global.user_id,
1493: Fnd_Global.login_id,
1494: l_space_assign_rec.start_from, -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1495: l_space_assign_rec.end_to -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1496: );
1489: SYSDATE,
1490: Fnd_Global.user_id,
1491: SYSDATE,
1492: Fnd_Global.user_id,
1493: Fnd_Global.login_id,
1494: l_space_assign_rec.start_from, -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1495: l_space_assign_rec.end_to -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1496: );
1497:
1723: attribute13 = l_Space_assign_rec.attribute13,
1724: attribute14 = l_Space_assign_rec.attribute14,
1725: attribute15 = l_Space_assign_rec.attribute15,
1726: last_update_date = SYSDATE,
1727: last_updated_by = Fnd_Global.user_id,
1728: last_update_login = Fnd_Global.login_id,
1729: start_from = l_Space_assign_rec.start_from, -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1730: end_to = l_Space_assign_rec.end_to -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1731: WHERE space_assignment_id = p_space_assign_rec.space_assignment_id;
1724: attribute14 = l_Space_assign_rec.attribute14,
1725: attribute15 = l_Space_assign_rec.attribute15,
1726: last_update_date = SYSDATE,
1727: last_updated_by = Fnd_Global.user_id,
1728: last_update_login = Fnd_Global.login_id,
1729: start_from = l_Space_assign_rec.start_from, -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1730: end_to = l_Space_assign_rec.end_to -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
1731: WHERE space_assignment_id = p_space_assign_rec.space_assignment_id;
1732:
2873: UPDATE ahl_schedule_materials
2874: SET requested_quantity = 0,
2875: object_version_number = l_object_version_number + 1,
2876: last_update_date = SYSDATE,
2877: last_updated_by = Fnd_Global.user_id,
2878: last_update_login = Fnd_Global.login_id
2879: WHERE scheduled_material_id = l_schedule_material_id;
2880: --
2881: END IF; --Scheduled date
2874: SET requested_quantity = 0,
2875: object_version_number = l_object_version_number + 1,
2876: last_update_date = SYSDATE,
2877: last_updated_by = Fnd_Global.user_id,
2878: last_update_login = Fnd_Global.login_id
2879: WHERE scheduled_material_id = l_schedule_material_id;
2880: --
2881: END IF; --Scheduled date
2882: CLOSE c_visit_task_matrl_cur;
2915: close_date_time = NULL,
2916: any_task_chg_flag = 'Y',
2917: object_version_number = l_object_version_number + 1,
2918: last_update_date = SYSDATE,
2919: last_updated_by = Fnd_Global.user_id,
2920: last_update_login = Fnd_Global.login_id
2921:
2922: WHERE visit_id = l_visit_id;
2923: */
2916: any_task_chg_flag = 'Y',
2917: object_version_number = l_object_version_number + 1,
2918: last_update_date = SYSDATE,
2919: last_updated_by = Fnd_Global.user_id,
2920: last_update_login = Fnd_Global.login_id
2921:
2922: WHERE visit_id = l_visit_id;
2923: */
2924: -- Visit Name Mandatory for Update