APPS.IGS_FI_VAL_ER dependencies on IGS_FI_F_TYP_CA_INST

Line 198: -- Validate IGS_FI_F_TYP_CA_INST.s_chg_method_type, fee_type and

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

Line 205: FROM IGS_FI_F_TYP_CA_INST ftci

201: -- element ranges cannot be defined
202: DECLARE
203: CURSOR c_ftci IS
204: SELECT ftci.s_chg_method_type
205: FROM IGS_FI_F_TYP_CA_INST ftci
206: WHERE ftci.fee_type = p_fee_type AND
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

Line 236: -- be a IGS_FI_F_TYP_CA_INST record

232: p_message_name := Null;
233: RETURN TRUE;
234: END IF;
235: -- 2. Determine the s_chg_method_type, if p_fee_cat is null, master record must
236: -- be a IGS_FI_F_TYP_CA_INST record
237: IF p_fee_cat IS NULL THEN
238: OPEN c_ftci;
239: FETCH c_ftci INTO v_ftci_scmt;
240: IF (c_ftci%NOTFOUND) THEN

Line 371: -- IGS_FI_F_TYP_CA_INSTs

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
374: SELECT s_fee_trigger_cat,
375: s_fee_type