DBA Data[Home] [Help]

APPS.OTA_OM_TDB_WAITLIST_API dependencies on HR_API

Line 122: and a.booking_id <> nvl(p_booking_id, hr_api.g_number);

118: where a.event_id = p_event_id
119: and a.booking_status_type_id = b.booking_status_type_id
120: and b.type in ('P','A')
121: and a.internal_booking_flag = 'Y'
122: and a.booking_id <> nvl(p_booking_id, hr_api.g_number);
123:
124:
125: l_proc varchar2(72) := g_package||'AUTO_ENROLL_FROM_WAITLIST';
126: l_count number(9) := 1;

Line 168: when hr_api.cannot_find_prog_unit then

164: (p_business_group_id => p_business_group_id
165: ,p_event_id => p_event_id
166: );
167: exception
168: when hr_api.cannot_find_prog_unit then
169: hr_api.cannot_find_prog_unit_error
170: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
171: ,p_hook_type => 'BP'
172: );

Line 169: hr_api.cannot_find_prog_unit_error

165: ,p_event_id => p_event_id
166: );
167: exception
168: when hr_api.cannot_find_prog_unit then
169: hr_api.cannot_find_prog_unit_error
170: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
171: ,p_hook_type => 'BP'
172: );
173: end;

Line 428: when hr_api.cannot_find_prog_unit then

424: (p_business_group_id => p_business_group_id
425: ,p_event_id => p_event_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
431: ,p_hook_type => 'AP'
432: );

Line 429: hr_api.cannot_find_prog_unit_error

425: ,p_event_id => p_event_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'AUTO_ENROLL_FROM_WAITLIST'
431: ,p_hook_type => 'AP'
432: );
433: end;

Line 439: raise hr_api.validate_enabled;

435: --
436: -- When in validation only mode raise the Validate_Enabled exception
437: --
438: if p_validate then
439: raise hr_api.validate_enabled;
440: end if;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 70);
443: exception

Line 444: when hr_api.validate_enabled then

440: end if;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 70);
443: exception
444: when hr_api.validate_enabled then
445: --
446: -- As the Validate_Enabled exception has been raised
447: -- we must rollback to the savepoint
448: --