APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_GENERAL

Line 1279: l_booking_status_changed boolean := ota_general.value_changed(

1275:
1276: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1277: p_booking_status_type_id);
1278:
1279: l_booking_status_changed boolean := ota_general.value_changed(
1280: ota_tdb_shd.g_old_rec.booking_status_type_id,
1281: p_booking_status_type_id);
1282:
1283: l_number_of_places_changed boolean := ota_general.value_changed(

Line 1283: l_number_of_places_changed boolean := ota_general.value_changed(

1279: l_booking_status_changed boolean := ota_general.value_changed(
1280: ota_tdb_shd.g_old_rec.booking_status_type_id,
1281: p_booking_status_type_id);
1282:
1283: l_number_of_places_changed boolean := ota_general.value_changed(
1284: ota_tdb_shd.g_old_rec.number_of_places,
1285: p_number_of_places);
1286:
1287: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);

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

2095: 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;
2096: 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;
2097:
2098:
2099: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
2100: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
2101: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
2102: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
2103: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);

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

2096: 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;
2097:
2098:
2099: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
2100: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
2101: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
2102: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
2103: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
2104:

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

2097:
2098:
2099: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
2100: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
2101: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
2102: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
2103: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
2104:
2105: IF l_event_id_changed or

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

2098:
2099: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
2100: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
2101: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
2102: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
2103: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
2104:
2105: IF l_event_id_changed or
2106: l_customer_id_changed or

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

2099: l_event_id_changed := ota_general.value_changed( l_enr_details_rec.event_id, l_new_event_id);
2100: l_customer_id_changed := ota_general.value_changed( l_enr_details_rec.customer_id, l_new_customer_id);
2101: l_organization_id_changed := ota_general.value_changed( l_enr_details_rec.organization_id, l_new_organization_id);
2102: l_delegate_person_id_changed := ota_general.value_changed( l_enr_details_rec.delegate_person_id, l_new_delegate_person_id);
2103: l_delegate_asg_changed := ota_general.value_changed( l_enr_details_rec.delegate_assignment_id, l_new_del_asg_id);
2104:
2105: IF l_event_id_changed or
2106: l_customer_id_changed or
2107: l_organization_id_changed or

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

2137:
2138: IF l_new_booking_status_type_id = hr_api.g_number THEN
2139: l_new_booking_status_type_id := l_existing_booking_status_id;
2140: END IF;
2141: l_booking_status_type_changed := ota_general.value_changed(l_existing_booking_status_id,l_new_booking_status_type_id);
2142:
2143: IF l_booking_status_type_changed then
2144: l_date_status_changed := trunc(sysdate);
2145: END IF;

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

2447: );
2448: */
2449: --
2450: l_status_type_id_changed :=
2451: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
2452: l_new_booking_status_type_id);
2453:
2454: -- Getting the old booking status to manipulate the fourm notification records
2455: l_old_booking_status := ota_tdb_bus.booking_status_type(

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

3463: Else
3464: l_booking_status_type_id := p_booking_status_type_id;
3465: End If;
3466:
3467: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
3468: l_check_prereq := true;
3469: End If;
3470:
3471: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then

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

3467: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_person_id, l_delegate_person_id) ) Then
3468: l_check_prereq := true;
3469: End If;
3470:
3471: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
3472: l_check_prereq := true;
3473: End If;
3474:
3475: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then

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

3471: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.delegate_contact_id, l_delegate_contact_id) ) Then
3472: l_check_prereq := true;
3473: End If;
3474:
3475: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
3476: l_check_prereq := true;
3477: End If;
3478:
3479: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then

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

3475: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.customer_id, l_customer_id) ) Then
3476: l_check_prereq := true;
3477: End If;
3478:
3479: If (ota_general.value_changed (ota_tdb_shd.g_old_rec.event_id, l_event_id) ) Then
3480: l_check_prereq := true;
3481: End If;
3482:
3483: ota_utility.get_booking_status_type(p_status_type_id => ota_tdb_shd.g_old_rec.booking_status_type_id,