APPS.IGS_FI_VAL_FAR dependencies on IGS_FI_FEE_AS_RATE

Line 32: -- Validate if IGS_FI_FEE_AS_RATE records can be created.

28: p_message_name OUT NOCOPY VARCHAR2 )
29: RETURN BOOLEAN AS
30: gv_other_detail VARCHAR2(255);
31: BEGIN -- finp_val_far_create
32: -- Validate if IGS_FI_FEE_AS_RATE records can be created.
33: -- When defined at FTCI level, they cannot also be
34: -- defined at FCFL level and vice-versa.
35: DECLARE
36: CURSOR c_far (

Line 37: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE) IS

33: -- When defined at FTCI level, they cannot also be
34: -- defined at FCFL level and vice-versa.
35: DECLARE
36: CURSOR c_far (
37: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE) IS
38: SELECT 'x'
39: FROM IGS_FI_FEE_AS_RATE
40: WHERE fee_type = p_fee_type AND
41: fee_cal_type = p_fee_cal_type AND

Line 39: FROM IGS_FI_FEE_AS_RATE

35: DECLARE
36: CURSOR c_far (
37: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE) IS
38: SELECT 'x'
39: FROM IGS_FI_FEE_AS_RATE
40: WHERE fee_type = p_fee_type AND
41: fee_cal_type = p_fee_cal_type AND
42: fee_ci_sequence_number = p_fee_ci_sequence_number AND
43: s_relation_type = cp_s_relation_type AND

Line 57: -- 2. If p_s_relation_type = 'FCFL', check if any IGS_FI_FEE_AS_RATE records

53: p_fee_ci_sequence_number IS NULL OR
54: p_s_relation_type IS NULL THEN
55: RETURN TRUE;
56: END IF;
57: -- 2. If p_s_relation_type = 'FCFL', check if any IGS_FI_FEE_AS_RATE records
58: -- have been defined at the FTCI level. If so, return error.
59: IF p_s_relation_type = 'FCFL' THEN
60: OPEN c_far(
61: 'FTCI');

Line 70: -- 3. If p_s_relation_type = 'FTCI', check if any IGS_FI_FEE_AS_RATE records

66: RETURN FALSE;
67: END IF;
68: CLOSE c_far;
69: END IF;
70: -- 3. If p_s_relation_type = 'FTCI', check if any IGS_FI_FEE_AS_RATE records
71: -- have been defined at the FCFL level. If so, return error.
72: IF p_s_relation_type = 'FTCI' THEN
73: OPEN c_far(
74: 'FCFL');

Line 147: -- then IGS_FI_FEE_AS_RATE.govt_hecs_payment_option must be entered.

143: RETURN BOOLEAN AS
144: gv_other_detail VARCHAR2(255);
145: BEGIN -- finp_val_far_rqrd
146: -- Validate if IGS_FI_FEE_TYPE.s_fee_type = 'HECS' or 'TUITION',
147: -- then IGS_FI_FEE_AS_RATE.govt_hecs_payment_option must be entered.
148: DECLARE
149: v_dummy VARCHAR2(1);
150: CURSOR c_ft IS
151: SELECT 'x'

Line 224: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,

220: -- Modified cursor c_far
221: /*****************************************************************************/
222: gv_other_detail VARCHAR2(255);
223: BEGIN -- finp_val_far_unique
224: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,
225: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option
226: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band form a unique combination.
227: -- Required as all five fields are optional.
228: DECLARE

Line 225: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option

221: /*****************************************************************************/
222: gv_other_detail VARCHAR2(255);
223: BEGIN -- finp_val_far_unique
224: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,
225: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option
226: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band form a unique combination.
227: -- Required as all five fields are optional.
228: DECLARE
229: v_dummy VARCHAR2(1);

Line 226: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band form a unique combination.

222: gv_other_detail VARCHAR2(255);
223: BEGIN -- finp_val_far_unique
224: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,
225: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option
226: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band form a unique combination.
227: -- Required as all five fields are optional.
228: DECLARE
229: v_dummy VARCHAR2(1);
230: CURSOR c_far IS

Line 232: FROM igs_fi_fee_as_rate far

228: DECLARE
229: v_dummy VARCHAR2(1);
230: CURSOR c_far IS
231: SELECT 'x'
232: FROM igs_fi_fee_as_rate far
233: WHERE far.fee_type = p_fee_type
234: AND far.fee_cal_type = p_fee_cal_type
235: AND far.fee_ci_sequence_number = p_fee_ci_sequence_number
236: AND far.s_relation_type = p_s_relation_type

Line 314: -- Validate IGS_FI_FEE_AS_RATE.order_of_precedence exists when one or more of

310: p_message_name OUT NOCOPY VARCHAR2 )
311: RETURN BOOLEAN AS
312: gv_other_detail VARCHAR2(255);
313: BEGIN -- finp_val_far_order
314: -- Validate IGS_FI_FEE_AS_RATE.order_of_precedence exists when one or more of
315: -- IGS_FI_FEE_AS_RATE.attendance_type, IGS_FI_FEE_AS_RATE.attendance_mode or
316: -- IGS_FI_FEE_AS_RATE.location_cd are specified, resulting in a non-mutually
317: -- exclusive fee assessment rate.
318: -- The mutually exclusive combinations are :

Line 315: -- IGS_FI_FEE_AS_RATE.attendance_type, IGS_FI_FEE_AS_RATE.attendance_mode or

311: RETURN BOOLEAN AS
312: gv_other_detail VARCHAR2(255);
313: BEGIN -- finp_val_far_order
314: -- Validate IGS_FI_FEE_AS_RATE.order_of_precedence exists when one or more of
315: -- IGS_FI_FEE_AS_RATE.attendance_type, IGS_FI_FEE_AS_RATE.attendance_mode or
316: -- IGS_FI_FEE_AS_RATE.location_cd are specified, resulting in a non-mutually
317: -- exclusive fee assessment rate.
318: -- The mutually exclusive combinations are :
319: -- only location code is defined across all related rates

Line 316: -- IGS_FI_FEE_AS_RATE.location_cd are specified, resulting in a non-mutually

312: gv_other_detail VARCHAR2(255);
313: BEGIN -- finp_val_far_order
314: -- Validate IGS_FI_FEE_AS_RATE.order_of_precedence exists when one or more of
315: -- IGS_FI_FEE_AS_RATE.attendance_type, IGS_FI_FEE_AS_RATE.attendance_mode or
316: -- IGS_FI_FEE_AS_RATE.location_cd are specified, resulting in a non-mutually
317: -- exclusive fee assessment rate.
318: -- The mutually exclusive combinations are :
319: -- only location code is defined across all related rates
320: -- only attendance type is defined across all related rates

Line 344: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

340: v_far_7_rec_found BOOLEAN := FALSE;
341: v_far_8_rec_found BOOLEAN := FALSE;
342: v_far_9_rec_found BOOLEAN := FALSE;
343: CURSOR c_far_1 (
344: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
345: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
346: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 345: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

341: v_far_8_rec_found BOOLEAN := FALSE;
342: v_far_9_rec_found BOOLEAN := FALSE;
343: CURSOR c_far_1 (
344: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
345: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
346: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
349: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

Line 346: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

342: v_far_9_rec_found BOOLEAN := FALSE;
343: CURSOR c_far_1 (
344: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
345: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
346: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
349: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
350: SELECT far.order_of_precedence

Line 347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

343: CURSOR c_far_1 (
344: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
345: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
346: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
349: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
350: SELECT far.order_of_precedence
351: FROM IGS_FI_FEE_AS_RATE far

Line 348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

344: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
345: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
346: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
349: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
350: SELECT far.order_of_precedence
351: FROM IGS_FI_FEE_AS_RATE far
352: WHERE far.fee_type = cp_fee_type AND

Line 349: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

345: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
346: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
349: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
350: SELECT far.order_of_precedence
351: FROM IGS_FI_FEE_AS_RATE far
352: WHERE far.fee_type = cp_fee_type AND
353: far.fee_cal_type = cp_fee_cal_type AND

Line 351: FROM IGS_FI_FEE_AS_RATE far

347: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
348: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
349: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
350: SELECT far.order_of_precedence
351: FROM IGS_FI_FEE_AS_RATE far
352: WHERE far.fee_type = cp_fee_type AND
353: far.fee_cal_type = cp_fee_cal_type AND
354: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
355: far.s_relation_type = cp_s_relation_type AND

Line 362: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

358: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
359: ((far.location_cd IS NULL) OR
360: (far.attendance_mode IS NOT NULL OR far.attendance_type IS NOT NULL));
361: CURSOR c_far_2 (
362: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
363: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
364: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 363: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

359: ((far.location_cd IS NULL) OR
360: (far.attendance_mode IS NOT NULL OR far.attendance_type IS NOT NULL));
361: CURSOR c_far_2 (
362: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
363: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
364: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
367: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

Line 364: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

360: (far.attendance_mode IS NOT NULL OR far.attendance_type IS NOT NULL));
361: CURSOR c_far_2 (
362: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
363: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
364: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
367: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
368: SELECT far.order_of_precedence

Line 365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

361: CURSOR c_far_2 (
362: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
363: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
364: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
367: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
368: SELECT far.order_of_precedence
369: FROM IGS_FI_FEE_AS_RATE far

Line 366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

362: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
363: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
364: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
367: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
368: SELECT far.order_of_precedence
369: FROM IGS_FI_FEE_AS_RATE far
370: WHERE far.fee_type = cp_fee_type AND

Line 367: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

363: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
364: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
367: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
368: SELECT far.order_of_precedence
369: FROM IGS_FI_FEE_AS_RATE far
370: WHERE far.fee_type = cp_fee_type AND
371: far.fee_cal_type = cp_fee_cal_type AND

Line 369: FROM IGS_FI_FEE_AS_RATE far

365: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
366: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
367: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
368: SELECT far.order_of_precedence
369: FROM IGS_FI_FEE_AS_RATE far
370: WHERE far.fee_type = cp_fee_type AND
371: far.fee_cal_type = cp_fee_cal_type AND
372: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
373: far.s_relation_type = cp_s_relation_type AND

Line 380: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

376: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
377: ((far.location_cd IS NULL OR far.attendance_mode IS NULL) OR
378: (far.attendance_type IS NOT NULL));
379: CURSOR c_far_3 (
380: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
381: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
382: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 381: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

377: ((far.location_cd IS NULL OR far.attendance_mode IS NULL) OR
378: (far.attendance_type IS NOT NULL));
379: CURSOR c_far_3 (
380: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
381: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
382: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
385: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

Line 382: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

378: (far.attendance_type IS NOT NULL));
379: CURSOR c_far_3 (
380: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
381: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
382: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
385: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
386: SELECT far.order_of_precedence

Line 383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

379: CURSOR c_far_3 (
380: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
381: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
382: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
385: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
386: SELECT far.order_of_precedence
387: FROM IGS_FI_FEE_AS_RATE far

Line 384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

380: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
381: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
382: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
385: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
386: SELECT far.order_of_precedence
387: FROM IGS_FI_FEE_AS_RATE far
388: WHERE far.fee_type = cp_fee_type AND

Line 385: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

381: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
382: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
385: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
386: SELECT far.order_of_precedence
387: FROM IGS_FI_FEE_AS_RATE far
388: WHERE far.fee_type = cp_fee_type AND
389: far.fee_cal_type = cp_fee_cal_type AND

Line 387: FROM IGS_FI_FEE_AS_RATE far

383: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
384: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
385: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
386: SELECT far.order_of_precedence
387: FROM IGS_FI_FEE_AS_RATE far
388: WHERE far.fee_type = cp_fee_type AND
389: far.fee_cal_type = cp_fee_cal_type AND
390: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
391: far.s_relation_type = cp_s_relation_type AND

Line 398: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

394: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
395: ((far.location_cd IS NULL OR far.attendance_type IS NULL) OR
396: (far.attendance_mode IS NOT NULL));
397: CURSOR c_far_4 (
398: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
399: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
400: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 399: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

395: ((far.location_cd IS NULL OR far.attendance_type IS NULL) OR
396: (far.attendance_mode IS NOT NULL));
397: CURSOR c_far_4 (
398: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
399: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
400: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
403: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

Line 400: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

396: (far.attendance_mode IS NOT NULL));
397: CURSOR c_far_4 (
398: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
399: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
400: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
403: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
404: SELECT far.order_of_precedence

Line 401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

397: CURSOR c_far_4 (
398: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
399: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
400: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
403: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
404: SELECT far.order_of_precedence
405: FROM IGS_FI_FEE_AS_RATE far

Line 402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

398: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
399: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
400: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
403: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
404: SELECT far.order_of_precedence
405: FROM IGS_FI_FEE_AS_RATE far
406: WHERE far.fee_type = cp_fee_type AND

Line 403: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

399: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
400: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
403: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
404: SELECT far.order_of_precedence
405: FROM IGS_FI_FEE_AS_RATE far
406: WHERE far.fee_type = cp_fee_type AND
407: far.fee_cal_type = cp_fee_cal_type AND

Line 405: FROM IGS_FI_FEE_AS_RATE far

401: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
402: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
403: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
404: SELECT far.order_of_precedence
405: FROM IGS_FI_FEE_AS_RATE far
406: WHERE far.fee_type = cp_fee_type AND
407: far.fee_cal_type = cp_fee_cal_type AND
408: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
409: far.s_relation_type = cp_s_relation_type AND

Line 417: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

413: ((far.location_cd IS NULL OR
414: far.attendance_mode IS NULL) OR
415: (far.attendance_type IS NULL));
416: CURSOR c_far_5 (
417: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
418: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
419: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 418: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

414: far.attendance_mode IS NULL) OR
415: (far.attendance_type IS NULL));
416: CURSOR c_far_5 (
417: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
418: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
419: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
422: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

Line 419: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

415: (far.attendance_type IS NULL));
416: CURSOR c_far_5 (
417: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
418: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
419: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
422: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
423: SELECT far.order_of_precedence

Line 420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

416: CURSOR c_far_5 (
417: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
418: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
419: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
422: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
423: SELECT far.order_of_precedence
424: FROM IGS_FI_FEE_AS_RATE far

Line 421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

417: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
418: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
419: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
422: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
423: SELECT far.order_of_precedence
424: FROM IGS_FI_FEE_AS_RATE far
425: WHERE far.fee_type = cp_fee_type AND

Line 422: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

418: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
419: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
422: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
423: SELECT far.order_of_precedence
424: FROM IGS_FI_FEE_AS_RATE far
425: WHERE far.fee_type = cp_fee_type AND
426: far.fee_cal_type = cp_fee_cal_type AND

Line 424: FROM IGS_FI_FEE_AS_RATE far

420: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
421: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
422: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
423: SELECT far.order_of_precedence
424: FROM IGS_FI_FEE_AS_RATE far
425: WHERE far.fee_type = cp_fee_type AND
426: far.fee_cal_type = cp_fee_cal_type AND
427: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
428: far.s_relation_type = cp_s_relation_type AND

Line 435: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

431: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
432: ((far.attendance_type IS NULL) OR
433: (far.location_cd IS NOT NULL OR far.attendance_mode IS NOT NULL));
434: CURSOR c_far_6 (
435: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
436: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
437: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 436: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

432: ((far.attendance_type IS NULL) OR
433: (far.location_cd IS NOT NULL OR far.attendance_mode IS NOT NULL));
434: CURSOR c_far_6 (
435: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
436: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
437: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
440: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

Line 437: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

433: (far.location_cd IS NOT NULL OR far.attendance_mode IS NOT NULL));
434: CURSOR c_far_6 (
435: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
436: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
437: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
440: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
441: SELECT far.order_of_precedence

Line 438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

434: CURSOR c_far_6 (
435: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
436: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
437: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
440: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
441: SELECT far.order_of_precedence
442: FROM IGS_FI_FEE_AS_RATE far

Line 439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

435: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
436: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
437: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
440: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
441: SELECT far.order_of_precedence
442: FROM IGS_FI_FEE_AS_RATE far
443: WHERE far.fee_type = cp_fee_type AND

Line 440: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

436: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
437: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
440: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
441: SELECT far.order_of_precedence
442: FROM IGS_FI_FEE_AS_RATE far
443: WHERE far.fee_type = cp_fee_type AND
444: far.fee_cal_type = cp_fee_cal_type AND

Line 442: FROM IGS_FI_FEE_AS_RATE far

438: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
439: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
440: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
441: SELECT far.order_of_precedence
442: FROM IGS_FI_FEE_AS_RATE far
443: WHERE far.fee_type = cp_fee_type AND
444: far.fee_cal_type = cp_fee_cal_type AND
445: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
446: far.s_relation_type = cp_s_relation_type AND

Line 453: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

449: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
450: ((far.attendance_mode IS NULL OR far.attendance_type IS NULL) OR
451: (far.location_cd IS NOT NULL));
452: CURSOR c_far_7 (
453: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
454: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
455: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 454: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

450: ((far.attendance_mode IS NULL OR far.attendance_type IS NULL) OR
451: (far.location_cd IS NOT NULL));
452: CURSOR c_far_7 (
453: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
454: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
455: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
458: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

Line 455: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

451: (far.location_cd IS NOT NULL));
452: CURSOR c_far_7 (
453: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
454: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
455: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
458: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
459: SELECT far.order_of_precedence

Line 456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

452: CURSOR c_far_7 (
453: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
454: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
455: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
458: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
459: SELECT far.order_of_precedence
460: FROM IGS_FI_FEE_AS_RATE far

Line 457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

453: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
454: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
455: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
458: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
459: SELECT far.order_of_precedence
460: FROM IGS_FI_FEE_AS_RATE far
461: WHERE far.fee_type = cp_fee_type AND

Line 458: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS

454: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
455: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
458: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
459: SELECT far.order_of_precedence
460: FROM IGS_FI_FEE_AS_RATE far
461: WHERE far.fee_type = cp_fee_type AND
462: far.fee_cal_type = cp_fee_cal_type AND

Line 460: FROM IGS_FI_FEE_AS_RATE far

456: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
457: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
458: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE) IS
459: SELECT far.order_of_precedence
460: FROM IGS_FI_FEE_AS_RATE far
461: WHERE far.fee_type = cp_fee_type AND
462: far.fee_cal_type = cp_fee_cal_type AND
463: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
464: far.s_relation_type = cp_s_relation_type AND

Line 471: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

467: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
468: ((far.attendance_mode IS NULL) OR
469: (far.location_cd IS NOT NULL OR far.attendance_type IS NOT NULL));
470: CURSOR c_far_8 (
471: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
472: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 472: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

468: ((far.attendance_mode IS NULL) OR
469: (far.location_cd IS NOT NULL OR far.attendance_type IS NOT NULL));
470: CURSOR c_far_8 (
471: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
472: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,

Line 473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

469: (far.location_cd IS NOT NULL OR far.attendance_type IS NOT NULL));
470: CURSOR c_far_8 (
471: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
472: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
477: cp_order_of_precedence IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE) IS

Line 474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

470: CURSOR c_far_8 (
471: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
472: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
477: cp_order_of_precedence IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE) IS
478: SELECT far.order_of_precedence

Line 475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

471: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
472: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
477: cp_order_of_precedence IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE) IS
478: SELECT far.order_of_precedence
479: FROM IGS_FI_FEE_AS_RATE far

Line 476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,

472: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
477: cp_order_of_precedence IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE) IS
478: SELECT far.order_of_precedence
479: FROM IGS_FI_FEE_AS_RATE far
480: WHERE far.fee_type = cp_fee_type AND

Line 477: cp_order_of_precedence IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE) IS

473: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
474: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
477: cp_order_of_precedence IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE) IS
478: SELECT far.order_of_precedence
479: FROM IGS_FI_FEE_AS_RATE far
480: WHERE far.fee_type = cp_fee_type AND
481: far.fee_cal_type = cp_fee_cal_type AND

Line 479: FROM IGS_FI_FEE_AS_RATE far

475: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
476: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
477: cp_order_of_precedence IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE) IS
478: SELECT far.order_of_precedence
479: FROM IGS_FI_FEE_AS_RATE far
480: WHERE far.fee_type = cp_fee_type AND
481: far.fee_cal_type = cp_fee_cal_type AND
482: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
483: far.s_relation_type = cp_s_relation_type AND

Line 489: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,

485: far.logical_delete_dt IS NULL AND
486: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
487: far.order_of_precedence = cp_order_of_precedence;
488: CURSOR c_far_9 (
489: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
490: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

Line 490: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

486: NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
487: far.order_of_precedence = cp_order_of_precedence;
488: CURSOR c_far_9 (
489: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
490: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,

Line 491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

487: far.order_of_precedence = cp_order_of_precedence;
488: CURSOR c_far_9 (
489: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
490: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,

Line 492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,

488: CURSOR c_far_9 (
489: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
490: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,

Line 493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,

489: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE,
490: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,
497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,

Line 494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,

490: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,
497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,
498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,

Line 495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,

491: cp_fee_ci_sequence_number IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,
497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,
498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,
499: cp_govt_hecs_cntrbtn_band IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE) IS

Line 496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,

492: cp_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE,
493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,
497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,
498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,
499: cp_govt_hecs_cntrbtn_band IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE) IS
500: SELECT far.order_of_precedence

Line 497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,

493: cp_rate_number IGS_FI_FEE_AS_RATE.rate_number%TYPE,
494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,
497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,
498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,
499: cp_govt_hecs_cntrbtn_band IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE) IS
500: SELECT far.order_of_precedence
501: FROM IGS_FI_FEE_AS_RATE far

Line 498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,

494: cp_fee_cat IGS_FI_FEE_AS_RATE.fee_cat%TYPE,
495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,
497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,
498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,
499: cp_govt_hecs_cntrbtn_band IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE) IS
500: SELECT far.order_of_precedence
501: FROM IGS_FI_FEE_AS_RATE far
502: WHERE far.fee_type = cp_fee_type AND

Line 499: cp_govt_hecs_cntrbtn_band IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE) IS

495: cp_location_cd IGS_FI_FEE_AS_RATE.location_cd%TYPE,
496: cp_attendance_mode IGS_FI_FEE_AS_RATE.attendance_mode%TYPE,
497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,
498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,
499: cp_govt_hecs_cntrbtn_band IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE) IS
500: SELECT far.order_of_precedence
501: FROM IGS_FI_FEE_AS_RATE far
502: WHERE far.fee_type = cp_fee_type AND
503: far.fee_cal_type = cp_fee_cal_type AND

Line 501: FROM IGS_FI_FEE_AS_RATE far

497: cp_attendance_type IGS_FI_FEE_AS_RATE.attendance_type%TYPE,
498: cp_govt_hecs_payment_option IGS_FI_FEE_AS_RATE.govt_hecs_payment_option%TYPE,
499: cp_govt_hecs_cntrbtn_band IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE) IS
500: SELECT far.order_of_precedence
501: FROM IGS_FI_FEE_AS_RATE far
502: WHERE far.fee_type = cp_fee_type AND
503: far.fee_cal_type = cp_fee_cal_type AND
504: far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
505: far.s_relation_type = cp_s_relation_type AND

Line 653: -- values for matching IGS_FI_FEE_AS_RATE records of the same FTCI/FCFL parent.

649: ELSE -- p_order_of_precedence IS NOT NULL
650: -- Check_order_uniqueness.
651: -- As the order_of_precedence has been specified,
652: -- validate that it is unique from other order_of_precedence
653: -- values for matching IGS_FI_FEE_AS_RATE records of the same FTCI/FCFL parent.
654: FOR v_far_8_rec IN c_far_8(
655: p_fee_type,
656: p_fee_cal_type,
657: p_fee_ci_sequence_number,

Line 699: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,

695: p_message_name OUT NOCOPY VARCHAR2 )
696: RETURN BOOLEAN AS
697: gv_other_detail VARCHAR2(255);
698: BEGIN -- finp_val_far_defntn
699: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,
700: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option
701: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band are allowed to be specified
702: -- or not, depending on fee_type value.
703: DECLARE

Line 700: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option

696: RETURN BOOLEAN AS
697: gv_other_detail VARCHAR2(255);
698: BEGIN -- finp_val_far_defntn
699: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,
700: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option
701: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band are allowed to be specified
702: -- or not, depending on fee_type value.
703: DECLARE
704: cst_other CONSTANT VARCHAR2(10) := 'OTHER';

Line 701: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band are allowed to be specified

697: gv_other_detail VARCHAR2(255);
698: BEGIN -- finp_val_far_defntn
699: -- Validate if IGS_FI_FEE_AS_RATE.location_cd, IGS_FI_FEE_AS_RATE.attendance_type,
700: -- IGS_FI_FEE_AS_RATE.attendance_mode, IGS_FI_FEE_AS_RATE.govt_hecs_payment_option
701: -- and IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band are allowed to be specified
702: -- or not, depending on fee_type value.
703: DECLARE
704: cst_other CONSTANT VARCHAR2(10) := 'OTHER';
705: cst_tutnfee CONSTANT VARCHAR2(10) := 'TUTNFEE';

Line 709: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE) IS

705: cst_tutnfee CONSTANT VARCHAR2(10) := 'TUTNFEE';
706: cst_hecs CONSTANT VARCHAR2(10) := 'HECS';
707: cst_tuition CONSTANT VARCHAR2(10) := 'TUITION';
708: CURSOR c_ft(
709: cp_fee_type IGS_FI_FEE_AS_RATE.fee_type%TYPE) IS
710: SELECT s_fee_type
711: FROM IGS_FI_FEE_TYPE
712: WHERE fee_type = cp_fee_type;
713: v_ft_rec c_ft%ROWTYPE;

Line 936: -- Validate IGS_FI_FEE_AS_RATE.fee_type. If IGS_FI_FEE_TYPE.s_fee_trigger_cat = ?INSTITUTN?

932: p_message_name OUT NOCOPY VARCHAR2 )
933: RETURN BOOLEAN AS
934: gv_other_detail VARCHAR2(255);
935: BEGIN -- finp_val_far_ins
936: -- Validate IGS_FI_FEE_AS_RATE.fee_type. If IGS_FI_FEE_TYPE.s_fee_trigger_cat = ?INSTITUTN?
937: -- or IGS_FI_FEE_TYPE.s_fee_type = ?HECS?, then assessment rates can only be defined
938: -- against fee_type_cal_instances.
939: DECLARE
940: CURSOR c_ft(

Line 987: -- Validate IGS_FI_FEE_AS_RATE.fee_cat is only specified for the appropriate

983: p_message_name OUT NOCOPY VARCHAR2 )
984: RETURN BOOLEAN AS
985: gv_other_detail VARCHAR2(255);
986: BEGIN -- finp_val_far_relation
987: -- Validate IGS_FI_FEE_AS_RATE.fee_cat is only specified for the appropriate
988: -- IGS_FI_FEE_AS_RATE.s_relation_type
989: DECLARE
990: BEGIN
991: --- Set the default message number

Line 988: -- IGS_FI_FEE_AS_RATE.s_relation_type

984: RETURN BOOLEAN AS
985: gv_other_detail VARCHAR2(255);
986: BEGIN -- finp_val_far_relation
987: -- Validate IGS_FI_FEE_AS_RATE.fee_cat is only specified for the appropriate
988: -- IGS_FI_FEE_AS_RATE.s_relation_type
989: DECLARE
990: BEGIN
991: --- Set the default message number
992: p_message_name := Null;