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_US_PRENR_CFG

Line 165: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,

161:
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,

Line 178: IGS_PS_US_PRENR_CFG CFG

174: FROM IGS_PS_OFR_UNIT_SET COUS,
175: IGS_PS_OFR_OPT COO,
176: IGS_EN_UNIT_SET US,
177: IGS_EN_UNIT_SET_CAT USC,
178: IGS_PS_US_PRENR_CFG CFG
179: WHERE COUS.COURSE_CD = P_COURSE_CD
180: AND COUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
181: AND COUS.CAL_TYPE = P_ACAD_CAL_TYPE
182: AND COO.LOCATION_CD = P_LOCATION_CD

Line 201: IGS_PS_US_PRENR_CFG CFG

197: US.VERSION_NUMBER US_VERSION_NUMBER
198: FROM IGS_PS_OF_OPT_UNT_ST COOUS,
199: IGS_EN_UNIT_SET US,
200: IGS_EN_UNIT_SET_CAT USC,
201: IGS_PS_US_PRENR_CFG CFG
202: WHERE COOUS.COURSE_CD = P_COURSE_CD
203: AND COOUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
204: AND COOUS.CAL_TYPE = P_ACAD_CAL_TYPE
205: AND COOUS.LOCATION_CD = P_LOCATION_CD

Line 1020: CURSOR c_unit_set_cd(p_seq_no igs_ps_us_prenr_cfg.sequence_no%TYPE,

1016:
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,

Line 1033: IGS_PS_US_PRENR_CFG CFG

1029: FROM IGS_PS_OFR_UNIT_SET COUS,
1030: IGS_PS_OFR_OPT COO,
1031: IGS_EN_UNIT_SET US,
1032: IGS_EN_UNIT_SET_CAT USC,
1033: IGS_PS_US_PRENR_CFG CFG
1034: WHERE COUS.COURSE_CD = P_COURSE_CD
1035: AND COUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
1036: AND COUS.CAL_TYPE = P_ACAD_CAL_TYPE
1037: AND COO.LOCATION_CD = P_LOCATION_CD

Line 1056: IGS_PS_US_PRENR_CFG CFG

1052: US.VERSION_NUMBER US_VERSION_NUMBER
1053: FROM IGS_PS_OF_OPT_UNT_ST COOUS,
1054: IGS_EN_UNIT_SET US,
1055: IGS_EN_UNIT_SET_CAT USC,
1056: IGS_PS_US_PRENR_CFG CFG
1057: WHERE COOUS.COURSE_CD = P_COURSE_CD
1058: AND COOUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
1059: AND COOUS.CAL_TYPE = P_ACAD_CAL_TYPE
1060: AND COOUS.LOCATION_CD = P_LOCATION_CD

Line 1140: igs_ps_us_prenr_cfg cnfg,

1136: igs_ad_appl_all apl,
1137: igs_ad_ps_appl_inst_all aplinst,
1138: igs_en_unit_set us,
1139: igs_en_unit_set_cat usc,
1140: igs_ps_us_prenr_cfg cnfg,
1141: igs_uc_map_out_stat mos,
1142: igs_uc_map_off_resp mor
1143: WHERE uac.app_no = cp_app_no
1144: AND uac.choice_no = cp_choice_no