[Home] [Help]
27:
28: /* Who When What
29: vivuyyur 10-sep-2001 Bug No :1966961
30: PROCEDURE finp_val_ftci_ac is changed */
31: -- Validate the IGS_FI_ACC has the correct calendar relations.
32: FUNCTION finp_val_ftci_ac(
33: p_fee_cal_type IN VARCHAR2 ,
34: p_fee_ci_sequence_number IN NUMBER ,
35: p_message_name OUT NOCOPY VARCHAR2 )
36: RETURN BOOLEAN AS
37: gv_other_detail VARCHAR2(255);
38: BEGIN -- finp_val_ftci_account
39: -- Validate the IGS_FI_F_TYP_CA_INST calendar instance
40: -- is a subordinate of the IGS_FI_ACC finace calendar instance.
41: DECLARE
42: v_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE;
43: CURSOR c_cir IS
44: SELECT sub_cal_type
54: p_fee_ci_sequence_number IS NULL) THEN
55: RETURN TRUE;
56: END IF;
57: -- Check if the IGS_FI_F_TYP_CA_INST fee calendar
58: -- is a subordinate of the IGS_FI_ACC finace calendar.
59: OPEN c_cir;
60: FETCH c_cir INTO v_sub_cal_type;
61: IF (c_cir%FOUND) THEN
62: CLOSE c_cir;
349: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
351: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
352: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE;
353: v_acc_closed_ind IGS_FI_ACC.closed_ind%TYPE;
354: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
355: v_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;
356: CURSOR c_fss (
357: cp_fee_type_ci_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS