APPS.IGS_FI_VAL_FCFL dependencies on IGS_FI_FEE_TYPE

Line 94: v_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE;

90: RETURN BOOLEAN AS
91: gv_other_detail VARCHAR2(255);
92: BEGIN
93: DECLARE
94: v_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE;
95: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
96: v_s_chg_method_type IGS_FI_F_TYP_CA_INST.s_chg_method_type%TYPE;
97: v_rul_sequence_number IGS_FI_F_TYP_CA_INST.rul_sequence_number%TYPE;
98: cst_fee_trigger_cat CONSTANT VARCHAR2(9):= 'INSTITUTN';

Line 95: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

91: gv_other_detail VARCHAR2(255);
92: BEGIN
93: DECLARE
94: v_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE;
95: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
96: v_s_chg_method_type IGS_FI_F_TYP_CA_INST.s_chg_method_type%TYPE;
97: v_rul_sequence_number IGS_FI_F_TYP_CA_INST.rul_sequence_number%TYPE;
98: cst_fee_trigger_cat CONSTANT VARCHAR2(9):= 'INSTITUTN';
99: cst_fee_type CONSTANT VARCHAR2(4):= 'HECS';

Line 103: FROM IGS_FI_FEE_TYPE ft

99: cst_fee_type CONSTANT VARCHAR2(4):= 'HECS';
100: CURSOR c_ft IS
101: SELECT ft.s_fee_type,
102: ft.s_fee_trigger_cat
103: FROM IGS_FI_FEE_TYPE ft
104: WHERE ft.fee_type = p_fee_type;
105: CURSOR c_ftci IS
106: SELECT ftci.s_chg_method_type,
107: ftci.rul_sequence_number

Line 126: --IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN' or s_fee_type =

122: END IF;
123: --2. If p_chg_method is not null or p_rule_sequence is not
124: --null then validate the fee_type to see if it is permissable
125: --for these values to be specified. Not permissable when
126: --IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN' or s_fee_type =
127: --'HECS'.
128: OPEN c_ft;
129: FETCH c_ft INTO v_fee_type,
130: v_s_fee_trigger_cat;

Line 279: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

275: -- Validate insert of FCFL does not clash currency with FTCI definitions
276: FUNCTION finp_val_fcfl_cur(
277: p_fee_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
278: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
279: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
280: p_fee_cat IN IGS_FI_FEE_CAT_ALL.fee_cat%TYPE ,
281: p_message_name OUT NOCOPY VARCHAR2 )
282: RETURN BOOLEAN AS
283: /*----------------------------------------------------------------------------