APPS.IGS_AS_SU_ATMPT_ITM_PKG dependencies on IGS_AS_SPL_CONS_APPL

Line 385: CURSOR cur_igs_as_spl_cons_appl IS

381: END IF;
382: END check_parent_existance;
383:
384: PROCEDURE check_child_existance AS
385: CURSOR cur_igs_as_spl_cons_appl IS
386: SELECT ROWID
387: FROM igs_as_spl_cons_appl
388: WHERE course_cd = old_references.course_cd
389: AND person_id = old_references.person_id

Line 387: FROM igs_as_spl_cons_appl

383:
384: PROCEDURE check_child_existance AS
385: CURSOR cur_igs_as_spl_cons_appl IS
386: SELECT ROWID
387: FROM igs_as_spl_cons_appl
388: WHERE course_cd = old_references.course_cd
389: AND person_id = old_references.person_id
390: AND ass_id = old_references.ass_id
391: AND creation_dt = old_references.creation_dt

Line 394: FOR igs_as_spl_cons_appl_rec IN cur_igs_as_spl_cons_appl LOOP

390: AND ass_id = old_references.ass_id
391: AND creation_dt = old_references.creation_dt
392: AND uoo_id = old_references.uoo_id;
393: BEGIN
394: FOR igs_as_spl_cons_appl_rec IN cur_igs_as_spl_cons_appl LOOP
395: igs_as_spl_cons_appl_pkg.delete_row (x_rowid => igs_as_spl_cons_appl_rec.ROWID);
396: END LOOP;
397: igs_as_std_exm_instn_pkg.get_fk_igs_as_su_atmpt_itm (
398: old_references.course_cd,

Line 395: igs_as_spl_cons_appl_pkg.delete_row (x_rowid => igs_as_spl_cons_appl_rec.ROWID);

391: AND creation_dt = old_references.creation_dt
392: AND uoo_id = old_references.uoo_id;
393: BEGIN
394: FOR igs_as_spl_cons_appl_rec IN cur_igs_as_spl_cons_appl LOOP
395: igs_as_spl_cons_appl_pkg.delete_row (x_rowid => igs_as_spl_cons_appl_rec.ROWID);
396: END LOOP;
397: igs_as_std_exm_instn_pkg.get_fk_igs_as_su_atmpt_itm (
398: old_references.course_cd,
399: old_references.person_id,