APPS.IGS_GE_VAL_PARAM dependencies on IGS_GE_GEN_001

Line 37: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('UNIT_CD','IGS_PS_UNIT_VER')

33: v_unit_ok VARCHAR2(1) := NULL;
34: BEGIN
35: --
36: -- check for uppper case requirement
37: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('UNIT_CD','IGS_PS_UNIT_VER')
38: THEN
39: p_unit_cd := UPPER(p_unit_cd);
40: END IF;
41: --

Line 93: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('LOCATION_CD','LOCATION')

89: v_loc_ok VARCHAR2(1) := NULL;
90: BEGIN
91: --
92: -- check for uppper case requirement
93: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('LOCATION_CD','LOCATION')
94: THEN
95: p_location_cd := UPPER(p_location_cd);
96: END IF;
97: --

Line 149: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_EN_ATD_MODE','IGS_EN_ATD_MODE')

145: v_ok VARCHAR2(1) := NULL;
146: BEGIN
147: --
148: -- check for uppper case requirement
149: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_EN_ATD_MODE','IGS_EN_ATD_MODE')
150: THEN
151: p_att_mode := UPPER(p_att_mode);
152: END IF;
153: --

Line 205: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('ATTEDANCE_TYPE','IGS_EN_ATD_TYPE')

201: v_att_ok VARCHAR2(1) := NULL;
202: BEGIN
203: --
204: -- check for uppper case requirement
205: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('ATTEDANCE_TYPE','IGS_EN_ATD_TYPE')
206: THEN
207: p_att_type := UPPER(p_att_type);
208: END IF;
209: --

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 318: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_AS_UNIT_MODE','IGS_AS_UNIT_MODE')

314: v_um_ok VARCHAR2(1) := NULL;
315: BEGIN
316: --
317: -- check for uppper case requirement
318: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_AS_UNIT_MODE','IGS_AS_UNIT_MODE')
319: THEN
320: p_unit_mode := UPPER(p_unit_mode);
321: END IF;
322: --

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: --

Line 432: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_EN_ENROLMENT_CAT','IGS_EN_ENROLMENT_CAT')

428: v_ok VARCHAR2(1) := NULL;
429: BEGIN
430: --
431: -- check for uppper case requirement
432: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_EN_ENROLMENT_CAT','IGS_EN_ENROLMENT_CAT')
433: THEN
434: p_enr_cat := UPPER(p_enr_cat);
435: END IF;
436: --

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: --

Line 546: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_FI_FEE_CAT','IGS_FI_FEE_CAT')

542: v_ok VARCHAR2(1) := NULL;
543: BEGIN
544: --
545: -- check for uppper case requirement
546: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('IGS_FI_FEE_CAT','IGS_FI_FEE_CAT')
547: THEN
548: p_fee_cat := UPPER(p_fee_cat);
549: END IF;
550: --

Line 688: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('COURSE_CD','COURSE')

684: IF p_course_cd IS NULL THEN
685: p_course_cd := '%';
686: END IF;
687: -- upper case test
688: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('COURSE_CD','COURSE')
689: THEN
690: p_course_cd := UPPER(p_course_cd);
691: END IF;
692: -- start of main loop

Line 954: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('ORG_UNIT_CD','IGS_OR_UNIT')

950: IF p_org_cd IS NULL THEN
951: p_org_cd := '%';
952: END IF;
953: -- upper case test
954: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('ORG_UNIT_CD','IGS_OR_UNIT')
955: THEN
956: p_org_cd := UPPER(p_org_cd);
957: END IF;
958: -- start of main loop