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 690: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);

686: 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;
687: 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;
688:
689:
690: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
691: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
692: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
693: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
694: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);

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

687: 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;
688:
689:
690: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
691: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
692: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
693: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
694: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
695:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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