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_EVT_UPD dependencies on OTA_EVT_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ota_evt_shd.g_rec_type) is

50: -- Internal Development Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ota_evt_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ota_evt_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ota_evt_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ota_events Row
68: --
69: update ota_events

Line 140: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

136: parent_offering_id = p_rec.parent_offering_id,
137: data_source = p_rec.data_source
138: where event_id = p_rec.event_id;
139: --
140: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: --
144: Exception

Line 147: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

143: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
148: ota_evt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated

Line 148: ota_evt_shd.constraint_error

144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
148: ota_evt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

148: ota_evt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
153: ota_evt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated

Line 153: ota_evt_shd.constraint_error

149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
153: ota_evt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

153: ota_evt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
158: ota_evt_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 158: ota_evt_shd.constraint_error

154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
158: ota_evt_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
162: Raise;

Line 161: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
158: ota_evt_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
162: Raise;
163: End update_dml;
164: --
165: -- ----------------------------------------------------------------------------

Line 197: Procedure pre_update(p_rec in ota_evt_shd.g_rec_type) is

193: -- Internal Development Use Only.
194: --
195: -- {End Of Comments}
196: -- ----------------------------------------------------------------------------
197: Procedure pre_update(p_rec in ota_evt_shd.g_rec_type) is
198: --
199: l_proc varchar2(72) := g_package||'pre_update';
200: --
201: Begin

Line 239: Procedure post_update(p_rec in ota_evt_shd.g_rec_type) is

235: -- Internal Development Use Only.
236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure post_update(p_rec in ota_evt_shd.g_rec_type) is
240: --
241: l_proc varchar2(72) := g_package||'post_update';
242: --
243: Begin

Line 300: Function convert_defs(p_rec in out nocopy ota_evt_shd.g_rec_type)

296: -- Internal Development Use Only.
297: --
298: -- {End Of Comments}
299: -- ----------------------------------------------------------------------------
300: Function convert_defs(p_rec in out nocopy ota_evt_shd.g_rec_type)
301: Return ota_evt_shd.g_rec_type is
302: --
303: l_proc varchar2(72) := g_package||'convert_defs';
304: --

Line 301: Return ota_evt_shd.g_rec_type is

297: --
298: -- {End Of Comments}
299: -- ----------------------------------------------------------------------------
300: Function convert_defs(p_rec in out nocopy ota_evt_shd.g_rec_type)
301: Return ota_evt_shd.g_rec_type is
302: --
303: l_proc varchar2(72) := g_package||'convert_defs';
304: --
305: Begin

Line 316: ota_evt_shd.g_old_rec.vendor_id;

312: -- is being used then we must set to the 'current' argument value.
313: --
314: If (p_rec.vendor_id = hr_api.g_number) then
315: p_rec.vendor_id :=
316: ota_evt_shd.g_old_rec.vendor_id;
317: End If;
318: If (p_rec.activity_version_id = hr_api.g_number) then
319: p_rec.activity_version_id :=
320: ota_evt_shd.g_old_rec.activity_version_id;

Line 320: ota_evt_shd.g_old_rec.activity_version_id;

316: ota_evt_shd.g_old_rec.vendor_id;
317: End If;
318: If (p_rec.activity_version_id = hr_api.g_number) then
319: p_rec.activity_version_id :=
320: ota_evt_shd.g_old_rec.activity_version_id;
321: End If;
322: If (p_rec.business_group_id = hr_api.g_number) then
323: p_rec.business_group_id :=
324: ota_evt_shd.g_old_rec.business_group_id;

Line 324: ota_evt_shd.g_old_rec.business_group_id;

320: ota_evt_shd.g_old_rec.activity_version_id;
321: End If;
322: If (p_rec.business_group_id = hr_api.g_number) then
323: p_rec.business_group_id :=
324: ota_evt_shd.g_old_rec.business_group_id;
325: End If;
326: If (p_rec.organization_id = hr_api.g_number) then
327: p_rec.organization_id :=
328: ota_evt_shd.g_old_rec.organization_id;

Line 328: ota_evt_shd.g_old_rec.organization_id;

324: ota_evt_shd.g_old_rec.business_group_id;
325: End If;
326: If (p_rec.organization_id = hr_api.g_number) then
327: p_rec.organization_id :=
328: ota_evt_shd.g_old_rec.organization_id;
329: End If;
330: If (p_rec.event_type = hr_api.g_varchar2) then
331: p_rec.event_type :=
332: ota_evt_shd.g_old_rec.event_type;

Line 332: ota_evt_shd.g_old_rec.event_type;

328: ota_evt_shd.g_old_rec.organization_id;
329: End If;
330: If (p_rec.event_type = hr_api.g_varchar2) then
331: p_rec.event_type :=
332: ota_evt_shd.g_old_rec.event_type;
333: End If;
334: If (p_rec.title = hr_api.g_varchar2) then
335: p_rec.title :=
336: ota_evt_shd.g_old_rec.title;

Line 336: ota_evt_shd.g_old_rec.title;

332: ota_evt_shd.g_old_rec.event_type;
333: End If;
334: If (p_rec.title = hr_api.g_varchar2) then
335: p_rec.title :=
336: ota_evt_shd.g_old_rec.title;
337: End If;
338: If (p_rec.budget_cost = hr_api.g_number) then
339: p_rec.budget_cost :=
340: ota_evt_shd.g_old_rec.budget_cost;

Line 340: ota_evt_shd.g_old_rec.budget_cost;

336: ota_evt_shd.g_old_rec.title;
337: End If;
338: If (p_rec.budget_cost = hr_api.g_number) then
339: p_rec.budget_cost :=
340: ota_evt_shd.g_old_rec.budget_cost;
341: End If;
342: If (p_rec.actual_cost = hr_api.g_number) then
343: p_rec.actual_cost :=
344: ota_evt_shd.g_old_rec.actual_cost;

Line 344: ota_evt_shd.g_old_rec.actual_cost;

340: ota_evt_shd.g_old_rec.budget_cost;
341: End If;
342: If (p_rec.actual_cost = hr_api.g_number) then
343: p_rec.actual_cost :=
344: ota_evt_shd.g_old_rec.actual_cost;
345: End If;
346: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
347: p_rec.budget_currency_code :=
348: ota_evt_shd.g_old_rec.budget_currency_code;

Line 348: ota_evt_shd.g_old_rec.budget_currency_code;

344: ota_evt_shd.g_old_rec.actual_cost;
345: End If;
346: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
347: p_rec.budget_currency_code :=
348: ota_evt_shd.g_old_rec.budget_currency_code;
349: End If;
350: If (p_rec.centre = hr_api.g_varchar2) then
351: p_rec.centre :=
352: ota_evt_shd.g_old_rec.centre;

Line 352: ota_evt_shd.g_old_rec.centre;

348: ota_evt_shd.g_old_rec.budget_currency_code;
349: End If;
350: If (p_rec.centre = hr_api.g_varchar2) then
351: p_rec.centre :=
352: ota_evt_shd.g_old_rec.centre;
353: End If;
354: If (p_rec.comments = hr_api.g_varchar2) then
355: p_rec.comments :=
356: ota_evt_shd.g_old_rec.comments;

Line 356: ota_evt_shd.g_old_rec.comments;

352: ota_evt_shd.g_old_rec.centre;
353: End If;
354: If (p_rec.comments = hr_api.g_varchar2) then
355: p_rec.comments :=
356: ota_evt_shd.g_old_rec.comments;
357: End If;
358: If (p_rec.course_end_date = hr_api.g_date) then
359: p_rec.course_end_date :=
360: ota_evt_shd.g_old_rec.course_end_date;

Line 360: ota_evt_shd.g_old_rec.course_end_date;

356: ota_evt_shd.g_old_rec.comments;
357: End If;
358: If (p_rec.course_end_date = hr_api.g_date) then
359: p_rec.course_end_date :=
360: ota_evt_shd.g_old_rec.course_end_date;
361: End If;
362: If (p_rec.course_end_time = hr_api.g_varchar2) then
363: p_rec.course_end_time :=
364: ota_evt_shd.g_old_rec.course_end_time;

Line 364: ota_evt_shd.g_old_rec.course_end_time;

360: ota_evt_shd.g_old_rec.course_end_date;
361: End If;
362: If (p_rec.course_end_time = hr_api.g_varchar2) then
363: p_rec.course_end_time :=
364: ota_evt_shd.g_old_rec.course_end_time;
365: End If;
366: If (p_rec.course_start_date = hr_api.g_date) then
367: p_rec.course_start_date :=
368: ota_evt_shd.g_old_rec.course_start_date;

Line 368: ota_evt_shd.g_old_rec.course_start_date;

364: ota_evt_shd.g_old_rec.course_end_time;
365: End If;
366: If (p_rec.course_start_date = hr_api.g_date) then
367: p_rec.course_start_date :=
368: ota_evt_shd.g_old_rec.course_start_date;
369: End If;
370: If (p_rec.course_start_time = hr_api.g_varchar2) then
371: p_rec.course_start_time :=
372: ota_evt_shd.g_old_rec.course_start_time;

Line 372: ota_evt_shd.g_old_rec.course_start_time;

368: ota_evt_shd.g_old_rec.course_start_date;
369: End If;
370: If (p_rec.course_start_time = hr_api.g_varchar2) then
371: p_rec.course_start_time :=
372: ota_evt_shd.g_old_rec.course_start_time;
373: End If;
374: If (p_rec.duration = hr_api.g_number) then
375: p_rec.duration :=
376: ota_evt_shd.g_old_rec.duration;

Line 376: ota_evt_shd.g_old_rec.duration;

372: ota_evt_shd.g_old_rec.course_start_time;
373: End If;
374: If (p_rec.duration = hr_api.g_number) then
375: p_rec.duration :=
376: ota_evt_shd.g_old_rec.duration;
377: End If;
378: If (p_rec.duration_units = hr_api.g_varchar2) then
379: p_rec.duration_units :=
380: ota_evt_shd.g_old_rec.duration_units;

Line 380: ota_evt_shd.g_old_rec.duration_units;

376: ota_evt_shd.g_old_rec.duration;
377: End If;
378: If (p_rec.duration_units = hr_api.g_varchar2) then
379: p_rec.duration_units :=
380: ota_evt_shd.g_old_rec.duration_units;
381: End If;
382: If (p_rec.enrolment_end_date = hr_api.g_date) then
383: p_rec.enrolment_end_date :=
384: ota_evt_shd.g_old_rec.enrolment_end_date;

Line 384: ota_evt_shd.g_old_rec.enrolment_end_date;

380: ota_evt_shd.g_old_rec.duration_units;
381: End If;
382: If (p_rec.enrolment_end_date = hr_api.g_date) then
383: p_rec.enrolment_end_date :=
384: ota_evt_shd.g_old_rec.enrolment_end_date;
385: End If;
386: If (p_rec.enrolment_start_date = hr_api.g_date) then
387: p_rec.enrolment_start_date :=
388: ota_evt_shd.g_old_rec.enrolment_start_date;

Line 388: ota_evt_shd.g_old_rec.enrolment_start_date;

384: ota_evt_shd.g_old_rec.enrolment_end_date;
385: End If;
386: If (p_rec.enrolment_start_date = hr_api.g_date) then
387: p_rec.enrolment_start_date :=
388: ota_evt_shd.g_old_rec.enrolment_start_date;
389: End If;
390: If (p_rec.language_id = hr_api.g_number) then
391: p_rec.language_id :=
392: ota_evt_shd.g_old_rec.language_id;

Line 392: ota_evt_shd.g_old_rec.language_id;

388: ota_evt_shd.g_old_rec.enrolment_start_date;
389: End If;
390: If (p_rec.language_id = hr_api.g_number) then
391: p_rec.language_id :=
392: ota_evt_shd.g_old_rec.language_id;
393: End If;
394: If (p_rec.user_status = hr_api.g_varchar2) then
395: p_rec.user_status :=
396: ota_evt_shd.g_old_rec.user_status;

Line 396: ota_evt_shd.g_old_rec.user_status;

392: ota_evt_shd.g_old_rec.language_id;
393: End If;
394: If (p_rec.user_status = hr_api.g_varchar2) then
395: p_rec.user_status :=
396: ota_evt_shd.g_old_rec.user_status;
397: End If;
398: If (p_rec.development_event_type = hr_api.g_varchar2) then
399: p_rec.development_event_type :=
400: ota_evt_shd.g_old_rec.development_event_type;

Line 400: ota_evt_shd.g_old_rec.development_event_type;

396: ota_evt_shd.g_old_rec.user_status;
397: End If;
398: If (p_rec.development_event_type = hr_api.g_varchar2) then
399: p_rec.development_event_type :=
400: ota_evt_shd.g_old_rec.development_event_type;
401: End If;
402: If (p_rec.event_status = hr_api.g_varchar2) then
403: p_rec.event_status :=
404: ota_evt_shd.g_old_rec.event_status;

Line 404: ota_evt_shd.g_old_rec.event_status;

400: ota_evt_shd.g_old_rec.development_event_type;
401: End If;
402: If (p_rec.event_status = hr_api.g_varchar2) then
403: p_rec.event_status :=
404: ota_evt_shd.g_old_rec.event_status;
405: End If;
406: If (p_rec.price_basis = hr_api.g_varchar2) then
407: p_rec.price_basis :=
408: ota_evt_shd.g_old_rec.price_basis;

Line 408: ota_evt_shd.g_old_rec.price_basis;

404: ota_evt_shd.g_old_rec.event_status;
405: End If;
406: If (p_rec.price_basis = hr_api.g_varchar2) then
407: p_rec.price_basis :=
408: ota_evt_shd.g_old_rec.price_basis;
409: End If;
410: If (p_rec.currency_code = hr_api.g_varchar2) then
411: p_rec.currency_code :=
412: ota_evt_shd.g_old_rec.currency_code;

Line 412: ota_evt_shd.g_old_rec.currency_code;

408: ota_evt_shd.g_old_rec.price_basis;
409: End If;
410: If (p_rec.currency_code = hr_api.g_varchar2) then
411: p_rec.currency_code :=
412: ota_evt_shd.g_old_rec.currency_code;
413: End If;
414: If (p_rec.maximum_attendees = hr_api.g_number) then
415: p_rec.maximum_attendees :=
416: ota_evt_shd.g_old_rec.maximum_attendees;

Line 416: ota_evt_shd.g_old_rec.maximum_attendees;

412: ota_evt_shd.g_old_rec.currency_code;
413: End If;
414: If (p_rec.maximum_attendees = hr_api.g_number) then
415: p_rec.maximum_attendees :=
416: ota_evt_shd.g_old_rec.maximum_attendees;
417: End If;
418: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
419: p_rec.maximum_internal_attendees :=
420: ota_evt_shd.g_old_rec.maximum_internal_attendees;

Line 420: ota_evt_shd.g_old_rec.maximum_internal_attendees;

416: ota_evt_shd.g_old_rec.maximum_attendees;
417: End If;
418: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
419: p_rec.maximum_internal_attendees :=
420: ota_evt_shd.g_old_rec.maximum_internal_attendees;
421: End If;
422: If (p_rec.minimum_attendees = hr_api.g_number) then
423: p_rec.minimum_attendees :=
424: ota_evt_shd.g_old_rec.minimum_attendees;

Line 424: ota_evt_shd.g_old_rec.minimum_attendees;

420: ota_evt_shd.g_old_rec.maximum_internal_attendees;
421: End If;
422: If (p_rec.minimum_attendees = hr_api.g_number) then
423: p_rec.minimum_attendees :=
424: ota_evt_shd.g_old_rec.minimum_attendees;
425: End If;
426: If (p_rec.standard_price = hr_api.g_number) then
427: p_rec.standard_price :=
428: ota_evt_shd.g_old_rec.standard_price;

Line 428: ota_evt_shd.g_old_rec.standard_price;

424: ota_evt_shd.g_old_rec.minimum_attendees;
425: End If;
426: If (p_rec.standard_price = hr_api.g_number) then
427: p_rec.standard_price :=
428: ota_evt_shd.g_old_rec.standard_price;
429: End If;
430: If (p_rec.category_code = hr_api.g_varchar2) then
431: p_rec.category_code :=
432: ota_evt_shd.g_old_rec.category_code;

Line 432: ota_evt_shd.g_old_rec.category_code;

428: ota_evt_shd.g_old_rec.standard_price;
429: End If;
430: If (p_rec.category_code = hr_api.g_varchar2) then
431: p_rec.category_code :=
432: ota_evt_shd.g_old_rec.category_code;
433: End If;
434: If (p_rec.parent_event_id = hr_api.g_number) then
435: p_rec.parent_event_id :=
436: ota_evt_shd.g_old_rec.parent_event_id;

Line 436: ota_evt_shd.g_old_rec.parent_event_id;

432: ota_evt_shd.g_old_rec.category_code;
433: End If;
434: If (p_rec.parent_event_id = hr_api.g_number) then
435: p_rec.parent_event_id :=
436: ota_evt_shd.g_old_rec.parent_event_id;
437: End If;
438: If (p_rec.book_independent_flag = hr_api.g_varchar2) then
439: p_rec.book_independent_flag :=
440: ota_evt_shd.g_old_rec.book_independent_flag;

Line 440: ota_evt_shd.g_old_rec.book_independent_flag;

436: ota_evt_shd.g_old_rec.parent_event_id;
437: End If;
438: If (p_rec.book_independent_flag = hr_api.g_varchar2) then
439: p_rec.book_independent_flag :=
440: ota_evt_shd.g_old_rec.book_independent_flag;
441: End If;
442: If (p_rec.public_event_flag = hr_api.g_varchar2) then
443: p_rec.public_event_flag :=
444: ota_evt_shd.g_old_rec.public_event_flag;

Line 444: ota_evt_shd.g_old_rec.public_event_flag;

440: ota_evt_shd.g_old_rec.book_independent_flag;
441: End If;
442: If (p_rec.public_event_flag = hr_api.g_varchar2) then
443: p_rec.public_event_flag :=
444: ota_evt_shd.g_old_rec.public_event_flag;
445: End If;
446: If (p_rec.secure_event_flag = hr_api.g_varchar2) then
447: p_rec.secure_event_flag :=
448: ota_evt_shd.g_old_rec.secure_event_flag;

Line 448: ota_evt_shd.g_old_rec.secure_event_flag;

444: ota_evt_shd.g_old_rec.public_event_flag;
445: End If;
446: If (p_rec.secure_event_flag = hr_api.g_varchar2) then
447: p_rec.secure_event_flag :=
448: ota_evt_shd.g_old_rec.secure_event_flag;
449: End If;
450: If (p_rec.evt_information_category = hr_api.g_varchar2) then
451: p_rec.evt_information_category :=
452: ota_evt_shd.g_old_rec.evt_information_category;

Line 452: ota_evt_shd.g_old_rec.evt_information_category;

448: ota_evt_shd.g_old_rec.secure_event_flag;
449: End If;
450: If (p_rec.evt_information_category = hr_api.g_varchar2) then
451: p_rec.evt_information_category :=
452: ota_evt_shd.g_old_rec.evt_information_category;
453: End If;
454: If (p_rec.evt_information1 = hr_api.g_varchar2) then
455: p_rec.evt_information1 :=
456: ota_evt_shd.g_old_rec.evt_information1;

Line 456: ota_evt_shd.g_old_rec.evt_information1;

452: ota_evt_shd.g_old_rec.evt_information_category;
453: End If;
454: If (p_rec.evt_information1 = hr_api.g_varchar2) then
455: p_rec.evt_information1 :=
456: ota_evt_shd.g_old_rec.evt_information1;
457: End If;
458: If (p_rec.evt_information2 = hr_api.g_varchar2) then
459: p_rec.evt_information2 :=
460: ota_evt_shd.g_old_rec.evt_information2;

Line 460: ota_evt_shd.g_old_rec.evt_information2;

456: ota_evt_shd.g_old_rec.evt_information1;
457: End If;
458: If (p_rec.evt_information2 = hr_api.g_varchar2) then
459: p_rec.evt_information2 :=
460: ota_evt_shd.g_old_rec.evt_information2;
461: End If;
462: If (p_rec.evt_information3 = hr_api.g_varchar2) then
463: p_rec.evt_information3 :=
464: ota_evt_shd.g_old_rec.evt_information3;

Line 464: ota_evt_shd.g_old_rec.evt_information3;

460: ota_evt_shd.g_old_rec.evt_information2;
461: End If;
462: If (p_rec.evt_information3 = hr_api.g_varchar2) then
463: p_rec.evt_information3 :=
464: ota_evt_shd.g_old_rec.evt_information3;
465: End If;
466: If (p_rec.evt_information4 = hr_api.g_varchar2) then
467: p_rec.evt_information4 :=
468: ota_evt_shd.g_old_rec.evt_information4;

Line 468: ota_evt_shd.g_old_rec.evt_information4;

464: ota_evt_shd.g_old_rec.evt_information3;
465: End If;
466: If (p_rec.evt_information4 = hr_api.g_varchar2) then
467: p_rec.evt_information4 :=
468: ota_evt_shd.g_old_rec.evt_information4;
469: End If;
470: If (p_rec.evt_information5 = hr_api.g_varchar2) then
471: p_rec.evt_information5 :=
472: ota_evt_shd.g_old_rec.evt_information5;

Line 472: ota_evt_shd.g_old_rec.evt_information5;

468: ota_evt_shd.g_old_rec.evt_information4;
469: End If;
470: If (p_rec.evt_information5 = hr_api.g_varchar2) then
471: p_rec.evt_information5 :=
472: ota_evt_shd.g_old_rec.evt_information5;
473: End If;
474: If (p_rec.evt_information6 = hr_api.g_varchar2) then
475: p_rec.evt_information6 :=
476: ota_evt_shd.g_old_rec.evt_information6;

Line 476: ota_evt_shd.g_old_rec.evt_information6;

472: ota_evt_shd.g_old_rec.evt_information5;
473: End If;
474: If (p_rec.evt_information6 = hr_api.g_varchar2) then
475: p_rec.evt_information6 :=
476: ota_evt_shd.g_old_rec.evt_information6;
477: End If;
478: If (p_rec.evt_information7 = hr_api.g_varchar2) then
479: p_rec.evt_information7 :=
480: ota_evt_shd.g_old_rec.evt_information7;

Line 480: ota_evt_shd.g_old_rec.evt_information7;

476: ota_evt_shd.g_old_rec.evt_information6;
477: End If;
478: If (p_rec.evt_information7 = hr_api.g_varchar2) then
479: p_rec.evt_information7 :=
480: ota_evt_shd.g_old_rec.evt_information7;
481: End If;
482: If (p_rec.evt_information8 = hr_api.g_varchar2) then
483: p_rec.evt_information8 :=
484: ota_evt_shd.g_old_rec.evt_information8;

Line 484: ota_evt_shd.g_old_rec.evt_information8;

480: ota_evt_shd.g_old_rec.evt_information7;
481: End If;
482: If (p_rec.evt_information8 = hr_api.g_varchar2) then
483: p_rec.evt_information8 :=
484: ota_evt_shd.g_old_rec.evt_information8;
485: End If;
486: If (p_rec.evt_information9 = hr_api.g_varchar2) then
487: p_rec.evt_information9 :=
488: ota_evt_shd.g_old_rec.evt_information9;

Line 488: ota_evt_shd.g_old_rec.evt_information9;

484: ota_evt_shd.g_old_rec.evt_information8;
485: End If;
486: If (p_rec.evt_information9 = hr_api.g_varchar2) then
487: p_rec.evt_information9 :=
488: ota_evt_shd.g_old_rec.evt_information9;
489: End If;
490: If (p_rec.evt_information10 = hr_api.g_varchar2) then
491: p_rec.evt_information10 :=
492: ota_evt_shd.g_old_rec.evt_information10;

Line 492: ota_evt_shd.g_old_rec.evt_information10;

488: ota_evt_shd.g_old_rec.evt_information9;
489: End If;
490: If (p_rec.evt_information10 = hr_api.g_varchar2) then
491: p_rec.evt_information10 :=
492: ota_evt_shd.g_old_rec.evt_information10;
493: End If;
494: If (p_rec.evt_information11 = hr_api.g_varchar2) then
495: p_rec.evt_information11 :=
496: ota_evt_shd.g_old_rec.evt_information11;

Line 496: ota_evt_shd.g_old_rec.evt_information11;

492: ota_evt_shd.g_old_rec.evt_information10;
493: End If;
494: If (p_rec.evt_information11 = hr_api.g_varchar2) then
495: p_rec.evt_information11 :=
496: ota_evt_shd.g_old_rec.evt_information11;
497: End If;
498: If (p_rec.evt_information12 = hr_api.g_varchar2) then
499: p_rec.evt_information12 :=
500: ota_evt_shd.g_old_rec.evt_information12;

Line 500: ota_evt_shd.g_old_rec.evt_information12;

496: ota_evt_shd.g_old_rec.evt_information11;
497: End If;
498: If (p_rec.evt_information12 = hr_api.g_varchar2) then
499: p_rec.evt_information12 :=
500: ota_evt_shd.g_old_rec.evt_information12;
501: End If;
502: If (p_rec.evt_information13 = hr_api.g_varchar2) then
503: p_rec.evt_information13 :=
504: ota_evt_shd.g_old_rec.evt_information13;

Line 504: ota_evt_shd.g_old_rec.evt_information13;

500: ota_evt_shd.g_old_rec.evt_information12;
501: End If;
502: If (p_rec.evt_information13 = hr_api.g_varchar2) then
503: p_rec.evt_information13 :=
504: ota_evt_shd.g_old_rec.evt_information13;
505: End If;
506: If (p_rec.evt_information14 = hr_api.g_varchar2) then
507: p_rec.evt_information14 :=
508: ota_evt_shd.g_old_rec.evt_information14;

Line 508: ota_evt_shd.g_old_rec.evt_information14;

504: ota_evt_shd.g_old_rec.evt_information13;
505: End If;
506: If (p_rec.evt_information14 = hr_api.g_varchar2) then
507: p_rec.evt_information14 :=
508: ota_evt_shd.g_old_rec.evt_information14;
509: End If;
510: If (p_rec.evt_information15 = hr_api.g_varchar2) then
511: p_rec.evt_information15 :=
512: ota_evt_shd.g_old_rec.evt_information15;

Line 512: ota_evt_shd.g_old_rec.evt_information15;

508: ota_evt_shd.g_old_rec.evt_information14;
509: End If;
510: If (p_rec.evt_information15 = hr_api.g_varchar2) then
511: p_rec.evt_information15 :=
512: ota_evt_shd.g_old_rec.evt_information15;
513: End If;
514: If (p_rec.evt_information16 = hr_api.g_varchar2) then
515: p_rec.evt_information16 :=
516: ota_evt_shd.g_old_rec.evt_information16;

Line 516: ota_evt_shd.g_old_rec.evt_information16;

512: ota_evt_shd.g_old_rec.evt_information15;
513: End If;
514: If (p_rec.evt_information16 = hr_api.g_varchar2) then
515: p_rec.evt_information16 :=
516: ota_evt_shd.g_old_rec.evt_information16;
517: End If;
518: If (p_rec.evt_information17 = hr_api.g_varchar2) then
519: p_rec.evt_information17 :=
520: ota_evt_shd.g_old_rec.evt_information17;

Line 520: ota_evt_shd.g_old_rec.evt_information17;

516: ota_evt_shd.g_old_rec.evt_information16;
517: End If;
518: If (p_rec.evt_information17 = hr_api.g_varchar2) then
519: p_rec.evt_information17 :=
520: ota_evt_shd.g_old_rec.evt_information17;
521: End If;
522: If (p_rec.evt_information18 = hr_api.g_varchar2) then
523: p_rec.evt_information18 :=
524: ota_evt_shd.g_old_rec.evt_information18;

Line 524: ota_evt_shd.g_old_rec.evt_information18;

520: ota_evt_shd.g_old_rec.evt_information17;
521: End If;
522: If (p_rec.evt_information18 = hr_api.g_varchar2) then
523: p_rec.evt_information18 :=
524: ota_evt_shd.g_old_rec.evt_information18;
525: End If;
526: If (p_rec.evt_information19 = hr_api.g_varchar2) then
527: p_rec.evt_information19 :=
528: ota_evt_shd.g_old_rec.evt_information19;

Line 528: ota_evt_shd.g_old_rec.evt_information19;

524: ota_evt_shd.g_old_rec.evt_information18;
525: End If;
526: If (p_rec.evt_information19 = hr_api.g_varchar2) then
527: p_rec.evt_information19 :=
528: ota_evt_shd.g_old_rec.evt_information19;
529: End If;
530: If (p_rec.evt_information20 = hr_api.g_varchar2) then
531: p_rec.evt_information20 :=
532: ota_evt_shd.g_old_rec.evt_information20;

Line 532: ota_evt_shd.g_old_rec.evt_information20;

528: ota_evt_shd.g_old_rec.evt_information19;
529: End If;
530: If (p_rec.evt_information20 = hr_api.g_varchar2) then
531: p_rec.evt_information20 :=
532: ota_evt_shd.g_old_rec.evt_information20;
533: End If;
534: If (p_rec.project_id = hr_api.g_number) then
535: p_rec.project_id :=
536: ota_evt_shd.g_old_rec.project_id;

Line 536: ota_evt_shd.g_old_rec.project_id;

532: ota_evt_shd.g_old_rec.evt_information20;
533: End If;
534: If (p_rec.project_id = hr_api.g_number) then
535: p_rec.project_id :=
536: ota_evt_shd.g_old_rec.project_id;
537: End If;
538: If (p_rec.owner_id = hr_api.g_number) then
539: p_rec.owner_id :=
540: ota_evt_shd.g_old_rec.owner_id;

Line 540: ota_evt_shd.g_old_rec.owner_id;

536: ota_evt_shd.g_old_rec.project_id;
537: End If;
538: If (p_rec.owner_id = hr_api.g_number) then
539: p_rec.owner_id :=
540: ota_evt_shd.g_old_rec.owner_id;
541: End If;
542: If (p_rec.line_id = hr_api.g_number) then
543: p_rec.line_id :=
544: ota_evt_shd.g_old_rec.line_id;

Line 544: ota_evt_shd.g_old_rec.line_id;

540: ota_evt_shd.g_old_rec.owner_id;
541: End If;
542: If (p_rec.line_id = hr_api.g_number) then
543: p_rec.line_id :=
544: ota_evt_shd.g_old_rec.line_id;
545: End If;
546: If (p_rec.org_id = hr_api.g_number) then
547: p_rec.org_id :=
548: ota_evt_shd.g_old_rec.org_id;

Line 548: ota_evt_shd.g_old_rec.org_id;

544: ota_evt_shd.g_old_rec.line_id;
545: End If;
546: If (p_rec.org_id = hr_api.g_number) then
547: p_rec.org_id :=
548: ota_evt_shd.g_old_rec.org_id;
549: End If;
550: If (p_rec.training_center_id = hr_api.g_number) then
551: p_rec.training_center_id :=
552: ota_evt_shd.g_old_rec.training_center_id;

Line 552: ota_evt_shd.g_old_rec.training_center_id;

548: ota_evt_shd.g_old_rec.org_id;
549: End If;
550: If (p_rec.training_center_id = hr_api.g_number) then
551: p_rec.training_center_id :=
552: ota_evt_shd.g_old_rec.training_center_id;
553: End If;
554: If (p_rec.location_id = hr_api.g_number) then
555: p_rec.location_id :=
556: ota_evt_shd.g_old_rec.location_id;

Line 556: ota_evt_shd.g_old_rec.location_id;

552: ota_evt_shd.g_old_rec.training_center_id;
553: End If;
554: If (p_rec.location_id = hr_api.g_number) then
555: p_rec.location_id :=
556: ota_evt_shd.g_old_rec.location_id;
557: End If;
558:
559: If (p_rec.offering_id = hr_api.g_number) then
560: p_rec.offering_id :=

Line 561: ota_evt_shd.g_old_rec.offering_id;

557: End If;
558:
559: If (p_rec.offering_id = hr_api.g_number) then
560: p_rec.offering_id :=
561: ota_evt_shd.g_old_rec.offering_id;
562: End If;
563:
564: If (p_rec.timezone = hr_api.g_varchar2) then
565: p_rec.timezone :=

Line 566: ota_evt_shd.g_old_rec.timezone;

562: End If;
563:
564: If (p_rec.timezone = hr_api.g_varchar2) then
565: p_rec.timezone :=
566: ota_evt_shd.g_old_rec.timezone;
567: End If;
568:
569: If (p_rec.parent_offering_id = hr_api.g_number) then
570: p_rec.parent_offering_id :=

Line 571: ota_evt_shd.g_old_rec.parent_offering_id;

567: End If;
568:
569: If (p_rec.parent_offering_id = hr_api.g_number) then
570: p_rec.parent_offering_id :=
571: ota_evt_shd.g_old_rec.parent_offering_id;
572: End If;
573:
574: If (p_rec.data_source = hr_api.g_varchar2) then
575: p_rec.data_source :=

Line 576: ota_evt_shd.g_old_rec.data_source;

572: End If;
573:
574: If (p_rec.data_source = hr_api.g_varchar2) then
575: p_rec.data_source :=
576: ota_evt_shd.g_old_rec.data_source;
577: End If;
578:
579: --
580: -- Return the plsql record structure.

Line 592: p_rec in out nocopy ota_evt_shd.g_rec_type,

588: -- |---------------------------------< upd >----------------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure upd
591: (
592: p_rec in out nocopy ota_evt_shd.g_rec_type,
593: p_validate in boolean default false
594: ) is
595: --
596: l_proc varchar2(72) := g_package||'upd';

Line 598: temp_var ota_evt_shd.g_rec_type;

594: ) is
595: --
596: l_proc varchar2(72) := g_package||'upd';
597: -- VT 05/06/97 #488173
598: temp_var ota_evt_shd.g_rec_type;
599: l_course_start_date_changed boolean;
600: l_course_end_date_changed boolean;
601: l_course_start_time_changed boolean;
602: l_course_end_time_changed boolean;

Line 620: ota_evt_shd.lck

616: End If;
617: --
618: -- We must lock the row which we need to update.
619: --
620: ota_evt_shd.lck
621: (
622: p_rec.event_id,
623: p_rec.object_version_number
624: );

Line 665: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,

661: End If;
662: -- CODING FOR NTF PROCESS
663:
664: l_course_start_date_changed
665: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
666: temp_var.course_start_date);
667: l_course_end_date_changed
668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);

Line 668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,

664: l_course_start_date_changed
665: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
666: temp_var.course_start_date);
667: l_course_end_date_changed
668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);
670: l_course_start_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,
671: temp_var.course_start_time);
672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,

Line 670: l_course_start_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,

666: temp_var.course_start_date);
667: l_course_end_date_changed
668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);
670: l_course_start_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,
671: temp_var.course_start_time);
672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,
673: temp_var.course_end_time);
674:

Line 672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,

668: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
669: temp_var.course_end_date);
670: l_course_start_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,
671: temp_var.course_start_time);
672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,
673: temp_var.course_end_time);
674:
675: l_location_id_changed
676: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,

Line 676: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,

672: l_course_end_time_changed := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,
673: temp_var.course_end_time);
674:
675: l_location_id_changed
676: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
677: temp_var.location_id);
678:
679: l_training_center_id_changed
680: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,

Line 680: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,

676: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
677: temp_var.location_id);
678:
679: l_training_center_id_changed
680: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
681: temp_var.training_center_id);
682:
683:
684: if (l_course_start_date_changed or

Line 694: if ota_evt_shd.g_old_rec.parent_event_id is null then

690: p_item_type => 'OTWF',
691: p_eventid => p_rec.event_id,
692: p_event_fired => 'CLASS_RESCHEDULE');
693:
694: if ota_evt_shd.g_old_rec.parent_event_id is null then
695: --send notification to all learners for class rescheduling
696: OTA_INITIALIZATION_WF.initialize_wf(p_process => 'OTA_CLASS_CANCEL_JSP_PRC',
697: p_item_type => 'OTWF',
698: p_eventid => p_rec.event_id,

Line 713: if ota_evt_shd.g_old_rec.parent_event_id is null then

709:
710: end if;
711:
712: ------------ Start Raise Business Event --------------------
713: if ota_evt_shd.g_old_rec.parent_event_id is null then
714:
715: if (l_course_start_date_changed or
716: l_course_end_date_changed or
717: l_course_start_time_changed or

Line 751: and ota_evt_shd.g_old_rec.course_start_date > trunc(sysdate)

747:
748: ------------ End Raise Business Event --------------------
749:
750: if (l_course_start_date_changed and trunc(temp_var.course_start_date) <= trunc(sysdate)
751: and ota_evt_shd.g_old_rec.course_start_date > trunc(sysdate)
752: and ota_evt_shd.g_old_rec.parent_event_id is null) then
753: -- send notification to all waitlisted learners of class begining
754: if (ota_utility.is_con_prog_periodic('OTEVTNTF')) then
755: ota_initialization_wf.Initialize_auto_wf(p_process => 'OTA_ENROLL_STATUS_CHNG_JSP_PRC',

Line 752: and ota_evt_shd.g_old_rec.parent_event_id is null) then

748: ------------ End Raise Business Event --------------------
749:
750: if (l_course_start_date_changed and trunc(temp_var.course_start_date) <= trunc(sysdate)
751: and ota_evt_shd.g_old_rec.course_start_date > trunc(sysdate)
752: and ota_evt_shd.g_old_rec.parent_event_id is null) then
753: -- send notification to all waitlisted learners of class begining
754: if (ota_utility.is_con_prog_periodic('OTEVTNTF')) then
755: ota_initialization_wf.Initialize_auto_wf(p_process => 'OTA_ENROLL_STATUS_CHNG_JSP_PRC',
756: p_item_type => 'OTWF',

Line 852: l_rec ota_evt_shd.g_rec_type;

848: -- p_timezone in varchar2 default null,
849: p_validate in boolean default false
850: ) is
851: --
852: l_rec ota_evt_shd.g_rec_type;
853: l_proc varchar2(72) := g_package||'upd';
854: --
855: Begin
856: hr_utility.set_location('Entering:'||l_proc, 5);

Line 862: ota_evt_shd.convert_args

858: -- Call conversion function to turn arguments into the
859: -- l_rec structure.
860: --
861: l_rec :=
862: ota_evt_shd.convert_args
863: (
864: p_event_id,
865: p_vendor_id,
866: p_activity_version_id,