APPS.IGS_AS_VAL_VEA dependencies on HZ_LOCATIONS

Line 19: p_start_dt HZ_LOCATIONS.ADDRESS_EFFECTIVE_DATE%TYPE ,

15: -- Retrofitted
16: FUNCTION assp_val_vea_coraddr(
17: p_venue_cd IGS_AD_LOCVENUE_ADDR.LOCATION_venue_cd%TYPE ,
18: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
19: p_start_dt HZ_LOCATIONS.ADDRESS_EFFECTIVE_DATE%TYPE ,
20: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
21: p_message_name OUT NOCOPY VARCHAR2)
22: RETURN BOOLEAN IS
23: gv_other_detail VARCHAR2(255);

Line 20: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,

16: FUNCTION assp_val_vea_coraddr(
17: p_venue_cd IGS_AD_LOCVENUE_ADDR.LOCATION_venue_cd%TYPE ,
18: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
19: p_start_dt HZ_LOCATIONS.ADDRESS_EFFECTIVE_DATE%TYPE ,
20: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
21: p_message_name OUT NOCOPY VARCHAR2)
22: RETURN BOOLEAN IS
23: gv_other_detail VARCHAR2(255);
24: return_val BOOLEAN;

Line 134: p_start_dt HZ_LOCATIONs.ADDRESS_EFFECTIVE_DATE%TYPE ,

130: -- Retrofitted
131: FUNCTION ASSP_VAL_VEA_OVRLP(
132: p_venue_cd IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
133: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
134: p_start_dt HZ_LOCATIONs.ADDRESS_EFFECTIVE_DATE%TYPE ,
135: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
136: p_message_name OUT NOCOPY VARCHAR2)
137: RETURN BOOLEAN IS
138: gv_other_detail VARCHAR2(255);

Line 135: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,

131: FUNCTION ASSP_VAL_VEA_OVRLP(
132: p_venue_cd IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
133: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
134: p_start_dt HZ_LOCATIONs.ADDRESS_EFFECTIVE_DATE%TYPE ,
135: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
136: p_message_name OUT NOCOPY VARCHAR2)
137: RETURN BOOLEAN IS
138: gv_other_detail VARCHAR2(255);
139: BEGIN -- assp_val_vea_ovrlp