APPS.IGS_GE_VAL_PARAM dependencies on IGS_AD_CAT

Line 469: FUNCTION repp_val_adm_cat( p_adm_cat IN OUT NOCOPY IGS_AD_CAT.ADMISSION_CAT%TYPE,

465: -- MODIFICATION HISTORY
466: -- Person Date Comments
467: -- --------- -------- ------------------------------------------
468: -- MSONTER 21/08/98 Initial creation of function
469: FUNCTION repp_val_adm_cat( p_adm_cat IN OUT NOCOPY IGS_AD_CAT.ADMISSION_CAT%TYPE,
470: p_msg_name OUT NOCOPY VARCHAR2)
471: RETURN BOOLEAN
472: AS
473: --

Line 475: CURSOR c_crs(cp_adm_cat IGS_AD_CAT.admission_cat%TYPE)

471: RETURN BOOLEAN
472: AS
473: --
474: -- Local Cursors
475: CURSOR c_crs(cp_adm_cat IGS_AD_CAT.admission_cat%TYPE)
476: IS
477: SELECT
478: 'x'
479: FROM IGS_AD_CAT ADC

Line 479: FROM IGS_AD_CAT ADC

475: CURSOR c_crs(cp_adm_cat IGS_AD_CAT.admission_cat%TYPE)
476: IS
477: SELECT
478: 'x'
479: FROM IGS_AD_CAT ADC
480: WHERE
481: adc.admission_cat LIKE cp_adm_cat
482: AND adc.closed_ind = 'N';
483: --

Line 489: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_AD_CAT','IGS_AD_CAT')

485: v_ok VARCHAR2(1) := NULL;
486: BEGIN
487: --
488: -- check for uppper case requirement
489: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_AD_CAT','IGS_AD_CAT')
490: THEN
491: p_adm_cat := UPPER(p_adm_cat);
492: END IF;
493: --