1 PACKAGE IGS_OR_VAL_OU AUTHID CURRENT_USER AS
2 /* $Header: IGSOR09S.pls 115.3 2002/11/29 01:48:09 nsidana ship $ */
3 --
4 -- Validate the organisational unit end date.
5 FUNCTION orgp_val_ou_end_dt(
6 p_org_unit_cd IN VARCHAR2 ,
7 p_start_dt IN DATE ,
8 p_end_dt IN DATE ,
9 p_message_name OUT NOCOPY VARCHAR2 )
10 RETURN Boolean;
11 --
12 -- Validate if any open ended org units exist for the current org unit.
13 FUNCTION orgp_val_open_ou(
14 p_org_unit_cd IN VARCHAR2 ,
15 p_start_dt IN DATE ,
16 p_message_name OUT NOCOPY VARCHAR2 )
17 RETURN BOOLEAN;
18 --
19 -- Validate the organisational status.
20 FUNCTION orgp_val_org_status(
21 p_org_status IN VARCHAR2 ,
22 p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN BOOLEAN;
24 --
25 -- Ensure an organisational unit status change is valid.
26 FUNCTION orgp_val_ou_sts_chng(
27 p_org_unit_cd IN VARCHAR2 ,
28 p_start_dt IN DATE ,
29 p_org_status IN VARCHAR2 ,
30 p_message_name OUT NOCOPY VARCHAR2 )
31 RETURN BOOLEAN;
32 --
33 -- Validate the organisational type.
34 FUNCTION orgp_val_org_type(
35 p_org_type IN VARCHAR2 ,
36 p_message_name OUT NOCOPY VARCHAR2 )
37 RETURN BOOLEAN;
38 --
39 -- Validate the member type.
40 FUNCTION orgp_val_mbr_type(
41 p_member_type IN VARCHAR2 ,
42 p_message_name OUT NOCOPY VARCHAR2 )
43 RETURN BOOLEAN;
44 --
45 -- Validate the organisational unit institution code is active.
46 FUNCTION orgp_val_ou_instn_cd(
47 p_institution_cd IN VARCHAR2 ,
48 p_message_name OUT NOCOPY VARCHAR2 )
49 RETURN BOOLEAN;
50 --
51 -- Validate for date overlaps for a specific organisational IGS_PS_UNIT.
52 FUNCTION orgp_val_ou_ovrlp(
53 p_org_unit_cd IN VARCHAR2 ,
54 p_start_dt IN DATE ,
55 p_end_dt IN DATE ,
56 p_message_name OUT NOCOPY VARCHAR2 )
57 RETURN BOOLEAN;
58 --
59 -- Cross-field validation of the org unit end date and status.
60 FUNCTION orgp_val_ou_end_sts(
61 p_end_dt IN DATE ,
62 p_org_status IN VARCHAR2 ,
63 p_message_name OUT NOCOPY VARCHAR2 )
64 RETURN BOOLEAN;
65
66 END IGS_OR_VAL_OU;