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.PER_SUPPLEMENTARY_ROLE_API dependencies on PER_ROLES

Line 74: l_role_id per_roles.role_id%TYPE;

70: --
71: -- Declare cursors and local variables
72: --
73: l_proc varchar2(72) := g_package||'create_role';
74: l_role_id per_roles.role_id%TYPE;
75: l_object_version_number per_roles.object_version_number%TYPE;
76: l_effective_date date;
77: l_start_date per_roles.start_date%TYPE;
78: l_end_date per_roles.end_date%TYPE;

Line 75: l_object_version_number per_roles.object_version_number%TYPE;

71: -- Declare cursors and local variables
72: --
73: l_proc varchar2(72) := g_package||'create_role';
74: l_role_id per_roles.role_id%TYPE;
75: l_object_version_number per_roles.object_version_number%TYPE;
76: l_effective_date date;
77: l_start_date per_roles.start_date%TYPE;
78: l_end_date per_roles.end_date%TYPE;
79: l_confidential_date per_roles.confidential_date%TYPE;

Line 77: l_start_date per_roles.start_date%TYPE;

73: l_proc varchar2(72) := g_package||'create_role';
74: l_role_id per_roles.role_id%TYPE;
75: l_object_version_number per_roles.object_version_number%TYPE;
76: l_effective_date date;
77: l_start_date per_roles.start_date%TYPE;
78: l_end_date per_roles.end_date%TYPE;
79: l_confidential_date per_roles.confidential_date%TYPE;
80: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
81: --

Line 78: l_end_date per_roles.end_date%TYPE;

74: l_role_id per_roles.role_id%TYPE;
75: l_object_version_number per_roles.object_version_number%TYPE;
76: l_effective_date date;
77: l_start_date per_roles.start_date%TYPE;
78: l_end_date per_roles.end_date%TYPE;
79: l_confidential_date per_roles.confidential_date%TYPE;
80: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
81: --
82: begin

Line 79: l_confidential_date per_roles.confidential_date%TYPE;

75: l_object_version_number per_roles.object_version_number%TYPE;
76: l_effective_date date;
77: l_start_date per_roles.start_date%TYPE;
78: l_end_date per_roles.end_date%TYPE;
79: l_confidential_date per_roles.confidential_date%TYPE;
80: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
81: --
82: begin
83: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 80: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;

76: l_effective_date date;
77: l_start_date per_roles.start_date%TYPE;
78: l_end_date per_roles.end_date%TYPE;
79: l_confidential_date per_roles.confidential_date%TYPE;
80: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
81: --
82: begin
83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --

Line 396: l_role_id per_roles.role_id%TYPE;

392: --
393: -- Declare cursors and local variables
394: --
395: l_proc varchar2(72) := g_package||'update_role';
396: l_role_id per_roles.role_id%TYPE;
397: l_object_version_number per_roles.object_version_number%TYPE;
398: l_effective_date date;
399: l_start_date per_roles.start_date%TYPE;
400: l_end_date per_roles.end_date%TYPE;

Line 397: l_object_version_number per_roles.object_version_number%TYPE;

393: -- Declare cursors and local variables
394: --
395: l_proc varchar2(72) := g_package||'update_role';
396: l_role_id per_roles.role_id%TYPE;
397: l_object_version_number per_roles.object_version_number%TYPE;
398: l_effective_date date;
399: l_start_date per_roles.start_date%TYPE;
400: l_end_date per_roles.end_date%TYPE;
401: l_confidential_date per_roles.confidential_date%TYPE;

Line 399: l_start_date per_roles.start_date%TYPE;

395: l_proc varchar2(72) := g_package||'update_role';
396: l_role_id per_roles.role_id%TYPE;
397: l_object_version_number per_roles.object_version_number%TYPE;
398: l_effective_date date;
399: l_start_date per_roles.start_date%TYPE;
400: l_end_date per_roles.end_date%TYPE;
401: l_confidential_date per_roles.confidential_date%TYPE;
402: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
403: l_old_end_date per_roles.old_end_date%TYPE; -- fix 1370960

Line 400: l_end_date per_roles.end_date%TYPE;

396: l_role_id per_roles.role_id%TYPE;
397: l_object_version_number per_roles.object_version_number%TYPE;
398: l_effective_date date;
399: l_start_date per_roles.start_date%TYPE;
400: l_end_date per_roles.end_date%TYPE;
401: l_confidential_date per_roles.confidential_date%TYPE;
402: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
403: l_old_end_date per_roles.old_end_date%TYPE; -- fix 1370960
404: l_temp_ovn number;

Line 401: l_confidential_date per_roles.confidential_date%TYPE;

397: l_object_version_number per_roles.object_version_number%TYPE;
398: l_effective_date date;
399: l_start_date per_roles.start_date%TYPE;
400: l_end_date per_roles.end_date%TYPE;
401: l_confidential_date per_roles.confidential_date%TYPE;
402: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
403: l_old_end_date per_roles.old_end_date%TYPE; -- fix 1370960
404: l_temp_ovn number;
405: --

Line 402: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;

398: l_effective_date date;
399: l_start_date per_roles.start_date%TYPE;
400: l_end_date per_roles.end_date%TYPE;
401: l_confidential_date per_roles.confidential_date%TYPE;
402: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
403: l_old_end_date per_roles.old_end_date%TYPE; -- fix 1370960
404: l_temp_ovn number;
405: --
406: begin

Line 403: l_old_end_date per_roles.old_end_date%TYPE; -- fix 1370960

399: l_start_date per_roles.start_date%TYPE;
400: l_end_date per_roles.end_date%TYPE;
401: l_confidential_date per_roles.confidential_date%TYPE;
402: l_end_of_rights_date per_roles.end_of_rights_date%TYPE;
403: l_old_end_date per_roles.old_end_date%TYPE; -- fix 1370960
404: l_temp_ovn number;
405: --
406: begin
407: hr_utility.set_location('Entering:'|| l_proc, 10);