27: IS
28: BEGIN
29:
30: IF p_eam_request_rec.request_type = 1 THEN
31: UPDATE WIP_EAM_WORK_REQUESTS
32: SET
33: wip_entity_id = p_eam_request_rec.wip_entity_id,
34: work_request_status_id = 4,
35: last_update_date = sysdate,
117: BEGIN
118:
119: IF p_eam_request_rec.request_type = 1 THEN
120:
121: UPDATE WIP_EAM_WORK_REQUESTS
122: SET wip_entity_id = null,
123: work_request_status_id = 3,
124: last_update_date = sysdate,
125: last_updated_by = FND_GLOBAL.user_id