APPS.IGS_PE_VISAPASS_PUB dependencies on IGS_PE_VISIT_HISTRY

Line 57: port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,

53: visa_issuing_country igs_pe_visa.visa_issuing_country%TYPE
54: );
55:
56: TYPE visit_hstry_rec_type IS RECORD(
57: port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,
58: cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,
59: visa_id igs_pe_visit_histry.visa_id%TYPE,
60: visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,
61: visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,

Line 58: cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,

54: );
55:
56: TYPE visit_hstry_rec_type IS RECORD(
57: port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,
58: cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,
59: visa_id igs_pe_visit_histry.visa_id%TYPE,
60: visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,
61: visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,
62: remarks igs_pe_visit_histry.remarks%TYPE

Line 59: visa_id igs_pe_visit_histry.visa_id%TYPE,

55:
56: TYPE visit_hstry_rec_type IS RECORD(
57: port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,
58: cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,
59: visa_id igs_pe_visit_histry.visa_id%TYPE,
60: visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,
61: visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,
62: remarks igs_pe_visit_histry.remarks%TYPE
63: );

Line 60: visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,

56: TYPE visit_hstry_rec_type IS RECORD(
57: port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,
58: cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,
59: visa_id igs_pe_visit_histry.visa_id%TYPE,
60: visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,
61: visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,
62: remarks igs_pe_visit_histry.remarks%TYPE
63: );
64:

Line 61: visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,

57: port_of_entry igs_pe_visit_histry.port_of_entry%TYPE,
58: cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,
59: visa_id igs_pe_visit_histry.visa_id%TYPE,
60: visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,
61: visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,
62: remarks igs_pe_visit_histry.remarks%TYPE
63: );
64:
65: TYPE passport_rec_type IS RECORD(

Line 62: remarks igs_pe_visit_histry.remarks%TYPE

58: cntry_entry_form_num igs_pe_visit_histry.cntry_entry_form_num%TYPE,
59: visa_id igs_pe_visit_histry.visa_id%TYPE,
60: visit_start_date igs_pe_visit_histry.visit_start_date%TYPE,
61: visit_end_date igs_pe_visit_histry.visit_end_date%TYPE,
62: remarks igs_pe_visit_histry.remarks%TYPE
63: );
64:
65: TYPE passport_rec_type IS RECORD(
66: passport_id igs_pe_passport.passport_id%TYPE,