APPS.IGS_GE_VAL_PARAM dependencies on IGS_EN_ATD_MODE

Line 129: FUNCTION repp_val_att_mode( p_att_mode IN OUT NOCOPY IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE,

125: -- MODIFICATION HISTORY
126: -- Person Date Comments
127: -- --------- -------- ------------------------------------------
128: -- MSONTER 21/08/98 Initial creation of function
129: FUNCTION repp_val_att_mode( p_att_mode IN OUT NOCOPY IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE,
130: p_msg_name OUT NOCOPY VARCHAR2)
131: RETURN BOOLEAN
132: AS
133: --

Line 135: CURSOR c_att(cp_att_mode IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE)

131: RETURN BOOLEAN
132: AS
133: --
134: -- Local Cursors
135: CURSOR c_att(cp_att_mode IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE)
136: IS
137: SELECT
138: 'x'
139: FROM IGS_EN_ATD_MODE atm

Line 139: FROM IGS_EN_ATD_MODE atm

135: CURSOR c_att(cp_att_mode IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE)
136: IS
137: SELECT
138: 'x'
139: FROM IGS_EN_ATD_MODE atm
140: WHERE
141: atm.attendance_mode LIKE cp_att_mode
142: AND atm.closed_ind = 'N';
143: --

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