APPS.IGS_GE_VAL_PARAM dependencies on IGS_AS_UNIT_CLASS

Line 241: FUNCTION repp_val_unit_class( p_unit_class IN OUT NOCOPY IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,

237: -- MODIFICATION HISTORY
238: -- Person Date Comments
239: -- --------- -------- ------------------------------------------
240: -- MSONTER 21/08/98 Initial creation of function
241: FUNCTION repp_val_unit_class( p_unit_class IN OUT NOCOPY IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
242: p_msg_name OUT NOCOPY VARCHAR2)
243: RETURN BOOLEAN
244: AS
245: --

Line 247: CURSOR c_uc(cp_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE)

243: RETURN BOOLEAN
244: AS
245: --
246: -- Local Cursors
247: CURSOR c_uc(cp_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE)
248: IS
249: SELECT
250: 'x'
251: FROM IGS_AS_UNIT_CLASS UC

Line 251: FROM IGS_AS_UNIT_CLASS UC

247: CURSOR c_uc(cp_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE)
248: IS
249: SELECT
250: 'x'
251: FROM IGS_AS_UNIT_CLASS UC
252: WHERE
253: uc.unit_class LIKE cp_unit_class
254: AND uc.closed_ind = 'N';
255: --

Line 261: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_AS_UNIT_CLASS','IGS_AS_UNIT_CLASS')

257: v_ok VARCHAR2(1) := NULL;
258: BEGIN
259: --
260: -- check for uppper case requirement
261: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_AS_UNIT_CLASS','IGS_AS_UNIT_CLASS')
262: THEN
263: p_unit_class := UPPER(p_unit_class);
264: END IF;
265: --

Line 612: ( p_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE,

608: -- Person Date Comments
609: -- --------- -------- ------------------------------------------
610: -- MSONTER 21/08/98 Initial creation of function
611: FUNCTION repp_val_unit_mode_class
612: ( p_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE,
613: p_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
614: p_msg_name OUT NOCOPY VARCHAR2)
615: RETURN BOOLEAN
616: AS

Line 613: p_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,

609: -- --------- -------- ------------------------------------------
610: -- MSONTER 21/08/98 Initial creation of function
611: FUNCTION repp_val_unit_mode_class
612: ( p_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE,
613: p_class IN IGS_AS_UNIT_CLASS_ALL.unit_class%TYPE,
614: p_msg_name OUT NOCOPY VARCHAR2)
615: RETURN BOOLEAN
616: AS
617: --

Line 619: CURSOR c_mode(cp_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,

615: RETURN BOOLEAN
616: AS
617: --
618: -- Local Cursors
619: CURSOR c_mode(cp_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,
620: cp_unit_mode IGS_AS_UNIT_MODE.unit_mode%TYPE)
621: IS
622: SELECT
623: 'x'

Line 624: FROM IGS_AS_UNIT_CLASS uc

620: cp_unit_mode IGS_AS_UNIT_MODE.unit_mode%TYPE)
621: IS
622: SELECT
623: 'x'
624: FROM IGS_AS_UNIT_CLASS uc
625: WHERE uc.unit_class LIKE cp_unit_class
626: AND uc.unit_mode LIKE cp_unit_mode
627: AND uc.closed_ind = 'N';
628: --