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_EN_FUTURE_DT_TRANS dependencies on IGS_HE_EN_SUSA

Line 706: FROM IGS_HE_EN_SUSA hes

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
709: AND hes.unit_set_cd = cp_unit_set_cd
710: AND hes.sequence_number = cp_sequence_number;

Line 713: cp_hesa_en_susa_id IGS_HE_EN_SUSA.hesa_en_susa_id%TYPE) IS

709: AND hes.unit_set_cd = cp_unit_set_cd
710: AND hes.sequence_number = cp_sequence_number;
711:
712: CURSOR c_hes_del (
713: cp_hesa_en_susa_id IGS_HE_EN_SUSA.hesa_en_susa_id%TYPE) IS
714: SELECT rowid
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 ;

Line 715: FROM IGS_HE_EN_SUSA hes

711:
712: CURSOR c_hes_del (
713: cp_hesa_en_susa_id IGS_HE_EN_SUSA.hesa_en_susa_id%TYPE) IS
714: SELECT rowid
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,

Line 722: FROM IGS_HE_EN_SUSA_CC hesc

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
725: AND hesc.unit_set_cd = cp_unit_set_cd
726: AND hesc.sequence_number = cp_sequence_number;

Line 729: cp_he_susa_cc_id IGS_HE_EN_SUSA_CC.he_susa_cc_id%TYPE) IS

725: AND hesc.unit_set_cd = cp_unit_set_cd
726: AND hesc.sequence_number = cp_sequence_number;
727:
728: CURSOR c_hesc_del (
729: cp_he_susa_cc_id IGS_HE_EN_SUSA_CC.he_susa_cc_id%TYPE) IS
730: SELECT rowid
731: FROM IGS_HE_EN_SUSA_CC hesc
732: WHERE hesc.he_susa_cc_id = cp_he_susa_cc_id
733: FOR UPDATE OF hesc.LAST_UPDATE_DATE NOWAIT ;

Line 731: FROM IGS_HE_EN_SUSA_CC hesc

727:
728: CURSOR c_hesc_del (
729: cp_he_susa_cc_id IGS_HE_EN_SUSA_CC.he_susa_cc_id%TYPE) IS
730: SELECT rowid
731: FROM IGS_HE_EN_SUSA_CC hesc
732: WHERE hesc.he_susa_cc_id = cp_he_susa_cc_id
733: FOR UPDATE OF hesc.LAST_UPDATE_DATE NOWAIT ;
734:
735: v_susa_del_exists c_susa_del%ROWTYPE;

Line 755: -- Delete unconfirmed IGS_HE_EN_SUSA records

751: FOR v_susa_rec IN c_susa LOOP
752: FOR v_hes_rec IN c_hes (v_susa_rec.unit_set_cd, v_susa_rec.sequence_number )
753: LOOP
754: BEGIN
755: -- Delete unconfirmed IGS_HE_EN_SUSA records
756: FOR v_hes_del_rec in c_hes_del(v_hes_rec.hesa_en_susa_id) LOOP
757:
758: IGS_HE_EN_SUSA_PKG.DELETE_ROW( X_ROWID => v_hes_del_rec.ROWID );
759:

Line 758: IGS_HE_EN_SUSA_PKG.DELETE_ROW( X_ROWID => v_hes_del_rec.ROWID );

754: BEGIN
755: -- Delete unconfirmed IGS_HE_EN_SUSA records
756: FOR v_hes_del_rec in c_hes_del(v_hes_rec.hesa_en_susa_id) LOOP
757:
758: IGS_HE_EN_SUSA_PKG.DELETE_ROW( X_ROWID => v_hes_del_rec.ROWID );
759:
760: END LOOP;
761: EXCEPTION
762: WHEN e_resource_busy THEN

Line 766: l_entity_name := 'IGS_HE_EN_SUSA';

762: WHEN e_resource_busy THEN
763: IF c_hes_del%ISOPEN THEN
764: CLOSE c_hes_del;
765: END IF;
766: l_entity_name := 'IGS_HE_EN_SUSA';
767: EXIT;
768: END;
769: END LOOP;
770:

Line 775: -- Delete unconfirmed IGS_HE_EN_SUSA_CC records

771: FOR v_hesc_rec IN c_hesc (v_susa_rec.unit_set_cd, v_susa_rec.sequence_number )
772: LOOP
773:
774: BEGIN
775: -- Delete unconfirmed IGS_HE_EN_SUSA_CC records
776: FOR v_hesc_del_rec in c_hesc_del(v_hesc_rec.he_susa_cc_id) LOOP
777:
778: IGS_HE_EN_SUSA_CC_PKG.DELETE_ROW( X_ROWID => v_hesc_del_rec.ROWID );
779:

Line 778: IGS_HE_EN_SUSA_CC_PKG.DELETE_ROW( X_ROWID => v_hesc_del_rec.ROWID );

774: BEGIN
775: -- Delete unconfirmed IGS_HE_EN_SUSA_CC records
776: FOR v_hesc_del_rec in c_hesc_del(v_hesc_rec.he_susa_cc_id) LOOP
777:
778: IGS_HE_EN_SUSA_CC_PKG.DELETE_ROW( X_ROWID => v_hesc_del_rec.ROWID );
779:
780: END LOOP;
781: EXCEPTION
782: WHEN e_resource_busy THEN

Line 786: l_entity_name := 'IGS_HE_EN_SUSA_CC';

782: WHEN e_resource_busy THEN
783: IF c_hesc_del%ISOPEN THEN
784: CLOSE c_hesc_del;
785: END IF;
786: l_entity_name := 'IGS_HE_EN_SUSA_CC';
787: EXIT;
788: END;
789: END LOOP;
790: IF l_entity_name IS NOT NULL THEN