APPS.IGS_AD_GEN_001 dependencies on IGS_HE_EN_SUSA_CC

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