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.OTA_CPR_UPD dependencies on HR_API

Line 86: When hr_api.check_integrity_violated Then

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

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

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

Line 91: When hr_api.parent_integrity_violated Then

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

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

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

Line 96: When hr_api.unique_integrity_violated Then

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

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

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

Line 219: when hr_api.cannot_find_prog_unit then

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

Line 221: hr_api.cannot_find_prog_unit_error

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

Line 284: If (p_rec.business_group_id = hr_api.g_number) then

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

Line 288: If (p_rec.prerequisite_type = hr_api.g_varchar2) then

284: If (p_rec.business_group_id = hr_api.g_number) then
285: p_rec.business_group_id :=
286: ota_cpr_shd.g_old_rec.business_group_id;
287: End If;
288: If (p_rec.prerequisite_type = hr_api.g_varchar2) then
289: p_rec.prerequisite_type :=
290: ota_cpr_shd.g_old_rec.prerequisite_type;
291: End If;
292: If (p_rec.enforcement_mode = hr_api.g_varchar2) then

Line 292: If (p_rec.enforcement_mode = hr_api.g_varchar2) then

288: If (p_rec.prerequisite_type = hr_api.g_varchar2) then
289: p_rec.prerequisite_type :=
290: ota_cpr_shd.g_old_rec.prerequisite_type;
291: End If;
292: If (p_rec.enforcement_mode = hr_api.g_varchar2) then
293: p_rec.enforcement_mode :=
294: ota_cpr_shd.g_old_rec.enforcement_mode;
295: End If;
296: --

Line 362: ,p_business_group_id in number default hr_api.g_number

358: (p_effective_date in date
359: ,p_activity_version_id in number
360: ,p_prerequisite_course_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_business_group_id in number default hr_api.g_number
363: ,p_prerequisite_type in varchar2 default hr_api.g_varchar2
364: ,p_enforcement_mode in varchar2 default hr_api.g_varchar2
365: ) is
366: --

Line 363: ,p_prerequisite_type in varchar2 default hr_api.g_varchar2

359: ,p_activity_version_id in number
360: ,p_prerequisite_course_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_business_group_id in number default hr_api.g_number
363: ,p_prerequisite_type in varchar2 default hr_api.g_varchar2
364: ,p_enforcement_mode in varchar2 default hr_api.g_varchar2
365: ) is
366: --
367: l_rec ota_cpr_shd.g_rec_type;

Line 364: ,p_enforcement_mode in varchar2 default hr_api.g_varchar2

360: ,p_prerequisite_course_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_business_group_id in number default hr_api.g_number
363: ,p_prerequisite_type in varchar2 default hr_api.g_varchar2
364: ,p_enforcement_mode in varchar2 default hr_api.g_varchar2
365: ) is
366: --
367: l_rec ota_cpr_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';