DBA Data[Home] [Help]

APPS.OTA_TRB_API_PROCEDURES dependencies on OTA_UTILITY

Line 499: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810);

495: open get_event_dates;
496: fetch get_event_dates into l_start_date,l_end_date,l_event_type,l_timezone,l_start_time,l_end_time;
497: close get_event_dates;
498: if l_event_type <> 'SESSION' then
499: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810);
500: else
501: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','S',810);
502: end if;
503:

Line 501: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','S',810);

497: close get_event_dates;
498: if l_event_type <> 'SESSION' then
499: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CL',810);
500: else
501: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','S',810);
502: end if;
503:
504: elsif p_chat_id is not null then
505: l_id_passed :=true;

Line 509: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CHT',810);

505: l_id_passed :=true;
506: open get_chat_dates;
507: fetch get_chat_dates into l_start_date,l_end_date,l_timezone;
508: close get_chat_dates;
509: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CHT',810);
510: elsif p_forum_id is not null then
511: l_id_passed :=true;
512: open get_forum_dates;
513: fetch get_forum_dates into l_start_date,l_end_date;

Line 515: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','FRM',810);

511: l_id_passed :=true;
512: open get_forum_dates;
513: fetch get_forum_dates into l_start_date,l_end_date;
514: close get_forum_dates;
515: l_token := ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','FRM',810);
516: end if;
517: --
518: p_warning := 'N';
519:

Line 1926: ota_utility.ignore_dff_validation('OTA_RESOURCE_BOOKINGS');

1922: fetch get_event_timezone into l_event_timezone;
1923: close get_event_timezone;
1924:
1925: -- bug 3891115
1926: ota_utility.ignore_dff_validation('OTA_RESOURCE_BOOKINGS');
1927: --
1928: ota_resource_booking.ins(p_resource_booking_id => l_resource_booking_id,
1929: p_supplied_resource_id => l_supplied_resource_id,
1930: p_event_id => p_event_id,