eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_001 dependencies on IGS_EN_SU_ATTEMPT

Line 544: -- (1) Delete IGS_EN_SU_ATTEMPT records

540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
541: RETURN BOOLEAN
542: IS
543: BEGIN -- admpl_del_sua
544: -- (1) Delete IGS_EN_SU_ATTEMPT records
545: DECLARE
546: CURSOR c_sua IS
547: SELECT uoo_id
548: FROM IGS_EN_SU_ATTEMPT sua

Line 548: FROM IGS_EN_SU_ATTEMPT sua

544: -- (1) Delete IGS_EN_SU_ATTEMPT records
545: DECLARE
546: CURSOR c_sua IS
547: SELECT uoo_id
548: FROM IGS_EN_SU_ATTEMPT sua
549: WHERE sua.person_id = p_person_id AND
550: sua.course_cd = p_course_cd;
551: CURSOR c_sua_del (
552: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

Line 552: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

548: FROM IGS_EN_SU_ATTEMPT sua
549: WHERE sua.person_id = p_person_id AND
550: sua.course_cd = p_course_cd;
551: CURSOR c_sua_del (
552: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
553: SELECT row_id
554: FROM IGS_EN_SU_ATTEMPT sua
555: WHERE sua.person_id = p_person_id AND
556: sua.course_cd = p_course_cd AND

Line 554: FROM IGS_EN_SU_ATTEMPT sua

550: sua.course_cd = p_course_cd;
551: CURSOR c_sua_del (
552: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
553: SELECT row_id
554: FROM IGS_EN_SU_ATTEMPT sua
555: WHERE sua.person_id = p_person_id AND
556: sua.course_cd = p_course_cd AND
557: sua.uoo_id = cp_uoo_id
558: FOR UPDATE OF

Line 567: -- Delete unconfirmed IGS_EN_SU_ATTEMPT

563: BEGIN
564: v_error_flag := FALSE;
565: FOR v_sua_rec IN c_sua LOOP
566:
567: -- Delete unconfirmed IGS_EN_SU_ATTEMPT
568: FOR v_sua_del_exists IN c_sua_del(v_sua_rec.uoo_id) LOOP
569: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(
570: X_ROWID => v_sua_del_exists.row_id );
571: END LOOP;

Line 569: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(

565: FOR v_sua_rec IN c_sua LOOP
566:
567: -- Delete unconfirmed IGS_EN_SU_ATTEMPT
568: FOR v_sua_del_exists IN c_sua_del(v_sua_rec.uoo_id) LOOP
569: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(
570: X_ROWID => v_sua_del_exists.row_id );
571: END LOOP;
572:
573: END LOOP;

Line 587: l_entity_name := 'IGS_EN_SU_ATTEMPT_ALL';

583: END IF;
584: IF c_sua_del%ISOPEN THEN
585: CLOSE c_sua_del;
586: END IF;
587: l_entity_name := 'IGS_EN_SU_ATTEMPT_ALL';
588: RETURN FALSE;
589: WHEN OTHERS THEN
590: IF c_sua%ISOPEN THEN
591: CLOSE c_sua;

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

Line 2069: -- Delete IGS_EN_SU_ATTEMPT (10)

2065: v_process_next := TRUE;
2066: END IF;
2067: END IF;
2068:
2069: -- Delete IGS_EN_SU_ATTEMPT (10)
2070: IF NOT v_process_next THEN
2071: IF NOT admpl_del_sua(
2072: v_sca_rec.person_id,
2073: v_sca_rec.course_cd) THEN