PACKAGE: APPS.IGS_AS_VAL_VEA

Source

1 PACKAGE IGS_AS_VAL_VEA AUTHID CURRENT_USER AS
2 /* $Header: IGSAS38S.pls 115.7 2002/11/28 22:48:51 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    29-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  -- Validate the IGS_PE_PERSON address codes
18   -- Retrofitted
19   FUNCTION assp_val_vea_coraddr(
20   p_venue_cd  IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
21   p_addr_type  FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
22   p_start_dt  HZ_LOCATIONS.ADDRESS_EFFECTIVE_DATE%TYPE ,
23   p_end_dt  HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
24   p_message_name OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26 
27   --
28   -- Retrofitted
29   FUNCTION ASSP_VAL_VEA_OVRLP(
30   p_venue_cd  IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
31   p_addr_type  FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
32   p_start_dt  HZ_LOCATIONs.ADDRESS_EFFECTIVE_DATE%TYPE ,
33   p_end_dt  HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
34   p_message_name OUT NOCOPY VARCHAR2 )
35 RETURN BOOLEAN;
36 
37   --
38   -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
39 
40   PROCEDURE validate_address
41   (
42     p_city IN VARCHAR2,
43     p_state IN VARCHAR2,
44     p_province IN VARCHAR2,
45     p_county IN VARCHAR2,
46     p_country IN VARCHAR2,
47     p_postcode IN VARCHAR2,
48     p_valid_address OUT NOCOPY BOOLEAN,
49     p_error_msg OUT NOCOPY VARCHAR2
50   );
51 
52 END IGS_AS_VAL_VEA;