DBA Data[Home] [Help]

APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 860: UPDATE igs_ps_unit_ofr_opt_all SET enrollment_actual = l_enrollment_actual WHERE ROWID = l_usec_row.ROWID;

856: -- Increment the Total enrollment actual count by 1.
857: l_enrollment_actual := NVL(l_usec_row.ENROLLMENT_ACTUAL,0)+1;
858:
859: BEGIN
860: UPDATE igs_ps_unit_ofr_opt_all SET enrollment_actual = l_enrollment_actual WHERE ROWID = l_usec_row.ROWID;
861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF (usec_upd_enr_act%ISOPEN) THEN

Line 879: UPDATE igs_ps_unit_ofr_opt_all SET waitlist_actual = l_waitlist_actual WHERE ROWID = l_usec_row.ROWID ;

875: -- Increment the Total waitlist actual count by 1.
876: l_waitlist_actual := NVL(l_usec_row.WAITLIST_ACTUAL,0)+1;
877:
878: BEGIN
879: UPDATE igs_ps_unit_ofr_opt_all SET waitlist_actual = l_waitlist_actual WHERE ROWID = l_usec_row.ROWID ;
880:
881: EXCEPTION
882: WHEN OTHERS THEN
883: IF (usec_upd_enr_act%ISOPEN) THEN