[Home] [Help]
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
98: where salary_survey_mapping_id = p_rec.salary_survey_mapping_id;
99: --
100: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --
161: Begin
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: End pre_update;
166: --
160: --
161: Begin
162: hr_utility.set_location('Entering:'||l_proc, 5);
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: End pre_update;
166: --
167: -- ----------------------------------------------------------------------------
168: -- |-----------------------------< post_update >------------------------------|
201: --
202: l_proc varchar2(72) := g_package||'post_update';
203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: begin
208: per_ssm_rku.after_update
209: (
275: );
276: end;
277: --
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: End post_update;
281: --
282: -- ----------------------------------------------------------------------------
283: -- |-----------------------------< convert_defs >-----------------------------|
328: l_proc varchar2(72) := g_package||'convert_defs';
329: --
330: Begin
331: --
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: -- We must now examine each argument value in the
335: -- p_rec plsql record structure
336: -- to see if a system default is being used. If a system default
452: p_rec.attribute20 :=
453: per_ssm_shd.g_old_rec.attribute20;
454: End If;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: --
458: End convert_defs;
459: --
460: -- ----------------------------------------------------------------------------
468: --
469: l_proc varchar2(72) := g_package||'upd';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- We must lock the row which we need to update.
475: --
476: per_ssm_shd.lck
539: l_rec per_ssm_shd.g_rec_type;
540: l_proc varchar2(72) := g_package||'upd';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Call conversion function to turn arguments into the
546: -- l_rec structure.
547: --
587: --
588: upd(l_rec, p_effective_date);
589: p_object_version_number := l_rec.object_version_number;
590: --
591: hr_utility.set_location(' Leaving:'||l_proc, 10);
592: End upd;
593: --
594: end per_ssm_upd;