APPS.IGS_FI_VAL_ER dependencies on IGS_FI_F_CAT_FEE_LBL

Line 199: -- IGS_FI_F_CAT_FEE_LBL.s_chg_method_type, fee_type.

195: RETURN BOOLEAN AS
196: gv_other_detail VARCHAR2(255);
197: BEGIN -- finp_val_er_create
198: -- Validate IGS_FI_F_TYP_CA_INST.s_chg_method_type, fee_type and
199: -- IGS_FI_F_CAT_FEE_LBL.s_chg_method_type, fee_type.
200: -- If s_chg_method_type = 'FLATRATE' or IGS_FI_FEE_TYPE.s_fee_type = 'HECS', then
201: -- element ranges cannot be defined
202: DECLARE
203: CURSOR c_ftci IS

Line 211: FROM IGS_FI_F_CAT_FEE_LBL ftfl

207: ftci.fee_cal_type = p_fee_cal_type AND
208: ftci.fee_ci_sequence_number = p_fee_ci_sequence_number;
209: CURSOR c_ftfl IS
210: SELECT ftfl.s_chg_method_type
211: FROM IGS_FI_F_CAT_FEE_LBL ftfl
212: WHERE ftfl.fee_type = p_fee_type AND
213: ftfl.fee_cal_type = p_fee_cal_type AND
214: ftfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
215: ftfl.fee_cat = p_fee_cat;

Line 223: v_ftci_scmt IGS_FI_F_CAT_FEE_LBL.s_chg_method_type%TYPE;

219: WHERE ft.fee_type = p_fee_type;
220: cst_flatrate CONSTANT VARCHAR2(10) := 'FLATRATE';
221: cst_hecs CONSTANT VARCHAR2(10) := 'HECS';
222: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
223: v_ftci_scmt IGS_FI_F_CAT_FEE_LBL.s_chg_method_type%TYPE;
224: v_ftfl_scmt IGS_FI_F_CAT_FEE_LBL.s_chg_method_type%TYPE;
225: BEGIN
226: --- Set the default message number
227: p_message_name := Null;

Line 224: v_ftfl_scmt IGS_FI_F_CAT_FEE_LBL.s_chg_method_type%TYPE;

220: cst_flatrate CONSTANT VARCHAR2(10) := 'FLATRATE';
221: cst_hecs CONSTANT VARCHAR2(10) := 'HECS';
222: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
223: v_ftci_scmt IGS_FI_F_CAT_FEE_LBL.s_chg_method_type%TYPE;
224: v_ftfl_scmt IGS_FI_F_CAT_FEE_LBL.s_chg_method_type%TYPE;
225: BEGIN
226: --- Set the default message number
227: p_message_name := Null;
228: -- 1. check parameters

Line 254: -- 3.if p_fee_cat is not null, master record must be a IGS_FI_F_CAT_FEE_LBL

250: END IF;
251: END IF;
252: CLOSE c_ftci;
253: END IF;
254: -- 3.if p_fee_cat is not null, master record must be a IGS_FI_F_CAT_FEE_LBL
255: -- record
256: IF p_fee_cat IS NOT NULL THEN
257: OPEN c_ftfl;
258: FETCH c_ftfl INTO v_ftfl_scmt;