APPS.IGS_GE_VAL_PARAM dependencies on IGS_EN_ATD_TYPE

Line 185: FUNCTION repp_val_att_type( p_att_type IN OUT NOCOPY IGS_EN_ATD_TYPE_ALL.attendance_type%TYPE,

181: -- MODIFICATION HISTORY
182: -- PERSON Date Comments
183: -- --------- -------- ------------------------------------------
184: -- MSONTER 21/08/98 Initial creation of function
185: FUNCTION repp_val_att_type( p_att_type IN OUT NOCOPY IGS_EN_ATD_TYPE_ALL.attendance_type%TYPE,
186: p_msg_name OUT NOCOPY VARCHAR2)
187: RETURN BOOLEAN
188: AS
189: --

Line 191: CURSOR c_att(cp_att_type IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE)

187: RETURN BOOLEAN
188: AS
189: --
190: -- Local Cursors
191: CURSOR c_att(cp_att_type IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE)
192: IS
193: SELECT
194: 'x'
195: FROM IGS_EN_ATD_TYPE att

Line 195: FROM IGS_EN_ATD_TYPE att

191: CURSOR c_att(cp_att_type IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE)
192: IS
193: SELECT
194: 'x'
195: FROM IGS_EN_ATD_TYPE att
196: WHERE
197: att.attendance_type LIKE cp_att_type
198: AND att.closed_ind = 'N';
199: --

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