eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_VAL_FAR dependencies on IGS_FI_FEE_TYPE

Line 146: -- Validate if IGS_FI_FEE_TYPE.s_fee_type = 'HECS' or 'TUITION',

142: p_message_name OUT NOCOPY VARCHAR2 )
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

Line 152: FROM IGS_FI_FEE_TYPE ft

148: DECLARE
149: v_dummy VARCHAR2(1);
150: CURSOR c_ft IS
151: SELECT 'x'
152: FROM IGS_FI_FEE_TYPE ft
153: WHERE ft.fee_type = p_fee_type AND
154: ft.s_fee_type IN ('HECS','TUITION');
155: BEGIN
156: -- Set the default message number

Line 162: -- 2. Determine the IGS_FI_FEE_TYPE.s_fee_type value.

158: -- 1. Check parameters :
159: IF (p_fee_type IS NULL) THEN
160: Return TRUE;
161: END IF;
162: -- 2. Determine the IGS_FI_FEE_TYPE.s_fee_type value.
163: OPEN c_ft;
164: FETCH c_ft INTO v_dummy;
165: IF c_ft%FOUND THEN --govt_hecs_payment_option must exist
166: IF (p_govt_hecs_payment_option IS NULL) THEN

Line 711: FROM IGS_FI_FEE_TYPE

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;
714: BEGIN
715: -- Set the default message number

Line 734: -- Validate the IGS_FI_FEE_TYPE to see if it is permissible for particular values to

730: CLOSE c_ft;
731: RETURN TRUE;
732: END IF;
733: CLOSE c_ft;
734: -- Validate the IGS_FI_FEE_TYPE to see if it is permissible for particular values to
735: -- be specified.
736: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?OTHER?, govt_hecs_payment_option and
737: -- govt_hecs_cntrbtn_band cannot be specified.
738: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?HECS?, location_cd, attendance_type and

Line 736: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?OTHER?, govt_hecs_payment_option and

732: END IF;
733: CLOSE c_ft;
734: -- Validate the IGS_FI_FEE_TYPE to see if it is permissible for particular values to
735: -- be specified.
736: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?OTHER?, govt_hecs_payment_option and
737: -- govt_hecs_cntrbtn_band cannot be specified.
738: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?HECS?, location_cd, attendance_type and
739: -- attendance_mode cannot be specified.
740: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?TUITION?, govt_hecs_cntrbtn_band

Line 738: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?HECS?, location_cd, attendance_type and

734: -- Validate the IGS_FI_FEE_TYPE to see if it is permissible for particular values to
735: -- be specified.
736: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?OTHER?, govt_hecs_payment_option and
737: -- govt_hecs_cntrbtn_band cannot be specified.
738: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?HECS?, location_cd, attendance_type and
739: -- attendance_mode cannot be specified.
740: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?TUITION?, govt_hecs_cntrbtn_band
741: -- cannot be specified.
742: IF v_ft_rec.s_fee_type in ( cst_other,cst_tutnfee) THEN

Line 740: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?TUITION?, govt_hecs_cntrbtn_band

736: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?OTHER?, govt_hecs_payment_option and
737: -- govt_hecs_cntrbtn_band cannot be specified.
738: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?HECS?, location_cd, attendance_type and
739: -- attendance_mode cannot be specified.
740: -- ? When IGS_FI_FEE_TYPE.s_fee_type = ?TUITION?, govt_hecs_cntrbtn_band
741: -- cannot be specified.
742: IF v_ft_rec.s_fee_type in ( cst_other,cst_tutnfee) THEN
743: IF p_govt_hecs_payment_option IS NOT NULL THEN
744: p_message_name := 'IGS_FI_GOVTHECS_PYMTOP_OTHER';

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 937: -- or IGS_FI_FEE_TYPE.s_fee_type = ?HECS?, then assessment rates can only be defined

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(
941: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 941: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

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(
941: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
942: SELECT s_fee_trigger_cat,
943: s_fee_type
944: FROM IGS_FI_FEE_TYPE
945: WHERE fee_type = cp_fee_type;

Line 944: FROM IGS_FI_FEE_TYPE

940: CURSOR c_ft(
941: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
942: SELECT s_fee_trigger_cat,
943: s_fee_type
944: FROM IGS_FI_FEE_TYPE
945: WHERE fee_type = cp_fee_type;
946: v_ft_rec c_ft%ROWTYPE;
947: cst_institutn CONSTANT VARCHAR2(10) := 'INSTITUTN';
948: cst_hecs CONSTANT VARCHAR2(5) := 'HECS';