APPS.IGS_PS_GEN_008 dependencies on IGS_PS_OF_UNT_SET_RL

Line 278: FROM IGS_PS_OF_UNT_SET_RL cousr

274: cousr.crv_version_number,
275: cousr.cal_type,
276: cousr.sub_unit_set_cd,
277: cousr.sub_us_version_number
278: FROM IGS_PS_OF_UNT_SET_RL cousr
279: WHERE cousr.sup_unit_set_cd = p_old_unit_set_cd AND
280: cousr.sup_us_version_number = p_old_version_number AND
281: cousr.course_cd = cp_cous_course_cd AND
282: cousr.cal_type = cp_cous_cal_type AND

Line 293: FROM IGS_PS_OF_UNT_SET_RL cousr

289: cousr.crv_version_number,
290: cousr.cal_type,
291: cousr.sup_unit_set_cd,
292: cousr.sup_us_version_number
293: FROM IGS_PS_OF_UNT_SET_RL cousr
294: WHERE cousr.sub_unit_set_cd = p_old_unit_set_cd AND
295: cousr.sub_us_version_number = p_old_version_number AND
296: cousr.course_cd = cp_cous_course_cd AND
297: cousr.cal_type = cp_cous_cal_type AND

Line 338: IGS_PS_OF_UNT_SET_RL_PKG.Insert_Row(

334: v_cous_rec.course_cd,
335: v_cous_rec.cal_type,
336: v_cous_rec.crv_version_number) LOOP
337: x_rowid := NULL;
338: IGS_PS_OF_UNT_SET_RL_PKG.Insert_Row(
339: X_ROWID => x_rowid,
340: X_COURSE_CD => v_cousr_sub_rec.course_cd,
341: X_CRV_VERSION_NUMBER => v_cousr_sub_rec.crv_version_number,
342: X_SUP_US_VERSION_NUMBER => v_cousr_sub_rec.sup_us_version_number,

Line 356: IGS_PS_OF_UNT_SET_RL_PKG.Insert_Row(

352: v_cous_rec.course_cd,
353: v_cous_rec.cal_type,
354: v_cous_rec.crv_version_number) LOOP
355: x_rowid := NULL;
356: IGS_PS_OF_UNT_SET_RL_PKG.Insert_Row(
357: X_ROWID => x_rowid,
358: X_COURSE_CD => v_cousr_sup_rec.course_cd,
359: X_CRV_VERSION_NUMBER => v_cousr_sup_rec.crv_version_number,
360: X_SUP_US_VERSION_NUMBER => p_new_version_number,