1 PACKAGE IGS_FI_VAL_CFAR AS
2 /* $Header: IGSFI12S.pls 120.0 2005/06/01 21:26:15 appldev noship $ */
3
4 --
5 -- Ensure S_FEE_TYPE is 'OTHER' and S_FEE_TRIGGER_CAT is not 'INSTITUTN'
6 FUNCTION finp_val_cfar_ins(
7 p_person_id IN NUMBER ,
8 p_course_cd IN VARCHAR2 ,
9 p_fee_type IN VARCHAR2 ,
10 p_message_name OUT NOCOPY VARCHAR2 )
11 RETURN BOOLEAN;
12 pragma restrict_references(finp_val_cfar_ins,wnds);
13 --
14 -- Ensure the start and end dates don't overlap with other records.
15 FUNCTION finp_val_cfar_ovrlp(
16 p_person_id IN NUMBER ,
17 p_course_cd IN VARCHAR2 ,
18 p_fee_type IN VARCHAR2 ,
19 p_start_dt IN DATE ,
20 p_end_dt IN DATE ,
21 p_message_name OUT NOCOPY VARCHAR2 )
22 RETURN BOOLEAN;
23 pragma restrict_references(finp_val_cfar_ovrlp,wnds);
24 --
25 -- Validate that only one record has an open end date.
26 FUNCTION finp_val_cfar_open(
27 p_person_id IN NUMBER ,
28 p_course_cd IN VARCHAR2 ,
29 p_fee_type IN VARCHAR2 ,
30 p_start_dt IN DATE ,
31 p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33 pragma restrict_references(finp_val_cfar_open,wnds);
34 --
35 -- Validate that end date is null or >= start date.
36 FUNCTION finp_val_cfar_end_dt(
37 p_start_dt IN DATE ,
38 p_end_dt IN DATE ,
39 p_message_name OUT NOCOPY VARCHAR2 )
40 RETURN BOOLEAN;
41 pragma restrict_references(finp_val_cfar_end_dt,wnds);
42 --
43 -- Validate the Attendance Mode closed indicator
44 FUNCTION finp_val_am_closed(
45 p_attendance_mode IN IGS_EN_ATD_MODE_ALL.attendance_mode%TYPE ,
46 p_message_name OUT NOCOPY VARCHAR2 )
47 RETURN BOOLEAN;
48 pragma restrict_references(finp_val_am_closed,wnds);
49 --
50 -- Validate the Attendance Type closed indicator
51 FUNCTION finp_val_att_closed(
52 p_attendance_type IN IGS_EN_ATD_TYPE_ALL.attendance_type%TYPE ,
53 p_message_name OUT NOCOPY VARCHAR2 )
54 RETURN BOOLEAN;
55 pragma restrict_references(finp_val_att_closed,wnds);
56 --
57 -- Validate the IGS_AD_LOCATION closed indicator
58 FUNCTION finp_val_loc_closed(
59 p_location_cd IN IGS_AD_LOCATION_ALL.location_cd%TYPE ,
60 p_message_name OUT NOCOPY VARCHAR2 )
61 RETURN BOOLEAN;
62 pragma restrict_references(finp_val_loc_closed,wnds);
63 --
64 -- Validate the IGS_FI_FEE_TYPE in the fee_type_account is not closed.
65 FUNCTION finp_val_ft_closed(
66 p_fee_type IN VARCHAR2 ,
67 p_message_name OUT NOCOPY VARCHAR2 )
68 RETURN BOOLEAN;
69 pragma restrict_references(finp_val_ft_closed,wnds);
70 END IGS_FI_VAL_CFAR;