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_RSS_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_rss_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_rss_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_rss_shd.constraint_error

Line 89: When hr_api.parent_integrity_violated Then

85: -- A check constraint has been violated
86: --
87: pqh_rss_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_rss_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_rss_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_rss_shd.constraint_error

Line 94: When hr_api.unique_integrity_violated Then

90: -- Parent integrity has been violated
91: --
92: pqh_rss_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_rss_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_rss_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_RESULT_SETS'
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_RESULT_SETS'
219: ,p_hook_type => 'AU');
220: --
221: end;

Line 280: If (p_rec.gradual_value_number_from = hr_api.g_number) 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.gradual_value_number_from = hr_api.g_number) then
281: p_rec.gradual_value_number_from :=
282: pqh_rss_shd.g_old_rec.gradual_value_number_from;
283: End If;
284: If (p_rec.gradual_value_number_to = hr_api.g_number) then

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

280: If (p_rec.gradual_value_number_from = hr_api.g_number) then
281: p_rec.gradual_value_number_from :=
282: pqh_rss_shd.g_old_rec.gradual_value_number_from;
283: End If;
284: If (p_rec.gradual_value_number_to = hr_api.g_number) then
285: p_rec.gradual_value_number_to :=
286: pqh_rss_shd.g_old_rec.gradual_value_number_to;
287: End If;
288: If (p_rec.grade_id = hr_api.g_number) then

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

284: If (p_rec.gradual_value_number_to = hr_api.g_number) then
285: p_rec.gradual_value_number_to :=
286: pqh_rss_shd.g_old_rec.gradual_value_number_to;
287: End If;
288: If (p_rec.grade_id = hr_api.g_number) then
289: p_rec.grade_id :=
290: pqh_rss_shd.g_old_rec.grade_id;
291: End If;
292: --

Line 356: ,p_gradual_value_number_from in number default hr_api.g_number

352: Procedure upd
353: (p_effective_date in date
354: ,p_result_set_id in number
355: ,p_object_version_number in out nocopy number
356: ,p_gradual_value_number_from in number default hr_api.g_number
357: ,p_gradual_value_number_to in number default hr_api.g_number
358: ,p_grade_id in number default hr_api.g_number
359: ) is
360: --

Line 357: ,p_gradual_value_number_to in number default hr_api.g_number

353: (p_effective_date in date
354: ,p_result_set_id in number
355: ,p_object_version_number in out nocopy number
356: ,p_gradual_value_number_from in number default hr_api.g_number
357: ,p_gradual_value_number_to in number default hr_api.g_number
358: ,p_grade_id in number default hr_api.g_number
359: ) is
360: --
361: l_rec pqh_rss_shd.g_rec_type;

Line 358: ,p_grade_id in number default hr_api.g_number

354: ,p_result_set_id in number
355: ,p_object_version_number in out nocopy number
356: ,p_gradual_value_number_from in number default hr_api.g_number
357: ,p_gradual_value_number_to in number default hr_api.g_number
358: ,p_grade_id in number default hr_api.g_number
359: ) is
360: --
361: l_rec pqh_rss_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'upd';