[Home] [Help]
33: --rmaddipa 28-SEP-2004 Enh #:3880438 . Added code to check whether any retention schedule exist at teaching period level
34: -- for the context fee type.
35: --------------------------------------------------------------------
36: BEGIN -- finp_val_ft_opt_pymt
37: -- Validate changes to the IGS_FI_FEE_TYPE.s_fee_trigger_cat, cannot be set yo 'Y'
38: -- when related fee_rentention_schedule records exist.
39: DECLARE
40: v_dummy VARCHAR2(1);
41: CURSOR c_fee_retention_schedule (
46: -- Removed reference to IGS_FI_FEE_ENCMB(c_fee_encumbrance cursor) table asthe table is obseleted as part of bug 2126091 sykrishn -30112001
47:
48: --cursor to check whether any retention schedule exists at teaching period level for a given fee type.
49: CURSOR cur_tp_ret_schd (
50: cp_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
51: SELECT 'X'
52: FROM igs_fi_tp_ret_schd
53: WHERE fee_type = cp_fee_type;
54:
114: -------------------------------------------------------------------
115:
116:
117: BEGIN -- finp_val_ft_trig
118: -- Validate changes to the IGS_FI_FEE_TYPE.s_fee_trigger_cat.
119: -- If changing from INSTITUTN to anything else ensure there are
120: -- no related IGS_FI_FEE_AS records.
121: -- If changing to INSTITUTN from anything else ensure there are no
122: -- related IGS_FI_FEE_AS records
414: p_message_name OUT NOCOPY VARCHAR2 )
415: RETURN BOOLEAN AS
416: BEGIN
417: -- finp_val_ft_sft_trig
418: -- Validate the IGS_FI_FEE_TYPE.s_fee_type and fee_type.s_fee_trigger_cat are
419: -- compatible.
420: DECLARE
421: BEGIN
422: p_message_name := NULL;
453: || which there is Check for FCFL level Fee Payment Schedules related to
454: || the Fee Type.
455: ----------------------------------------------------------------------------*/
456: BEGIN -- finp_val_ft_sftc
457: -- Validate changes to the IGS_FI_FEE_TYPE.s_fee_trigger_cat.
458: -- If changing to INSTITUTN from anything else ensure there are no
459: -- related IGS_FI_F_CAT_FEE_LBL records with SI_FI_S_CHG_MTH or
460: -- rule_sequence_number set.
461: -- If changing to INSTITUTN from anything else ensure there are no
467: -- IGS_FI_FEE_AS_RATE
468: -- IGS_FI_ELM_RANGE
469: DECLARE
470: v_dummy VARCHAR2(1);
471: CURSOR c_fee_cat_fee_liability (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
472: SELECT 'x'
473: FROM IGS_FI_F_CAT_FEE_LBL
474: WHERE FEE_TYPE = cp_fee_type AND
475: (s_chg_method_type IS NOT NULL OR
474: WHERE FEE_TYPE = cp_fee_type AND
475: (s_chg_method_type IS NOT NULL OR
476: rul_sequence_number IS NOT NULL);
477:
478: CURSOR c_fee_retention_schedule (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
479: SELECT 'x'
480: FROM IGS_FI_FEE_RET_SCHD
481: WHERE FEE_TYPE = cp_fee_type AND
482: s_relation_type = 'FCFL';
485:
486: -- removed the cursor selecting data from the charge method apportionment table
487: -- tbl obsoleted as a prt of bug - 2187247 (rnirwani)
488:
489: CURSOR c_fee_ass_rate (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
490: SELECT 'x'
491: FROM IGS_FI_FEE_AS_RATE
492: WHERE FEE_TYPE = cp_fee_type AND
493: s_relation_type = 'FCFL' AND
491: FROM IGS_FI_FEE_AS_RATE
492: WHERE FEE_TYPE = cp_fee_type AND
493: s_relation_type = 'FCFL' AND
494: logical_delete_dt IS NULL;
495: CURSOR c_elements_range (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
496: SELECT 'x'
497: FROM IGS_FI_ELM_RANGE
498: WHERE FEE_TYPE = cp_fee_type AND
499: s_relation_type = 'FCFL' AND