[Home] [Help]
164: p_message_name OUT NOCOPY VARCHAR2 )
165: RETURN BOOLEAN AS
166: gv_other_detail VARCHAR2(255);
167: BEGIN -- finp_val_ct_academic
168: -- Validates that the IGS_PS_FEE_TRG.IGS_CA_TYPE has a system calendar
169: -- category of 'ACADEMIC'
170: DECLARE
171: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
172: v_dummy VARCHAR2(1);
170: DECLARE
171: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
172: v_dummy VARCHAR2(1);
173: CURSOR c_cal_type (
174: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
175: SELECT 'x'
176: FROM IGS_CA_TYPE cat
177: WHERE cat.cal_type = cp_cal_type AND
178: cat.s_cal_cat = cst_academic;
172: v_dummy VARCHAR2(1);
173: CURSOR c_cal_type (
174: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
175: SELECT 'x'
176: FROM IGS_CA_TYPE cat
177: WHERE cat.cal_type = cp_cal_type AND
178: cat.s_cal_cat = cst_academic;
179: BEGIN
180: p_message_name := Null;
204: BEGIN
205: DECLARE
206: CURSOR c_cat IS
207: SELECT closed_ind
208: FROM IGS_CA_TYPE
209: WHERE cal_type = p_cal_type;
210: v_cat_rec c_cat%ROWTYPE;
211: BEGIN
212: -- Check if the IGS_CA_TYPE is closed
208: FROM IGS_CA_TYPE
209: WHERE cal_type = p_cal_type;
210: v_cat_rec c_cat%ROWTYPE;
211: BEGIN
212: -- Check if the IGS_CA_TYPE is closed
213: -- Set the default message number
214: p_message_name := Null;
215: -- Cursor handling
216: OPEN c_cat ;
235: --
236: -- Validate IGS_PS_COURSE fee trigger can belong to a fee trigger group.
237: FUNCTION finp_val_cft_ftg(
238: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
239: p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
240: p_fee_ci_sequence_num IN NUMBER ,
241: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
242: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE,
243: p_fee_trigger_group_num IN NUMBER ,