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

Line 79: When hr_api.check_integrity_violated Then

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

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

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

Line 83: When hr_api.parent_integrity_violated Then

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

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

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

Line 87: When hr_api.unique_integrity_violated Then

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

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

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

Line 194: when hr_api.cannot_find_prog_unit then

190: ,p_object_version_number_o => hr_qsf_shd.g_old_rec.object_version_number
191: ,p_effective_date => p_effective_date
192: );
193: exception
194: when hr_api.cannot_find_prog_unit then
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'HR_QUEST_FIELDS'
197: ,p_hook_type => 'AU'
198: );

Line 195: hr_api.cannot_find_prog_unit_error

191: ,p_effective_date => p_effective_date
192: );
193: exception
194: when hr_api.cannot_find_prog_unit then
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'HR_QUEST_FIELDS'
197: ,p_hook_type => 'AU'
198: );
199: end;

Line 261: If (p_rec.questionnaire_template_id = hr_api.g_number) then

257: -- p_rec plsql record structure
258: -- to see if a system default is being used. If a system default
259: -- is being used then we must set to the 'current' argument value.
260: --
261: If (p_rec.questionnaire_template_id = hr_api.g_number) then
262: p_rec.questionnaire_template_id :=
263: hr_qsf_shd.g_old_rec.questionnaire_template_id;
264: End If;
265: If (p_rec.name = hr_api.g_varchar2) then

Line 265: If (p_rec.name = hr_api.g_varchar2) then

261: If (p_rec.questionnaire_template_id = hr_api.g_number) then
262: p_rec.questionnaire_template_id :=
263: hr_qsf_shd.g_old_rec.questionnaire_template_id;
264: End If;
265: If (p_rec.name = hr_api.g_varchar2) then
266: p_rec.name :=
267: hr_qsf_shd.g_old_rec.name;
268: End If;
269: If (p_rec.type = hr_api.g_varchar2) then

Line 269: If (p_rec.type = hr_api.g_varchar2) then

265: If (p_rec.name = hr_api.g_varchar2) then
266: p_rec.name :=
267: hr_qsf_shd.g_old_rec.name;
268: End If;
269: If (p_rec.type = hr_api.g_varchar2) then
270: p_rec.type :=
271: hr_qsf_shd.g_old_rec.type;
272: End If;
273: If (p_rec.html_text = hr_api.g_varchar2) then

Line 273: If (p_rec.html_text = hr_api.g_varchar2) then

269: If (p_rec.type = hr_api.g_varchar2) then
270: p_rec.type :=
271: hr_qsf_shd.g_old_rec.type;
272: End If;
273: If (p_rec.html_text = hr_api.g_varchar2) then
274: p_rec.html_text :=
275: hr_qsf_shd.g_old_rec.html_text;
276: End If;
277: If (p_rec.sql_required_flag = hr_api.g_varchar2) then

Line 277: If (p_rec.sql_required_flag = hr_api.g_varchar2) then

273: If (p_rec.html_text = hr_api.g_varchar2) then
274: p_rec.html_text :=
275: hr_qsf_shd.g_old_rec.html_text;
276: End If;
277: If (p_rec.sql_required_flag = hr_api.g_varchar2) then
278: p_rec.sql_required_flag :=
279: hr_qsf_shd.g_old_rec.sql_required_flag;
280: End If;
281: If (p_rec.sql_text = hr_api.g_varchar2) then

Line 281: If (p_rec.sql_text = hr_api.g_varchar2) then

277: If (p_rec.sql_required_flag = hr_api.g_varchar2) then
278: p_rec.sql_required_flag :=
279: hr_qsf_shd.g_old_rec.sql_required_flag;
280: End If;
281: If (p_rec.sql_text = hr_api.g_varchar2) then
282: p_rec.sql_text :=
283: hr_qsf_shd.g_old_rec.sql_text;
284: End If;
285:

Line 343: p_sql_text in varchar2 default hr_api.g_varchar2,

339: -- ----------------------------------------------------------------------------
340: Procedure upd
341: (
342: p_field_id in number,
343: p_sql_text in varchar2 default hr_api.g_varchar2,
344: p_object_version_number in out nocopy number,
345: p_effective_date in date
346: ) is
347: --

Line 361: hr_api.g_number,

357: l_rec :=
358: hr_qsf_shd.convert_args
359: (
360: p_field_id,
361: hr_api.g_number,
362: hr_api.g_varchar2,
363: hr_api.g_varchar2,
364: hr_api.g_varchar2,
365: hr_api.g_varchar2,

Line 362: hr_api.g_varchar2,

358: hr_qsf_shd.convert_args
359: (
360: p_field_id,
361: hr_api.g_number,
362: hr_api.g_varchar2,
363: hr_api.g_varchar2,
364: hr_api.g_varchar2,
365: hr_api.g_varchar2,
366: p_sql_text,

Line 363: hr_api.g_varchar2,

359: (
360: p_field_id,
361: hr_api.g_number,
362: hr_api.g_varchar2,
363: hr_api.g_varchar2,
364: hr_api.g_varchar2,
365: hr_api.g_varchar2,
366: p_sql_text,
367: p_object_version_number

Line 364: hr_api.g_varchar2,

360: p_field_id,
361: hr_api.g_number,
362: hr_api.g_varchar2,
363: hr_api.g_varchar2,
364: hr_api.g_varchar2,
365: hr_api.g_varchar2,
366: p_sql_text,
367: p_object_version_number
368: );

Line 365: hr_api.g_varchar2,

361: hr_api.g_number,
362: hr_api.g_varchar2,
363: hr_api.g_varchar2,
364: hr_api.g_varchar2,
365: hr_api.g_varchar2,
366: p_sql_text,
367: p_object_version_number
368: );
369: --