eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_DELEGATE_BOOKING_BE1 dependencies on FND_NUMBER

Line 129: l_text:=l_text||fnd_number.number_to_canonical(p_booking_status_type_id);

125: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_number.number_to_canonical(p_booking_status_type_id);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_person_id);

Line 133: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_person_id);

129: l_text:=l_text||fnd_number.number_to_canonical(p_booking_status_type_id);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_person_id);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);

Line 137: l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);

133: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_person_id);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';
137: l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

Line 141: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

137: l_text:=l_text||fnd_number.number_to_canonical(p_contact_id);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='';
141: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||fnd_number.number_to_canonical(p_event_id);

Line 145: l_text:=l_text||fnd_number.number_to_canonical(p_event_id);

141: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
142: l_text:=l_text||'';
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='';
145: l_text:=l_text||fnd_number.number_to_canonical(p_event_id);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='';
149: l_text:=l_text||fnd_number.number_to_canonical(p_customer_id);

Line 149: l_text:=l_text||fnd_number.number_to_canonical(p_customer_id);

145: l_text:=l_text||fnd_number.number_to_canonical(p_event_id);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='';
149: l_text:=l_text||fnd_number.number_to_canonical(p_customer_id);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||fnd_number.number_to_canonical(p_authorizer_person_id);

Line 153: l_text:=l_text||fnd_number.number_to_canonical(p_authorizer_person_id);

149: l_text:=l_text||fnd_number.number_to_canonical(p_customer_id);
150: l_text:=l_text||'';
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='';
153: l_text:=l_text||fnd_number.number_to_canonical(p_authorizer_person_id);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='';
157: l_text:=l_text||fnd_date.date_to_canonical(p_date_booking_placed);

Line 169: l_text:=l_text||fnd_number.number_to_canonical(p_number_of_places);

165: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_booking_flag);
166: l_text:=l_text||'';
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
168: l_text:='';
169: l_text:=l_text||fnd_number.number_to_canonical(p_number_of_places);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||fnd_number.number_to_canonical(p_administrator);

Line 173: l_text:=l_text||fnd_number.number_to_canonical(p_administrator);

169: l_text:=l_text||fnd_number.number_to_canonical(p_number_of_places);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='';
173: l_text:=l_text||fnd_number.number_to_canonical(p_administrator);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_priority);

Line 185: l_text:=l_text||fnd_number.number_to_canonical(p_contact_address_id);

181: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||fnd_number.number_to_canonical(p_contact_address_id);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_phone);

Line 197: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_customer_id);

193: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_fax);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='';
197: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_customer_id);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_contact_id);

Line 201: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_contact_id);

197: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_customer_id);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_contact_id);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_address_id);

Line 205: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_address_id);

201: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_contact_id);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_address_id);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_phone);

Line 229: l_text:=l_text||fnd_number.number_to_canonical(p_language_id);

225: l_text:=l_text||irc_utilities_pkg.removeTags(p_attendance_result);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||fnd_number.number_to_canonical(p_language_id);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_booking);

Line 333: l_text:=l_text||fnd_number.number_to_canonical(p_finance_header_id);

329: l_text:=l_text||irc_utilities_pkg.removeTags(p_create_finance_line);
330: l_text:=l_text||'';
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
332: l_text:='';
333: l_text:=l_text||fnd_number.number_to_canonical(p_finance_header_id);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
336: l_text:='';
337: l_text:=l_text||irc_utilities_pkg.removeTags(p_currency_code);

Line 341: l_text:=l_text||fnd_number.number_to_canonical(p_standard_amount);

337: l_text:=l_text||irc_utilities_pkg.removeTags(p_currency_code);
338: l_text:=l_text||'';
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
340: l_text:='';
341: l_text:=l_text||fnd_number.number_to_canonical(p_standard_amount);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='';
345: l_text:=l_text||fnd_number.number_to_canonical(p_unitary_amount);

Line 345: l_text:=l_text||fnd_number.number_to_canonical(p_unitary_amount);

341: l_text:=l_text||fnd_number.number_to_canonical(p_standard_amount);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='';
345: l_text:=l_text||fnd_number.number_to_canonical(p_unitary_amount);
346: l_text:=l_text||'';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: l_text:=l_text||fnd_number.number_to_canonical(p_money_amount);

Line 349: l_text:=l_text||fnd_number.number_to_canonical(p_money_amount);

345: l_text:=l_text||fnd_number.number_to_canonical(p_unitary_amount);
346: l_text:=l_text||'';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: l_text:=l_text||fnd_number.number_to_canonical(p_money_amount);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='';
353: l_text:=l_text||fnd_number.number_to_canonical(p_booking_deal_id);

Line 353: l_text:=l_text||fnd_number.number_to_canonical(p_booking_deal_id);

349: l_text:=l_text||fnd_number.number_to_canonical(p_money_amount);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='';
353: l_text:=l_text||fnd_number.number_to_canonical(p_booking_deal_id);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='';
357: l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_deal_type);

Line 361: l_text:=l_text||fnd_number.number_to_canonical(p_finance_line_id);

357: l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_deal_type);
358: l_text:=l_text||'';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='';
361: l_text:=l_text||fnd_number.number_to_canonical(p_finance_line_id);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='';
365: l_text:=l_text||irc_utilities_pkg.removeTags(p_enrollment_type);

Line 369: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

365: l_text:=l_text||irc_utilities_pkg.removeTags(p_enrollment_type);
366: l_text:=l_text||'';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='';
369: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_person_id);

Line 373: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_person_id);

369: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_person_id);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_assignment_id);

Line 377: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_assignment_id);

373: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_person_id);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_assignment_id);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||fnd_number.number_to_canonical(p_person_address_id);

Line 381: l_text:=l_text||fnd_number.number_to_canonical(p_person_address_id);

377: l_text:=l_text||fnd_number.number_to_canonical(p_sponsor_assignment_id);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||fnd_number.number_to_canonical(p_person_address_id);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='';
385: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_assignment_id);

Line 385: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_assignment_id);

381: l_text:=l_text||fnd_number.number_to_canonical(p_person_address_id);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='';
385: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_assignment_id);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_contact_id);

Line 389: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_contact_id);

385: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_assignment_id);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_contact_id);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='';
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_email);

Line 405: l_text:=l_text||fnd_number.number_to_canonical(p_line_id);

401: l_text:=l_text||irc_utilities_pkg.removeTags(p_person_address_type);
402: l_text:=l_text||'';
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='';
405: l_text:=l_text||fnd_number.number_to_canonical(p_line_id);
406: l_text:=l_text||'';
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
408: l_text:='';
409: l_text:=l_text||fnd_number.number_to_canonical(p_org_id);

Line 409: l_text:=l_text||fnd_number.number_to_canonical(p_org_id);

405: l_text:=l_text||fnd_number.number_to_canonical(p_line_id);
406: l_text:=l_text||'';
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
408: l_text:='';
409: l_text:=l_text||fnd_number.number_to_canonical(p_org_id);
410: l_text:=l_text||'';
411: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
412: l_text:='';
413: l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_flag);

Line 421: l_text:=l_text||fnd_number.number_to_canonical(p_old_event_id);

417: l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_type);
418: l_text:=l_text||'';
419: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
420: l_text:='';
421: l_text:=l_text||fnd_number.number_to_canonical(p_old_event_id);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
424: l_text:='';
425: l_text:=l_text||fnd_number.number_to_canonical(p_quote_line_id);

Line 425: l_text:=l_text||fnd_number.number_to_canonical(p_quote_line_id);

421: l_text:=l_text||fnd_number.number_to_canonical(p_old_event_id);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
424: l_text:='';
425: l_text:=l_text||fnd_number.number_to_canonical(p_quote_line_id);
426: l_text:=l_text||'';
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
428: l_text:='';
429: l_text:=l_text||irc_utilities_pkg.removeTags(p_interface_source);

Line 441: l_text:=l_text||fnd_number.number_to_canonical(p_score);

437: l_text:=l_text||irc_utilities_pkg.removeTags(p_content_player_status);
438: l_text:=l_text||'';
439: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
440: l_text:='';
441: l_text:=l_text||fnd_number.number_to_canonical(p_score);
442: l_text:=l_text||'';
443: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
444: l_text:='';
445: l_text:=l_text||fnd_number.number_to_canonical(p_completed_content);

Line 445: l_text:=l_text||fnd_number.number_to_canonical(p_completed_content);

441: l_text:=l_text||fnd_number.number_to_canonical(p_score);
442: l_text:=l_text||'';
443: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
444: l_text:='';
445: l_text:=l_text||fnd_number.number_to_canonical(p_completed_content);
446: l_text:=l_text||'';
447: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
448: l_text:='';
449: l_text:=l_text||fnd_number.number_to_canonical(p_total_content);

Line 449: l_text:=l_text||fnd_number.number_to_canonical(p_total_content);

445: l_text:=l_text||fnd_number.number_to_canonical(p_completed_content);
446: l_text:=l_text||'';
447: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
448: l_text:='';
449: l_text:=l_text||fnd_number.number_to_canonical(p_total_content);
450: l_text:=l_text||'';
451: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
452: l_text:='';
453: l_text:=l_text||fnd_number.number_to_canonical(p_booking_justification_id);

Line 453: l_text:=l_text||fnd_number.number_to_canonical(p_booking_justification_id);

449: l_text:=l_text||fnd_number.number_to_canonical(p_total_content);
450: l_text:=l_text||'';
451: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
452: l_text:='';
453: l_text:=l_text||fnd_number.number_to_canonical(p_booking_justification_id);
454: l_text:=l_text||'';
455: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
456: l_text:='';
457: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_history_flag);

Line 465: l_text:=l_text||fnd_number.number_to_canonical(p_booking_id);

461: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_mandatory_enrollment);
462: l_text:=l_text||'';
463: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
464: l_text:='';
465: l_text:=l_text||fnd_number.number_to_canonical(p_booking_id);
466: l_text:=l_text||'';
467: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
468: l_text:='';
469: --