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_LCD_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_lcd_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_lcd_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_lcd_shd.constraint_error

Line 90: When hr_api.parent_integrity_violated Then

86: -- A check constraint has been violated
87: --
88: pqh_lcd_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_lcd_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_lcd_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_lcd_shd.constraint_error

Line 95: When hr_api.unique_integrity_violated Then

91: -- Parent integrity has been violated
92: --
93: pqh_lcd_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_lcd_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_lcd_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 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 => 'PQH_DE_LEVEL_CODES'
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 => 'PQH_DE_LEVEL_CODES'
222: ,p_hook_type => 'AU');
223: --
224: end;

Line 283: If (p_rec.level_number_id = hr_api.g_number) 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.level_number_id = hr_api.g_number) then
284: p_rec.level_number_id :=
285: pqh_lcd_shd.g_old_rec.level_number_id;
286: End If;
287: If (p_rec.level_code = hr_api.g_varchar2) then

Line 287: If (p_rec.level_code = hr_api.g_varchar2) then

283: If (p_rec.level_number_id = hr_api.g_number) then
284: p_rec.level_number_id :=
285: pqh_lcd_shd.g_old_rec.level_number_id;
286: End If;
287: If (p_rec.level_code = hr_api.g_varchar2) then
288: p_rec.level_code :=
289: pqh_lcd_shd.g_old_rec.level_code;
290: End If;
291: If (p_rec.description = hr_api.g_varchar2) then

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

287: If (p_rec.level_code = hr_api.g_varchar2) then
288: p_rec.level_code :=
289: pqh_lcd_shd.g_old_rec.level_code;
290: End If;
291: If (p_rec.description = hr_api.g_varchar2) then
292: p_rec.description :=
293: pqh_lcd_shd.g_old_rec.description;
294: End If;
295: If (p_rec.gradual_value_number = hr_api.g_number) then

Line 295: If (p_rec.gradual_value_number = hr_api.g_number) then

291: If (p_rec.description = hr_api.g_varchar2) then
292: p_rec.description :=
293: pqh_lcd_shd.g_old_rec.description;
294: End If;
295: If (p_rec.gradual_value_number = hr_api.g_number) then
296: p_rec.gradual_value_number :=
297: pqh_lcd_shd.g_old_rec.gradual_value_number;
298: End If;
299: --

Line 359: ,p_level_number_id in number default hr_api.g_number

355: -- ----------------------------------------------------------------------------
356: Procedure upd
357: (p_level_code_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_level_number_id in number default hr_api.g_number
360: ,p_level_code in varchar2 default hr_api.g_varchar2
361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_gradual_value_number in number default hr_api.g_number
363: ) is

Line 360: ,p_level_code in varchar2 default hr_api.g_varchar2

356: Procedure upd
357: (p_level_code_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_level_number_id in number default hr_api.g_number
360: ,p_level_code in varchar2 default hr_api.g_varchar2
361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_gradual_value_number in number default hr_api.g_number
363: ) is
364: --

Line 361: ,p_description in varchar2 default hr_api.g_varchar2

357: (p_level_code_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_level_number_id in number default hr_api.g_number
360: ,p_level_code in varchar2 default hr_api.g_varchar2
361: ,p_description in varchar2 default hr_api.g_varchar2
362: ,p_gradual_value_number in number default hr_api.g_number
363: ) is
364: --
365: l_rec pqh_lcd_shd.g_rec_type;

Line 362: ,p_gradual_value_number in number default hr_api.g_number

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