APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_HE_EN_SUSA_CC

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 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