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

Line 84: When hr_api.check_integrity_violated Then

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

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

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

Line 89: When hr_api.parent_integrity_violated Then

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

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

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

Line 94: When hr_api.unique_integrity_violated Then

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

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

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

Line 215: when hr_api.cannot_find_prog_unit then

211: );
212: --
213: exception
214: --
215: when hr_api.cannot_find_prog_unit then
216: --
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'PQH_DE_OPERATION_GROUPS'
219: ,p_hook_type => 'AU');

Line 217: hr_api.cannot_find_prog_unit_error

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

Line 280: If (p_rec.operation_group_code = hr_api.g_varchar2) then

276: -- p_rec plsql record structure
277: -- to see if a system default is being used. If a system default
278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.operation_group_code = hr_api.g_varchar2) then
281: p_rec.operation_group_code :=
282: pqh_opg_shd.g_old_rec.operation_group_code;
283: End If;
284: If (p_rec.description = hr_api.g_varchar2) then

Line 284: If (p_rec.description = hr_api.g_varchar2) then

280: If (p_rec.operation_group_code = hr_api.g_varchar2) then
281: p_rec.operation_group_code :=
282: pqh_opg_shd.g_old_rec.operation_group_code;
283: End If;
284: If (p_rec.description = hr_api.g_varchar2) then
285: p_rec.description :=
286: pqh_opg_shd.g_old_rec.description;
287: End If;
288: If (p_rec.business_group_id = hr_api.g_number) then

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

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

Line 360: ,p_operation_group_code in varchar2 default hr_api.g_varchar2

356: Procedure upd
357: (p_effective_date in date
358: ,p_operation_group_id in number
359: ,p_object_version_number in out nocopy number
360: ,p_operation_group_code in varchar2 default hr_api.g_varchar2
361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_business_group_id in number default hr_api.g_number
363: ) is
364: --

Line 361: ,p_description in varchar2 default hr_api.g_varchar2

357: (p_effective_date in date
358: ,p_operation_group_id in number
359: ,p_object_version_number in out nocopy number
360: ,p_operation_group_code in varchar2 default hr_api.g_varchar2
361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_business_group_id in number default hr_api.g_number
363: ) is
364: --
365: l_rec pqh_opg_shd.g_rec_type;

Line 362: ,p_business_group_id in number default hr_api.g_number

358: ,p_operation_group_id in number
359: ,p_object_version_number in out nocopy number
360: ,p_operation_group_code in varchar2 default hr_api.g_varchar2
361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_business_group_id in number default hr_api.g_number
363: ) is
364: --
365: l_rec pqh_opg_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'upd';