DBA Data[Home] [Help]

APPS.WIP_EAM_WORKREQUEST_PVT dependencies on WIP_EAM_WORK_REQUESTS_S

Line 113: SELECT wip_eam_work_requests_s.nextval

109: -- remove the carriage return character i.e remove chr(13)
110: -- fix for bug 2104571
111: l_request_log := replace(p_request_log,fnd_global.local_chr(13)||fnd_global.local_chr(10),fnd_global.local_chr(10));
112:
113: SELECT wip_eam_work_requests_s.nextval
114: INTO l_work_request_id FROM DUAL;
115: x_request_id := l_work_request_id;
116: l_stmt_num := 60;
117: BEGIN

Line 952: UPDATE wip_eam_work_requests SET

948: END IF;
949: END IF;
950: END IF;
951:
952: UPDATE wip_eam_work_requests SET
953: last_update_date = sysdate,
954: last_updated_by = NVL(p_user_id,FND_GLOBAL.user_id),
955: last_update_login = NVL(p_user_id,FND_GLOBAL.login_id),
956: work_request_priority_id = l_new_priority_id,