DBA Data[Home] [Help]

APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_EN_SU_ATTEMPT

Line 361: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

357: FUNCTION validate_trncmt_db_cons(
358: p_person_id IN igs_pe_person.person_id%TYPE,
359: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
360: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
361: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
362: p_lgcy_trncmt_rec IN lgcy_trncmt_rec_type
363: ) RETURN VARCHAR2
364: /****************************************************************************
365: || Created By : anilk

Line 520: --Foreign key validation with IGS_EN_SU_ATTEMPT

516: l_return_value := 'E';
517: END IF;
518: END IF;
519:
520: --Foreign key validation with IGS_EN_SU_ATTEMPT
521: IF p_lgcy_trncmt_rec.comment_type_code = 'CAREER_TERM' THEN
522: OPEN cur_check_career_term(
523: p_person_id,
524: p_lgcy_trncmt_rec.program_type,