PACKAGE: APPS.IGS_AD_IMP_026

Source

1 PACKAGE  igs_ad_imp_026 AS
2 /* $Header: IGSPE13S.pls 120.0 2005/06/01 22:35:36 appldev noship $ */
3 
4 /*
5  ||  Created By : gmuralid
6  ||  Date       : 2-DEC-2002
7  ||  Build      : SEVIS
8  ||  Bug No     : 2599109
9 
10  ||  Change History :
11  ||  Who             When            What
12  ||  ssaleem         8-OCT-2003      Included the procedure prc_pe_addr
13  ||  ssaleem         25 Aug 2004     Moving the validate_record function in visa, passport and visit histry outside to the package level
14  ||                                  Added new procedures validate_visa_pub,validate_passport_pub and visit histry pub that will be called by the Visa, Passport and Visit Histry Public APIs.
15  ||                                  Changes as part of Bug # 3847525
16 */
17 
18 PROCEDURE prc_pe_visa(
19    p_source_type_id  IN NUMBER,
20    p_batch_id        IN NUMBER );
21 
22 PROCEDURE prc_pe_passport(
23           p_source_type_id  IN NUMBER,
24           p_batch_id        IN NUMBER );
25 
26  PROCEDURE prc_pe_visit_histry(
27                p_source_type_id  IN NUMBER,
28                p_batch_id        IN NUMBER );
29 
30 PROCEDURE prc_pe_eit(
31           p_source_type_id  IN NUMBER,
32           p_batch_id        IN NUMBER );
33 
34 PROCEDURE prc_pe_addr(
35           p_source_type_id IN NUMBER,
36           p_batch_id IN  NUMBER );
37 
38 FUNCTION validate_visa_pub(api_visa_rec IGS_PE_VISAPASS_PUB.visa_rec_type,
39                            p_err_code OUT NOCOPY igs_pe_visa_int.error_code%TYPE) RETURN BOOLEAN;
40 
41 FUNCTION validate_visit_histry_pub(api_visit_rec IGS_PE_VISAPASS_PUB.visit_hstry_rec_type,
42                                    p_err_code OUT NOCOPY igs_pe_visa_int.error_code%TYPE) RETURN BOOLEAN;
43 
44 FUNCTION validate_passport_pub(api_pass_rec IGS_PE_VISAPASS_PUB.passport_rec_type,
45                                    p_err_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
46 
47 END igs_ad_imp_026;