APPS.IGS_FI_VAL_ER dependencies on IGS_FI_FEE_TYPE

Line 200: -- If s_chg_method_type = 'FLATRATE' or IGS_FI_FEE_TYPE.s_fee_type = 'HECS', then

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
204: SELECT ftci.s_chg_method_type

Line 218: FROM IGS_FI_FEE_TYPE ft

214: ftfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
215: ftfl.fee_cat = p_fee_cat;
216: CURSOR c_ft IS
217: SELECT ft.s_fee_type
218: FROM IGS_FI_FEE_TYPE ft
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;

Line 222: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;

218: FROM IGS_FI_FEE_TYPE ft
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

Line 369: -- validate IGS_FI_ELM_RANGE.fee_type. If IGS_FI_FEE_TYPE.s_fee_trigger_cat equals

365: p_message_name OUT NOCOPY VARCHAR2 )
366: RETURN BOOLEAN AS
367: gv_other_detail VARCHAR2(255);
368: BEGIN -- finp_val_er_ins
369: -- validate IGS_FI_ELM_RANGE.fee_type. If IGS_FI_FEE_TYPE.s_fee_trigger_cat equals
370: -- 'INSTITUTN', then apportionments can only be defined against
371: -- IGS_FI_F_TYP_CA_INSTs
372: DECLARE
373: CURSOR c_ft IS

Line 376: FROM IGS_FI_FEE_TYPE

372: DECLARE
373: CURSOR c_ft IS
374: SELECT s_fee_trigger_cat,
375: s_fee_type
376: FROM IGS_FI_FEE_TYPE
377: WHERE fee_type = p_fee_type;
378: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
379: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
380: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';

Line 378: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

374: SELECT s_fee_trigger_cat,
375: s_fee_type
376: FROM IGS_FI_FEE_TYPE
377: WHERE fee_type = p_fee_type;
378: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
379: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
380: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
381: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
382: BEGIN

Line 379: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;

375: s_fee_type
376: FROM IGS_FI_FEE_TYPE
377: WHERE fee_type = p_fee_type;
378: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
379: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
380: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
381: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
382: BEGIN
383: --- Set the default message number

Line 380: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';

376: FROM IGS_FI_FEE_TYPE
377: WHERE fee_type = p_fee_type;
378: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
379: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
380: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
381: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
382: BEGIN
383: --- Set the default message number
384: p_message_name := Null;

Line 381: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';

377: WHERE fee_type = p_fee_type;
378: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
379: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
380: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
381: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
382: BEGIN
383: --- Set the default message number
384: p_message_name := Null;
385: IF p_fee_type IS NULL THEN