156: l_friday_hours(l_J) ,
157: l_saturday_hours(l_J) ,
158: l_sunday_hours(l_J) ,
159: sysdate ,
160: fnd_global.user_id ,
161: sysdate ,
162: fnd_global.user_id ,
163: fnd_global.login_id);
164:
158: l_sunday_hours(l_J) ,
159: sysdate ,
160: fnd_global.user_id ,
161: sysdate ,
162: fnd_global.user_id ,
163: fnd_global.login_id);
164:
165:
166: EXCEPTION
159: sysdate ,
160: fnd_global.user_id ,
161: sysdate ,
162: fnd_global.user_id ,
163: fnd_global.login_id);
164:
165:
166: EXCEPTION
167: WHEN l_empty_tab_record THEN
300: p_friday_hours ,
301: p_saturday_hours ,
302: p_sunday_hours ,
303: sysdate ,
304: fnd_global.user_id ,
305: sysdate ,
306: fnd_global.user_id ,
307: fnd_global.login_id);
308:
302: p_sunday_hours ,
303: sysdate ,
304: fnd_global.user_id ,
305: sysdate ,
306: fnd_global.user_id ,
307: fnd_global.login_id);
308:
309: x_exception_id := l_t_schedule_exception_id;
310:
303: sysdate ,
304: fnd_global.user_id ,
305: sysdate ,
306: fnd_global.user_id ,
307: fnd_global.login_id);
308:
309: x_exception_id := l_t_schedule_exception_id;
310:
311: EXCEPTION
424: friday_hours = l_friday_hours(l_J),
425: saturday_hours = l_saturday_hours(l_J),
426: sunday_hours = l_sunday_hours(l_J),
427: last_update_date = sysdate,
428: last_update_by = fnd_global.user_id,
429: last_update_login = fnd_global.login_id
430: WHERE rowid = l_exceptrowid(l_J);
431:
432: EXCEPTION
425: saturday_hours = l_saturday_hours(l_J),
426: sunday_hours = l_sunday_hours(l_J),
427: last_update_date = sysdate,
428: last_update_by = fnd_global.user_id,
429: last_update_login = fnd_global.login_id
430: WHERE rowid = l_exceptrowid(l_J);
431:
432: EXCEPTION
433: WHEN l_empty_tab_record THEN
530: friday_hours = p_friday_hours,
531: saturday_hours = p_saturday_hours,
532: sunday_hours = p_sunday_hours,
533: last_update_date = sysdate,
534: last_update_by = fnd_global.user_id,
535: last_update_login = fnd_global.login_id
536: WHERE rowid = p_exceptrowid;
537:
538:
531: saturday_hours = p_saturday_hours,
532: sunday_hours = p_sunday_hours,
533: last_update_date = sysdate,
534: last_update_by = fnd_global.user_id,
535: last_update_login = fnd_global.login_id
536: WHERE rowid = p_exceptrowid;
537:
538:
539: EXCEPTION
631: friday_hours = p_friday_hours,
632: saturday_hours = p_saturday_hours,
633: sunday_hours = p_sunday_hours,
634: last_update_date = sysdate,
635: last_update_by = fnd_global.user_id,
636: last_update_login = fnd_global.login_id
637: WHERE schedule_exception_id = p_schedule_exception_id;
638:
639:
632: saturday_hours = p_saturday_hours,
633: sunday_hours = p_sunday_hours,
634: last_update_date = sysdate,
635: last_update_by = fnd_global.user_id,
636: last_update_login = fnd_global.login_id
637: WHERE schedule_exception_id = p_schedule_exception_id;
638:
639:
640: EXCEPTION