39: return FALSE if description is NULL and error
40:
41: */
42: FUNCTION breakdown_desc (
43: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
44: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
45: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
46: RETURN BOOLEAN IS
47: BEGIN DECLARE
40:
41: */
42: FUNCTION breakdown_desc (
43: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
44: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
45: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
46: RETURN BOOLEAN IS
47: BEGIN DECLARE
48: v_hash NUMBER;
41: */
42: FUNCTION breakdown_desc (
43: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
44: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
45: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
46: RETURN BOOLEAN IS
47: BEGIN DECLARE
48: v_hash NUMBER;
49: BEGIN
92: validate and save parameter order/type/number of new IGS_RU_RULE description
93:
94: */
95: FUNCTION validate_desc (
96: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE )
97: RETURN BOOLEAN IS
98: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
99: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
100: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
94: */
95: FUNCTION validate_desc (
96: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE )
97: RETURN BOOLEAN IS
98: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
99: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
100: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
101: BEGIN
102: gv_params := 0;
95: FUNCTION validate_desc (
96: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE )
97: RETURN BOOLEAN IS
98: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
99: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
100: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
101: BEGIN
102: gv_params := 0;
103: v_rule_description := p_rule_description;
120: validate parameter order and number (old vs new)
121:
122: */
123: FUNCTION validate_params (
124: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE,
125: p_message_name OUT NOCOPY VARCHAR2 )
126: RETURN BOOLEAN IS
127: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
128: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
123: FUNCTION validate_params (
124: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE,
125: p_message_name OUT NOCOPY VARCHAR2 )
126: RETURN BOOLEAN IS
127: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
128: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
129: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
130: v_params NUMBER;
131: BEGIN
124: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE,
125: p_message_name OUT NOCOPY VARCHAR2 )
126: RETURN BOOLEAN IS
127: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
128: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;
129: v_action IGS_RU_RET_TYPE.s_return_type%TYPE;
130: v_params NUMBER;
131: BEGIN
132: v_params := 0;
214: IF v_turing_count > 0 OR
215: v_nr_count > 0
216: THEN
217: /*
218: IGS_RU_DESCRIPTION has been used
219: no change to return type
220: */
221: IF p_old_return_type <> p_new_return_type
222: THEN