APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_ISTARG_INTS

Line 3258: FROM igs_uc_istarg_ints ivstk

3254:
3255: CURSOR new_ivstarg_cur IS
3256: SELECT ivstk.rowid,
3257: ivstk.*
3258: FROM igs_uc_istarg_ints ivstk
3259: WHERE record_status = 'N';
3260:
3261:
3262: CURSOR old_starg_cur (p_appno igs_uc_app_choices.app_no%TYPE,

Line 3287: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarg_ints.ucas_cycle%TYPE) IS

3283: FROM igs_uc_com_inst
3284: WHERE inst = p_inst;
3285:
3286: -- get entry year from UCAS Control.
3287: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarg_ints.ucas_cycle%TYPE) IS
3288: SELECT entry_year
3289: FROM igs_uc_ucas_control
3290: WHERE system_code = p_system
3291: AND ucas_cycle = p_cycle;

Line 4010: UPDATE igs_uc_istarg_ints

4006: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
4007: -- while processing the record.
4008: IF g_error_code IS NOT NULL THEN
4009:
4010: UPDATE igs_uc_istarg_ints
4011: SET error_code = g_error_code
4012: WHERE rowid = new_ivstarg_rec.rowid;
4013:
4014: -- log error message/meaning.

Line 4022: UPDATE igs_uc_istarg_ints

4018: g_error_rec_cnt := g_error_rec_cnt + 1;
4019:
4020: ELSE
4021:
4022: UPDATE igs_uc_istarg_ints
4023: SET record_status = 'D',
4024: error_code = NULL
4025: WHERE rowid = new_ivstarg_rec.rowid;
4026: