APPS.IGS_OR_VAL_LOT dependencies on IGS_AD_LOCATION

Line 4: p_location_type IGS_AD_LOCATION_TYPE_ALL.location_type%TYPE ,

1: PACKAGE BODY IGS_OR_VAL_LOT AS
2: /* $Header: IGSOR06B.pls 115.4 2002/11/29 01:47:11 nsidana ship $ */
3: FUNCTION assp_val_lot_loc(
4: p_location_type IGS_AD_LOCATION_TYPE_ALL.location_type%TYPE ,
5: p_message_name OUT NOCOPY VARCHAR2 )
6: RETURN BOOLEAN AS
7: gv_other_detail VARCHAR2(255);
8: BEGIN -- assp_val_lot_loc

Line 14: FROM IGS_AD_LOCATION

10: -- type can not be changed once locations have been created.
11: DECLARE
12: CURSOR c_loc IS
13: SELECT 'x'
14: FROM IGS_AD_LOCATION
15: WHERE location_type = p_location_type;
16: v_loc_exists VARCHAR2(1);
17: BEGIN
18: -- Set the default message number