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_QSF_SHD

Line 54: Procedure update_dml(p_rec in out nocopy hr_qsf_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy hr_qsf_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 81: hr_qsf_shd.constraint_error

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
84: -- Parent integrity has been violated
85: hr_qsf_shd.constraint_error

Line 85: hr_qsf_shd.constraint_error

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
88: -- Unique integrity has been violated
89: hr_qsf_shd.constraint_error

Line 89: hr_qsf_shd.constraint_error

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
92: Raise;
93: End update_dml;

Line 127: Procedure pre_update(p_rec in hr_qsf_shd.g_rec_type) is

123: -- Internal Row Handler Use Only.
124: --
125: -- {End Of Comments}
126: -- ----------------------------------------------------------------------------
127: Procedure pre_update(p_rec in hr_qsf_shd.g_rec_type) is
128: --
129: l_proc varchar2(72) := g_package||'pre_update';
130: --
131: Begin

Line 169: Procedure post_update(p_rec in hr_qsf_shd.g_rec_type

165: -- Internal Row Handler Use Only.
166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure post_update(p_rec in hr_qsf_shd.g_rec_type
170: ,p_effective_date in date
171: ) is
172: --
173: l_proc varchar2(72) := g_package||'post_update';

Line 184: => hr_qsf_shd.g_old_rec.questionnaire_template_id

180: (p_field_id => p_rec.field_id
181: ,p_sql_text => p_rec.sql_text
182: ,p_object_version_number => p_rec.object_version_number
183: ,p_questionnaire_template_id_o
184: => hr_qsf_shd.g_old_rec.questionnaire_template_id
185: ,p_name_o => hr_qsf_shd.g_old_rec.name
186: ,p_type_o => hr_qsf_shd.g_old_rec.type
187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text
188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag

Line 185: ,p_name_o => hr_qsf_shd.g_old_rec.name

181: ,p_sql_text => p_rec.sql_text
182: ,p_object_version_number => p_rec.object_version_number
183: ,p_questionnaire_template_id_o
184: => hr_qsf_shd.g_old_rec.questionnaire_template_id
185: ,p_name_o => hr_qsf_shd.g_old_rec.name
186: ,p_type_o => hr_qsf_shd.g_old_rec.type
187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text
188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag
189: ,p_sql_text_o => hr_qsf_shd.g_old_rec.sql_text

Line 186: ,p_type_o => hr_qsf_shd.g_old_rec.type

182: ,p_object_version_number => p_rec.object_version_number
183: ,p_questionnaire_template_id_o
184: => hr_qsf_shd.g_old_rec.questionnaire_template_id
185: ,p_name_o => hr_qsf_shd.g_old_rec.name
186: ,p_type_o => hr_qsf_shd.g_old_rec.type
187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text
188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag
189: ,p_sql_text_o => hr_qsf_shd.g_old_rec.sql_text
190: ,p_object_version_number_o => hr_qsf_shd.g_old_rec.object_version_number

Line 187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text

183: ,p_questionnaire_template_id_o
184: => hr_qsf_shd.g_old_rec.questionnaire_template_id
185: ,p_name_o => hr_qsf_shd.g_old_rec.name
186: ,p_type_o => hr_qsf_shd.g_old_rec.type
187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text
188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag
189: ,p_sql_text_o => hr_qsf_shd.g_old_rec.sql_text
190: ,p_object_version_number_o => hr_qsf_shd.g_old_rec.object_version_number
191: ,p_effective_date => p_effective_date

Line 188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag

184: => hr_qsf_shd.g_old_rec.questionnaire_template_id
185: ,p_name_o => hr_qsf_shd.g_old_rec.name
186: ,p_type_o => hr_qsf_shd.g_old_rec.type
187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text
188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag
189: ,p_sql_text_o => hr_qsf_shd.g_old_rec.sql_text
190: ,p_object_version_number_o => hr_qsf_shd.g_old_rec.object_version_number
191: ,p_effective_date => p_effective_date
192: );

Line 189: ,p_sql_text_o => hr_qsf_shd.g_old_rec.sql_text

185: ,p_name_o => hr_qsf_shd.g_old_rec.name
186: ,p_type_o => hr_qsf_shd.g_old_rec.type
187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text
188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag
189: ,p_sql_text_o => hr_qsf_shd.g_old_rec.sql_text
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

Line 190: ,p_object_version_number_o => hr_qsf_shd.g_old_rec.object_version_number

186: ,p_type_o => hr_qsf_shd.g_old_rec.type
187: ,p_html_text_o => hr_qsf_shd.g_old_rec.html_text
188: ,p_sql_required_flag_o => hr_qsf_shd.g_old_rec.sql_required_flag
189: ,p_sql_text_o => hr_qsf_shd.g_old_rec.sql_text
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

Line 248: Procedure convert_defs(p_rec in out nocopy hr_qsf_shd.g_rec_type) is

244: -- Internal Row Handler Use Only.
245: --
246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure convert_defs(p_rec in out nocopy hr_qsf_shd.g_rec_type) is
249: --
250: l_proc varchar2(72) := g_package||'convert_defs';
251: --
252: Begin

Line 263: hr_qsf_shd.g_old_rec.questionnaire_template_id;

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
266: p_rec.name :=
267: hr_qsf_shd.g_old_rec.name;

Line 267: hr_qsf_shd.g_old_rec.name;

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
270: p_rec.type :=
271: hr_qsf_shd.g_old_rec.type;

Line 271: hr_qsf_shd.g_old_rec.type;

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
274: p_rec.html_text :=
275: hr_qsf_shd.g_old_rec.html_text;

Line 275: hr_qsf_shd.g_old_rec.html_text;

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
278: p_rec.sql_required_flag :=
279: hr_qsf_shd.g_old_rec.sql_required_flag;

Line 279: hr_qsf_shd.g_old_rec.sql_required_flag;

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
282: p_rec.sql_text :=
283: hr_qsf_shd.g_old_rec.sql_text;

Line 283: hr_qsf_shd.g_old_rec.sql_text;

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:
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 296: p_rec in out nocopy hr_qsf_shd.g_rec_type,

292: -- |---------------------------------< upd >----------------------------------|
293: -- ----------------------------------------------------------------------------
294: Procedure upd
295: (
296: p_rec in out nocopy hr_qsf_shd.g_rec_type,
297: p_effective_date in date
298: ) is
299: --
300: l_proc varchar2(72) := g_package||'upd';

Line 307: hr_qsf_shd.lck

303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- We must lock the row which we need to update.
306: --
307: hr_qsf_shd.lck
308: (
309: p_rec.field_id,
310: p_rec.object_version_number
311: );

Line 348: l_rec hr_qsf_shd.g_rec_type;

344: p_object_version_number in out nocopy number,
345: p_effective_date in date
346: ) is
347: --
348: l_rec hr_qsf_shd.g_rec_type;
349: l_proc varchar2(72) := g_package||'upd';
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);

Line 358: hr_qsf_shd.convert_args

354: -- Call conversion function to turn arguments into the
355: -- l_rec structure.
356: --
357: l_rec :=
358: hr_qsf_shd.convert_args
359: (
360: p_field_id,
361: hr_api.g_number,
362: hr_api.g_varchar2,