[Home] [Help]
6: --
7:
8: FUNCTION test(p_event_name in varchar2) return varchar2 IS
9: BEGIN
10: return(wf_event.test(p_event_name => p_event_name));
11: END test;
12:
13: PROCEDURE raise(p_event_name in varchar2,
14: p_event_key in varchar2,
58: l_param_list WF_PARAMETER_LIST_T := wf_parameter_list_t();
59: BEGIN
60:
61: if (p_parameter_name1 is not null) then
62: wf_event.AddParameterToList(
63: p_name => p_parameter_name1,
64: p_value => p_parameter_value1,
65: p_parameterlist => l_param_list);
66: end if;
65: p_parameterlist => l_param_list);
66: end if;
67:
68: if (p_parameter_name2 is not null) then
69: wf_event.AddParameterToList(
70: p_name => p_parameter_name2,
71: p_value => p_parameter_value2,
72: p_parameterlist => l_param_list);
73: end if;
72: p_parameterlist => l_param_list);
73: end if;
74:
75: if (p_parameter_name3 is not null) then
76: wf_event.AddParameterToList(
77: p_name => p_parameter_name3,
78: p_value => p_parameter_value3,
79: p_parameterlist => l_param_list);
80: end if;
79: p_parameterlist => l_param_list);
80: end if;
81:
82: if (p_parameter_name4 is not null) then
83: wf_event.AddParameterToList(
84: p_name => p_parameter_name4,
85: p_value => p_parameter_value4,
86: p_parameterlist => l_param_list);
87: end if;
86: p_parameterlist => l_param_list);
87: end if;
88:
89: if (p_parameter_name5 is not null) then
90: wf_event.AddParameterToList(
91: p_name => p_parameter_name5,
92: p_value => p_parameter_value5,
93: p_parameterlist => l_param_list);
94: end if;
93: p_parameterlist => l_param_list);
94: end if;
95:
96: if (p_parameter_name6 is not null) then
97: wf_event.AddParameterToList(
98: p_name => p_parameter_name6,
99: p_value => p_parameter_value6,
100: p_parameterlist => l_param_list);
101: end if;
100: p_parameterlist => l_param_list);
101: end if;
102:
103: if (p_parameter_name7 is not null) then
104: wf_event.AddParameterToList(
105: p_name => p_parameter_name7,
106: p_value => p_parameter_value7,
107: p_parameterlist => l_param_list);
108: end if;
107: p_parameterlist => l_param_list);
108: end if;
109:
110: if (p_parameter_name8 is not null) then
111: wf_event.AddParameterToList(
112: p_name => p_parameter_name8,
113: p_value => p_parameter_value8,
114: p_parameterlist => l_param_list);
115: end if;
114: p_parameterlist => l_param_list);
115: end if;
116:
117: if (p_parameter_name9 is not null) then
118: wf_event.AddParameterToList(
119: p_name => p_parameter_name9,
120: p_value => p_parameter_value9,
121: p_parameterlist => l_param_list);
122: end if;
121: p_parameterlist => l_param_list);
122: end if;
123:
124: if (p_parameter_name10 is not null) then
125: wf_event.AddParameterToList(
126: p_name => p_parameter_name10,
127: p_value => p_parameter_value10,
128: p_parameterlist => l_param_list);
129: end if;
128: p_parameterlist => l_param_list);
129: end if;
130:
131: if (p_parameter_name11 is not null) then
132: wf_event.AddParameterToList(
133: p_name => p_parameter_name11,
134: p_value => p_parameter_value11,
135: p_parameterlist => l_param_list);
136: end if;
135: p_parameterlist => l_param_list);
136: end if;
137:
138: if (p_parameter_name12 is not null) then
139: wf_event.AddParameterToList(
140: p_name => p_parameter_name12,
141: p_value => p_parameter_value12,
142: p_parameterlist => l_param_list);
143: end if;
142: p_parameterlist => l_param_list);
143: end if;
144:
145: if (p_parameter_name13 is not null) then
146: wf_event.AddParameterToList(
147: p_name => p_parameter_name13,
148: p_value => p_parameter_value13,
149: p_parameterlist => l_param_list);
150: end if;
149: p_parameterlist => l_param_list);
150: end if;
151:
152: if (p_parameter_name14 is not null) then
153: wf_event.AddParameterToList(
154: p_name => p_parameter_name14,
155: p_value => p_parameter_value14,
156: p_parameterlist => l_param_list);
157: end if;
156: p_parameterlist => l_param_list);
157: end if;
158:
159: if (p_parameter_name15 is not null) then
160: wf_event.AddParameterToList(
161: p_name => p_parameter_name15,
162: p_value => p_parameter_value15,
163: p_parameterlist => l_param_list);
164: end if;
163: p_parameterlist => l_param_list);
164: end if;
165:
166: if (p_parameter_name16 is not null) then
167: wf_event.AddParameterToList(
168: p_name => p_parameter_name16,
169: p_value => p_parameter_value16,
170: p_parameterlist => l_param_list);
171: end if;
170: p_parameterlist => l_param_list);
171: end if;
172:
173: if (p_parameter_name17 is not null) then
174: wf_event.AddParameterToList(
175: p_name => p_parameter_name17,
176: p_value => p_parameter_value17,
177: p_parameterlist => l_param_list);
178: end if;
177: p_parameterlist => l_param_list);
178: end if;
179:
180: if (p_parameter_name18 is not null) then
181: wf_event.AddParameterToList(
182: p_name => p_parameter_name18,
183: p_value => p_parameter_value18,
184: p_parameterlist => l_param_list);
185: end if;
184: p_parameterlist => l_param_list);
185: end if;
186:
187: if (p_parameter_name19 is not null) then
188: wf_event.AddParameterToList(
189: p_name => p_parameter_name19,
190: p_value => p_parameter_value19,
191: p_parameterlist => l_param_list);
192: end if;
191: p_parameterlist => l_param_list);
192: end if;
193:
194: if (p_parameter_name20 is not null) then
195: wf_event.AddParameterToList(
196: p_name => p_parameter_name20,
197: p_value => p_parameter_value20,
198: p_parameterlist => l_param_list);
199: end if;
197: p_value => p_parameter_value20,
198: p_parameterlist => l_param_list);
199: end if;
200:
201: wf_event.raise(p_event_name => p_event_name,
202: p_event_key => p_event_key,
203: p_event_data => p_event_data,
204: p_parameters => l_param_list,
205: p_send_date => p_send_date);