APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_SH_USEC_OCCURS_S

Line 2395: SELECT IGS_PS_SH_USEC_OCCURS_S.NEXTVAL INTO l_new_usecsh_id FROM dual;

2391:
2392: l_new_instructor_id := NULL;
2393:
2394:
2395: SELECT IGS_PS_SH_USEC_OCCURS_S.NEXTVAL INTO l_new_usecsh_id FROM dual;
2396: l_new_unit_section_occur_id :=p_n_uso_id;
2397: INSERT INTO IGS_PS_SH_USEC_OCCURS(USECSH_ID,
2398: UNIT_SECTION_OCCURRENCE_ID,
2399: MONDAY,

Line 2568: UPDATE IGS_PS_SH_USEC_OCCURS SET

2564: NVL(l_shd_room_code,'X') <> NVL(l_new_room_code,'X') OR
2565: NVL(l_shd_instructor_id ,'X')<> NVL(l_new_instructor_id,'X') THEN
2566:
2567:
2568: UPDATE IGS_PS_SH_USEC_OCCURS SET
2569: monday = l_new_monday,
2570: tuesday = l_new_tuesday,
2571: wednesday = l_new_wednesday,
2572: thursday = l_new_thursday,