APPS.IGS_FI_VAL_CTFT dependencies on IGS_PS_TYPE_FEE_TRG

Line 16: -- Validate IGS_PS_TYPE_FEE_TRG.IGS_FI_FEE_TYPE.

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

Line 51: -- Ensure only one open IGS_PS_TYPE_FEE_TRG record exists..

47: RETURN TRUE;
48: END;
49: END finp_val_ctft_ins;
50: --
51: -- Ensure only one open IGS_PS_TYPE_FEE_TRG record exists..
52: FUNCTION finp_val_ctft_open(
53: p_fee_cat IN VARCHAR2 ,
54: p_fee_cal_type IN VARCHAR2 ,
55: p_fee_ci_sequence_number IN NUMBER ,

Line 68: FROM IGS_PS_TYPE_FEE_TRG ctft

64: -- the nominated IGS_PS_TYPE and the same parent IGS_FI_F_CAT_FEE_LBL
65: DECLARE
66: CURSOR c_ctft IS
67: SELECT ctft.course_type
68: FROM IGS_PS_TYPE_FEE_TRG ctft
69: WHERE ctft.fee_cat = p_fee_cat AND
70: ctft.fee_cal_type = p_fee_cal_type AND
71: ctft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
72: ctft.fee_type = p_fee_type AND

Line 76: v_course_type IGS_PS_TYPE_FEE_TRG.course_type%TYPE;

72: ctft.fee_type = p_fee_type AND
73: ctft.course_type = p_course_type AND
74: ctft.create_dt <> p_create_dt AND
75: ctft.logical_delete_dt IS NULL;
76: v_course_type IGS_PS_TYPE_FEE_TRG.course_type%TYPE;
77: BEGIN
78: --- Set the default message number
79: p_message_name := Null;
80: IF p_fee_cat IS NULL OR