APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_CJNTADM_INTS

Line 898: igs_uc_cjntadm_ints with record status N

894: /******************************************************************
895: Created By : smaddali
896: Date Created By : 11-Jun-03
897: Purpose : loads each record in the hercules view CVJOINTADMISSIONS into the interface table
898: igs_uc_cjntadm_ints with record status N
899: Known limitations,enhancements,remarks:
900: Change History
901: Who When What
902: jbaber 15-Sep-05 Replace parentinst1 value with '*' if NULL for bug 4589994

Line 940: UPDATE igs_uc_cjntadm_ints SET record_status = 'O' WHERE record_status = 'N' ;

936: -- if there is a difference in the timestamps then load all records from hercules view
937: IF ( l_new_max_timestamp > p_old_timestamp OR p_old_timestamp IS NULL ) THEN
938:
939: -- Obsolete all records in interface table with status N
940: UPDATE igs_uc_cjntadm_ints SET record_status = 'O' WHERE record_status = 'N' ;
941:
942: -- create interface records for each record in the hercules view
943: FOR c_cvjntadm_rec IN c_cvjntadm LOOP
944: -- set x_sync_read to true if the loop is entered even once

Line 948: INSERT INTO igs_uc_cjntadm_ints ( childinst,

944: -- set x_sync_read to true if the loop is entered even once
945: g_sync_reqd := TRUE;
946:
947: -- copy hercules record into interface table with record status N
948: INSERT INTO igs_uc_cjntadm_ints ( childinst,
949: parentinst1,
950: parentinst2,
951: parentinst3,
952: parentinst4,