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_SSB_UPD dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: per_ssb_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: per_ssb_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

91: -- A check constraint has been violated
92: --
93: per_ssb_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_ssb_shd.constraint_error

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_ssb_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_ssb_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;
108: End update_dml;

Line 224: when hr_api.cannot_find_prog_unit then

220: );
221: --
222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'PER_RI_SETUP_SUB_TASKS'
228: ,p_hook_type => 'AU');

Line 226: hr_api.cannot_find_prog_unit_error

222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'PER_RI_SETUP_SUB_TASKS'
228: ,p_hook_type => 'AU');
229: --
230: end;

Line 289: If (p_rec.setup_task_code = hr_api.g_varchar2) then

285: -- p_rec plsql record structure
286: -- to see if a system default is being used. If a system default
287: -- is being used then we must set to the 'current' argument value.
288: --
289: If (p_rec.setup_task_code = hr_api.g_varchar2) then
290: p_rec.setup_task_code :=
291: per_ssb_shd.g_old_rec.setup_task_code;
292: End If;
293: If (p_rec.setup_sub_task_sequence = hr_api.g_number) then

Line 293: If (p_rec.setup_sub_task_sequence = hr_api.g_number) then

289: If (p_rec.setup_task_code = hr_api.g_varchar2) then
290: p_rec.setup_task_code :=
291: per_ssb_shd.g_old_rec.setup_task_code;
292: End If;
293: If (p_rec.setup_sub_task_sequence = hr_api.g_number) then
294: p_rec.setup_sub_task_sequence :=
295: per_ssb_shd.g_old_rec.setup_sub_task_sequence;
296: End If;
297: If (p_rec.setup_sub_task_status = hr_api.g_varchar2) then

Line 297: If (p_rec.setup_sub_task_status = hr_api.g_varchar2) then

293: If (p_rec.setup_sub_task_sequence = hr_api.g_number) then
294: p_rec.setup_sub_task_sequence :=
295: per_ssb_shd.g_old_rec.setup_sub_task_sequence;
296: End If;
297: If (p_rec.setup_sub_task_status = hr_api.g_varchar2) then
298: p_rec.setup_sub_task_status :=
299: per_ssb_shd.g_old_rec.setup_sub_task_status;
300: End If;
301: If (p_rec.setup_sub_task_type = hr_api.g_varchar2) then

Line 301: If (p_rec.setup_sub_task_type = hr_api.g_varchar2) then

297: If (p_rec.setup_sub_task_status = hr_api.g_varchar2) then
298: p_rec.setup_sub_task_status :=
299: per_ssb_shd.g_old_rec.setup_sub_task_status;
300: End If;
301: If (p_rec.setup_sub_task_type = hr_api.g_varchar2) then
302: p_rec.setup_sub_task_type :=
303: per_ssb_shd.g_old_rec.setup_sub_task_type;
304: End If;
305: If (p_rec.setup_sub_task_data_pump_link = hr_api.g_varchar2) then

Line 305: If (p_rec.setup_sub_task_data_pump_link = hr_api.g_varchar2) then

301: If (p_rec.setup_sub_task_type = hr_api.g_varchar2) then
302: p_rec.setup_sub_task_type :=
303: per_ssb_shd.g_old_rec.setup_sub_task_type;
304: End If;
305: If (p_rec.setup_sub_task_data_pump_link = hr_api.g_varchar2) then
306: p_rec.setup_sub_task_data_pump_link :=
307: per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link;
308: End If;
309: If (p_rec.setup_sub_task_action = hr_api.g_varchar2) then

Line 309: If (p_rec.setup_sub_task_action = hr_api.g_varchar2) then

305: If (p_rec.setup_sub_task_data_pump_link = hr_api.g_varchar2) then
306: p_rec.setup_sub_task_data_pump_link :=
307: per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link;
308: End If;
309: If (p_rec.setup_sub_task_action = hr_api.g_varchar2) then
310: p_rec.setup_sub_task_action :=
311: per_ssb_shd.g_old_rec.setup_sub_task_action;
312: End If;
313: If (p_rec.setup_sub_task_creation_date = hr_api.g_date) then

Line 313: If (p_rec.setup_sub_task_creation_date = hr_api.g_date) then

309: If (p_rec.setup_sub_task_action = hr_api.g_varchar2) then
310: p_rec.setup_sub_task_action :=
311: per_ssb_shd.g_old_rec.setup_sub_task_action;
312: End If;
313: If (p_rec.setup_sub_task_creation_date = hr_api.g_date) then
314: p_rec.setup_sub_task_creation_date :=
315: per_ssb_shd.g_old_rec.setup_sub_task_creation_date;
316: End If;
317: If (p_rec.setup_sub_task_last_mod_date = hr_api.g_date) then

Line 317: If (p_rec.setup_sub_task_last_mod_date = hr_api.g_date) then

313: If (p_rec.setup_sub_task_creation_date = hr_api.g_date) then
314: p_rec.setup_sub_task_creation_date :=
315: per_ssb_shd.g_old_rec.setup_sub_task_creation_date;
316: End If;
317: If (p_rec.setup_sub_task_last_mod_date = hr_api.g_date) then
318: p_rec.setup_sub_task_last_mod_date :=
319: per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date;
320: End If;
321: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 321: If (p_rec.legislation_code = hr_api.g_varchar2) then

317: If (p_rec.setup_sub_task_last_mod_date = hr_api.g_date) then
318: p_rec.setup_sub_task_last_mod_date :=
319: per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date;
320: End If;
321: If (p_rec.legislation_code = hr_api.g_varchar2) then
322: p_rec.legislation_code := per_ssb_shd.g_old_rec.legislation_code;
323: End If;
324:
325: --

Line 389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2

385: Procedure upd
386: (p_effective_date in date
387: ,p_setup_sub_task_code in varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2

Line 390: ,p_setup_sub_task_sequence in number default hr_api.g_number

386: (p_effective_date in date
387: ,p_setup_sub_task_code in varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2

Line 391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2

387: ,p_setup_sub_task_code in varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date

Line 392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2

388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date

Line 393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2

389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2

390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is

Line 395: ,p_setup_sub_task_creation_date in date default hr_api.g_date

391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is
399: --

Line 396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date

392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is
399: --
400: l_rec per_ssb_shd.g_rec_type;

Line 397: ,p_legislation_code in varchar2 default hr_api.g_varchar2

393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is
399: --
400: l_rec per_ssb_shd.g_rec_type;
401: l_proc varchar2(72) := g_package||'upd';