3159: ,term4start
3160: ,term4end
3161: ,RTRIM(jointadmission) jointadmission
3162: ,RTRIM(openextra) openextra
3163: FROM igs_uc_u_uvcourse_2003
3164: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
3165:
3166: -- get the max timestamp value of the hercules view
3167: CURSOR c_max_timestamp IS
3165:
3166: -- get the max timestamp value of the hercules view
3167: CURSOR c_max_timestamp IS
3168: SELECT MAX(timestamp)
3169: FROM igs_uc_u_uvcourse_2003 ;
3170:
3171: -- Variables
3172: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3173: l_new_max_timestamp igs_uc_u_uvcourse_2003.timestamp%TYPE ;
3169: FROM igs_uc_u_uvcourse_2003 ;
3170:
3171: -- Variables
3172: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
3173: l_new_max_timestamp igs_uc_u_uvcourse_2003.timestamp%TYPE ;
3174: l_count NUMBER ;
3175:
3176: BEGIN
3177: -- set syncronization required to false