[Home] [Help]
121:
122: FUNCTION validate_ftci(p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
123: p_n_fee_ci_sequence_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
124: p_c_fee_type IN igs_fi_f_typ_ca_inst.fee_type%TYPE,
125: p_c_transaction_type IN igs_lookup_values.lookup_code%TYPE) RETURN BOOLEAN AS
126: /***********************************************************************************************
127:
128: Created By: Amit Gairola
129:
149: CURSOR cur_ftci(cp_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
150: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
151: cp_c_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
152: cp_c_status VARCHAR2,
153: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
154: SELECT 'x'
155: FROM igs_fi_f_typ_ca_inst ftci,
156: igs_fi_fee_str_stat fsst
157: WHERE ftci.fee_cal_type = cp_c_fee_cal_type
185: END validate_ftci;
186:
187: FUNCTION validate_fcfl(p_c_fee_cat IN igs_fi_f_cat_fee_lbl.fee_cat%TYPE,
188: p_c_fee_type IN igs_fi_f_cat_fee_lbl.fee_type%TYPE,
189: p_c_transaction_type IN igs_lookup_values.lookup_code%TYPE) RETURN BOOLEAN AS
190:
191: /***********************************************************************************************
192:
193: Created By: Amit Gairola
213: -- Cursor for validating the Fee Category Fee Liability
214: CURSOR cur_fcfl(cp_c_fee_cat igs_fi_f_cat_fee_lbl.fee_cat%TYPE,
215: cp_c_fee_type igs_fi_f_cat_fee_lbl.fee_type%TYPE,
216: cp_c_status VARCHAR2,
217: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
218: SELECT 'x'
219: FROM igs_fi_f_cat_fee_lbl fcfl,
220: igs_fi_fee_str_stat fsst
221: WHERE fcfl.fee_cat = cp_c_fee_cat