2424: l_new_SATURDAY,
2425: l_new_SUNDAY,
2426: to_number(l_new_ROOM_CODE),
2427: to_number(l_new_BUILDING_CODE),
2428: fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_START_TIME,'DD-MON-YYYY HH24:MI:SS')),
2429: fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_END_TIME,'DD-MON-YYYY HH24:MI:SS')),
2430: l_new_INSTRUCTOR_ID,
2431: g_n_user_id,
2432: SYSDATE,
2425: l_new_SUNDAY,
2426: to_number(l_new_ROOM_CODE),
2427: to_number(l_new_BUILDING_CODE),
2428: fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_START_TIME,'DD-MON-YYYY HH24:MI:SS')),
2429: fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_END_TIME,'DD-MON-YYYY HH24:MI:SS')),
2430: l_new_INSTRUCTOR_ID,
2431: g_n_user_id,
2432: SYSDATE,
2433: g_n_user_id,
2572: thursday = l_new_thursday,
2573: friday = l_new_friday,
2574: saturday = l_new_saturday,
2575: sunday = l_new_sunday,
2576: start_time = fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_START_TIME,'DD-MON-YYYY HH24:MI:SS')),
2577: end_time = fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_END_TIME,'DD-MON-YYYY HH24:MI:SS')),
2578: room_code = to_number(l_new_room_code),
2579: building_code = to_number(l_new_building_code),
2580: instructor_id = l_new_instructor_id,
2573: friday = l_new_friday,
2574: saturday = l_new_saturday,
2575: sunday = l_new_sunday,
2576: start_time = fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_START_TIME,'DD-MON-YYYY HH24:MI:SS')),
2577: end_time = fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_new_END_TIME,'DD-MON-YYYY HH24:MI:SS')),
2578: room_code = to_number(l_new_room_code),
2579: building_code = to_number(l_new_building_code),
2580: instructor_id = l_new_instructor_id,
2581: last_updated_by = g_n_user_id,