1 PACKAGE IGS_OR_VAL_INS AUTHID CURRENT_USER AS
2 /* $Header: IGSOR03S.pls 115.4 2002/11/29 01:46:20 nsidana ship $ */
3
4 /*
5 || Created By : [email protected]
6 || Created On : 28-AUG-2000
7 || Purpose :
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || WHO WHEN WHAT
11 || pkpatel 5-MAR-2002 Bug NO: 2224621
12 || Modified the field GOVT_INSTITUTION_CD from NUMBER to VARCHAR2
13 || in Procedure ORGP_VAL_GOVT_CD
14 || (reverse chronological order - newest change first)
15 */
16
17 --
18 -- Validate the delete of an instn code on records with no foreign key.
19 FUNCTION orgp_val_instn_del(
20 p_institution_cd IN VARCHAR2 ,
21 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23
24 --
25 -- Validate the government institution code.
26 FUNCTION orgp_val_govt_cd(
27 p_govt_institution_cd IN VARCHAR2,
28 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
29 RETURN Boolean;
30 --
31 -- Validate the institution status.
32 FUNCTION orgp_val_instn_sts(
33 p_institution_cd IN VARCHAR2 ,
34 p_institution_status IN VARCHAR2 ,
35 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
36 RETURN Boolean;
37 --
38 -- Validate no active org units are associated with the specified instn.
39 FUNCTION orgp_val_no_actv_ou(
40 p_institution_cd IN VARCHAR2 ,
41 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
42 RETURN Boolean;
43 --
44 -- Validate the local indicator is for only one institution
45 FUNCTION orgp_val_ins_local(
46 p_institution_cd IN VARCHAR2 ,
47 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
48 RETURN BOOLEAN;
49 --
50 -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
51 -- PROCEDURE genp_prc_clear_rowid;
52 --
53 -- Routine to save rowids in a PL/SQL TABLE for the current commit.
54
55 END IGS_OR_VAL_INS;