DBA Data[Home] [Help]

APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_LRNG_PATH_MEMBER_UTIL

Line 757: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,

753: p_booking_status_type_id => p_booking_status_type_id,
754: p_event_id => p_event_id,
755: p_delegate_person_id => p_delegate_person_id);
756:
757: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,
758: p_person_id => p_delegate_person_id,
759: p_contact_id => p_delegate_contact_id,
760: p_lp_enrollment_ids => l_lp_enrollment_ids);
761:

Line 2294: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,

2290: p_contact_id => l_delegate_contact_id,
2291: p_learning_path_ids => l_learning_path_ids);
2292: */
2293:
2294: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,
2295: p_person_id => l_person_id,
2296: p_contact_id => null,
2297: p_lp_enrollment_ids => l_lp_enrollment_ids);
2298:

Line 2306: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,

2302: p_contact_id => null,
2303: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2304:
2305: ELSIF l_delegate_contact_id IS NOT NULL THEN
2306: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,
2307: p_person_id => null,
2308: p_contact_id => l_delegate_contact_id,
2309: p_lp_enrollment_ids => l_lp_enrollment_ids);
2310: -- update any associated cert member enrollment statuses

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 2533: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id =>p_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:
2533: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id =>p_event_id,
2534: p_person_id => l_person_id,
2535: p_contact_id => null,
2536: p_lp_enrollment_ids => l_lp_enrollment_ids);
2537:

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 2561: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_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:
2561: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,
2562: p_person_id => null,
2563: p_contact_id => l_delegate_contact_id,
2564: p_lp_enrollment_ids => l_lp_enrollment_ids);
2565:

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 2589: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_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,
2590: p_person_id => l_person_id,
2591: p_contact_id => null,
2592: p_lp_enrollment_ids => l_lp_enrollment_ids);
2593:

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 2618: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_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,
2620: p_contact_id => p_delegate_contact_id,
2621: p_lp_enrollment_ids => l_lp_enrollment_ids);
2622:

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 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 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 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: