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_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_VISIT_HISTRY

Line 4024: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;

4020: l_visa_number IGS_PE_VISA.visa_number%TYPE;
4021: l_visa_issuing_post IGS_PE_VISA.visa_issuing_post%TYPE;
4022: l_visa_expiration_date IGS_PE_VISA.visa_expiry_date%TYPE;
4023: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;
4024: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4025: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4026: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4027: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4028: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;

Line 4026: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;

4022: l_visa_expiration_date IGS_PE_VISA.visa_expiry_date%TYPE;
4023: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;
4024: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4025: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4026: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4027: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4028: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4029: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4030: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;

Line 4027: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;

4023: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;
4024: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4025: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4026: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4027: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4028: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4029: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4030: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
4031: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;

Line 4028: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;

4024: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4025: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4026: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4027: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4028: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4029: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4030: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
4031: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
4032: l_not_valid BOOLEAN := FALSE;

Line 4048: igs_pe_visit_histry pevv,

4044: pspt.passport_expiry_date,
4045: peva.visa_issuing_country,
4046: peva.visa_issue_date
4047: FROM igs_pe_visa peva,
4048: igs_pe_visit_histry pevv,
4049: igs_pe_passport pspt
4050: WHERE peva.person_id = p_person_rec.person_id
4051: AND peva.visa_type IN ('F-1', 'F-2','M-1','M-2')
4052: AND peva.visa_id = pevv.visa_id (+)

Line 4169: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;

4165: l_visa_issuing_post IGS_PE_VISA.visa_issuing_post%TYPE;
4166: l_visa_expiration_date IGS_PE_VISA.visa_expiry_date%TYPE;
4167: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4168: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;
4169: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4170: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4171: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4172: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4173: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;

Line 4170: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;

4166: l_visa_expiration_date IGS_PE_VISA.visa_expiry_date%TYPE;
4167: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4168: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;
4169: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4170: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4171: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4172: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4173: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4174: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;

Line 4171: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;

4167: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;
4168: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;
4169: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4170: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4171: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4172: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4173: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4174: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
4175: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;

Line 4172: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;

4168: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;
4169: l_I94_number IGS_PE_VISIT_HISTRY.cntry_entry_form_num%TYPE;
4170: l_port_of_entry IGS_PE_VISIT_HISTRY.port_of_entry%TYPE;
4171: l_date_of_entry IGS_PE_VISIT_HISTRY.visit_start_date%TYPE;
4172: l_remarks IGS_PE_VISIT_HISTRY.remarks%TYPE;
4173: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;
4174: l_psprt_issuing_cntry_code IGS_PE_PASSPORT.passport_cntry_code%TYPE;
4175: l_psprt_exp_date IGS_PE_PASSPORT.passport_expiry_date%TYPE;
4176: l_not_valid BOOLEAN := FALSE;

Line 4194: igs_pe_visit_histry pevv,

4190: pspt.passport_expiry_date,
4191: peva.visa_issuing_country,
4192: peva.visa_issue_date
4193: FROM igs_pe_visa peva,
4194: igs_pe_visit_histry pevv,
4195: igs_pe_passport pspt
4196: WHERE peva.person_id = p_person_rec.person_id
4197: AND peva.visa_type IN ('J-1', 'J-2')
4198: AND peva.visa_id = pevv.visa_id (+)