eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_EN_SVS_AUTH

Line 898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;

894: l_cal_type igs_ca_inst.cal_type%TYPE;
895: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
896: l_person_id igs_en_elgb_ovr.person_id%TYPE;
897: l_message VARCHAR2(5000);
898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;
899: l_auth_end_dt igs_en_svs_auth.END_DT%TYPE;
900: l_sevis_auth_id igs_en_svs_auth.SEVIS_AUTH_ID%TYPE;
901: l_sevis_authorization_no igs_en_svs_auth.sevis_authorization_no%TYPE;
902:

Line 899: l_auth_end_dt igs_en_svs_auth.END_DT%TYPE;

895: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
896: l_person_id igs_en_elgb_ovr.person_id%TYPE;
897: l_message VARCHAR2(5000);
898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;
899: l_auth_end_dt igs_en_svs_auth.END_DT%TYPE;
900: l_sevis_auth_id igs_en_svs_auth.SEVIS_AUTH_ID%TYPE;
901: l_sevis_authorization_no igs_en_svs_auth.sevis_authorization_no%TYPE;
902:
903: -- Cursor to check whether active sevis person type exists for that person

Line 900: l_sevis_auth_id igs_en_svs_auth.SEVIS_AUTH_ID%TYPE;

896: l_person_id igs_en_elgb_ovr.person_id%TYPE;
897: l_message VARCHAR2(5000);
898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;
899: l_auth_end_dt igs_en_svs_auth.END_DT%TYPE;
900: l_sevis_auth_id igs_en_svs_auth.SEVIS_AUTH_ID%TYPE;
901: l_sevis_authorization_no igs_en_svs_auth.sevis_authorization_no%TYPE;
902:
903: -- Cursor to check whether active sevis person type exists for that person
904: -- modified by ckasu as a part of bug 5300119

Line 901: l_sevis_authorization_no igs_en_svs_auth.sevis_authorization_no%TYPE;

897: l_message VARCHAR2(5000);
898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;
899: l_auth_end_dt igs_en_svs_auth.END_DT%TYPE;
900: l_sevis_auth_id igs_en_svs_auth.SEVIS_AUTH_ID%TYPE;
901: l_sevis_authorization_no igs_en_svs_auth.sevis_authorization_no%TYPE;
902:
903: -- Cursor to check whether active sevis person type exists for that person
904: -- modified by ckasu as a part of bug 5300119
905: CURSOR c_sevis_person_type IS