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