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

Line 85: When hr_api.check_integrity_violated Then

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

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

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

Line 90: When hr_api.parent_integrity_violated Then

86: -- A check constraint has been violated
87: --
88: pqh_def_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pqh_def_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.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pqh_def_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pqh_def_shd.constraint_error

Line 95: When hr_api.unique_integrity_violated Then

91: -- Parent integrity has been violated
92: --
93: pqh_def_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pqh_def_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.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pqh_def_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;
103: End update_dml;

Line 220: when hr_api.cannot_find_prog_unit then

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

Line 222: hr_api.cannot_find_prog_unit_error

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

Line 285: If (p_rec.validation_name = hr_api.g_varchar2) then

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

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

285: If (p_rec.validation_name = hr_api.g_varchar2) then
286: p_rec.validation_name :=
287: pqh_def_shd.g_old_rec.validation_name;
288: End If;
289: If (p_rec.business_group_id = hr_api.g_number) then
290: p_rec.business_group_id :=
291: pqh_def_shd.g_old_rec.business_group_id;
292: End If;
293: If (p_rec.employment_type = hr_api.g_varchar2) then

Line 293: If (p_rec.employment_type = hr_api.g_varchar2) then

289: If (p_rec.business_group_id = hr_api.g_number) then
290: p_rec.business_group_id :=
291: pqh_def_shd.g_old_rec.business_group_id;
292: End If;
293: If (p_rec.employment_type = hr_api.g_varchar2) then
294: p_rec.employment_type :=
295: pqh_def_shd.g_old_rec.employment_type;
296: End If;
297: If (p_rec.remuneration_regulation = hr_api.g_varchar2) then

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

293: If (p_rec.employment_type = hr_api.g_varchar2) then
294: p_rec.employment_type :=
295: pqh_def_shd.g_old_rec.employment_type;
296: End If;
297: If (p_rec.remuneration_regulation = hr_api.g_varchar2) then
298: p_rec.remuneration_regulation :=
299: pqh_def_shd.g_old_rec.remuneration_regulation;
300: End If;
301: --

Line 365: ,p_validation_name in varchar2 default hr_api.g_varchar2

361: Procedure upd
362: (p_effective_date in date
363: ,p_wrkplc_vldtn_id in number
364: ,p_object_version_number in out nocopy number
365: ,p_validation_name in varchar2 default hr_api.g_varchar2
366: ,p_business_group_id in number default hr_api.g_number
367: ,p_employment_type in varchar2 default hr_api.g_varchar2
368: ,p_remuneration_regulation in varchar2 default hr_api.g_varchar2
369: ) is

Line 366: ,p_business_group_id in number default hr_api.g_number

362: (p_effective_date in date
363: ,p_wrkplc_vldtn_id in number
364: ,p_object_version_number in out nocopy number
365: ,p_validation_name in varchar2 default hr_api.g_varchar2
366: ,p_business_group_id in number default hr_api.g_number
367: ,p_employment_type in varchar2 default hr_api.g_varchar2
368: ,p_remuneration_regulation in varchar2 default hr_api.g_varchar2
369: ) is
370: --

Line 367: ,p_employment_type in varchar2 default hr_api.g_varchar2

363: ,p_wrkplc_vldtn_id in number
364: ,p_object_version_number in out nocopy number
365: ,p_validation_name in varchar2 default hr_api.g_varchar2
366: ,p_business_group_id in number default hr_api.g_number
367: ,p_employment_type in varchar2 default hr_api.g_varchar2
368: ,p_remuneration_regulation in varchar2 default hr_api.g_varchar2
369: ) is
370: --
371: l_rec pqh_def_shd.g_rec_type;

Line 368: ,p_remuneration_regulation in varchar2 default hr_api.g_varchar2

364: ,p_object_version_number in out nocopy number
365: ,p_validation_name in varchar2 default hr_api.g_varchar2
366: ,p_business_group_id in number default hr_api.g_number
367: ,p_employment_type in varchar2 default hr_api.g_varchar2
368: ,p_remuneration_regulation in varchar2 default hr_api.g_varchar2
369: ) is
370: --
371: l_rec pqh_def_shd.g_rec_type;
372: l_proc varchar2(72) := g_package||'upd';