DBA Data[Home] [Help]

APPS.EAM_WO_COMP_UTILITY_PVT dependencies on WIP_EAM_WORK_REQUESTS

Line 930: -- Update wip_eam_work_requests table

926: SET USER_DEFINED_STATUS_ID = p_eam_wo_comp_rec.user_status_id
927: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
928: AND organization_id = p_eam_wo_comp_rec.organization_id ;
929:
930: -- Update wip_eam_work_requests table
931: UPDATE WIP_EAM_WORK_REQUESTS
932: SET work_request_status_id = i_work_request_status,
933: last_update_date = sysdate,
934: last_updated_by = fnd_global.user_id,

Line 931: UPDATE WIP_EAM_WORK_REQUESTS

927: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
928: AND organization_id = p_eam_wo_comp_rec.organization_id ;
929:
930: -- Update wip_eam_work_requests table
931: UPDATE WIP_EAM_WORK_REQUESTS
932: SET work_request_status_id = i_work_request_status,
933: last_update_date = sysdate,
934: last_updated_by = fnd_global.user_id,
935: last_update_login = fnd_global.login_id