DBA Data[Home] [Help]

APPS.IRC_ASG_STATUS_API dependencies on HR_API

Line 21: , p_status_change_reason in varchar2 default hr_api.g_varchar2

17: , p_datetrack_mode in varchar2
18: , p_assignment_id in number
19: , p_assignment_status_type_id in number
20: , p_status_change_date in date
21: , p_status_change_reason in varchar2 default hr_api.g_varchar2
22: , p_assignment_status_id out nocopy number
23: , p_object_version_number out nocopy number
24: ) IS
25:

Line 50: l_assignment_status_type_id := hr_api.g_number;

46: p_object_version_number => c_rec.object_version_number);
47: end loop;
48: end if;
49:
50: l_assignment_status_type_id := hr_api.g_number;
51:
52: open csr_get_status;
53: fetch csr_get_Status into l_assignment_Status_Type_id;
54: close csr_get_status;

Line 250: when hr_api.cannot_find_prog_unit then

246: , p_status_change_reason =>p_status_change_reason
247: , p_status_change_date =>l_status_change_date
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'create_irc_asg_status'
253: ,p_hook_type => 'BP'
254: );

Line 251: hr_api.cannot_find_prog_unit_error

247: , p_status_change_date =>l_status_change_date
248: );
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'create_irc_asg_status'
253: ,p_hook_type => 'BP'
254: );
255: end;

Line 290: when hr_api.cannot_find_prog_unit then

286: , p_object_version_number =>l_object_version_number
287: , p_status_change_date =>l_status_change_date
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'create_irc_asg_status'
293: ,p_hook_type => 'AP'
294: );

Line 291: hr_api.cannot_find_prog_unit_error

287: , p_status_change_date =>l_status_change_date
288: );
289: exception
290: when hr_api.cannot_find_prog_unit then
291: hr_api.cannot_find_prog_unit_error
292: (p_module_name => 'create_irc_asg_status'
293: ,p_hook_type => 'AP'
294: );
295: end;

Line 300: raise hr_api.validate_enabled;

296: --
297: -- When in validation only mode raise the Validate_Enabled exception
298: --
299: if p_validate then
300: raise hr_api.validate_enabled;
301: end if;
302: --
303: -- Set all output arguments
304: --

Line 310: when hr_api.validate_enabled then

306: p_object_version_number := l_object_version_number;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 70);
309: exception
310: when hr_api.validate_enabled then
311: --
312: -- As the Validate_Enabled exception has been raised
313: -- we must rollback to the savepoint
314: --

Line 349: , p_status_change_reason in varchar2 default hr_api.g_varchar2

345: --
346: procedure update_irc_asg_status
347: (
348: p_validate in boolean default false
349: , p_status_change_reason in varchar2 default hr_api.g_varchar2
350: , p_status_change_date in date
351: , p_assignment_status_id in number
352: , p_object_version_number in out nocopy number
353: ) is

Line 390: when hr_api.cannot_find_prog_unit then

386: , p_assignment_status_id => p_assignment_status_id
387: , p_object_version_number => l_object_version_number
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'update_irc_asg_status'
393: ,p_hook_type => 'BP'
394: );

Line 391: hr_api.cannot_find_prog_unit_error

387: , p_object_version_number => l_object_version_number
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'update_irc_asg_status'
393: ,p_hook_type => 'BP'
394: );
395: end;

Line 418: when hr_api.cannot_find_prog_unit then

414: , p_assignment_status_id => p_assignment_status_id
415: , p_object_version_number => l_object_version_number
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'update_irc_asg_status'
421: ,p_hook_type => 'AP'
422: );

Line 419: hr_api.cannot_find_prog_unit_error

415: , p_object_version_number => l_object_version_number
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'update_irc_asg_status'
421: ,p_hook_type => 'AP'
422: );
423: end;

Line 428: raise hr_api.validate_enabled;

424: --
425: -- When in validation only mode raise the Validate_Enabled exception
426: --
427: if p_validate then
428: raise hr_api.validate_enabled;
429: end if;
430: --
431: -- Set all output arguments
432: --

Line 438: when hr_api.validate_enabled then

434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 70);
436: --
437: exception
438: when hr_api.validate_enabled then
439: --
440: -- As the Validate_Enabled exception has been raised
441: -- we must rollback to the savepoint
442: --

Line 494: when hr_api.cannot_find_prog_unit then

490: p_assignment_status_id => p_assignment_status_id
491: , p_object_version_number => p_object_version_number
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'delete_irc_asg_status'
497: ,p_hook_type => 'BP'
498: );

Line 495: hr_api.cannot_find_prog_unit_error

491: , p_object_version_number => p_object_version_number
492: );
493: exception
494: when hr_api.cannot_find_prog_unit then
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'delete_irc_asg_status'
497: ,p_hook_type => 'BP'
498: );
499: end;

Line 517: when hr_api.cannot_find_prog_unit then

513: p_assignment_status_id => p_assignment_status_id
514: , p_object_version_number => p_object_version_number
515: );
516: exception
517: when hr_api.cannot_find_prog_unit then
518: hr_api.cannot_find_prog_unit_error
519: (p_module_name => 'delete_irc_asg_status'
520: ,p_hook_type => 'AP'
521: );

Line 518: hr_api.cannot_find_prog_unit_error

514: , p_object_version_number => p_object_version_number
515: );
516: exception
517: when hr_api.cannot_find_prog_unit then
518: hr_api.cannot_find_prog_unit_error
519: (p_module_name => 'delete_irc_asg_status'
520: ,p_hook_type => 'AP'
521: );
522: end;

Line 527: raise hr_api.validate_enabled;

523: --
524: -- When in validation only mode raise the Validate_Enabled exception
525: --
526: if p_validate then
527: raise hr_api.validate_enabled;
528: end if;
529: --
530: -- Set all output arguments
531: --

Line 534: when hr_api.validate_enabled then

530: -- Set all output arguments
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 70);
533: exception
534: when hr_api.validate_enabled then
535: --
536: -- As the Validate_Enabled exception has been raised
537: -- we must rollback to the savepoint
538: --