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_VISA

Line 1292: FROM igs_pe_visa peva

1288: AND sysdate between hzpp.effective_start_date AND NVL(hzpp.effective_end_date,sysdate+1);
1289:
1290: CURSOR c_nonimg_data IS
1291: SELECT peva.visa_type
1292: FROM igs_pe_visa peva
1293: WHERE peva.person_id = p_person_rec.person_id
1294: AND SYSDATE BETWEEN peva.visa_issue_date AND peva.visa_expiry_date;
1295:
1296: CURSOR c_com_data IS

Line 1329: l_visa_type IGS_PE_VISA.visa_type%TYPE;

1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1326: l_gender hz_person_profiles.gender%TYPE;
1327: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1328: l_citizen_cntry_code hz_citizenship.country_code%TYPE;
1329: l_visa_type IGS_PE_VISA.visa_type%TYPE;
1330: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type
1331: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1332: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1333: l_category_code IGS_PE_EV_FORM.category_code%TYPE;

Line 4020: l_visa_number IGS_PE_VISA.visa_number%TYPE;

4016: ) RETURN VARCHAR2
4017: IS
4018:
4019: l_api_name CONSTANT VARCHAR(30) := 'Validate_Legal_Info';
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;

Line 4021: l_visa_issuing_post IGS_PE_VISA.visa_issuing_post%TYPE;

4017: IS
4018:
4019: l_api_name CONSTANT VARCHAR(30) := 'Validate_Legal_Info';
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;

Line 4022: l_visa_expiration_date IGS_PE_VISA.visa_expiry_date%TYPE;

4018:
4019: l_api_name CONSTANT VARCHAR(30) := 'Validate_Legal_Info';
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;

Line 4023: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;

4019: l_api_name CONSTANT VARCHAR(30) := 'Validate_Legal_Info';
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;

Line 4025: l_visa_issue_date IGS_PE_VISA.visa_issue_date%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;
4029: l_psprt_number IGS_PE_PASSPORT.passport_number%TYPE;

Line 4047: FROM igs_pe_visa peva,

4043: pspt.passport_cntry_code,
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')

Line 4164: l_visa_number IGS_PE_VISA.visa_number%TYPE;

4160: ) RETURN VARCHAR2
4161: IS
4162:
4163: l_api_name CONSTANT VARCHAR(30) := 'Validate_ev_Legal_Info';
4164: l_visa_number IGS_PE_VISA.visa_number%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;

Line 4165: l_visa_issuing_post IGS_PE_VISA.visa_issuing_post%TYPE;

4161: IS
4162:
4163: l_api_name CONSTANT VARCHAR(30) := 'Validate_ev_Legal_Info';
4164: l_visa_number IGS_PE_VISA.visa_number%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;

Line 4166: l_visa_expiration_date IGS_PE_VISA.visa_expiry_date%TYPE;

4162:
4163: l_api_name CONSTANT VARCHAR(30) := 'Validate_ev_Legal_Info';
4164: l_visa_number IGS_PE_VISA.visa_number%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;

Line 4167: l_visa_issue_date IGS_PE_VISA.visa_issue_date%TYPE;

4163: l_api_name CONSTANT VARCHAR(30) := 'Validate_ev_Legal_Info';
4164: l_visa_number IGS_PE_VISA.visa_number%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;

Line 4168: l_visa_issuing_country IGS_PE_VISA.visa_issuing_country%TYPE;

4164: l_visa_number IGS_PE_VISA.visa_number%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;

Line 4193: FROM igs_pe_visa peva,

4189: pspt.passport_cntry_code,
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')