APPS.IGS_EN_GEN_001 dependencies on IGS_AS_SU_SETATMPT_H

Line 516: v_person_id IGS_AS_SU_SETATMPT_H.person_id%TYPE;

512: BEGIN -- enrp_del_susa_hist
513: -- This module will delete the history records associated with a
514: -- IGS_AS_SU_SETATMPT record.
515: DECLARE
516: v_person_id IGS_AS_SU_SETATMPT_H.person_id%TYPE;
517: -- Delete student_unit_set_attempt_hist record, returning false if
518: -- a lock exists. Select FOR UPDATE NOWAIT to acquire locks.
519: CURSOR c_susah IS
520: SELECT susah.rowid,

Line 522: FROM IGS_AS_SU_SETATMPT_H susah

518: -- a lock exists. Select FOR UPDATE NOWAIT to acquire locks.
519: CURSOR c_susah IS
520: SELECT susah.rowid,
521: susah.person_id person_id
522: FROM IGS_AS_SU_SETATMPT_H susah
523: WHERE susah.person_id = p_person_id AND
524: susah.course_cd = p_course_cd AND
525: susah.unit_set_cd = p_unit_set_cd AND
526: susah.sequence_number = p_sequence_number

Line 534: IGS_AS_SU_SETATMPT_H_PKG.DELETE_ROW(

530: p_message_name := null;
531: FOR v_susah_rec IN c_susah LOOP
532: -- Delete the current record.
533:
534: IGS_AS_SU_SETATMPT_H_PKG.DELETE_ROW(
535: v_susah_rec.rowid
536: );
537:
538: END LOOP;