2799: ,RTRIM(forms) forms
2800: ,RTRIM(referee) referee
2801: ,RTRIM(careers) careers
2802: ,RTRIM(eascontact) eascontact
2803: FROM igs_uc_u_cvschoolcontact_2003
2804: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
2805:
2806: -- get the max timestamp value of the hercules view
2807: CURSOR c_max_timestamp IS
2805:
2806: -- get the max timestamp value of the hercules view
2807: CURSOR c_max_timestamp IS
2808: SELECT MAX(timestamp)
2809: FROM igs_uc_u_cvschoolcontact_2003 ;
2810:
2811: -- Variables
2812: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2813: l_new_max_timestamp igs_uc_u_cvschoolcontact_2003.timestamp%TYPE ;
2809: FROM igs_uc_u_cvschoolcontact_2003 ;
2810:
2811: -- Variables
2812: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
2813: l_new_max_timestamp igs_uc_u_cvschoolcontact_2003.timestamp%TYPE ;
2814: l_count NUMBER ;
2815:
2816: BEGIN
2817: -- set syncronization required to false