APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_ISTARZ1_INTS

Line 5690: arvsrini 04-MAR-04 Added code to use IGS_UC_ISTARZ1_INTS record to update Choice Number 9 record in IGS_UC_APP_CHOICES when the

5686: Clearing info. details from UCAS.
5687: Known limitations,enhancements,remarks:
5688: Change History
5689: Who When What
5690: arvsrini 04-MAR-04 Added code to use IGS_UC_ISTARZ1_INTS record to update Choice Number 9 record in IGS_UC_APP_CHOICES when the
5691: IGS_UC_ISTARZ1_INTS.INST = Current Institution Code defined in UCAS Setup.
5692: modified wrt UCCR008 build. Bug#3239860
5693: anwest 29-MAY-06 Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
5694: anwest 02-AUG-06 Bug #5440216 URGENT - UCAS CLEARING 2006 - PART 2 - CLEARING CHOICE NUMBER NULL

Line 5691: IGS_UC_ISTARZ1_INTS.INST = Current Institution Code defined in UCAS Setup.

5687: Known limitations,enhancements,remarks:
5688: Change History
5689: Who When What
5690: arvsrini 04-MAR-04 Added code to use IGS_UC_ISTARZ1_INTS record to update Choice Number 9 record in IGS_UC_APP_CHOICES when the
5691: IGS_UC_ISTARZ1_INTS.INST = Current Institution Code defined in UCAS Setup.
5692: modified wrt UCCR008 build. Bug#3239860
5693: anwest 29-MAY-06 Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
5694: anwest 02-AUG-06 Bug #5440216 URGENT - UCAS CLEARING 2006 - PART 2 - CLEARING CHOICE NUMBER NULL
5695:

Line 5701: FROM igs_uc_istarz1_ints ivstz1

5697:
5698: CURSOR new_ivstarz1_cur IS
5699: SELECT ivstz1.rowid,
5700: ivstz1.*
5701: FROM igs_uc_istarz1_ints ivstz1
5702: WHERE ivstz1.record_status = 'N';
5703:
5704: -- check for corresponding record in main table.
5705: CURSOR old_starz1_cur(p_appno igs_uc_app_clearing.app_no%TYPE) IS

Line 5718: CURSOR validate_Course (p_course igs_uc_istarz1_ints.course%TYPE,

5714: FROM igs_uc_com_inst
5715: WHERE inst = p_inst;
5716:
5717: -- validate Course value
5718: CURSOR validate_Course (p_course igs_uc_istarz1_ints.course%TYPE,
5719: p_campus igs_uc_istarz1_ints.campus%TYPE,
5720: p_inst igs_uc_istarz1_ints.inst%TYPE,
5721: p_system igs_uc_crse_dets.system_code%TYPE) IS
5722: SELECT 'X'

Line 5719: p_campus igs_uc_istarz1_ints.campus%TYPE,

5715: WHERE inst = p_inst;
5716:
5717: -- validate Course value
5718: CURSOR validate_Course (p_course igs_uc_istarz1_ints.course%TYPE,
5719: p_campus igs_uc_istarz1_ints.campus%TYPE,
5720: p_inst igs_uc_istarz1_ints.inst%TYPE,
5721: p_system igs_uc_crse_dets.system_code%TYPE) IS
5722: SELECT 'X'
5723: FROM igs_uc_crse_dets

Line 5720: p_inst igs_uc_istarz1_ints.inst%TYPE,

5716:
5717: -- validate Course value
5718: CURSOR validate_Course (p_course igs_uc_istarz1_ints.course%TYPE,
5719: p_campus igs_uc_istarz1_ints.campus%TYPE,
5720: p_inst igs_uc_istarz1_ints.inst%TYPE,
5721: p_system igs_uc_crse_dets.system_code%TYPE) IS
5722: SELECT 'X'
5723: FROM igs_uc_crse_dets
5724: WHERE ucas_program_code = p_course

Line 6210: UPDATE igs_uc_istarz1_ints

6206: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
6207: -- while processing the record.
6208: IF g_error_code IS NOT NULL THEN
6209:
6210: UPDATE igs_uc_istarz1_ints
6211: SET error_code = g_error_code
6212: WHERE rowid = new_ivstarz1_rec.rowid;
6213:
6214: -- log error message/meaning.

Line 6222: UPDATE igs_uc_istarz1_ints

6218: g_error_rec_cnt := g_error_rec_cnt + 1;
6219:
6220: ELSE
6221:
6222: UPDATE igs_uc_istarz1_ints
6223: SET record_status = 'D',
6224: error_code = NULL
6225: WHERE rowid = new_ivstarz1_rec.rowid;
6226: