DBA Data[Home] [Help]

APPS.IGS_FI_VAL_CFAR dependencies on IGS_AD_LOCATION

Line 293: p_location_cd IN IGS_AD_LOCATION_ALL.location_cd%TYPE ,

289: END finp_val_att_closed;
290: --
291: -- Validate the Location closed indicator
292: FUNCTION finp_val_loc_closed(
293: p_location_cd IN IGS_AD_LOCATION_ALL.location_cd%TYPE ,
294: p_message_name OUT NOCOPY VARCHAR2)
295: RETURN BOOLEAN AS
296: gv_other_detail VARCHAR2(255);
297: BEGIN --finp_val_loc_closed

Line 305: FROM IGS_AD_LOCATION loc

301: v_location_type igs_lookups_view.lookup_code%TYPE;
302: CURSOR c_loc IS
303: SELECT loc.closed_ind,
304: loc.location_type
305: FROM IGS_AD_LOCATION loc
306: WHERE loc.location_cd = p_location_cd;
307: BEGIN
308: --set default message_number
309: p_message_name := Null;