eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: , p_status_change_comments in varchar2 default hr_api.g_varchar2
25: ) IS

Line 24: , p_status_change_comments in varchar2 default hr_api.g_varchar2

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: , p_status_change_comments in varchar2 default hr_api.g_varchar2
25: ) IS
26: --
27: cursor csr_after_date is
28: select assignment_status_id, object_Version_number

Line 56: l_assignment_status_type_id := hr_api.g_number;

52: p_object_version_number => c_rec.object_version_number);
53: end loop;
54: end if;
55: --+
56: l_assignment_status_type_id := hr_api.g_number;
57: --+
58: open csr_get_status;
59: fetch csr_get_Status into l_assignment_Status_Type_id;
60: close csr_get_status;

Line 62: if p_status_change_reason = hr_api.g_varchar2 then

58: open csr_get_status;
59: fetch csr_get_Status into l_assignment_Status_Type_id;
60: close csr_get_status;
61: --+
62: if p_status_change_reason = hr_api.g_varchar2 then
63: l_status_change_reason := null;
64: end if;
65: --+
66: if l_assignment_status_type_id <> p_assignment_status_type_id then

Line 78: if l_status_change_comments = hr_api.g_varchar2 then

74: ,p_object_version_number => p_object_version_number
75: ,p_status_change_comments => p_status_change_comments);
76: --+
77: else
78: if l_status_change_comments = hr_api.g_varchar2 then
79: l_status_change_comments := null;
80: end if;
81: create_irc_asg_status
82: (p_validate => p_validate

Line 288: if p_status_change_reason = hr_api.g_varchar2 then

284: --
285: end if;
286:
287: --+
288: if p_status_change_reason = hr_api.g_varchar2 then
289: l_status_change_reason := null;
290: end if;
291: --+
292: --

Line 306: when hr_api.cannot_find_prog_unit then

302: , p_status_change_comments => p_status_change_comments
303: , p_status_change_by => l_status_change_by
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'create_irc_asg_status'
309: ,p_hook_type => 'BP'
310: );

Line 307: hr_api.cannot_find_prog_unit_error

303: , p_status_change_by => l_status_change_by
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'create_irc_asg_status'
309: ,p_hook_type => 'BP'
310: );
311: end;

Line 364: when hr_api.cannot_find_prog_unit then

360: , p_status_change_comments => p_status_change_comments
361: , p_status_change_by => l_status_change_by
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'create_irc_asg_status'
367: ,p_hook_type => 'AP'
368: );

Line 365: hr_api.cannot_find_prog_unit_error

361: , p_status_change_by => l_status_change_by
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'create_irc_asg_status'
367: ,p_hook_type => 'AP'
368: );
369: end;

Line 374: raise hr_api.validate_enabled;

370: --
371: -- When in validation only mode raise the Validate_Enabled exception
372: --
373: if p_validate then
374: raise hr_api.validate_enabled;
375: end if;
376: --
377: -- Set all output arguments
378: --

Line 384: when hr_api.validate_enabled then

380: p_object_version_number := l_object_version_number;
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 70);
383: exception
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised
387: -- we must rollback to the savepoint
388: --

Line 423: , p_status_change_reason in varchar2 default hr_api.g_varchar2

419: --
420: procedure update_irc_asg_status
421: (
422: p_validate in boolean default false
423: , p_status_change_reason in varchar2 default hr_api.g_varchar2
424: , p_status_change_date in date
425: , p_assignment_status_id in number
426: , p_object_version_number in out nocopy number
427: , p_status_change_comments in varchar2 default hr_api.g_varchar2

Line 427: , p_status_change_comments in varchar2 default hr_api.g_varchar2

423: , p_status_change_reason in varchar2 default hr_api.g_varchar2
424: , p_status_change_date in date
425: , p_assignment_status_id in number
426: , p_object_version_number in out nocopy number
427: , p_status_change_comments in varchar2 default hr_api.g_varchar2
428: ) is
429: --
430: -- Declare cursors and local variables
431: --

Line 455: if p_status_change_reason = hr_api.g_varchar2 then

451: else
452: l_status_change_date := p_status_change_date;
453: end if;
454: --+
455: if p_status_change_reason = hr_api.g_varchar2 then
456: l_status_change_reason := null;
457: end if;
458: --+
459: --

Line 472: when hr_api.cannot_find_prog_unit then

468: , p_object_version_number => l_object_version_number
469: , p_status_change_comments => p_status_change_comments
470: );
471: exception
472: when hr_api.cannot_find_prog_unit then
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'update_irc_asg_status'
475: ,p_hook_type => 'BP'
476: );

Line 473: hr_api.cannot_find_prog_unit_error

469: , p_status_change_comments => p_status_change_comments
470: );
471: exception
472: when hr_api.cannot_find_prog_unit then
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'update_irc_asg_status'
475: ,p_hook_type => 'BP'
476: );
477: end;

Line 502: when hr_api.cannot_find_prog_unit then

498: , p_object_version_number => l_object_version_number
499: , p_status_change_comments => p_status_change_comments
500: );
501: exception
502: when hr_api.cannot_find_prog_unit then
503: hr_api.cannot_find_prog_unit_error
504: (p_module_name => 'update_irc_asg_status'
505: ,p_hook_type => 'AP'
506: );

Line 503: hr_api.cannot_find_prog_unit_error

499: , p_status_change_comments => p_status_change_comments
500: );
501: exception
502: when hr_api.cannot_find_prog_unit then
503: hr_api.cannot_find_prog_unit_error
504: (p_module_name => 'update_irc_asg_status'
505: ,p_hook_type => 'AP'
506: );
507: end;

Line 512: raise hr_api.validate_enabled;

508: --
509: -- When in validation only mode raise the Validate_Enabled exception
510: --
511: if p_validate then
512: raise hr_api.validate_enabled;
513: end if;
514: --
515: -- Set all output arguments
516: --

Line 522: when hr_api.validate_enabled then

518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 70);
520: --
521: exception
522: when hr_api.validate_enabled then
523: --
524: -- As the Validate_Enabled exception has been raised
525: -- we must rollback to the savepoint
526: --

Line 578: when hr_api.cannot_find_prog_unit then

574: p_assignment_status_id => p_assignment_status_id
575: , p_object_version_number => p_object_version_number
576: );
577: exception
578: when hr_api.cannot_find_prog_unit then
579: hr_api.cannot_find_prog_unit_error
580: (p_module_name => 'delete_irc_asg_status'
581: ,p_hook_type => 'BP'
582: );

Line 579: hr_api.cannot_find_prog_unit_error

575: , p_object_version_number => p_object_version_number
576: );
577: exception
578: when hr_api.cannot_find_prog_unit then
579: hr_api.cannot_find_prog_unit_error
580: (p_module_name => 'delete_irc_asg_status'
581: ,p_hook_type => 'BP'
582: );
583: end;

Line 601: when hr_api.cannot_find_prog_unit then

597: p_assignment_status_id => p_assignment_status_id
598: , p_object_version_number => p_object_version_number
599: );
600: exception
601: when hr_api.cannot_find_prog_unit then
602: hr_api.cannot_find_prog_unit_error
603: (p_module_name => 'delete_irc_asg_status'
604: ,p_hook_type => 'AP'
605: );

Line 602: hr_api.cannot_find_prog_unit_error

598: , p_object_version_number => p_object_version_number
599: );
600: exception
601: when hr_api.cannot_find_prog_unit then
602: hr_api.cannot_find_prog_unit_error
603: (p_module_name => 'delete_irc_asg_status'
604: ,p_hook_type => 'AP'
605: );
606: end;

Line 611: raise hr_api.validate_enabled;

607: --
608: -- When in validation only mode raise the Validate_Enabled exception
609: --
610: if p_validate then
611: raise hr_api.validate_enabled;
612: end if;
613: --
614: -- Set all output arguments
615: --

Line 618: when hr_api.validate_enabled then

614: -- Set all output arguments
615: --
616: hr_utility.set_location(' Leaving:'||l_proc, 70);
617: exception
618: when hr_api.validate_enabled then
619: --
620: -- As the Validate_Enabled exception has been raised
621: -- we must rollback to the savepoint
622: --