APPS.IGS_AD_GEN_001 dependencies on IGS_HE_EN_SUSA

Line 727: FROM IGS_HE_EN_SUSA hes

723:
724: CURSOR c_hes ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
725: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
726: SELECT hesa_en_susa_id
727: FROM IGS_HE_EN_SUSA hes
728: WHERE hes.person_id = p_person_id AND
729: hes.course_cd = p_course_cd AND
730: hes.unit_set_cd = cp_unit_set_cd AND
731: hes.sequence_number = cp_sequence_number;

Line 734: cp_hesa_en_susa_id IGS_HE_EN_SUSA.hesa_en_susa_id%TYPE) IS

730: hes.unit_set_cd = cp_unit_set_cd AND
731: hes.sequence_number = cp_sequence_number;
732:
733: CURSOR c_hes_del (
734: cp_hesa_en_susa_id IGS_HE_EN_SUSA.hesa_en_susa_id%TYPE) IS
735: SELECT rowid
736: FROM IGS_HE_EN_SUSA hes
737: WHERE hes.hesa_en_susa_id = cp_hesa_en_susa_id
738: FOR UPDATE OF hes.LAST_UPDATE_DATE NOWAIT ;

Line 736: FROM IGS_HE_EN_SUSA hes

732:
733: CURSOR c_hes_del (
734: cp_hesa_en_susa_id IGS_HE_EN_SUSA.hesa_en_susa_id%TYPE) IS
735: SELECT rowid
736: FROM IGS_HE_EN_SUSA hes
737: WHERE hes.hesa_en_susa_id = cp_hesa_en_susa_id
738: FOR UPDATE OF hes.LAST_UPDATE_DATE NOWAIT ;
739:
740: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

Line 743: FROM IGS_HE_EN_SUSA_CC hesc

739:
740: CURSOR c_hesc ( cp_unit_set_cd IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
741: cp_sequence_number IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
742: SELECT he_susa_cc_id
743: FROM IGS_HE_EN_SUSA_CC hesc
744: WHERE hesc.person_id = p_person_id AND
745: hesc.course_cd = p_course_cd AND
746: hesc.unit_set_cd = cp_unit_set_cd AND
747: hesc.sequence_number = cp_sequence_number;

Line 750: cp_he_susa_cc_id IGS_HE_EN_SUSA_CC.he_susa_cc_id%TYPE) IS

746: hesc.unit_set_cd = cp_unit_set_cd AND
747: hesc.sequence_number = cp_sequence_number;
748:
749: CURSOR c_hesc_del (
750: cp_he_susa_cc_id IGS_HE_EN_SUSA_CC.he_susa_cc_id%TYPE) IS
751: SELECT rowid
752: FROM IGS_HE_EN_SUSA_CC hesc
753: WHERE hesc.he_susa_cc_id = cp_he_susa_cc_id
754: FOR UPDATE OF hesc.LAST_UPDATE_DATE NOWAIT ;

Line 752: FROM IGS_HE_EN_SUSA_CC hesc

748:
749: CURSOR c_hesc_del (
750: cp_he_susa_cc_id IGS_HE_EN_SUSA_CC.he_susa_cc_id%TYPE) IS
751: SELECT rowid
752: FROM IGS_HE_EN_SUSA_CC hesc
753: WHERE hesc.he_susa_cc_id = cp_he_susa_cc_id
754: FOR UPDATE OF hesc.LAST_UPDATE_DATE NOWAIT ;
755:
756: L_ROWID VARCHAR2(25);

Line 775: -- Delete unconfirmed IGS_HE_EN_SUSA records

771:
772: FOR v_hes_rec IN c_hes (v_susa_rec.unit_set_cd, v_susa_rec.sequence_number )
773: LOOP
774: BEGIN
775: -- Delete unconfirmed IGS_HE_EN_SUSA records
776: FOR v_hes_del_rec in c_hes_del(
777: v_hes_rec.hesa_en_susa_id) LOOP
778:
779: IGS_HE_EN_SUSA_PKG.DELETE_ROW(

Line 779: IGS_HE_EN_SUSA_PKG.DELETE_ROW(

775: -- Delete unconfirmed IGS_HE_EN_SUSA records
776: FOR v_hes_del_rec in c_hes_del(
777: v_hes_rec.hesa_en_susa_id) LOOP
778:
779: IGS_HE_EN_SUSA_PKG.DELETE_ROW(
780: X_ROWID => v_hes_del_rec.ROWID );
781:
782: END LOOP;
783: EXCEPTION

Line 788: l_entity_name := 'IGS_HE_EN_SUSA';

784: WHEN e_resource_busy THEN
785: IF c_hes_del%ISOPEN THEN
786: CLOSE c_hes_del;
787: END IF;
788: l_entity_name := 'IGS_HE_EN_SUSA';
789: EXIT;
790: END;
791:
792: END LOOP;

Line 797: -- Delete unconfirmed IGS_HE_EN_SUSA_CC records

793:
794: FOR v_hesc_rec IN c_hesc (v_susa_rec.unit_set_cd, v_susa_rec.sequence_number )
795: LOOP
796: BEGIN
797: -- Delete unconfirmed IGS_HE_EN_SUSA_CC records
798: FOR v_hesc_del_rec in c_hesc_del(
799: v_hesc_rec.he_susa_cc_id) LOOP
800:
801: IGS_HE_EN_SUSA_CC_PKG.DELETE_ROW(

Line 801: IGS_HE_EN_SUSA_CC_PKG.DELETE_ROW(

797: -- Delete unconfirmed IGS_HE_EN_SUSA_CC records
798: FOR v_hesc_del_rec in c_hesc_del(
799: v_hesc_rec.he_susa_cc_id) LOOP
800:
801: IGS_HE_EN_SUSA_CC_PKG.DELETE_ROW(
802: X_ROWID => v_hesc_del_rec.ROWID );
803:
804: END LOOP;
805: EXCEPTION

Line 810: l_entity_name := 'IGS_HE_EN_SUSA_CC';

806: WHEN e_resource_busy THEN
807: IF c_hesc_del%ISOPEN THEN
808: CLOSE c_hesc_del;
809: END IF;
810: l_entity_name := 'IGS_HE_EN_SUSA_CC';
811: EXIT;
812: END;
813:
814: END LOOP;