APPS.IGS_EN_SEVIS dependencies on IGS_EN_SEVIS

Line 1: PACKAGE BODY igs_en_sevis AS

1: PACKAGE BODY igs_en_sevis AS
2: /* $Header: IGSEN97B.pls 120.5 2006/06/19 11:54:53 amuthu noship $ */
3:
4:
5: FUNCTION enrf_chk_sevis_auth_req ( p_person_id NUMBER,

Line 133: WHERE lookup_type = 'IGS_EN_SEVIS_AUTH_CODES'

129: -- Get the sevis meaning for the passed sevis lookup code
130: CURSOR c_sevis_meaning (l_lookup_code igs_lookups_view.lookup_code%TYPE) IS
131: SELECT meaning
132: FROM igs_lookups_view
133: WHERE lookup_type = 'IGS_EN_SEVIS_AUTH_CODES'
134: AND lookup_code = l_lookup_code;
135:
136: -- Get the preferred alternate person id
137: CURSOR c_api_person(l_person_id hz_parties.party_id%TYPE) IS

Line 877: END igs_en_sevis;

873: CLOSE c_chk_for_auth_rec_overlap;
874: RETURN FALSE;
875: END is_auth_records_overlap;
876:
877: END igs_en_sevis;