DBA Data[Home] [Help]

APPS.IGS_FI_GEN_003 dependencies on IGS_FI_VAL_CFAR

Line 201: IF NOT IGS_FI_VAL_CFAR.finp_val_ft_closed(

197: X_ROWID VARCHAR2(25);
198: v_ret_val BOOLEAN DEFAULT TRUE;
199: BEGIN
200: p_message_name := Null;
201: IF NOT IGS_FI_VAL_CFAR.finp_val_ft_closed(
202: p_fee_type,
203: p_message_name) THEN
204: RETURN FALSE;
205: END IF;

Line 206: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_ins(

202: p_fee_type,
203: p_message_name) THEN
204: RETURN FALSE;
205: END IF;
206: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_ins(
207: p_person_id,
208: p_course_cd,
209: p_fee_type,
210: p_message_name) THEN

Line 213: IF NOT IGS_FI_VAL_CFAR.finp_val_att_closed(

209: p_fee_type,
210: p_message_name) THEN
211: RETURN FALSE;
212: END IF;
213: IF NOT IGS_FI_VAL_CFAR.finp_val_att_closed(
214: p_attendance_type,
215: p_message_name) THEN
216: RETURN FALSE;
217: END IF;

Line 218: IF NOT IGS_FI_VAL_CFAR.finp_val_am_closed(

214: p_attendance_type,
215: p_message_name) THEN
216: RETURN FALSE;
217: END IF;
218: IF NOT IGS_FI_VAL_CFAR.finp_val_am_closed(
219: p_attendance_mode,
220: p_message_name) THEN
221: RETURN FALSE;
222: END IF;

Line 223: IF NOT IGS_FI_VAL_CFAR.finp_val_loc_closed(

219: p_attendance_mode,
220: p_message_name) THEN
221: RETURN FALSE;
222: END IF;
223: IF NOT IGS_FI_VAL_CFAR.finp_val_loc_closed(
224: p_location_cd,
225: p_message_name) THEN
226: RETURN FALSE;
227: END IF;

Line 232: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_open (

228: --Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that for
229: --records with the same person_id, course_cd and IGS_FI_FEE_TYPE, that only
230: --one record has a open end_dt.
231: IF p_end_dt IS NULL THEN
232: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_open (
233: p_person_id,
234: p_course_cd,
235: p_fee_type,
236: p_start_dt,

Line 244: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_ovrlp (

240: END IF;
241: --Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that for
242: --records with the same person_id, course_cd and IGS_FI_FEE_TYPE, that the
243: --date ranges don't overlap.
244: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_ovrlp (
245: p_person_id,
246: p_course_cd,
247: p_fee_type,
248: p_start_dt,