DBA Data[Home] [Help]

APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_LRNG_PATH_MEMBER_UTIL

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

909: p_booking_status_type_id => p_booking_status_type_id,
910: p_event_id => p_event_id,
911: p_delegate_person_id => p_delegate_person_id);
912:
913: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => p_event_id,
914: p_person_id => p_delegate_person_id,
915: p_contact_id => p_delegate_contact_id,
916: p_lp_enrollment_ids => l_lp_enrollment_ids);
917:

Line 2505: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,

2501: p_contact_id => l_delegate_contact_id,
2502: p_learning_path_ids => l_learning_path_ids);
2503: */
2504:
2505: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,
2506: p_person_id => l_person_id,
2507: p_contact_id => null,
2508: p_lp_enrollment_ids => l_lp_enrollment_ids);
2509:

Line 2517: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,

2513: p_contact_id => null,
2514: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2515:
2516: ELSIF l_delegate_contact_id IS NOT NULL THEN
2517: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,
2518: p_person_id => null,
2519: p_contact_id => l_delegate_contact_id,
2520: p_lp_enrollment_ids => l_lp_enrollment_ids);
2521: -- update any associated cert member enrollment statuses

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

2723: update lme must be called once for old class, old learner and once for new class and new learner
2724: **/
2725: IF l_event_id_changed AND NOT l_person_id_changed AND NOT l_contact_id_changed THEN
2726: IF l_person_id IS NOT NULL THEN
2727: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2728: p_person_id => l_person_id,
2729: p_contact_id => null,
2730: p_lp_enrollment_ids => l_lp_enrollment_ids);
2731:

Line 2738: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id =>l_new_event_id,

2734: p_person_id => l_person_id,
2735: p_contact_id => null,
2736: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2737:
2738: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id =>l_new_event_id,
2739: p_person_id => l_person_id,
2740: p_contact_id => null,
2741: p_lp_enrollment_ids => l_lp_enrollment_ids);
2742:

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

2751: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null);
2752: createForumNotification(l_new_event_id, l_person_id, null, l_effective_date, l_new_booking_status_type_id);
2753:
2754: ELSIF l_delegate_contact_id IS NOT NULL THEN
2755: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2756: p_person_id => null,
2757: p_contact_id => l_delegate_contact_id,
2758: p_lp_enrollment_ids => l_lp_enrollment_ids);
2759:

Line 2766: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,

2762: p_person_id => null,
2763: p_contact_id => l_delegate_contact_id,
2764: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2765:
2766: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,
2767: p_person_id => null,
2768: p_contact_id => l_delegate_contact_id,
2769: p_lp_enrollment_ids => l_lp_enrollment_ids);
2770:

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

2779:
2780: END IF;
2781: ELSIF l_event_id_changed THEN
2782: IF l_person_id_changed THEN
2783: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2784: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
2785: p_contact_id => null,
2786: p_lp_enrollment_ids => l_lp_enrollment_ids);
2787:

Line 2794: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,

2790: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
2791: p_contact_id => null,
2792: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2793:
2794: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,
2795: p_person_id => l_person_id,
2796: p_contact_id => null,
2797: p_lp_enrollment_ids => l_lp_enrollment_ids);
2798:

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

2808: createForumNotification(l_new_event_id, l_person_id, null, l_effective_date, l_new_booking_status_type_id);
2809:
2810: ELSIF l_contact_id_changed THEN
2811:
2812: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2813: p_person_id => null,
2814: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2815: p_lp_enrollment_ids => l_lp_enrollment_ids);
2816:

Line 2823: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,

2819: p_person_id => null,
2820: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
2821: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2822:
2823: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => l_new_event_id,
2824: p_person_id => null,
2825: p_contact_id => p_delegate_contact_id,
2826: p_lp_enrollment_ids => l_lp_enrollment_ids);
2827:

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

2836:
2837: END IF;
2838:
2839: ELSIF l_person_id_changed THEN
2840: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2841: p_person_id =>ota_tdb_shd.g_old_rec.delegate_person_id,
2842: p_contact_id => null,
2843: p_lp_enrollment_ids => l_lp_enrollment_ids);
2844:

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

2847: p_person_id => ota_tdb_shd.g_old_rec.delegate_person_id,
2848: p_contact_id => null,
2849: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2850:
2851: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2852: p_person_id => l_person_id,
2853: p_contact_id => null,
2854: p_lp_enrollment_ids => l_lp_enrollment_ids);
2855: -- update any associated cert member enrollment statuses

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

2863: deleteForumNotification(ota_tdb_shd.g_old_rec.event_id, ota_tdb_shd.g_old_rec.delegate_person_id, null);
2864: createForumNotification(ota_tdb_shd.g_old_rec.event_id, l_person_id, null, l_effective_date, l_new_booking_status_type_id);
2865:
2866: ELSIF l_contact_id_changed THEN
2867: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2868: p_person_id => null,
2869: p_contact_id =>ota_tdb_shd.g_old_rec.delegate_contact_id,
2870: p_lp_enrollment_ids => l_lp_enrollment_ids);
2871:

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

2874: p_person_id => null,
2875: p_contact_id => ota_tdb_shd.g_old_rec.delegate_contact_id,
2876: p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);
2877:
2878: ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id => ota_tdb_shd.g_old_rec.event_id,
2879: p_person_id => null,
2880: p_contact_id => p_delegate_contact_id,
2881: p_lp_enrollment_ids => l_lp_enrollment_ids);
2882: