APPS.IGS_AD_GEN_001 dependencies on IGS_EN_SU_ATTEMPT_H

Line 616: -- Delete IGS_EN_SU_ATTEMPT_H records

612: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
613: RETURN BOOLEAN
614: IS
615: BEGIN -- admpl_del_suah
616: -- Delete IGS_EN_SU_ATTEMPT_H records
617: DECLARE
618: CURSOR c_suah IS
619: SELECT suah.uoo_id,
620: suah.hist_start_dt

Line 621: FROM IGS_EN_SU_ATTEMPT_H suah

617: DECLARE
618: CURSOR c_suah IS
619: SELECT suah.uoo_id,
620: suah.hist_start_dt
621: FROM IGS_EN_SU_ATTEMPT_H suah
622: WHERE suah.person_id = p_person_id AND
623: suah.course_cd = p_course_cd ;
624:
625:

Line 627: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,

623: suah.course_cd = p_course_cd ;
624:
625:
626: CURSOR c_suah_del (
627: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
628: cp_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE) IS
629: SELECT row_id
630: FROM IGS_EN_SU_ATTEMPT_H suah
631: WHERE suah.person_id = p_person_id AND

Line 628: cp_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE) IS

624:
625:
626: CURSOR c_suah_del (
627: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
628: cp_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE) IS
629: SELECT row_id
630: FROM IGS_EN_SU_ATTEMPT_H suah
631: WHERE suah.person_id = p_person_id AND
632: suah.course_cd = p_course_cd AND

Line 630: FROM IGS_EN_SU_ATTEMPT_H suah

626: CURSOR c_suah_del (
627: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
628: cp_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE) IS
629: SELECT row_id
630: FROM IGS_EN_SU_ATTEMPT_H suah
631: WHERE suah.person_id = p_person_id AND
632: suah.course_cd = p_course_cd AND
633: suah.uoo_id = cp_uoo_id AND
634: suah.hist_start_dt = cp_hist_start_dt

Line 645: -- Delete IGS_EN_SU_ATTEMPT_H records

641:
642: v_error_flag := FALSE;
643:
644: FOR v_suah_rec IN c_suah LOOP
645: -- Delete IGS_EN_SU_ATTEMPT_H records
646: FOR v_suah_del_exists IN c_suah_del(v_suah_rec.uoo_id, v_suah_rec.hist_start_dt) LOOP
647:
648: IGS_EN_SU_ATTEMPT_H_PKG.DELETE_ROW(
649: X_ROWID => v_suah_del_exists.ROW_ID );

Line 648: IGS_EN_SU_ATTEMPT_H_PKG.DELETE_ROW(

644: FOR v_suah_rec IN c_suah LOOP
645: -- Delete IGS_EN_SU_ATTEMPT_H records
646: FOR v_suah_del_exists IN c_suah_del(v_suah_rec.uoo_id, v_suah_rec.hist_start_dt) LOOP
647:
648: IGS_EN_SU_ATTEMPT_H_PKG.DELETE_ROW(
649: X_ROWID => v_suah_del_exists.ROW_ID );
650: END LOOP;
651: END LOOP;
652:

Line 663: l_entity_name := 'IGS_EN_SU_ATTEMPT_H';

659: END IF;
660: IF c_suah_del%ISOPEN THEN
661: CLOSE c_suah_del;
662: END IF;
663: l_entity_name := 'IGS_EN_SU_ATTEMPT_H';
664: RETURN FALSE;
665: WHEN OTHERS THEN
666: IF c_suah%ISOPEN THEN
667: CLOSE c_suah;

Line 2058: -- Delete IGS_EN_SU_ATTEMPT_H (9)

2054: END IF;
2055: END IF;
2056: */
2057:
2058: -- Delete IGS_EN_SU_ATTEMPT_H (9)
2059: IF NOT v_process_next THEN
2060: IF NOT admpl_del_suah(
2061: v_sca_rec.person_id,
2062: v_sca_rec.course_cd) THEN