787: /*
788: get the called rule number using called rule name
789: */
790: FUNCTION get_called_rule (
791: p_called_rule_cd IGS_RU_CALL_RULE.called_rule_cd%TYPE
792: ) RETURN NUMBER IS
793: BEGIN
794: DECLARE
795: v_rule_number IGS_RU_RULE.sequence_number%TYPE;
795: v_rule_number IGS_RU_RULE.sequence_number%TYPE;
796: BEGIN
797: SELECT nr_rul_sequence_number
798: INTO v_rule_number
799: FROM IGS_RU_CALL_RULE
800: WHERE called_rule_cd = p_called_rule_cd;
801: RETURN v_rule_number;
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN