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.

[Home] [Help]

APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_AS_SU_SETATMPT

Line 673: -- (2) Delete IGS_AS_SU_SETATMPT records

669: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
670: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
671: IS
672: BEGIN -- del_susa
673: -- (2) Delete IGS_AS_SU_SETATMPT records
674: DECLARE
675: CURSOR c_susa IS
676: SELECT susa.unit_set_cd,susa.sequence_number
677: FROM IGS_AS_SU_SETATMPT susa

Line 677: FROM IGS_AS_SU_SETATMPT susa

673: -- (2) Delete IGS_AS_SU_SETATMPT records
674: DECLARE
675: CURSOR c_susa IS
676: SELECT susa.unit_set_cd,susa.sequence_number
677: FROM IGS_AS_SU_SETATMPT susa
678: WHERE susa.person_id = p_person_id
679: AND susa.course_cd = p_course_cd
680: START WITH
681: susa.person_id = p_person_id AND

Line 692: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

688: PRIOR susa.sequence_number = susa.parent_sequence_number
689: ORDER BY LEVEL DESC;
690:
691: CURSOR c_susa_del (
692: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
693: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
694: SELECT ROWID, susa.*
695: FROM IGS_AS_SU_SETATMPT susa
696: WHERE susa.person_id = p_person_id

Line 693: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS

689: ORDER BY LEVEL DESC;
690:
691: CURSOR c_susa_del (
692: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
693: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
694: SELECT ROWID, susa.*
695: FROM IGS_AS_SU_SETATMPT susa
696: WHERE susa.person_id = p_person_id
697: AND susa.course_cd = p_course_cd

Line 695: FROM IGS_AS_SU_SETATMPT susa

691: CURSOR c_susa_del (
692: cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
693: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
694: SELECT ROWID, susa.*
695: FROM IGS_AS_SU_SETATMPT susa
696: WHERE susa.person_id = p_person_id
697: AND susa.course_cd = p_course_cd
698: AND susa.unit_set_cd = cp_unit_set_cd
699: AND susa.sequence_number = cp_sequence_number

Line 703: CURSOR c_hes ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

699: AND susa.sequence_number = cp_sequence_number
700: FOR UPDATE OF
701: susa.LAST_UPDATE_DATE NOWAIT;
702:
703: CURSOR c_hes ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
704: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
705: SELECT hesa_en_susa_id
706: FROM IGS_HE_EN_SUSA hes
707: WHERE hes.person_id = p_person_id

Line 704: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS

700: FOR UPDATE OF
701: susa.LAST_UPDATE_DATE NOWAIT;
702:
703: CURSOR c_hes ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
704: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
705: SELECT hesa_en_susa_id
706: FROM IGS_HE_EN_SUSA hes
707: WHERE hes.person_id = p_person_id
708: AND hes.course_cd = p_course_cd

Line 719: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

715: FROM IGS_HE_EN_SUSA hes
716: WHERE hes.hesa_en_susa_id = cp_hesa_en_susa_id
717: FOR UPDATE OF hes.LAST_UPDATE_DATE NOWAIT ;
718:
719: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
720: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
721: SELECT he_susa_cc_id
722: FROM IGS_HE_EN_SUSA_CC hesc
723: WHERE hesc.person_id = p_person_id

Line 720: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS

716: WHERE hes.hesa_en_susa_id = cp_hesa_en_susa_id
717: FOR UPDATE OF hes.LAST_UPDATE_DATE NOWAIT ;
718:
719: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
720: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
721: SELECT he_susa_cc_id
722: FROM IGS_HE_EN_SUSA_CC hesc
723: WHERE hesc.person_id = p_person_id
724: AND hesc.course_cd = p_course_cd

Line 793: -- Delete unconfirmed IGS_AS_SU_SETATMPT

789: END LOOP;
790: IF l_entity_name IS NOT NULL THEN
791: EXIT;
792: END IF;
793: -- Delete unconfirmed IGS_AS_SU_SETATMPT
794: FOR v_susa_del_exists IN c_susa_del(
795: v_susa_rec.unit_set_cd,
796: v_susa_rec.sequence_number) LOOP
797:

Line 798: IGS_AS_SU_SETATMPT_PKG.DELETE_ROW ( X_ROWID => V_SUSA_DEL_EXISTS.ROWID );

794: FOR v_susa_del_exists IN c_susa_del(
795: v_susa_rec.unit_set_cd,
796: v_susa_rec.sequence_number) LOOP
797:
798: IGS_AS_SU_SETATMPT_PKG.DELETE_ROW ( X_ROWID => V_SUSA_DEL_EXISTS.ROWID );
799:
800: END LOOP;
801:
802: END LOOP;