1 PACKAGE IGS_OR_VAL_IA AUTHID CURRENT_USER AS
2 /* $Header: IGSOR02S.pls 115.6 2002/11/29 01:46:01 nsidana ship $ */
3
4 --
5 -- bug id : 1956374
6 -- sjadhav , 29-aug-2001
7 -- removed function enrp_val_pc_closed
8 --
9 -------------------------------------------------------------------------------------------
10 --Change History:
11 --Who When What
12 --smadathi 28-AUG-2001 Bug No. 1956374 .The function declaration of genp_val_strt_end_dt
13 -- removed .
14 --smadathi 27-AUG-2001 Bug No. 1956374 .The function declaration of orgp_val_addr_type
15 -- removed .
16 -------------------------------------------------------------------------------------------
17 --
18 -- Validate that there is only one cor address per institution
19 FUNCTION orgp_val_ia_cor_addr(
20 p_institution_cd IN VARCHAR2 ,
21 p_addr_type IN VARCHAR2 ,
22 p_start_dt IN DATE ,
23 p_end_dt IN DATE ,
24 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26
27 --
28 -- Validate that only one institution address is open per address type
29 FUNCTION orgp_val_ia_one_open(
30 p_institution_cd IN VARCHAR2 ,
31 p_addr_type IN VARCHAR2 ,
32 p_start_dt IN DATE ,
33 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
34 RETURN BOOLEAN;
35
36 --
37 -- Validate that address dates do not overlap for an institution
38 FUNCTION orgp_val_ia_ovrlp(
39 p_institution_cd IN VARCHAR2 ,
40 p_addr_type IN VARCHAR2 ,
41 p_start_dt IN DATE ,
42 p_end_dt IN DATE ,
43 P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
44 RETURN BOOLEAN;
45
46 --
47 --
48
49 PROCEDURE validate_address
50 (
51 p_city IN VARCHAR2,
52 p_state IN VARCHAR2,
53 p_province IN VARCHAR2,
54 p_county IN VARCHAR2,
55 p_country IN VARCHAR2,
56 p_postcode IN VARCHAR2,
57 p_valid_address OUT NOCOPY BOOLEAN,
58 p_error_msg OUT NOCOPY VARCHAR2
59 );
60
61 END IGS_OR_VAL_IA;