APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_UC_CRSE_DETS

Line 218: CURSOR cur_oss_prog_mapped (cp_ucas_program_code igs_uc_crse_dets.ucas_program_code%TYPE,

214: c_unit_set_cd_rec c_unit_set_cd%ROWTYPE;
215:
216: -- Get the oss POP to which ucas program is mapped to
217: -- smaddali modified cursor to add parameter cp_system_code and its check in where clause ,for bug 2643048
218: CURSOR cur_oss_prog_mapped (cp_ucas_program_code igs_uc_crse_dets.ucas_program_code%TYPE,
219: cp_ucas_campus igs_uc_crse_dets.ucas_campus%TYPE,
220: cp_system_code igs_uc_crse_dets.system_code%TYPE ) IS
221: SELECT cr.oss_program_code, cr.oss_program_version, cr.oss_location, cr.oss_attendance_type,
222: cr.oss_attendance_mode

Line 219: cp_ucas_campus igs_uc_crse_dets.ucas_campus%TYPE,

215:
216: -- Get the oss POP to which ucas program is mapped to
217: -- smaddali modified cursor to add parameter cp_system_code and its check in where clause ,for bug 2643048
218: CURSOR cur_oss_prog_mapped (cp_ucas_program_code igs_uc_crse_dets.ucas_program_code%TYPE,
219: cp_ucas_campus igs_uc_crse_dets.ucas_campus%TYPE,
220: cp_system_code igs_uc_crse_dets.system_code%TYPE ) IS
221: SELECT cr.oss_program_code, cr.oss_program_version, cr.oss_location, cr.oss_attendance_type,
222: cr.oss_attendance_mode
223: FROM igs_uc_crse_dets cr

Line 220: cp_system_code igs_uc_crse_dets.system_code%TYPE ) IS

216: -- Get the oss POP to which ucas program is mapped to
217: -- smaddali modified cursor to add parameter cp_system_code and its check in where clause ,for bug 2643048
218: CURSOR cur_oss_prog_mapped (cp_ucas_program_code igs_uc_crse_dets.ucas_program_code%TYPE,
219: cp_ucas_campus igs_uc_crse_dets.ucas_campus%TYPE,
220: cp_system_code igs_uc_crse_dets.system_code%TYPE ) IS
221: SELECT cr.oss_program_code, cr.oss_program_version, cr.oss_location, cr.oss_attendance_type,
222: cr.oss_attendance_mode
223: FROM igs_uc_crse_dets cr
224: WHERE cr.ucas_program_code = cp_ucas_program_code

Line 223: FROM igs_uc_crse_dets cr

219: cp_ucas_campus igs_uc_crse_dets.ucas_campus%TYPE,
220: cp_system_code igs_uc_crse_dets.system_code%TYPE ) IS
221: SELECT cr.oss_program_code, cr.oss_program_version, cr.oss_location, cr.oss_attendance_type,
222: cr.oss_attendance_mode
223: FROM igs_uc_crse_dets cr
224: WHERE cr.ucas_program_code = cp_ucas_program_code
225: AND cr.ucas_campus = cp_ucas_campus
226: AND cr.institute = (SELECT current_inst_code FROM igs_uc_defaults df WHERE df.system_code = cr.system_code)
227: AND cr.system_code = cp_system_code

Line 388: --Populate the OSS code mapping done in IGSUC013 Form from the IGS_UC_CRSE_DETS Table.

384:
385: OPEN cur_oss_prog_mapped(j.ucas_program_code, j.campus, j.system_code) ;
386: FETCH cur_oss_prog_mapped INTO oss_prog_mapped_rec ;
387: IF cur_oss_prog_mapped%FOUND THEN
388: --Populate the OSS code mapping done in IGSUC013 Form from the IGS_UC_CRSE_DETS Table.
389: j.oss_program_code := oss_prog_mapped_rec.oss_program_code;
390: j.oss_program_version := oss_prog_mapped_rec.oss_program_version;
391: j.oss_location := oss_prog_mapped_rec.oss_location;
392: j.oss_attendance_mode := oss_prog_mapped_rec.oss_attendance_mode;