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_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_PASSPORT

Line 4981: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;

4977: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4978: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4979: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4980: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4981: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4982: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
4983: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
4984: l_not_valid BOOLEAN := FALSE;
4985:

Line 4982: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;

4978: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4979: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4980: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4981: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4982: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
4983: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
4984: l_not_valid BOOLEAN := FALSE;
4985:
4986: CURSOR c_get_visa_data IS

Line 4983: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;

4979: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4980: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4981: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4982: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
4983: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
4984: l_not_valid BOOLEAN := FALSE;
4985:
4986: CURSOR c_get_visa_data IS
4987: SELECT peva.visa_number,

Line 5001: igs_pe_passport pspt

4997: peva.visa_issuing_country,
4998: peva.visa_issue_date
4999: FROM igs_pe_visa peva,
5000: igs_pe_visit_histry pevv,
5001: igs_pe_passport pspt
5002: WHERE peva.person_id = p_person_rec.person_id
5003: AND peva.visa_type IN ('F-1', 'F-2','M-1','M-2')
5004: AND peva.visa_id = pevv.visa_id (+)
5005: AND pspt.passport_id (+) = peva.passport_id

Line 5129: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;

5125: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
5126: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
5127: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
5128: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
5129: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
5130: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
5131: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
5132: l_not_valid BOOLEAN := FALSE;
5133:

Line 5130: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;

5126: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
5127: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
5128: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
5129: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
5130: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
5131: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
5132: l_not_valid BOOLEAN := FALSE;
5133:
5134: --to_char(peva.visa_issue_date,'YYYY-MM-DD') visa_issue_date

Line 5131: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;

5127: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
5128: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
5129: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
5130: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
5131: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
5132: l_not_valid BOOLEAN := FALSE;
5133:
5134: --to_char(peva.visa_issue_date,'YYYY-MM-DD') visa_issue_date
5135:

Line 5151: igs_pe_passport pspt

5147: peva.visa_issuing_country,
5148: peva.visa_issue_date
5149: FROM igs_pe_visa peva,
5150: igs_pe_visit_histry pevv,
5151: igs_pe_passport pspt
5152: WHERE peva.person_id = p_person_rec.person_id
5153: AND peva.visa_type IN ('J-1', 'J-2')
5154: AND peva.visa_id = pevv.visa_id (+)
5155: AND pspt.passport_id (+) = peva.passport_id