1 PACKAGE igs_uc_exp_applicant_dtls AS
2 /* $Header: IGSUC44S.pls 120.1 2006/08/21 06:16:25 jbaber noship $ */
3
4 PROCEDURE export_process ( errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY NUMBER,
6 p_app_no IN NUMBER,
7 p_addr_usage_home IN VARCHAR2 DEFAULT NULL,
8 p_addr_usage_corr IN VARCHAR2 DEFAULT NULL) ;
9
10 PROCEDURE pop_api_int ( p_ni_number IN VARCHAR2,
11 p_ninumber_alt_type IN VARCHAR2,
12 p_scn IN VARCHAR2,
13 p_person_id IN NUMBER,
14 p_interface_id IN NUMBER,
15 p_app_valid_status IN OUT NOCOPY BOOLEAN) ;
16
17 PROCEDURE pop_res_dtls_int( p_rescat IN VARCHAR2,
18 p_application_date IN DATE,
19 p_system_code IN VARCHAR2,
20 p_interface_id IN NUMBER,
21 p_cal_type IN VARCHAR2, -- anwest UCFD040 Bug# 4015492 Added new parameter
22 p_sequence_number IN NUMBER, -- anwest UCFD040 Bug# 4015492 Added new parameter
23 p_app_valid_status IN OUT NOCOPY BOOLEAN) ;
24
25 PROCEDURE pop_citizen_int ( p_nationality IN NUMBER,
26 p_dual_nationality IN NUMBER,
27 p_person_id IN NUMBER,
28 p_application_date IN DATE,
29 p_interface_id IN NUMBER,
30 p_app_valid_status IN OUT NOCOPY BOOLEAN) ;
31
32 PROCEDURE pop_acad_hist_int ( p_person_id IN NUMBER,
33 p_person_number IN VARCHAR2,
34 p_school IN NUMBER,
35 p_interface_id IN NUMBER,
36 p_app_valid_status IN OUT NOCOPY BOOLEAN);
37
38 PROCEDURE pop_disability_int(p_special_needs IN VARCHAR2,
39 p_person_id IN NUMBER,
40 p_application_date IN DATE,
41 p_interface_id IN NUMBER,
42 p_app_valid_status IN OUT NOCOPY BOOLEAN) ;
43
44 PROCEDURE pop_contact_int ( p_telephone IN VARCHAR2,
45 p_email IN VARCHAR2,
46 p_home_phone IN VARCHAR2,
47 p_mobile IN VARCHAR2,
48 p_interface_id IN NUMBER,
49 p_app_valid_status IN OUT NOCOPY BOOLEAN) ;
50
51 PROCEDURE pop_address_int ( p_app_address_dtls_rec IN IGS_UC_APP_ADDRESES%ROWTYPE,
52 p_domocile_apr IN VARCHAR2,
53 p_interface_id IN NUMBER,
54 p_addr_usage_home IN VARCHAR2,
55 p_addr_usage_corr IN VARCHAR2,
56 p_app_valid_status IN OUT NOCOPY BOOLEAN) ;
57
58 FUNCTION chk_src_cat( p_source_type_id IN NUMBER,
59 p_category IN VARCHAR2)
60 RETURN BOOLEAN;
61
62 PROCEDURE adm_import_process( p_ad_batch_id IN NUMBER,
63 p_source_type_id IN NUMBER,
64 p_status IN OUT NOCOPY BOOLEAN);
65
66 END igs_uc_exp_applicant_dtls;