APPS.IGS_PE_VISAPASS_PUB dependencies on IGS_PE_VISIT_HISTRY

Line 879: igs_pe_visit_histry_pkg.insert_row(

875: END IF;
876:
877: IF igs_ad_imp_026.Validate_visit_histry_pub(api_visit_rec => l_visit_hstry_rec, p_err_code => l_error_code) THEN
878:
879: igs_pe_visit_histry_pkg.insert_row(
880: X_ROWID => l_rowid,
881: X_PORT_OF_ENTRY => l_visit_hstry_rec.port_of_entry,
882: X_CNTRY_ENTRY_FORM_NUM => l_visit_hstry_rec.cntry_entry_form_num ,
883: X_VISA_ID => l_visit_hstry_rec.visa_id ,

Line 1001: FROM IGS_PE_VISIT_HISTRY

997:
998: CURSOR null_handlng_cur(cp_visit_rec IN visit_hstry_rec_type) IS
999: SELECT rowid,
1000: port_of_entry, cntry_entry_form_num, visa_id, visit_start_date, visit_end_date, remarks
1001: FROM IGS_PE_VISIT_HISTRY
1002: WHERE port_of_entry = cp_visit_rec.port_of_entry AND
1003: cntry_entry_form_num = cp_visit_rec.cntry_entry_form_num FOR UPDATE NOWAIT;
1004:
1005: dup_visit_rec null_handlng_cur%ROWTYPE;

Line 1100: igs_pe_visit_histry_pkg.update_row(

1096: END IF;
1097:
1098: IF igs_ad_imp_026.Validate_visit_histry_pub(api_visit_rec => l_visit_hstry_rec, p_err_code => l_error_code) THEN
1099:
1100: igs_pe_visit_histry_pkg.update_row(
1101: X_ROWID => dup_visit_rec.rowid,
1102: X_PORT_OF_ENTRY => l_visit_hstry_rec.port_of_entry,
1103: X_CNTRY_ENTRY_FORM_NUM => l_visit_hstry_rec.cntry_entry_form_num,
1104: X_VISA_ID => l_visit_hstry_rec.visa_id ,