APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_GENERAL

Line 1120: l_booking_status_changed boolean := ota_general.value_changed(

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

Line 1124: l_number_of_places_changed boolean := ota_general.value_changed(

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,
1126: p_number_of_places);
1127:
1128: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);

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

1904: 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;
1905: 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;
1906:
1907:
1908: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
1909: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
1910: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
1911: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
1912: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);

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

1905: 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;
1906:
1907:
1908: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
1909: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
1910: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
1911: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
1912: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
1913:

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

1906:
1907:
1908: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
1909: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
1910: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
1911: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
1912: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
1913:
1914: IF l_event_id_changed or

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

1907:
1908: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
1909: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
1910: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
1911: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
1912: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
1913:
1914: IF l_event_id_changed or
1915: l_customer_id_changed or

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

1908: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
1909: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
1910: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
1911: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
1912: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
1913:
1914: IF l_event_id_changed or
1915: l_customer_id_changed or
1916: l_organization_id_changed or

Line 1940: l_booking_status_type_changed := ota_general.value_changed(l_existing_booking_status_id,l_new_booking_status_type_id);

1936:
1937: IF l_new_booking_status_type_id = hr_api.g_number THEN
1938: l_new_booking_status_type_id := l_existing_booking_status_id;
1939: END IF;
1940: l_booking_status_type_changed := ota_general.value_changed(l_existing_booking_status_id,l_new_booking_status_type_id);
1941:
1942: IF l_booking_status_type_changed then
1943: l_date_status_changed := trunc(sysdate);
1944: END IF;

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