APPS.IGS_AD_GEN_005 dependencies on IGS_AS_UNIT_CLASS

Line 282: v_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE;

278: BEGIN -- admp_get_dflt_uc
279: -- Return the default unit class for a unit mode.
280: DECLARE
281: v_multiple_records BOOLEAN DEFAULT FALSE;
282: v_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE;
283: CURSOR c_ucl IS
284: SELECT UNIQUE ucl.unit_class
285: FROM IGS_AS_UNIT_CLASS ucl
286: WHERE ucl.unit_mode = p_unit_mode AND

Line 285: FROM IGS_AS_UNIT_CLASS ucl

281: v_multiple_records BOOLEAN DEFAULT FALSE;
282: v_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE;
283: CURSOR c_ucl IS
284: SELECT UNIQUE ucl.unit_class
285: FROM IGS_AS_UNIT_CLASS ucl
286: WHERE ucl.unit_mode = p_unit_mode AND
287: ucl.closed_ind = 'N';
288: BEGIN
289: FOR v_ucl_rec IN c_ucl LOOP

Line 322: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;

318: RETURN VARCHAR2 IS
319: BEGIN -- admp_get_dflt_um
320: -- Return the default unit mode for a unit class
321: DECLARE
322: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
323: v_count_OK BOOLEAN DEFAULT FALSE;
324: CURSOR c_ucl IS
325: SELECT ucl.unit_mode
326: FROM IGS_AS_UNIT_CLASS ucl

Line 326: FROM IGS_AS_UNIT_CLASS ucl

322: v_unit_mode IGS_AS_UNIT_CLASS.unit_mode%TYPE;
323: v_count_OK BOOLEAN DEFAULT FALSE;
324: CURSOR c_ucl IS
325: SELECT ucl.unit_mode
326: FROM IGS_AS_UNIT_CLASS ucl
327: WHERE ucl.unit_class = p_unit_class
328: AND ucl.closed_ind = 'N';
329: BEGIN
330: FOR v_ucl_rec IN c_ucl LOOP