DBA Data[Home] [Help]

PACKAGE BODY: APPS.OTA_DELEGATE_BOOKING_BE2

Source


1 package body ota_delegate_booking_be2 as 
2 --Code generated on 30/03/2009 04:39:25
3 /* $Header: hrapiwfe.pkb 120.4.12010000.2 2008/09/29 12:54:07 srgnanas ship $*/
4 procedure update_delegate_booking_a (
5 p_effective_date               date,
6 p_booking_id                   number,
7 p_booking_status_type_id       number,
8 p_delegate_person_id           number,
9 p_contact_id                   number,
10 p_business_group_id            number,
11 p_event_id                     number,
12 p_customer_id                  number,
13 p_authorizer_person_id         number,
14 p_date_booking_placed          date,
15 p_corespondent                 varchar2,
16 p_internal_booking_flag        varchar2,
17 p_number_of_places             number,
18 p_object_version_number        number,
19 p_administrator                number,
20 p_booking_priority             varchar2,
21 p_comments                     varchar2,
22 p_contact_address_id           number,
23 p_delegate_contact_phone       varchar2,
24 p_delegate_contact_fax         varchar2,
25 p_third_party_customer_id      number,
26 p_third_party_contact_id       number,
27 p_third_party_address_id       number,
28 p_third_party_contact_phone    varchar2,
29 p_third_party_contact_fax      varchar2,
30 p_date_status_changed          date,
31 p_status_change_comments       varchar2,
32 p_failure_reason               varchar2,
33 p_attendance_result            varchar2,
34 p_language_id                  number,
35 p_source_of_booking            varchar2,
36 p_special_booking_instructions varchar2,
37 p_successful_attendance_flag   varchar2,
38 p_tdb_information_category     varchar2,
39 p_tdb_information1             varchar2,
40 p_tdb_information2             varchar2,
41 p_tdb_information3             varchar2,
42 p_tdb_information4             varchar2,
43 p_tdb_information5             varchar2,
44 p_tdb_information6             varchar2,
45 p_tdb_information7             varchar2,
46 p_tdb_information8             varchar2,
47 p_tdb_information9             varchar2,
48 p_tdb_information10            varchar2,
49 p_tdb_information11            varchar2,
50 p_tdb_information12            varchar2,
51 p_tdb_information13            varchar2,
52 p_tdb_information14            varchar2,
53 p_tdb_information15            varchar2,
54 p_tdb_information16            varchar2,
55 p_tdb_information17            varchar2,
56 p_tdb_information18            varchar2,
57 p_tdb_information19            varchar2,
58 p_tdb_information20            varchar2,
59 p_update_finance_line          varchar2,
60 p_tfl_object_version_number    number,
61 p_finance_header_id            number,
62 p_currency_code                varchar2,
63 p_standard_amount              number,
64 p_unitary_amount               number,
65 p_money_amount                 number,
66 p_booking_deal_id              number,
67 p_booking_deal_type            varchar2,
68 p_finance_line_id              number,
69 p_enrollment_type              varchar2,
70 p_organization_id              number,
71 p_sponsor_person_id            number,
72 p_sponsor_assignment_id        number,
73 p_person_address_id            number,
74 p_delegate_assignment_id       number,
75 p_delegate_contact_id          number,
76 p_delegate_contact_email       varchar2,
77 p_third_party_email            varchar2,
78 p_person_address_type          varchar2,
79 p_line_id                      number,
80 p_org_id                       number,
81 p_daemon_flag                  varchar2,
82 p_daemon_type                  varchar2,
83 p_old_event_id                 number,
84 p_quote_line_id                number,
85 p_interface_source             varchar2,
86 p_total_training_time          varchar2,
87 p_content_player_status        varchar2,
88 p_score                        number,
89 p_completed_content            number,
90 p_total_content                number,
91 p_booking_justification_id     number,
92 p_is_history_flag              varchar2) is
93   l_event_key number;
94   l_event_data clob;
95   l_event_name varchar2(250);
96   l_text varchar2(2000);
97   l_message varchar2(10);
98   --
99   cursor get_seq is
100   select per_wf_events_s.nextval from dual;
101   --
102   l_proc varchar2(72):='  ota_delegate_booking_be2.update_delegate_booking_a';
103 begin
104   hr_utility.set_location('Entering: '||l_proc,10);
105   -- check the status of the business event
106   l_event_name:='oracle.apps.ota.api.delegate_booking.update_delegate_booking';
107   l_message:=wf_event.test(l_event_name);
108   --
109   if (l_message='MESSAGE') then
110     hr_utility.set_location(l_proc,20);
111     --
112     -- get a key for the event
113     --
114     open get_seq;
115     fetch get_seq into l_event_key;
116     close get_seq;
117     --
118     -- build the xml data for the event
119     --
120     dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
121     l_text:='<?xml version =''1.0'' encoding =''ASCII''?>';
122     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123     l_text:='<delegate_booking>';
124     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125     --
126     l_text:='<effective_date>';
127     l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
128     l_text:=l_text||'</effective_date>';
129     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
130     l_text:='<booking_id>';
131     l_text:=l_text||fnd_number.number_to_canonical(p_booking_id);
132     l_text:=l_text||'</booking_id>';
133     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134     l_text:='<booking_status_type_id>';
135     l_text:=l_text||fnd_number.number_to_canonical(p_booking_status_type_id);
136     l_text:=l_text||'</booking_status_type_id>';
137     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138     l_text:='<delegate_person_id>';
139     l_text:=l_text||fnd_number.number_to_canonical(p_delegate_person_id);
140     l_text:=l_text||'</delegate_person_id>';
141     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142     l_text:='<contact_id>';
143     l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);
144     l_text:=l_text||'</contact_id>';
145     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146     l_text:='<business_group_id>';
147     l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
148     l_text:=l_text||'</business_group_id>';
149     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
150     l_text:='<event_id>';
151     l_text:=l_text||fnd_number.number_to_canonical(p_event_id);
152     l_text:=l_text||'</event_id>';
153     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
154     l_text:='<customer_id>';
155     l_text:=l_text||fnd_number.number_to_canonical(p_customer_id);
156     l_text:=l_text||'</customer_id>';
157     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
158     l_text:='<authorizer_person_id>';
159     l_text:=l_text||fnd_number.number_to_canonical(p_authorizer_person_id);
160     l_text:=l_text||'</authorizer_person_id>';
161     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
162     l_text:='<date_booking_placed>';
163     l_text:=l_text||fnd_date.date_to_canonical(p_date_booking_placed);
164     l_text:=l_text||'</date_booking_placed>';
165     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
166     l_text:='<corespondent>';
167     l_text:=l_text||irc_utilities_pkg.removeTags(p_corespondent);
168     l_text:=l_text||'</corespondent>';
169     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170     l_text:='<internal_booking_flag>';
171     l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_booking_flag);
172     l_text:=l_text||'</internal_booking_flag>';
173     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174     l_text:='<number_of_places>';
175     l_text:=l_text||fnd_number.number_to_canonical(p_number_of_places);
176     l_text:=l_text||'</number_of_places>';
177     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178     l_text:='<object_version_number>';
179     l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
180     l_text:=l_text||'</object_version_number>';
181     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182     l_text:='<administrator>';
183     l_text:=l_text||fnd_number.number_to_canonical(p_administrator);
184     l_text:=l_text||'</administrator>';
185     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186     l_text:='<booking_priority>';
187     l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_priority);
188     l_text:=l_text||'</booking_priority>';
189     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190     l_text:='<comments>';
191     l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
192     l_text:=l_text||'</comments>';
193     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194     l_text:='<contact_address_id>';
195     l_text:=l_text||fnd_number.number_to_canonical(p_contact_address_id);
196     l_text:=l_text||'</contact_address_id>';
197     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198     l_text:='<delegate_contact_phone>';
199     l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_phone);
200     l_text:=l_text||'</delegate_contact_phone>';
201     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
202     l_text:='<delegate_contact_fax>';
203     l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_fax);
204     l_text:=l_text||'</delegate_contact_fax>';
205     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
206     l_text:='<third_party_customer_id>';
207     l_text:=l_text||fnd_number.number_to_canonical(p_third_party_customer_id);
208     l_text:=l_text||'</third_party_customer_id>';
209     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
210     l_text:='<third_party_contact_id>';
211     l_text:=l_text||fnd_number.number_to_canonical(p_third_party_contact_id);
212     l_text:=l_text||'</third_party_contact_id>';
213     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214     l_text:='<third_party_address_id>';
215     l_text:=l_text||fnd_number.number_to_canonical(p_third_party_address_id);
216     l_text:=l_text||'</third_party_address_id>';
217     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
218     l_text:='<third_party_contact_phone>';
219     l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_phone);
220     l_text:=l_text||'</third_party_contact_phone>';
221     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
222     l_text:='<third_party_contact_fax>';
223     l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_fax);
224     l_text:=l_text||'</third_party_contact_fax>';
225     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
226     l_text:='<date_status_changed>';
227     l_text:=l_text||fnd_date.date_to_canonical(p_date_status_changed);
228     l_text:=l_text||'</date_status_changed>';
229     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230     l_text:='<status_change_comments>';
231     l_text:=l_text||irc_utilities_pkg.removeTags(p_status_change_comments);
232     l_text:=l_text||'</status_change_comments>';
233     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234     l_text:='<failure_reason>';
235     l_text:=l_text||irc_utilities_pkg.removeTags(p_failure_reason);
236     l_text:=l_text||'</failure_reason>';
237     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238     l_text:='<attendance_result>';
239     l_text:=l_text||irc_utilities_pkg.removeTags(p_attendance_result);
240     l_text:=l_text||'</attendance_result>';
241     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
242     l_text:='<language_id>';
243     l_text:=l_text||fnd_number.number_to_canonical(p_language_id);
244     l_text:=l_text||'</language_id>';
245     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
246     l_text:='<source_of_booking>';
247     l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_booking);
248     l_text:=l_text||'</source_of_booking>';
249     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
250     l_text:='<special_booking_instructions>';
251     l_text:=l_text||irc_utilities_pkg.removeTags(p_special_booking_instructions);
252     l_text:=l_text||'</special_booking_instructions>';
253     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
254     l_text:='<successful_attendance_flag>';
255     l_text:=l_text||irc_utilities_pkg.removeTags(p_successful_attendance_flag);
256     l_text:=l_text||'</successful_attendance_flag>';
257     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
258     l_text:='<tdb_information_category>';
259     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information_category);
260     l_text:=l_text||'</tdb_information_category>';
261     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
262     l_text:='<tdb_information1>';
263     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information1);
264     l_text:=l_text||'</tdb_information1>';
265     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
266     l_text:='<tdb_information2>';
267     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information2);
268     l_text:=l_text||'</tdb_information2>';
269     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
270     l_text:='<tdb_information3>';
271     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information3);
272     l_text:=l_text||'</tdb_information3>';
273     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
274     l_text:='<tdb_information4>';
275     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information4);
276     l_text:=l_text||'</tdb_information4>';
277     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
278     l_text:='<tdb_information5>';
279     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information5);
280     l_text:=l_text||'</tdb_information5>';
281     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
282     l_text:='<tdb_information6>';
283     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information6);
284     l_text:=l_text||'</tdb_information6>';
285     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
286     l_text:='<tdb_information7>';
287     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information7);
288     l_text:=l_text||'</tdb_information7>';
289     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
290     l_text:='<tdb_information8>';
291     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information8);
292     l_text:=l_text||'</tdb_information8>';
293     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
294     l_text:='<tdb_information9>';
295     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information9);
296     l_text:=l_text||'</tdb_information9>';
297     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
298     l_text:='<tdb_information10>';
299     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information10);
300     l_text:=l_text||'</tdb_information10>';
301     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
302     l_text:='<tdb_information11>';
303     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information11);
304     l_text:=l_text||'</tdb_information11>';
305     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
306     l_text:='<tdb_information12>';
307     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information12);
308     l_text:=l_text||'</tdb_information12>';
309     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
310     l_text:='<tdb_information13>';
311     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information13);
312     l_text:=l_text||'</tdb_information13>';
313     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
314     l_text:='<tdb_information14>';
315     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information14);
316     l_text:=l_text||'</tdb_information14>';
317     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
318     l_text:='<tdb_information15>';
319     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information15);
320     l_text:=l_text||'</tdb_information15>';
321     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
322     l_text:='<tdb_information16>';
323     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information16);
324     l_text:=l_text||'</tdb_information16>';
325     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
326     l_text:='<tdb_information17>';
327     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information17);
328     l_text:=l_text||'</tdb_information17>';
329     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
330     l_text:='<tdb_information18>';
331     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information18);
332     l_text:=l_text||'</tdb_information18>';
333     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
334     l_text:='<tdb_information19>';
335     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information19);
336     l_text:=l_text||'</tdb_information19>';
337     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
338     l_text:='<tdb_information20>';
339     l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information20);
340     l_text:=l_text||'</tdb_information20>';
341     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
342     l_text:='<update_finance_line>';
343     l_text:=l_text||irc_utilities_pkg.removeTags(p_update_finance_line);
344     l_text:=l_text||'</update_finance_line>';
345     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
346     l_text:='<tfl_object_version_number>';
347     l_text:=l_text||fnd_number.number_to_canonical(p_tfl_object_version_number);
348     l_text:=l_text||'</tfl_object_version_number>';
349     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
350     l_text:='<finance_header_id>';
351     l_text:=l_text||fnd_number.number_to_canonical(p_finance_header_id);
352     l_text:=l_text||'</finance_header_id>';
353     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
354     l_text:='<currency_code>';
355     l_text:=l_text||irc_utilities_pkg.removeTags(p_currency_code);
356     l_text:=l_text||'</currency_code>';
357     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
358     l_text:='<standard_amount>';
359     l_text:=l_text||fnd_number.number_to_canonical(p_standard_amount);
360     l_text:=l_text||'</standard_amount>';
361     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
362     l_text:='<unitary_amount>';
363     l_text:=l_text||fnd_number.number_to_canonical(p_unitary_amount);
364     l_text:=l_text||'</unitary_amount>';
365     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
366     l_text:='<money_amount>';
367     l_text:=l_text||fnd_number.number_to_canonical(p_money_amount);
368     l_text:=l_text||'</money_amount>';
369     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
370     l_text:='<booking_deal_id>';
371     l_text:=l_text||fnd_number.number_to_canonical(p_booking_deal_id);
372     l_text:=l_text||'</booking_deal_id>';
373     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
374     l_text:='<booking_deal_type>';
375     l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_deal_type);
376     l_text:=l_text||'</booking_deal_type>';
377     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
378     l_text:='<finance_line_id>';
379     l_text:=l_text||fnd_number.number_to_canonical(p_finance_line_id);
380     l_text:=l_text||'</finance_line_id>';
381     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
382     l_text:='<enrollment_type>';
383     l_text:=l_text||irc_utilities_pkg.removeTags(p_enrollment_type);
384     l_text:=l_text||'</enrollment_type>';
385     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
386     l_text:='<organization_id>';
387     l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
388     l_text:=l_text||'</organization_id>';
389     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
390     l_text:='<sponsor_person_id>';
391     l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_person_id);
392     l_text:=l_text||'</sponsor_person_id>';
393     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
394     l_text:='<sponsor_assignment_id>';
395     l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_assignment_id);
396     l_text:=l_text||'</sponsor_assignment_id>';
397     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
398     l_text:='<person_address_id>';
399     l_text:=l_text||fnd_number.number_to_canonical(p_person_address_id);
400     l_text:=l_text||'</person_address_id>';
401     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
402     l_text:='<delegate_assignment_id>';
403     l_text:=l_text||fnd_number.number_to_canonical(p_delegate_assignment_id);
404     l_text:=l_text||'</delegate_assignment_id>';
405     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
406     l_text:='<delegate_contact_id>';
407     l_text:=l_text||fnd_number.number_to_canonical(p_delegate_contact_id);
408     l_text:=l_text||'</delegate_contact_id>';
409     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
410     l_text:='<delegate_contact_email>';
411     l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_email);
412     l_text:=l_text||'</delegate_contact_email>';
413     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
414     l_text:='<third_party_email>';
415     l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_email);
416     l_text:=l_text||'</third_party_email>';
417     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
418     l_text:='<person_address_type>';
419     l_text:=l_text||irc_utilities_pkg.removeTags(p_person_address_type);
420     l_text:=l_text||'</person_address_type>';
421     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
422     l_text:='<line_id>';
423     l_text:=l_text||fnd_number.number_to_canonical(p_line_id);
424     l_text:=l_text||'</line_id>';
425     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
426     l_text:='<org_id>';
427     l_text:=l_text||fnd_number.number_to_canonical(p_org_id);
428     l_text:=l_text||'</org_id>';
429     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
430     l_text:='<daemon_flag>';
431     l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_flag);
432     l_text:=l_text||'</daemon_flag>';
433     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
434     l_text:='<daemon_type>';
435     l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_type);
436     l_text:=l_text||'</daemon_type>';
437     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
438     l_text:='<old_event_id>';
439     l_text:=l_text||fnd_number.number_to_canonical(p_old_event_id);
440     l_text:=l_text||'</old_event_id>';
441     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
442     l_text:='<quote_line_id>';
443     l_text:=l_text||fnd_number.number_to_canonical(p_quote_line_id);
444     l_text:=l_text||'</quote_line_id>';
445     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
446     l_text:='<interface_source>';
447     l_text:=l_text||irc_utilities_pkg.removeTags(p_interface_source);
448     l_text:=l_text||'</interface_source>';
449     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
450     l_text:='<total_training_time>';
451     l_text:=l_text||irc_utilities_pkg.removeTags(p_total_training_time);
452     l_text:=l_text||'</total_training_time>';
453     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
454     l_text:='<content_player_status>';
455     l_text:=l_text||irc_utilities_pkg.removeTags(p_content_player_status);
456     l_text:=l_text||'</content_player_status>';
457     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
458     l_text:='<score>';
459     l_text:=l_text||fnd_number.number_to_canonical(p_score);
460     l_text:=l_text||'</score>';
461     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
462     l_text:='<completed_content>';
463     l_text:=l_text||fnd_number.number_to_canonical(p_completed_content);
464     l_text:=l_text||'</completed_content>';
465     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
466     l_text:='<total_content>';
467     l_text:=l_text||fnd_number.number_to_canonical(p_total_content);
468     l_text:=l_text||'</total_content>';
469     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
470     l_text:='<booking_justification_id>';
471     l_text:=l_text||fnd_number.number_to_canonical(p_booking_justification_id);
472     l_text:=l_text||'</booking_justification_id>';
473     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
474     l_text:='<is_history_flag>';
475     l_text:=l_text||irc_utilities_pkg.removeTags(p_is_history_flag);
476     l_text:=l_text||'</is_history_flag>';
477     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
478     l_text:='</delegate_booking>';
479     --
480     dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
481     --
482     -- raise the event with the event data
483     wf_event.raise(p_event_name=>l_event_name
484                   ,p_event_key=>l_event_key
485                   ,p_event_data=>l_event_data);
486   elsif (l_message='KEY') then
487     hr_utility.set_location(l_proc,30);
488     -- get a key for the event
489     open get_seq;
490     fetch get_seq into l_event_key;
491     close get_seq;
492     -- this is a key event, so just raise the event
493     -- without the event data
494     wf_event.raise(p_event_name=>l_event_name
495                   ,p_event_key=>l_event_key);
496   elsif (l_message='NONE') then
497     hr_utility.set_location(l_proc,40);
498     -- no event is required, so do nothing
499     null;
500   end if;
501     hr_utility.set_location('Leaving: '||l_proc,50);
502 end update_delegate_booking_a;
503 end ota_delegate_booking_be2;