APPS.OTA_TDB_API_UPD2 dependencies on OTA_GENERAL

Line 32: l_booking_status_changed boolean := ota_general.value_changed(

28:
29: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
30: p_booking_status_type_id);
31:
32: l_booking_status_changed boolean := ota_general.value_changed(
33: ota_tdb_shd.g_old_rec.booking_status_type_id,
34: p_booking_status_type_id);
35:
36: l_number_of_places_changed boolean := ota_general.value_changed(

Line 36: l_number_of_places_changed boolean := ota_general.value_changed(

32: l_booking_status_changed boolean := ota_general.value_changed(
33: ota_tdb_shd.g_old_rec.booking_status_type_id,
34: p_booking_status_type_id);
35:
36: l_number_of_places_changed boolean := ota_general.value_changed(
37: ota_tdb_shd.g_old_rec.number_of_places,
38: p_number_of_places);
39:
40: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);

Line 688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);

684: IF l_new_del_asg_id = hr_api.g_number THEN l_new_del_asg_id := l_enr_details_rec.delegate_assignment_id; END IF;
685: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
686:
687:
688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
689: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
690: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
691: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
692: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);

Line 689: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);

685: IF l_new_delegate_person_id = hr_api.g_number THEN l_new_delegate_person_id := l_enr_details_rec.delegate_person_id; END IF;
686:
687:
688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
689: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
690: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
691: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
692: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
693:

Line 690: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);

686:
687:
688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
689: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
690: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
691: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
692: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
693:
694: if l_event_id_changed or

Line 691: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);

687:
688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
689: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
690: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
691: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
692: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
693:
694: if l_event_id_changed or
695: l_customer_id_changed or

Line 692: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);

688: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
689: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
690: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
691: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
692: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
693:
694: if l_event_id_changed or
695: l_customer_id_changed or
696: l_organization_id_changed or

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

876: p_is_history_flag
877: );
878: --
879: l_status_type_id_changed :=
880: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
881: p_booking_status_type_id);
882:
883: --Getting the old booking status to manipulate the fourm notification records
884: l_old_booking_status := ota_tdb_bus.booking_status_type(

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

1431: Else
1432: l_booking_status_type_id := p_booking_status_type_id;
1433: End If;
1434:
1435: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
1436: l_check_prereq := true;
1437: End If;
1438:
1439: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then

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

1435: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
1436: l_check_prereq := true;
1437: End If;
1438:
1439: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
1440: l_check_prereq := true;
1441: End If;
1442:
1443: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then

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

1439: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
1440: l_check_prereq := true;
1441: End If;
1442:
1443: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
1444: l_check_prereq := true;
1445: End If;
1446:
1447: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then

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

1443: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
1444: l_check_prereq := true;
1445: End If;
1446:
1447: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
1448: l_check_prereq := true;
1449: End If;
1450:
1451: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,