APPS.IGS_HE_SPA_LGCY_PUB dependencies on HZ_PARTIES

Line 59: p_person_id IN hz_parties.party_id%TYPE,

55: --jtmathew 21-Sep-2004 Added validation for the new fields
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:

Line 576: l_person_id hz_parties.party_id%TYPE;

572: l_api_version CONSTANT NUMBER := 1.0;
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