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