APPS.IGS_HE_SPA_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT

Line 60: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

56: -- described in HEFD350.
57: ------------------------------------------------------------------ */
58: FUNCTION validate_db_cons(
59: p_person_id IN hz_parties.party_id%TYPE,
60: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
61: p_hesa_spa_stats_rec IN hesa_spa_rec_type)
62: RETURN VARCHAR2 AS
63:
64: l_msg_count NUMBER;

Line 80: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation(x_person_id => p_person_id,

76:
77: -- start of Foreign Key validations
78: --
79: -- Check whether the program attempt exists
80: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation(x_person_id => p_person_id,
81: x_course_cd => p_hesa_spa_stats_rec.program_cd) THEN
82: FND_MESSAGE.SET_NAME('IGS','IGS_HE_EXT_SPA_DTL_NOT_FOUND');
83: FND_MSG_PUB.ADD;
84: l_db_val_failed := TRUE;

Line 577: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;

573:
574: l_validation_failed BOOLEAN := FALSE;
575: l_db_val_status VARCHAR2(1);
576: l_person_id hz_parties.party_id%TYPE;
577: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;
578: l_hesa_st_spa_id igs_he_st_spa_all.hesa_st_spa_id%TYPE;
579:
580: BEGIN
581: -- Create save point