APPS.IGS_FI_VAL_CGFT dependencies on IGS_PS_GRP_FEE_TRG

Line 15: -- Validate IGS_PS_GRP_FEE_TRG.IGS_FI_FEE_TYPE.

11: p_message_name OUT NOCOPY VARCHAR2 )
12: RETURN BOOLEAN AS
13: gv_other_detail VARCHAR2(255);
14: BEGIN -- finp_val_cgft_ins
15: -- Validate IGS_PS_GRP_FEE_TRG.IGS_FI_FEE_TYPE.
16: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat <> IGS_PS_COURSE
17: -- then IGS_PS_COURSE group fee triggers cannot be defined.
18: DECLARE
19: CURSOR c_ft(

Line 50: -- Ensure only one open IGS_PS_GRP_FEE_TRG record exists..

46: RETURN TRUE;
47: END;
48: END finp_val_cgft_ins;
49: --
50: -- Ensure only one open IGS_PS_GRP_FEE_TRG record exists..
51: FUNCTION finp_val_cgft_open(
52: p_fee_cat IN VARCHAR2 ,
53: p_fee_cal_type IN VARCHAR2 ,
54: p_fee_ci_sequence_number IN NUMBER ,

Line 62: -- validate that there no other 'open-ended' IGS_PS_GRP_FEE_TRG records for

58: p_message_name OUT NOCOPY VARCHAR2 )
59: RETURN BOOLEAN AS
60: gv_other_detail VARCHAR2(255);
61: BEGIN -- finp_val_cgft_open
62: -- validate that there no other 'open-ended' IGS_PS_GRP_FEE_TRG records for
63: -- the nominated course_group_cd and the same parent IGS_FI_F_CAT_FEE_LBL
64: DECLARE
65: CURSOR c_cgft IS
66: SELECT cgft.course_group_cd

Line 67: FROM IGS_PS_GRP_FEE_TRG cgft

63: -- the nominated course_group_cd and the same parent IGS_FI_F_CAT_FEE_LBL
64: DECLARE
65: CURSOR c_cgft IS
66: SELECT cgft.course_group_cd
67: FROM IGS_PS_GRP_FEE_TRG cgft
68: WHERE cgft.fee_cat = p_fee_cat AND
69: cgft.fee_cal_type = p_fee_cal_type AND
70: cgft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
71: cgft.fee_type = p_fee_type AND