[Home] [Help]
447: WHERE course_status = new_references.course_status;
448:
449: CURSOR spvh_cur IS
450: SELECT ROWID
451: FROM igs_ps_ver_hist
452: WHERE course_cd = old_references.course_cd AND
453: version_number = old_references.version_number;
454:
455: BEGIN
885:
886: BEGIN
887: FOR spvh_rec IN spvh_cur
888: LOOP
889: igs_ps_ver_hist_pkg.delete_row(x_rowid => spvh_rec.rowid);
890: END LOOP;
891: END;
892:
893: END IF;