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_QSV_SHD

Line 54: Procedure update_dml(p_rec in out nocopy hr_qsv_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_qsv_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 79: hr_qsv_shd.constraint_error

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
82: -- Parent integrity has been violated
83: hr_qsv_shd.constraint_error

Line 83: hr_qsv_shd.constraint_error

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
86: -- Unique integrity has been violated
87: hr_qsv_shd.constraint_error

Line 87: hr_qsv_shd.constraint_error

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
90: Raise;
91: End update_dml;

Line 125: Procedure pre_update(p_rec in hr_qsv_shd.g_rec_type) is

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

Line 167: Procedure post_update(p_rec in hr_qsv_shd.g_rec_type) is

163: -- Internal Row Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure post_update(p_rec in hr_qsv_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'post_update';
170: --
171: Begin

Line 180: => hr_qsv_shd.g_old_rec.questionnaire_answer_id

176: (p_quest_answer_val_id => p_rec.quest_answer_val_id
177: ,p_object_version_number => p_rec.object_version_number
178: ,p_value => p_rec.value
179: ,p_questionnaire_answer_id_o
180: => hr_qsv_shd.g_old_rec.questionnaire_answer_id
181: ,p_field_id_o => hr_qsv_shd.g_old_rec.field_id
182: ,p_object_version_number_o
183: => hr_qsv_shd.g_old_rec.object_version_number
184: ,p_value_o => hr_qsv_shd.g_old_rec.value

Line 181: ,p_field_id_o => hr_qsv_shd.g_old_rec.field_id

177: ,p_object_version_number => p_rec.object_version_number
178: ,p_value => p_rec.value
179: ,p_questionnaire_answer_id_o
180: => hr_qsv_shd.g_old_rec.questionnaire_answer_id
181: ,p_field_id_o => hr_qsv_shd.g_old_rec.field_id
182: ,p_object_version_number_o
183: => hr_qsv_shd.g_old_rec.object_version_number
184: ,p_value_o => hr_qsv_shd.g_old_rec.value
185: );

Line 183: => hr_qsv_shd.g_old_rec.object_version_number

179: ,p_questionnaire_answer_id_o
180: => hr_qsv_shd.g_old_rec.questionnaire_answer_id
181: ,p_field_id_o => hr_qsv_shd.g_old_rec.field_id
182: ,p_object_version_number_o
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

Line 184: ,p_value_o => hr_qsv_shd.g_old_rec.value

180: => hr_qsv_shd.g_old_rec.questionnaire_answer_id
181: ,p_field_id_o => hr_qsv_shd.g_old_rec.field_id
182: ,p_object_version_number_o
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

Line 241: Procedure convert_defs(p_rec in out nocopy hr_qsv_shd.g_rec_type) is

237: -- Internal Row Handler Use Only.
238: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: Procedure convert_defs(p_rec in out nocopy hr_qsv_shd.g_rec_type) is
242: --
243: l_proc varchar2(72) := g_package||'convert_defs';
244: --
245: Begin

Line 256: hr_qsv_shd.g_old_rec.questionnaire_answer_id;

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
259: p_rec.field_id :=
260: hr_qsv_shd.g_old_rec.field_id;

Line 260: hr_qsv_shd.g_old_rec.field_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
263: p_rec.value :=
264: hr_qsv_shd.g_old_rec.value;

Line 264: hr_qsv_shd.g_old_rec.value;

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

Line 276: p_rec in out nocopy hr_qsv_shd.g_rec_type

272: -- |---------------------------------< upd >----------------------------------|
273: -- ----------------------------------------------------------------------------
274: Procedure upd
275: (
276: p_rec in out nocopy hr_qsv_shd.g_rec_type
277: ) is
278: --
279: l_proc varchar2(72) := g_package||'upd';
280: --

Line 286: hr_qsv_shd.lck

282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: -- We must lock the row which we need to update.
285: --
286: hr_qsv_shd.lck
287: (
288: p_rec.quest_answer_val_id,
289: p_rec.object_version_number
290: );

Line 324: l_rec hr_qsv_shd.g_rec_type;

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';
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);

Line 334: hr_qsv_shd.convert_args

330: -- Call conversion function to turn arguments into the
331: -- l_rec structure.
332: --
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,