APPS.IGS_PS_GEN_008 dependencies on IGS_EN_UNITSETPSTYPE

Line 214: FROM IGS_EN_UNITSETPSTYPE usct

210: BEGIN
211: DECLARE
212: CURSOR c_usct IS
213: SELECT usct.course_type
214: FROM IGS_EN_UNITSETPSTYPE usct
215: WHERE usct.unit_set_cd = p_old_unit_set_cd AND
216: usct.version_number = p_old_version_number;
217: BEGIN
218: FOR v_usct_rec IN c_usct LOOP

Line 221: IGS_EN_UNITSETPSTYPE_PKG.Insert_Row(

217: BEGIN
218: FOR v_usct_rec IN c_usct LOOP
219: BEGIN
220: x_rowid := NULL;
221: IGS_EN_UNITSETPSTYPE_PKG.Insert_Row(
222: X_ROWID => x_rowid,
223: X_UNIT_SET_CD => p_new_unit_set_cd,
224: X_VERSION_NUMBER => p_new_version_number,
225: X_COURSE_TYPE => v_usct_rec.course_type,

Line 578: --- Check if the IGS_EN_UNITSETPSTYPE record exists for

574: -- Check if the IGS_EN_UNIT_SET_NOTE record exists for the old IGS_PS_UNIT
575: -- code and version number. If so, create the new record
576: -- with the substituted values.
577: crspl_unit_set_note;
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