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

Line 88: When hr_api.check_integrity_violated Then

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

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

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

Line 93: When hr_api.parent_integrity_violated Then

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

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

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

Line 98: When hr_api.unique_integrity_violated Then

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

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

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

Line 218: when hr_api.cannot_find_prog_unit then

214: );
215: --
216: exception
217: --
218: when hr_api.cannot_find_prog_unit then
219: --
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'PER_RI_SETUP_TASKS'
222: ,p_hook_type => 'AU');

Line 220: hr_api.cannot_find_prog_unit_error

216: exception
217: --
218: when hr_api.cannot_find_prog_unit then
219: --
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'PER_RI_SETUP_TASKS'
222: ,p_hook_type => 'AU');
223: --
224: end;

Line 283: If (p_rec.workbench_item_code = hr_api.g_varchar2) then

279: -- p_rec plsql record structure
280: -- to see if a system default is being used. If a system default
281: -- is being used then we must set to the 'current' argument value.
282: --
283: If (p_rec.workbench_item_code = hr_api.g_varchar2) then
284: p_rec.workbench_item_code :=
285: per_stb_shd.g_old_rec.workbench_item_code;
286: End If;
287: If (p_rec.setup_task_sequence = hr_api.g_number) then

Line 287: If (p_rec.setup_task_sequence = hr_api.g_number) then

283: If (p_rec.workbench_item_code = hr_api.g_varchar2) then
284: p_rec.workbench_item_code :=
285: per_stb_shd.g_old_rec.workbench_item_code;
286: End If;
287: If (p_rec.setup_task_sequence = hr_api.g_number) then
288: p_rec.setup_task_sequence :=
289: per_stb_shd.g_old_rec.setup_task_sequence;
290: End If;
291: If (p_rec.setup_task_status = hr_api.g_varchar2) then

Line 291: If (p_rec.setup_task_status = hr_api.g_varchar2) then

287: If (p_rec.setup_task_sequence = hr_api.g_number) then
288: p_rec.setup_task_sequence :=
289: per_stb_shd.g_old_rec.setup_task_sequence;
290: End If;
291: If (p_rec.setup_task_status = hr_api.g_varchar2) then
292: p_rec.setup_task_status :=
293: per_stb_shd.g_old_rec.setup_task_status;
294: End If;
295: If (p_rec.setup_task_creation_date = hr_api.g_date) then

Line 295: If (p_rec.setup_task_creation_date = hr_api.g_date) then

291: If (p_rec.setup_task_status = hr_api.g_varchar2) then
292: p_rec.setup_task_status :=
293: per_stb_shd.g_old_rec.setup_task_status;
294: End If;
295: If (p_rec.setup_task_creation_date = hr_api.g_date) then
296: p_rec.setup_task_creation_date :=
297: per_stb_shd.g_old_rec.setup_task_creation_date;
298: End If;
299: If (p_rec.setup_task_last_modified_date = hr_api.g_date) then

Line 299: If (p_rec.setup_task_last_modified_date = hr_api.g_date) then

295: If (p_rec.setup_task_creation_date = hr_api.g_date) then
296: p_rec.setup_task_creation_date :=
297: per_stb_shd.g_old_rec.setup_task_creation_date;
298: End If;
299: If (p_rec.setup_task_last_modified_date = hr_api.g_date) then
300: p_rec.setup_task_last_modified_date :=
301: per_stb_shd.g_old_rec.setup_task_last_modified_date;
302: End If;
303: If (p_rec.setup_task_type = hr_api.g_varchar2) then

Line 303: If (p_rec.setup_task_type = hr_api.g_varchar2) then

299: If (p_rec.setup_task_last_modified_date = hr_api.g_date) then
300: p_rec.setup_task_last_modified_date :=
301: per_stb_shd.g_old_rec.setup_task_last_modified_date;
302: End If;
303: If (p_rec.setup_task_type = hr_api.g_varchar2) then
304: p_rec.setup_task_type :=
305: per_stb_shd.g_old_rec.setup_task_type;
306: End If;
307: If (p_rec.setup_task_action = hr_api.g_varchar2) then

Line 307: If (p_rec.setup_task_action = hr_api.g_varchar2) then

303: If (p_rec.setup_task_type = hr_api.g_varchar2) then
304: p_rec.setup_task_type :=
305: per_stb_shd.g_old_rec.setup_task_type;
306: End If;
307: If (p_rec.setup_task_action = hr_api.g_varchar2) then
308: p_rec.setup_task_action :=
309: per_stb_shd.g_old_rec.setup_task_action;
310: End If;
311: --

Line 375: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2

371: Procedure upd
372: (p_effective_date in date
373: ,p_setup_task_code in varchar2
374: ,p_object_version_number in out nocopy number
375: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
376: ,p_setup_task_sequence in number default hr_api.g_number
377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
378: ,p_setup_task_creation_date in date default hr_api.g_date
379: ,p_setup_task_last_modified_dat in date default hr_api.g_date

Line 376: ,p_setup_task_sequence in number default hr_api.g_number

372: (p_effective_date in date
373: ,p_setup_task_code in varchar2
374: ,p_object_version_number in out nocopy number
375: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
376: ,p_setup_task_sequence in number default hr_api.g_number
377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
378: ,p_setup_task_creation_date in date default hr_api.g_date
379: ,p_setup_task_last_modified_dat in date default hr_api.g_date
380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2

Line 377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2

373: ,p_setup_task_code in varchar2
374: ,p_object_version_number in out nocopy number
375: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
376: ,p_setup_task_sequence in number default hr_api.g_number
377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
378: ,p_setup_task_creation_date in date default hr_api.g_date
379: ,p_setup_task_last_modified_dat in date default hr_api.g_date
380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
381: ,p_setup_task_action in varchar2 default hr_api.g_varchar2

Line 378: ,p_setup_task_creation_date in date default hr_api.g_date

374: ,p_object_version_number in out nocopy number
375: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
376: ,p_setup_task_sequence in number default hr_api.g_number
377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
378: ,p_setup_task_creation_date in date default hr_api.g_date
379: ,p_setup_task_last_modified_dat in date default hr_api.g_date
380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
381: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
382: ) is

Line 379: ,p_setup_task_last_modified_dat in date default hr_api.g_date

375: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
376: ,p_setup_task_sequence in number default hr_api.g_number
377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
378: ,p_setup_task_creation_date in date default hr_api.g_date
379: ,p_setup_task_last_modified_dat in date default hr_api.g_date
380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
381: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
382: ) is
383: --

Line 380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2

376: ,p_setup_task_sequence in number default hr_api.g_number
377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
378: ,p_setup_task_creation_date in date default hr_api.g_date
379: ,p_setup_task_last_modified_dat in date default hr_api.g_date
380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
381: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
382: ) is
383: --
384: l_rec per_stb_shd.g_rec_type;

Line 381: ,p_setup_task_action in varchar2 default hr_api.g_varchar2

377: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
378: ,p_setup_task_creation_date in date default hr_api.g_date
379: ,p_setup_task_last_modified_dat in date default hr_api.g_date
380: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
381: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
382: ) is
383: --
384: l_rec per_stb_shd.g_rec_type;
385: l_proc varchar2(72) := g_package||'upd';