APPS.OTA_TRB_API_PROCEDURES dependencies on OTA_RESOURCE_ALLOCATIONS

Line 679: from ota_resource_allocations

675: -- cursor to perform the check
676: --
677: cursor chk_dates is
678: select 1
679: from ota_resource_allocations
680: where (trainer_resource_booking_id = p_resource_booking_id
681: OR equipment_resource_booking_id = p_resource_booking_id)
682: and (start_date < p_req_date_from OR end_date > p_req_date_to);
683: --

Line 704: -- in OTA_RESOURCE_ALLOCATIONS with this resource booking

700: -- |------------------------< check_tra_trainer_exists >----------------
701: -- ---------------------------------------------------------------------
702: -- PUBLIC
703: -- Description: A resource booking may not be deleted if a row exists
704: -- in OTA_RESOURCE_ALLOCATIONS with this resource booking
705: -- id.
706: --
707: procedure check_tra_trainer_exists(p_resource_booking_id in number) is
708: --

Line 716: from ota_resource_allocations

712: -- cursor to perform check
713: --
714: cursor chk_trn is
715: select 1
716: from ota_resource_allocations
717: where trainer_resource_booking_id = p_resource_booking_id;
718: --
719: begin
720: hr_utility.set_location('Entering:'||l_proc,5);

Line 740: -- OTA_RESOURCE_ALLOCATIONS.

736: -- ---------------------------------------------------------------------
737: -- PUBLIC
738: -- Description: A resource booking may not be deleted if in use as a
739: -- EQUIPMENT_RESOURCE_BOOKING_ID in
740: -- OTA_RESOURCE_ALLOCATIONS.
741: --
742: procedure check_tra_resource_exists(p_resource_booking_id in number) is
743: --
744: l_proc varchar2(72) := g_package||'check_tra_resource_exists';

Line 751: from ota_resource_allocations

747: -- cursor to perform check
748: --
749: cursor chk_res is
750: select 1
751: from ota_resource_allocations
752: where equipment_resource_booking_id = p_resource_booking_id;
753: --
754: begin
755: hr_utility.set_location('Entering:'||l_proc,5);

Line 1841: from ota_resource_allocations

1837: -- cursor to perform count
1838: --
1839: cursor get_count is
1840: select count(*)
1841: from ota_resource_allocations
1842: where equipment_resource_booking_id = p_resource_booking_id;
1843: --
1844: begin
1845: hr_utility.set_location('Entering:'||l_proc,5);