7: IS
8: l_nextval NUMBER;
9: BEGIN
10:
11: SELECT pa_schedule_exceptions_s.nextval
12: INTO l_nextval
13: FROM SYS.DUAL;
14:
15: RETURN(l_nextval);
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: /*Bug 5854571: Added following for inserting l_t_schedule_exception_id
240: as schedule_exception_id into PA_SCHEDULE_EXCEPTIONS */
241: SELECT pa_schedule_exceptions_s.nextval
242: INTO l_t_schedule_exception_id
243: FROM dual;
244:
245:
274: last_update_date ,
275: last_update_by ,
276: last_update_login)
277: VALUES
278: (l_t_schedule_exception_id, -- removed pa_schedule_exceptions_s.nextval /*Bug 5854571*/
279: p_calendar_id ,
280: p_assignment_id ,
281: p_project_id ,
282: p_schedule_type_code ,