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

Line 77: When hr_api.check_integrity_violated Then

73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: hr_qsv_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then

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

76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: hr_qsv_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: hr_qsv_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 81: When hr_api.parent_integrity_violated Then

77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: hr_qsv_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: hr_qsv_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then

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

80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: hr_qsv_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: hr_qsv_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 85: When hr_api.unique_integrity_violated Then

81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: hr_qsv_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: hr_qsv_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others Then

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

84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: hr_qsv_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others Then
90: Raise;
91: End update_dml;
92: --

Line 187: when hr_api.cannot_find_prog_unit then

183: => hr_qsv_shd.g_old_rec.object_version_number
184: ,p_value_o => hr_qsv_shd.g_old_rec.value
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'HR_QUEST_ANSWER_VALUES'
190: ,p_hook_type => 'AU'
191: );

Line 188: hr_api.cannot_find_prog_unit_error

184: ,p_value_o => hr_qsv_shd.g_old_rec.value
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'HR_QUEST_ANSWER_VALUES'
190: ,p_hook_type => 'AU'
191: );
192: end;

Line 254: If (p_rec.questionnaire_answer_id = hr_api.g_number) then

250: -- p_rec plsql record structure
251: -- to see if a system default is being used. If a system default
252: -- is being used then we must set to the 'current' argument value.
253: --
254: If (p_rec.questionnaire_answer_id = hr_api.g_number) then
255: p_rec.questionnaire_answer_id :=
256: hr_qsv_shd.g_old_rec.questionnaire_answer_id;
257: End If;
258: If (p_rec.field_id = hr_api.g_number) then

Line 258: If (p_rec.field_id = hr_api.g_number) then

254: If (p_rec.questionnaire_answer_id = hr_api.g_number) then
255: p_rec.questionnaire_answer_id :=
256: hr_qsv_shd.g_old_rec.questionnaire_answer_id;
257: End If;
258: If (p_rec.field_id = hr_api.g_number) then
259: p_rec.field_id :=
260: hr_qsv_shd.g_old_rec.field_id;
261: End If;
262: If (p_rec.value = hr_api.g_varchar2) then

Line 262: If (p_rec.value = hr_api.g_varchar2) then

258: If (p_rec.field_id = hr_api.g_number) then
259: p_rec.field_id :=
260: hr_qsv_shd.g_old_rec.field_id;
261: End If;
262: If (p_rec.value = hr_api.g_varchar2) then
263: p_rec.value :=
264: hr_qsv_shd.g_old_rec.value;
265: End If;
266: --

Line 321: p_value in varchar2 default hr_api.g_varchar2

317: Procedure upd
318: (
319: p_quest_answer_val_id in number,
320: p_object_version_number in out nocopy number,
321: p_value in varchar2 default hr_api.g_varchar2
322: ) is
323: --
324: l_rec hr_qsv_shd.g_rec_type;
325: l_proc varchar2(72) := g_package||'upd';

Line 337: hr_api.g_number,

333: l_rec :=
334: hr_qsv_shd.convert_args
335: (
336: p_quest_answer_val_id,
337: hr_api.g_number,
338: hr_api.g_number,
339: p_object_version_number,
340: p_value
341: );

Line 338: hr_api.g_number,

334: hr_qsv_shd.convert_args
335: (
336: p_quest_answer_val_id,
337: hr_api.g_number,
338: hr_api.g_number,
339: p_object_version_number,
340: p_value
341: );
342: --