[Home] [Help]
PACKAGE: APPS.IGS_OR_INST_IMP_001
Source
1 PACKAGE IGS_OR_INST_IMP_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSOR14S.pls 115.7 2003/09/29 06:19:27 ssaleem noship $ */
3 -------------------------------------------------------------------------------------------
4 -- Change History:
5 -- Who When What
6 -- ssaleem 09-26-2003 Added two new functions delete_log_int_rec and
7 -- validate_inst_code.
8 -- Modified log_writer to incorporate logging mechanism
9 -------------------------------------------------------------------------------------------
10
11 PROCEDURE log_writer(p_which_rec IN varchar2 default NULL,
12 p_error_code IN igs_or_inst_int.error_code%TYPE,
13 p_error_text igs_or_inst_int.error_text%TYPE DEFAULT NULL);
14
15
16 gb_write_exception_log1 BOOLEAN;
17 gb_write_exception_log2 BOOLEAN;
18 gb_write_exception_log3 BOOLEAN;
19 g_request_id NUMBER;
20
21 PROCEDURE imp_or_institution(
22 ERRBUF OUT NOCOPY VARCHAR2,
23 RETCODE OUT NOCOPY NUMBER,
24 P_DATE IN VARCHAR2,
25 P_BATCH_ID IN NUMBER,
26 P_DATA_SOURCE IN VARCHAR2,
27 P_DS_MATCH IN VARCHAR2,
28 P_NUMERIC IN VARCHAR2,
29 P_ADDR_USAGE IN VARCHAR2,
30 P_PERSON_TYPE IN VARCHAR2,
31 P_ORG_ID IN NUMBER ) ;
32
33
34 PROCEDURE simpleAltidcomp(
35 p_batch_id IN NUMBER,
36 p_data_source IN VARCHAR2,
37 p_addr_usage IN VARCHAR2,
38 p_person_type IN VARCHAR2 );
39
40
41 PROCEDURE exactAltidcomp(
42 p_batch_id IN NUMBER,
43 p_data_source IN VARCHAR2,
44 p_ds_match IN VARCHAR2,
45 p_addr_usage IN VARCHAR2,
46 p_person_type IN VARCHAR2 );
47
48
49 PROCEDURE numericAltidcomp(
50 p_batch_id IN NUMBER,
51 p_data_source IN VARCHAR2,
52 p_ds_match IN VARCHAR2,
53 p_addr_usage IN VARCHAR2,
54 p_person_type IN VARCHAR2 );
55
56 PROCEDURE delete_log_int_rec(p_batch_id IN IGS_OR_INST_INT.BATCH_ID%TYPE);
57
58 FUNCTION validate_inst_code(p_new_inst_code IN igs_or_inst_int.new_institution_cd%TYPE,
59 p_exst_inst_code IN igs_or_inst_int.exst_institution_cd%TYPE,
60 p_cwlk_inst_code IN igs_or_cwlk_v.inst_code%TYPE,
61 p_interface_id IN igs_or_inst_int.interface_id%TYPE) RETURN BOOLEAN;
62
63 END IGS_OR_INST_IMP_001;