eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_PS_OFR_OPT_UNIT_SET_V

Line 89: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,

85: cp_oss_program_version igs_uc_app_choices.oss_program_version%TYPE,
86: cp_oss_location igs_uc_app_choices.oss_location%TYPE,
87: cp_oss_attendance_mode igs_uc_app_choices.oss_attendance_mode%TYPE,
88: cp_oss_attendance_type igs_uc_app_choices.oss_attendance_type%TYPE,
89: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
90: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE ) IS
91: SELECT acai.sequence_number
92: FROM igs_ad_ps_appl_inst acai
93: WHERE acai.person_id = cp_person_id

Line 90: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE ) IS

86: cp_oss_location igs_uc_app_choices.oss_location%TYPE,
87: cp_oss_attendance_mode igs_uc_app_choices.oss_attendance_mode%TYPE,
88: cp_oss_attendance_type igs_uc_app_choices.oss_attendance_type%TYPE,
89: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
90: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE ) IS
91: SELECT acai.sequence_number
92: FROM igs_ad_ps_appl_inst acai
93: WHERE acai.person_id = cp_person_id
94: AND acai.admission_appl_number = cp_admission_appl_number

Line 166: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,

162:
163: -- Get the unit set code corresponding to the application choice point of entry
164: -- jchin - bug 3691277 and 3691250
165: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
166: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
167: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
168: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
169: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
170: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

Line 167: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,

163: -- Get the unit set code corresponding to the application choice point of entry
164: -- jchin - bug 3691277 and 3691250
165: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
166: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
167: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
168: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
169: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
170: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
171: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS

Line 168: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,

164: -- jchin - bug 3691277 and 3691250
165: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
166: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
167: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
168: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
169: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
170: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
171: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
172: SELECT US.UNIT_SET_CD,

Line 169: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,

165: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
166: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
167: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
168: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
169: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
170: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
171: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
172: SELECT US.UNIT_SET_CD,
173: US.VERSION_NUMBER US_VERSION_NUMBER

Line 170: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

166: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
167: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
168: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
169: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
170: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
171: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
172: SELECT US.UNIT_SET_CD,
173: US.VERSION_NUMBER US_VERSION_NUMBER
174: FROM IGS_PS_OFR_UNIT_SET COUS,

Line 171: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS

167: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
168: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
169: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
170: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
171: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
172: SELECT US.UNIT_SET_CD,
173: US.VERSION_NUMBER US_VERSION_NUMBER
174: FROM IGS_PS_OFR_UNIT_SET COUS,
175: IGS_PS_OFR_OPT COO,

Line 1021: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,

1017: -- Get the unit set code corresponding to the application choice point of entry
1018: -- smaddali added this cursor for bug 2630219
1019: -- jchin - bug 3691277 and 3691250
1020: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
1021: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
1022: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
1023: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
1024: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
1025: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

Line 1022: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,

1018: -- smaddali added this cursor for bug 2630219
1019: -- jchin - bug 3691277 and 3691250
1020: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
1021: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
1022: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
1023: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
1024: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
1025: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
1026: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS

Line 1023: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,

1019: -- jchin - bug 3691277 and 3691250
1020: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
1021: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
1022: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
1023: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
1024: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
1025: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
1026: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
1027: SELECT US.UNIT_SET_CD,

Line 1024: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,

1020: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,
1021: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
1022: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
1023: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
1024: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
1025: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
1026: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
1027: SELECT US.UNIT_SET_CD,
1028: US.VERSION_NUMBER US_VERSION_NUMBER

Line 1025: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

1021: p_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
1022: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
1023: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
1024: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
1025: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
1026: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
1027: SELECT US.UNIT_SET_CD,
1028: US.VERSION_NUMBER US_VERSION_NUMBER
1029: FROM IGS_PS_OFR_UNIT_SET COUS,

Line 1026: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS

1022: p_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
1023: p_acad_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
1024: p_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
1025: p_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
1026: p_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE) IS
1027: SELECT US.UNIT_SET_CD,
1028: US.VERSION_NUMBER US_VERSION_NUMBER
1029: FROM IGS_PS_OFR_UNIT_SET COUS,
1030: IGS_PS_OFR_OPT COO,