APPS.IGS_FI_VAL_CFAR dependencies on IGS_EN_ATD_TYPE

Line 262: p_attendance_type IN IGS_EN_ATD_TYPE_ALL.attendance_type%TYPE ,

258: END finp_val_am_closed;
259: --
260: -- Validate the Attendance Type closed indicator
261: FUNCTION finp_val_att_closed(
262: p_attendance_type IN IGS_EN_ATD_TYPE_ALL.attendance_type%TYPE ,
263: p_message_name OUT NOCOPY VARCHAR2)
264: RETURN BOOLEAN AS
265: gv_other_detail VARCHAR2(255);
266: BEGIN --finp_val_att_closed

Line 267: --Validate if IGS_EN_ATD_TYPE.attendance_type is closed

263: p_message_name OUT NOCOPY VARCHAR2)
264: RETURN BOOLEAN AS
265: gv_other_detail VARCHAR2(255);
266: BEGIN --finp_val_att_closed
267: --Validate if IGS_EN_ATD_TYPE.attendance_type is closed
268: DECLARE
269: v_closed_ind VARCHAR2(1);
270: CURSOR c_att IS
271: SELECT att.closed_ind

Line 272: FROM IGS_EN_ATD_TYPE att

268: DECLARE
269: v_closed_ind VARCHAR2(1);
270: CURSOR c_att IS
271: SELECT att.closed_ind
272: FROM IGS_EN_ATD_TYPE att
273: WHERE att.attendance_type = p_attendance_type;
274: BEGIN
275: --set default message_number
276: p_message_name := Null;

Line 298: --Validate if IGS_EN_ATD_TYPE.attendance_type is closed

294: p_message_name OUT NOCOPY VARCHAR2)
295: RETURN BOOLEAN AS
296: gv_other_detail VARCHAR2(255);
297: BEGIN --finp_val_loc_closed
298: --Validate if IGS_EN_ATD_TYPE.attendance_type is closed
299: DECLARE
300: v_closed_ind VARCHAR2(1);
301: v_location_type igs_lookups_view.lookup_code%TYPE;
302: CURSOR c_loc IS