354: SET approval_status_type = 1,
355: approval_request_date = null,
356: approval_date = null,
357: last_update_date = SYSDATE,
358: last_updated_by = FND_GLOBAL.USER_ID,
359: last_update_login = FND_GLOBAL.LOGIN_ID
360: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id;
361:
362: -- Set all "Scheduled" revised items to "Open"
355: approval_request_date = null,
356: approval_date = null,
357: last_update_date = SYSDATE,
358: last_updated_by = FND_GLOBAL.USER_ID,
359: last_update_login = FND_GLOBAL.LOGIN_ID
360: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id;
361:
362: -- Set all "Scheduled" revised items to "Open"
363:
363:
364: UPDATE eng_revised_items
365: SET status_type = 1,
366: last_update_date = SYSDATE,
367: last_updated_by = FND_GLOBAL.USER_ID,
368: last_update_login = FND_GLOBAL.LOGIN_ID
369: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id
370: AND status_type = 4;
371:
364: UPDATE eng_revised_items
365: SET status_type = 1,
366: last_update_date = SYSDATE,
367: last_updated_by = FND_GLOBAL.USER_ID,
368: last_update_login = FND_GLOBAL.LOGIN_ID
369: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id
370: AND status_type = 4;
371:
372: end if;