PACKAGE: APPS.IGS_OR_INST_IMP_002

Source

1 PACKAGE IGS_OR_INST_IMP_002 AUTHID CURRENT_USER AS
2 /* $Header: IGSOR15S.pls 115.5 2002/11/29 01:49:30 nsidana noship $ */
3 /* change history
4 who                     when                         what
5 npalanis                27-OCT-2002                  Bug : 2613704
6                                                      Parameter p_error_code added to the procedure
7                                                      create alternate id.
8 */
9 
10 PROCEDURE create_institution (
11     p_inst_rec IN IGS_OR_INST_INT%ROWTYPE,
12     p_instcode OUT NOCOPY VARCHAR2,
13     p_errind  OUT NOCOPY VARCHAR2,
14     p_error_code OUT NOCOPY VARCHAR2,
15     p_error_text OUT NOCOPY VARCHAR2);
16 
17 
18 PROCEDURE create_crosswalk_master (
19     p_inst_code IN VARCHAR2,
20     p_inst_name IN VARCHAR2,
21     p_errind OUT NOCOPY VARCHAR2,
22     p_crswalk_id OUT NOCOPY NUMBER ) ;
23 
24 
25 PROCEDURE create_crosswalk_detail (
26     p_crwlkid IN NUMBER,
27     p_datasrc IN VARCHAR2,
28     p_dataval IN VARCHAR2,
29     p_errind OUT NOCOPY VARCHAR2 );
30 
31 
32 PROCEDURE create_alternate_id (
33     p_instcd IN VARCHAR2,
34     p_altidtype IN VARCHAR2,
35     p_altidval IN VARCHAR2,
36     p_error_code OUT NOCOPY VARCHAR2,
37     p_errind OUT NOCOPY VARCHAR2 );
38 
39 PROCEDURE update_institution(
40     p_instcd IN VARCHAR2,
41     p_instrec IN IGS_OR_INST_INT%ROWTYPE,
42     p_errind OUT NOCOPY VARCHAR2,
43     p_error_code OUT NOCOPY VARCHAR2,
44     p_error_text OUT NOCOPY VARCHAR2);
45 
46 PROCEDURE update_crosswalk_master (
47     p_cwlkid IN NUMBER,
48     p_instcd IN VARCHAR2,
49     p_errind OUT NOCOPY VARCHAR2);
50 
51 PROCEDURE autoGenerateLogic(
52    p_inst_rec IN IGS_OR_INST_INT%ROWTYPE,
53    p_success  OUT NOCOPY VARCHAR2,
54    p_err_cd OUT NOCOPY VARCHAR2);
55 
56 END IGS_OR_INST_IMP_002;