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_PS_GEN_008 dependencies on IGS_PS_OFR_UNIT_SET

Line 266: FROM IGS_PS_OFR_UNIT_SET cous

262: cous.cal_type,
263: cous.override_title,
264: cous.only_as_sub_ind,
265: cous.show_on_official_ntfctn_ind
266: FROM IGS_PS_OFR_UNIT_SET cous
267: WHERE cous.unit_set_cd = p_old_unit_set_cd AND
268: cous.us_version_number = p_old_version_number;
269: CURSOR c_cousr_sup (
270: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,

Line 270: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,

266: FROM IGS_PS_OFR_UNIT_SET cous
267: WHERE cous.unit_set_cd = p_old_unit_set_cd AND
268: cous.us_version_number = p_old_version_number;
269: CURSOR c_cousr_sup (
270: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
271: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,
272: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS
273: SELECT cousr.course_cd,
274: cousr.crv_version_number,

Line 271: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,

267: WHERE cous.unit_set_cd = p_old_unit_set_cd AND
268: cous.us_version_number = p_old_version_number;
269: CURSOR c_cousr_sup (
270: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
271: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,
272: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS
273: SELECT cousr.course_cd,
274: cousr.crv_version_number,
275: cousr.cal_type,

Line 272: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS

268: cous.us_version_number = p_old_version_number;
269: CURSOR c_cousr_sup (
270: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
271: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,
272: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS
273: SELECT cousr.course_cd,
274: cousr.crv_version_number,
275: cousr.cal_type,
276: cousr.sub_unit_set_cd,

Line 285: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,

281: cousr.course_cd = cp_cous_course_cd AND
282: cousr.cal_type = cp_cous_cal_type AND
283: cousr.crv_version_number = cp_cous_crv_ver_num;
284: CURSOR c_cousr_sub (
285: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
286: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,
287: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS
288: SELECT cousr.course_cd,
289: cousr.crv_version_number,

Line 286: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,

282: cousr.cal_type = cp_cous_cal_type AND
283: cousr.crv_version_number = cp_cous_crv_ver_num;
284: CURSOR c_cousr_sub (
285: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
286: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,
287: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS
288: SELECT cousr.course_cd,
289: cousr.crv_version_number,
290: cousr.cal_type,

Line 287: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS

283: cousr.crv_version_number = cp_cous_crv_ver_num;
284: CURSOR c_cousr_sub (
285: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
286: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE,
287: cp_cous_crv_ver_num IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE) IS
288: SELECT cousr.course_cd,
289: cousr.crv_version_number,
290: cousr.cal_type,
291: cousr.sup_unit_set_cd,

Line 300: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,

296: cousr.course_cd = cp_cous_course_cd AND
297: cousr.cal_type = cp_cous_cal_type AND
298: cousr.crv_version_number = cp_cous_crv_ver_num;
299: CURSOR c_coous (
300: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
301: cp_cous_version_number IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE,
302: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE) IS
303: SELECT coous.course_cd,
304: coous.crv_version_number,

Line 301: cp_cous_version_number IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE,

297: cousr.cal_type = cp_cous_cal_type AND
298: cousr.crv_version_number = cp_cous_crv_ver_num;
299: CURSOR c_coous (
300: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
301: cp_cous_version_number IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE,
302: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE) IS
303: SELECT coous.course_cd,
304: coous.crv_version_number,
305: coous.cal_type,

Line 302: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE) IS

298: cousr.crv_version_number = cp_cous_crv_ver_num;
299: CURSOR c_coous (
300: cp_cous_course_cd IGS_PS_OFR_UNIT_SET.course_cd%TYPE,
301: cp_cous_version_number IGS_PS_OFR_UNIT_SET.crv_version_number%TYPE,
302: cp_cous_cal_type IGS_PS_OFR_UNIT_SET.cal_type%TYPE) IS
303: SELECT coous.course_cd,
304: coous.crv_version_number,
305: coous.cal_type,
306: coous.location_cd,

Line 321: IGS_PS_OFR_UNIT_SET_PKG.Insert_Row(

317: BEGIN
318: FOR v_cous_rec IN c_cous LOOP
319: BEGIN
320: x_rowid := NULL;
321: IGS_PS_OFR_UNIT_SET_PKG.Insert_Row(
322: X_ROWID => x_rowid,
323: X_COURSE_CD => v_cous_rec.course_cd,
324: X_CRV_VERSION_NUMBER => v_cous_rec.crv_version_number,
325: X_CAL_TYPE => v_cous_rec.cal_type,

Line 582: -- Check if the IGS_PS_OFR_UNIT_SET record exists

578: --- Check if the IGS_EN_UNITSETPSTYPE record exists for
579: -- the old IGS_PS_UNIT code and version number. If so, create
580: -- the new record with the substituted values.
581: crspl_unit_set_crs_type;
582: -- Check if the IGS_PS_OFR_UNIT_SET record exists
583: -- for the old IGS_PS_UNIT code and version number. If so,
584: -- create the new record with the substituted values.
585: -- Create new records for child records of cous
586: -- i.e. cousr and coous