DBA Data[Home] [Help]

APPS.IGS_AS_VAL_VEA dependencies on FND_LOOKUP_VALUES

Line 21: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,

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;

Line 31: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,

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;