DBA Data[Home] [Help]

APPS.IGS_RU_VAL_RUD dependencies on IGS_RU_DESCRIPTION

Line 43: p_string IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,

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

Line 44: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,

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;

Line 45: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )

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

Line 96: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE )

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;

Line 98: v_rule_description IGS_RU_DESCRIPTION.rule_description%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;

Line 99: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;

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;

Line 124: p_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE,

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;

Line 127: v_rule_description 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

Line 128: v_string IGS_RU_DESCRIPTION.rule_description%TYPE;

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;

Line 218: IGS_RU_DESCRIPTION has been used

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