1 PACKAGE IGS_FI_VAL_CFT AUTHID CURRENT_USER AS
2 /* $Header: IGSFI13S.pls 115.6 2002/11/29 00:17:40 nsidana ship $ */
3 -- Bug #1956374
4 -- As part of the bug# 1956374 removed the function crsp_val_loc_cd
5 -- As part of the bug# 1956374 removed the function enrp_val_am_closed
6 --
7 --
8 -- bug id : 1956374
9 -- sjadhav , 28-aug-2001
10 -- removed FUNCTION enrp_val_att_closed
11 --
12 -------------------------------------------------------------------------------------------
13 --Change History:
14 --Who When What
15 --avenkatr 29-AUG-2001 Bug Id : 1956374. Removed procedure "crsp_val_cty_closed"
16 -------------------------------------------------------------------------------------------
17 -- Ensure IGS_PS_COURSE fee triggers can be created.
18 FUNCTION finp_val_cft_ins(
19 p_fee_type IN VARCHAR2 ,
20 p_message_name OUT NOCOPY VARCHAR2 )
21 RETURN BOOLEAN;
22 pragma restrict_references(finp_val_cft_ins,wnds);
23 --
24 -- Ensure only one open IGS_PS_FEE_TRG record exists.
25 FUNCTION finp_val_cft_open(
26 p_fee_cat IN VARCHAR2 ,
27 p_fee_cal_type IN VARCHAR2 ,
28 p_fee_ci_sequence_number IN NUMBER ,
29 p_fee_type IN VARCHAR2 ,
30 p_course_cd IN VARCHAR2 ,
31 p_sequence_number IN NUMBER ,
32 p_version_number IN NUMBER ,
33 p_cal_type IN VARCHAR2 ,
34 p_location_cd IN VARCHAR2 ,
35 p_attendance_mode IN VARCHAR2 ,
36 p_attendance_type IN VARCHAR2 ,
37 p_create_dt IN DATE ,
38 p_fee_trigger_group_number IN NUMBER ,
39 p_message_name OUT NOCOPY VARCHAR2 )
40 RETURN BOOLEAN;
41 pragma restrict_references(finp_val_cft_open,wnds);
42 --
43 -- Validate IGS_PS_COURSE code has an 'ACTIVE' or 'PLANNED' version.
44 FUNCTION finp_val_cft_crs(
45 p_course_cd IN VARCHAR2 ,
46 p_message_name OUT NOCOPY VARCHAR2 )
47 RETURN BOOLEAN;
48 pragma restrict_references(finp_val_cft_crs,wnds);
49 --
50 -- Validate calendar type has a system category of 'ACADEMIC'.
51 FUNCTION finp_val_ct_academic(
52 p_cal_type IN VARCHAR2 ,
53 p_message_name OUT NOCOPY VARCHAR2 )
54 RETURN BOOLEAN;
55 pragma restrict_references(finp_val_ct_academic,wnds);
56
57 -- Validate the Calendar Type closed ind
58 FUNCTION calp_val_cat_closed(
59 p_cal_type IN VARCHAR2 ,
60 p_message_name OUT NOCOPY VARCHAR2 )
61 RETURN BOOLEAN;
62 pragma restrict_references(calp_val_cat_closed,wnds);
63 --
64 -- bug id : 1956374
65 -- sjadhav , 28-aug-2001
66 -- removed FUNCTION enrp_val_att_closed
67 --
68 -- Validate IGS_PS_COURSE fee trigger can belong to a fee trigger group.
69 FUNCTION finp_val_cft_ftg(
70 p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
71 p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
72 p_fee_ci_sequence_num IN NUMBER ,
73 p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
74 p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
75 p_fee_trigger_group_num IN NUMBER ,
76 p_message_name OUT NOCOPY VARCHAR2 )
77 RETURN BOOLEAN;
78 pragma restrict_references(finp_val_cft_ftg,wnds);
79 END IGS_FI_VAL_CFT;