[Home] [Help]
PACKAGE: APPS.IGS_EN_VAL_PA
Source
1 PACKAGE IGS_EN_VAL_PA AUTHID CURRENT_USER AS
2 /* $Header: IGSEN48S.pls 115.5 2002/11/29 00:01:40 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 27-AUG-2001 Bug No. 1956374 .The function declaration of genp_val_strt_end_dt
13 -- removed .
14 ----------------------------------------------------------------------------------------
15 --
16 -- Validate the IGS_PE_PERSON address correspondence addresses
17 FUNCTION enrp_val_pa_corr(
18 p_person_id IN NUMBER ,
19 p_addr_type IN VARCHAR2 ,
20 p_start_dt IN DATE ,
21 p_end_dt IN DATE ,
22 p_message_name OUT NOCOPY VARCHAR2)
23 RETURN BOOLEAN;
24 --PRAGMA RESTRICT_REFERENCES (enrp_val_pa_corr,WNDS);
25 --
26 -- Validate for IGS_PE_PERSON address date overlaps.
27 FUNCTION enrp_val_pa_ovrlp(
28 p_person_id IN NUMBER ,
29 p_addr_type IN VARCHAR2 ,
30 p_start_dt IN DATE ,
31 p_end_dt IN DATE ,
32 p_message_name OUT NOCOPY VARCHAR2)
33 RETURN BOOLEAN;
34 --PRAGMA RESTRICT_REFERENCES (enrp_val_pa_ovrlp,WNDS);
35 --
36 -- Validate that no other open-ended IGS_PE_PERSON addr record exists.
37 FUNCTION enrp_val_pa_open(
38 p_person_id IN NUMBER ,
39 p_addr_type IN VARCHAR2 ,
40 p_start_dt IN DATE ,
41 p_message_name OUT NOCOPY VARCHAR2)
42 RETURN BOOLEAN;
43 --PRAGMA RESTRICT_REFERENCES (enrp_val_pa_open,WNDS);
44 --
45 -- Validate the address type closed indicator
46 FUNCTION enrp_val_adt_closed(
47 p_addr_type IN VARCHAR2 ,
48 p_message_name OUT NOCOPY VARCHAR2)
49 RETURN BOOLEAN;
50 --PRAGMA RESTRICT_REFERENCES (enrp_val_adt_closed,WNDS);
51 END IGS_EN_VAL_PA;