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_API dependencies on OTA_TDB_SHD

Line 1115: ota_tdb_shd.g_old_rec.booking_status_type_id);

1111: -- Set up local variables
1112: --
1113:
1114: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1115: ota_tdb_shd.g_old_rec.booking_status_type_id);
1116:
1117: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1118: p_booking_status_type_id);
1119:

Line 1121: ota_tdb_shd.g_old_rec.booking_status_type_id,

1117: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1118: p_booking_status_type_id);
1119:
1120: l_booking_status_changed boolean := ota_general.value_changed(
1121: ota_tdb_shd.g_old_rec.booking_status_type_id,
1122: p_booking_status_type_id);
1123:
1124: l_number_of_places_changed boolean := ota_general.value_changed(
1125: ota_tdb_shd.g_old_rec.number_of_places,

Line 1125: ota_tdb_shd.g_old_rec.number_of_places,

1121: ota_tdb_shd.g_old_rec.booking_status_type_id,
1122: p_booking_status_type_id);
1123:
1124: l_number_of_places_changed boolean := ota_general.value_changed(
1125: ota_tdb_shd.g_old_rec.number_of_places,
1126: p_number_of_places);
1127:
1128: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
1129:

Line 1130: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;

1126: p_number_of_places);
1127:
1128: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
1129:
1130: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;
1131:
1132: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;
1133:
1134: Cursor c_eval_info is

Line 1132: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;

1128: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
1129:
1130: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;
1131:
1132: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;
1133:
1134: Cursor c_eval_info is
1135: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',
1136: decode(act_eval.evaluation_id,null,'N',decode(nvl(act_eval.eval_mandatory_flag,'N'),'Y','Y','N'))) flag --bug 7184369

Line 1880: ota_tdb_shd.lck(p_booking_id,p_object_version_number);

1876: --
1877: --
1878: -- Lock Enrollment (Bug 2468167)
1879: --
1880: ota_tdb_shd.lck(p_booking_id,p_object_version_number);
1881: --
1882:
1883: -- Prerequisite Validation Code
1884: -- Can be overridden if p_override_prerequisites parameter is 'Y'

Line 2240: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,

2236: );
2237: */
2238: --
2239: l_status_type_id_changed :=
2240: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
2241: p_booking_status_type_id);
2242:
2243: -- Getting the old booking status to manipulate the fourm notification records
2244: l_old_booking_status := ota_tdb_bus.booking_status_type(

Line 2245: ota_tdb_shd.g_old_rec.booking_status_type_id);

2241: p_booking_status_type_id);
2242:
2243: -- Getting the old booking status to manipulate the fourm notification records
2244: l_old_booking_status := ota_tdb_bus.booking_status_type(
2245: ota_tdb_shd.g_old_rec.booking_status_type_id);
2246:
2247: OPEN is_contact;
2248: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;
2249: CLOSE is_contact;

Line 2400: ota_tdb_shd.g_old_rec.date_status_changed,

2396: l_date_status_changed, --p_date_status_changed,Bug6801749
2397: p_administrator,
2398: l_status_change_comments, --p_status_change_comments,Bug 2359495
2399: p_booking_id,
2400: ota_tdb_shd.g_old_rec.date_status_changed,
2401: ota_tdb_shd.g_old_rec.booking_status_type_id,
2402: ota_tdb_shd.g_created_by,
2403: p_date_booking_placed);
2404: end if;

Line 2401: ota_tdb_shd.g_old_rec.booking_status_type_id,

2397: p_administrator,
2398: l_status_change_comments, --p_status_change_comments,Bug 2359495
2399: p_booking_id,
2400: ota_tdb_shd.g_old_rec.date_status_changed,
2401: ota_tdb_shd.g_old_rec.booking_status_type_id,
2402: ota_tdb_shd.g_created_by,
2403: p_date_booking_placed);
2404: end if;
2405: --

Line 2402: ota_tdb_shd.g_created_by,

2398: l_status_change_comments, --p_status_change_comments,Bug 2359495
2399: p_booking_id,
2400: ota_tdb_shd.g_old_rec.date_status_changed,
2401: ota_tdb_shd.g_old_rec.booking_status_type_id,
2402: ota_tdb_shd.g_created_by,
2403: p_date_booking_placed);
2404: end if;
2405: --
2406: ota_tdb_bus.ota_letter_lines

Line 2419: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN

2415: END IF;
2416: --
2417: --Added for Bug#4106893
2418: IF p_event_id <> hr_api.g_number
2419: AND p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2420: l_event_id_changed:= true;
2421: END IF;
2422:
2423: IF p_delegate_person_id <> hr_api.g_number

Line 2424: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN

2420: l_event_id_changed:= true;
2421: END IF;
2422:
2423: IF p_delegate_person_id <> hr_api.g_number
2424: AND p_delegate_person_id <> ota_tdb_shd.g_old_rec.delegate_person_id THEN
2425: l_person_id_changed := true;
2426: END IF;
2427:
2428: IF p_delegate_contact_id <> hr_api.g_number

Line 2429: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN

2425: l_person_id_changed := true;
2426: END IF;
2427:
2428: IF p_delegate_contact_id <> hr_api.g_number
2429: AND p_delegate_contact_id <> ota_tdb_shd.g_old_rec.delegate_contact_id THEN
2430: l_contact_id_changed := true;
2431: END IF;
2432:
2433: --bug 603768 changes starts

Line 2436: l_old_event_id := ota_tdb_shd.g_old_rec.event_id;

2432:
2433: --bug 603768 changes starts
2434: --Send ntf to class owner if any enrollment has been cancelled
2435: --or deleted or class changed
2436: l_old_event_id := ota_tdb_shd.g_old_rec.event_id;
2437: l_auto_waitlist := fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
2438: l_waitlist_size := ota_utility.students_on_waitlist(l_old_event_id);
2439:
2440: if (l_auto_waitlist = 'Y' and l_waitlist_size > 0) then

Line 2522: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2518: update lme must be called once for old class, old learner and once for new class and new learner
2519: **/
2520: IF l_event_id_changed AND NOT l_person_id_changed AND NOT l_contact_id_changed THEN
2521: IF l_person_id IS NOT NULL THEN
2522: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2523: p_person_id => l_person_id,
2524: p_contact_id => null,
2525: p_lp_enrollment_ids => l_lp_enrollment_ids);
2526:

Line 2528: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2524: p_contact_id => null,
2525: p_lp_enrollment_ids => l_lp_enrollment_ids);
2526:
2527: -- update any associated cert member enrollment statuses
2528: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2529: p_person_id => l_person_id,
2530: p_contact_id => null,
2531: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2532:

Line 2546: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null);

2542: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2543:
2544: --If the event has changed, the forum notification record should be deleted and created for the new event
2545: -- FRM Notification should be created only for Placed or Attended status. Not for 'C','W' or 'R'.
2546: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null);
2547: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
2548:
2549: ELSIF l_delegate_contact_id IS NOT NULL THEN
2550: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 2550: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2546: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null);
2547: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
2548:
2549: ELSIF l_delegate_contact_id IS NOT NULL THEN
2550: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2551: p_person_id => null,
2552: p_contact_id => l_delegate_contact_id,
2553: p_lp_enrollment_ids => l_lp_enrollment_ids);
2554:

Line 2556: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2552: p_contact_id => l_delegate_contact_id,
2553: p_lp_enrollment_ids => l_lp_enrollment_ids);
2554:
2555: -- update any associated cert member enrollment statuses
2556: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2557: p_person_id => null,
2558: p_contact_id => l_delegate_contact_id,
2559: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2560:

Line 2572: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, l_delegate_contact_id);

2568: p_person_id => null,
2569: p_contact_id => l_delegate_contact_id,
2570: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2571:
2572: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, l_delegate_contact_id);
2573: createForumNotification(p_event_id, null, l_delegate_contact_id, l_effective_date, p_booking_status_type_id);
2574:
2575: END IF;
2576: ELSIF l_event_id_changed THEN

Line 2578: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2574:
2575: END IF;
2576: ELSIF l_event_id_changed THEN
2577: IF l_person_id_changed THEN
2578: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2579: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
2580: p_contact_id => null,
2581: p_lp_enrollment_ids => l_lp_enrollment_ids);
2582:

Line 2579: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,

2575: END IF;
2576: ELSIF l_event_id_changed THEN
2577: IF l_person_id_changed THEN
2578: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2579: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
2580: p_contact_id => null,
2581: p_lp_enrollment_ids => l_lp_enrollment_ids);
2582:
2583: -- update any associated cert member enrollment statuses

Line 2584: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2580: p_contact_id => null,
2581: p_lp_enrollment_ids => l_lp_enrollment_ids);
2582:
2583: -- update any associated cert member enrollment statuses
2584: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2585: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
2586: p_contact_id => null,
2587: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2588:

Line 2585: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,

2581: p_lp_enrollment_ids => l_lp_enrollment_ids);
2582:
2583: -- update any associated cert member enrollment statuses
2584: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2585: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
2586: p_contact_id => null,
2587: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2588:
2589: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,

Line 2602: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);

2598: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2599:
2600: -- the class and the learner have change.So delete the forum record for old class and person
2601: -- and create a notification record for the new class and new person
2602: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
2603: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
2604:
2605: ELSIF l_contact_id_changed THEN
2606:

Line 2607: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2603: createForumNotification(p_event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
2604:
2605: ELSIF l_contact_id_changed THEN
2606:
2607: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2608: p_person_id => null,
2609: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2610: p_lp_enrollment_ids => l_lp_enrollment_ids);
2611:

Line 2609: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,

2605: ELSIF l_contact_id_changed THEN
2606:
2607: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2608: p_person_id => null,
2609: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2610: p_lp_enrollment_ids => l_lp_enrollment_ids);
2611:
2612: -- update any associated cert member enrollment statuses
2613: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 2613: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2609: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2610: p_lp_enrollment_ids => l_lp_enrollment_ids);
2611:
2612: -- update any associated cert member enrollment statuses
2613: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2614: p_person_id => null,
2615: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
2616: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2617:

Line 2615: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,

2611:
2612: -- update any associated cert member enrollment statuses
2613: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2614: p_person_id => null,
2615: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
2616: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2617:
2618: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,
2619: p_person_id => null,

Line 2629: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);

2625: p_person_id => null,
2626: p_contact_id => p_delegate_contact_id,
2627: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2628:
2629: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);
2630: createForumNotification(p_event_id, null, l_delegate_contact_id, l_effective_date, p_booking_status_type_id);
2631:
2632: END IF;
2633:

Line 2635: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2631:
2632: END IF;
2633:
2634: ELSIF l_person_id_changed THEN
2635: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2636: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
2637: p_contact_id => null,
2638: p_lp_enrollment_ids => l_lp_enrollment_ids);
2639:

Line 2636: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,

2632: END IF;
2633:
2634: ELSIF l_person_id_changed THEN
2635: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2636: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
2637: p_contact_id => null,
2638: p_lp_enrollment_ids => l_lp_enrollment_ids);
2639:
2640: -- update any associated cert member enrollment statuses

Line 2641: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2637: p_contact_id => null,
2638: p_lp_enrollment_ids => l_lp_enrollment_ids);
2639:
2640: -- update any associated cert member enrollment statuses
2641: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2642: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
2643: p_contact_id => null,
2644: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2645:

Line 2642: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,

2638: p_lp_enrollment_ids => l_lp_enrollment_ids);
2639:
2640: -- update any associated cert member enrollment statuses
2641: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2642: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
2643: p_contact_id => null,
2644: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2645:
2646: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 2646: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2642: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
2643: p_contact_id => null,
2644: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2645:
2646: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2647: p_person_id => l_person_id,
2648: p_contact_id => null,
2649: p_lp_enrollment_ids => l_lp_enrollment_ids);
2650: -- update any associated cert member enrollment statuses

Line 2651: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2647: p_person_id => l_person_id,
2648: p_contact_id => null,
2649: p_lp_enrollment_ids => l_lp_enrollment_ids);
2650: -- update any associated cert member enrollment statuses
2651: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2652: p_person_id => l_person_id,
2653: p_contact_id => null,
2654: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2655:

Line 2658: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);

2654: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2655:
2656: -- the learner has changed.So delete the forum record for old person
2657: --and create a notification record for the new person
2658: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
2659: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
2660:
2661: ELSIF l_contact_id_changed THEN
2662: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 2659: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);

2655:
2656: -- the learner has changed.So delete the forum record for old person
2657: --and create a notification record for the new person
2658: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
2659: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
2660:
2661: ELSIF l_contact_id_changed THEN
2662: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2663: p_person_id => null,

Line 2662: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2658: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
2659: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, p_booking_status_type_id);
2660:
2661: ELSIF l_contact_id_changed THEN
2662: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2663: p_person_id => null,
2664: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2665: p_lp_enrollment_ids => l_lp_enrollment_ids);
2666:

Line 2664: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,

2660:
2661: ELSIF l_contact_id_changed THEN
2662: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2663: p_person_id => null,
2664: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2665: p_lp_enrollment_ids => l_lp_enrollment_ids);
2666:
2667: -- update any associated cert member enrollment statuses
2668: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

Line 2668: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2664: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2665: p_lp_enrollment_ids => l_lp_enrollment_ids);
2666:
2667: -- update any associated cert member enrollment statuses
2668: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2669: p_person_id => null,
2670: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
2671: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2672:

Line 2670: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,

2666:
2667: -- update any associated cert member enrollment statuses
2668: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2669: p_person_id => null,
2670: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
2671: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2672:
2673: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2674: p_person_id => null,

Line 2673: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2669: p_person_id => null,
2670: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
2671: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2672:
2673: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2674: p_person_id => null,
2675: p_contact_id => p_delegate_contact_id,
2676: p_lp_enrollment_ids => l_lp_enrollment_ids);
2677:

Line 2679: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,

2675: p_contact_id => p_delegate_contact_id,
2676: p_lp_enrollment_ids => l_lp_enrollment_ids);
2677:
2678: -- update any associated cert member enrollment statuses
2679: ota_cme_util.update_cme_status(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2680: p_person_id => null,
2681: p_contact_id => p_delegate_contact_id,
2682: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2683:

Line 2684: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);

2680: p_person_id => null,
2681: p_contact_id => p_delegate_contact_id,
2682: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2683:
2684: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);
2685: createForumNotification(ota_tdb_shd.g_old_rec.event_id, null, p_delegate_contact_id, l_effective_date, p_booking_status_type_id);
2686:
2687: END IF;
2688:

Line 2685: createForumNotification(ota_tdb_shd.g_old_rec.event_id, null, p_delegate_contact_id, l_effective_date, p_booking_status_type_id);

2681: p_contact_id => p_delegate_contact_id,
2682: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2683:
2684: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, null, ota_tdb_shd.g_old_rec.delegate_contact_id);
2685: createForumNotification(ota_tdb_shd.g_old_rec.event_id, null, p_delegate_contact_id, l_effective_date, p_booking_status_type_id);
2686:
2687: END IF;
2688:
2689: --bug#6683076.Added for sending notifications to learners for

Line 2741: IF p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN

2737: ,l_event_rec.maximum_attendees);
2738: --
2739: -- *** In case of Event Change -- Reset Event Status for Old Event ***
2740: --
2741: IF p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2742: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
2743:
2744: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2745: l_event_rec,

Line 2742: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);

2738: --
2739: -- *** In case of Event Change -- Reset Event Status for Old Event ***
2740: --
2741: IF p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2742: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
2743:
2744: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2745: l_event_rec,
2746: l_event_exists);

Line 2744: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,

2740: --
2741: IF p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2742: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
2743:
2744: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2745: l_event_rec,
2746: l_event_exists);
2747:
2748: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id

Line 2748: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id

2744: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2745: l_event_rec,
2746: l_event_exists);
2747:
2748: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id
2749: ,l_event_rec.object_version_number
2750: ,l_event_rec.event_status
2751: ,l_event_rec.maximum_attendees);
2752:

Line 3192: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;

3188: -- Prerequisite Validation Code
3189: l_check_prereq := false;
3190:
3191: If ( p_delegate_person_id = hr_api.g_number ) Then
3192: l_delegate_person_id := ota_tdb_shd.g_old_rec.delegate_person_id;
3193: Else
3194: l_delegate_person_id := p_delegate_person_id;
3195: End If;
3196:

Line 3198: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;

3194: l_delegate_person_id := p_delegate_person_id;
3195: End If;
3196:
3197: If ( p_delegate_contact_id = hr_api.g_number ) Then
3198: l_delegate_contact_id := ota_tdb_shd.g_old_rec.delegate_contact_id;
3199: Else
3200: l_delegate_contact_id := p_delegate_contact_id;
3201: End If;
3202:

Line 3204: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;

3200: l_delegate_contact_id := p_delegate_contact_id;
3201: End If;
3202:
3203: If ( p_customer_id = hr_api.g_number ) Then
3204: l_customer_id := ota_tdb_shd.g_old_rec.customer_id;
3205: Else
3206: l_customer_id := p_customer_id;
3207: End If;
3208:

Line 3210: l_event_id := ota_tdb_shd.g_old_rec.event_id;

3206: l_customer_id := p_customer_id;
3207: End If;
3208:
3209: If ( p_event_id = hr_api.g_number ) Then
3210: l_event_id := ota_tdb_shd.g_old_rec.event_id;
3211: Else
3212: l_event_id := p_event_id;
3213: End If;
3214:

Line 3216: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;

3212: l_event_id := p_event_id;
3213: End If;
3214:
3215: If ( p_booking_status_type_id = hr_api.g_number ) Then
3216: l_booking_status_type_id := ota_tdb_shd.g_old_rec.booking_status_type_id;
3217: Else
3218: l_booking_status_type_id := p_booking_status_type_id;
3219: End If;
3220:

Line 3221: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then

3217: Else
3218: l_booking_status_type_id := p_booking_status_type_id;
3219: End If;
3220:
3221: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
3222: l_check_prereq := true;
3223: End If;
3224:
3225: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then

Line 3225: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then

3221: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
3222: l_check_prereq := true;
3223: End If;
3224:
3225: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
3226: l_check_prereq := true;
3227: End If;
3228:
3229: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then

Line 3229: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then

3225: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
3226: l_check_prereq := true;
3227: End If;
3228:
3229: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
3230: l_check_prereq := true;
3231: End If;
3232:
3233: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then

Line 3233: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then

3229: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
3230: l_check_prereq := true;
3231: End If;
3232:
3233: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
3234: l_check_prereq := true;
3235: End If;
3236:
3237: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

Line 3237: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,

3233: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
3234: l_check_prereq := true;
3235: End If;
3236:
3237: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,
3238: p_type => l_old_status_type);
3239:
3240: ota_utility.get_booking_status_type(p_status_type_id => l_booking_status_type_id,
3241: p_type => l_new_status_type);