APPS.IGS_GE_VAL_PARAM dependencies on IGS_PS_TYPE

Line 349: -- Purpose: validation for IGS_PS_TYPEs

345: p_msg_name := 'IGS_AS_USER_EXCEPTION_RAISED';
346: RETURN FALSE;
347: END; -- repp_val_unit_mode
348: -- Module: repp_val_crs_type
349: -- Purpose: validation for IGS_PS_TYPEs
350: --
351: -- MODIFICATION HISTORY
352: -- Person Date Comments
353: -- --------- -------- ------------------------------------------

Line 355: FUNCTION repp_val_crs_type( p_crs_type IN OUT NOCOPY IGS_PS_TYPE_ALL.COURSE_TYPE%TYPE,

351: -- MODIFICATION HISTORY
352: -- Person Date Comments
353: -- --------- -------- ------------------------------------------
354: -- MSONTER 21/08/98 Initial creation of function
355: FUNCTION repp_val_crs_type( p_crs_type IN OUT NOCOPY IGS_PS_TYPE_ALL.COURSE_TYPE%TYPE,
356: p_msg_name OUT NOCOPY VARCHAR2)
357: RETURN BOOLEAN
358: AS
359: --

Line 361: CURSOR c_crs(cp_crs_type IGS_PS_TYPE.course_type%TYPE)

357: RETURN BOOLEAN
358: AS
359: --
360: -- Local Cursors
361: CURSOR c_crs(cp_crs_type IGS_PS_TYPE.course_type%TYPE)
362: IS
363: SELECT
364: 'x'
365: FROM IGS_PS_TYPE CT

Line 365: FROM IGS_PS_TYPE CT

361: CURSOR c_crs(cp_crs_type IGS_PS_TYPE.course_type%TYPE)
362: IS
363: SELECT
364: 'x'
365: FROM IGS_PS_TYPE CT
366: WHERE
367: ct.course_type LIKE cp_crs_type
368: AND ct.closed_ind = 'N';
369: --

Line 375: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_PS_TYPE','IGS_PS_TYPE')

371: v_ok VARCHAR2(1) := NULL;
372: BEGIN
373: --
374: -- check for uppper case requirement
375: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_PS_TYPE','IGS_PS_TYPE')
376: THEN
377: p_crs_type := UPPER(p_crs_type);
378: END IF;
379: --