230: ******************************************************************/
231: -- Cursor for selecting the credit type Description for the Credit id passed.
232: CURSOR cur_credit_type_desc(cp_n_credit_type_id NUMBER ) IS
233: SELECT crtyp.description
234: FROM igs_fi_cr_types crtyp
235: WHERE credit_type_id = cp_n_credit_type_id;
236:
237: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
238: l_b_return_status BOOLEAN;
233: SELECT crtyp.description
234: FROM igs_fi_cr_types crtyp
235: WHERE credit_type_id = cp_n_credit_type_id;
236:
237: l_v_credit_class igs_fi_cr_types_all.credit_class%TYPE;
238: l_b_return_status BOOLEAN;
239: l_b_validation_flag BOOLEAN;
240: l_v_msg_name VARCHAR2(4000) := NULL;
241: l_n_msg_count NUMBER := 0;