[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;
102: where person_analysis_id = p_rec.person_analysis_id;
103: --
104: per_pea_shd.g_api_dml := false; -- Unset the api dml status
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: --
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
162: --
163: l_proc varchar2(72) := g_package||'pre_update';
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: End pre_update;
170: --
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: End pre_update;
170: --
171: -- ----------------------------------------------------------------------------
172: -- |-----------------------------< post_update >------------------------------|
210: l_new_rec ben_pac_ler.g_pac_ler_rec;
211:
212:
213: Begin
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- Start of API User Hook for post_update.
217: begin
218: per_pea_rku.after_update
338: l_new_rec.attribute18 :=p_rec.attribute18;
339: l_new_rec.attribute19 :=p_rec.attribute19;
340: l_new_rec.attribute20 :=p_rec.attribute20;
341:
342: hr_utility.set_location('Calling BEN Package :'||l_proc, 7);
343:
344: ben_pac_ler.ler_chk(l_old_rec
345: ,l_new_rec
346: ,nvl(l_new_rec.date_from, sysdate ));
344: ben_pac_ler.ler_chk(l_old_rec
345: ,l_new_rec
346: ,nvl(l_new_rec.date_from, sysdate ));
347:
348: hr_utility.set_location('End of BEN Call :'||l_proc, 9);
349:
350: -- End of BEN LER Check
351:
352:
358: );
359: end;
360: -- End of API User Hook for post_update.
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 10);
363: End post_update;
364: --
365: -- ----------------------------------------------------------------------------
366: -- |-----------------------------< convert_defs >-----------------------------|
411: l_proc varchar2(72) := g_package||'convert_defs';
412: --
413: Begin
414: --
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- We must now examine each argument value in the
418: -- p_rec plsql record structure
419: -- to see if a system default is being used. If a system default
547: p_rec.attribute20 :=
548: per_pea_shd.g_old_rec.attribute20;
549: End If;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: --
553: End convert_defs;
554: --
555: -- ----------------------------------------------------------------------------
566: l_object_version_number number;
567:
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Determine if the business process is to be validated.
573: --
574: l_rec := p_rec;
622: If p_validate then
623: Raise HR_Api.Validate_Enabled;
624: End If;
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: Exception
628: When HR_Api.Validate_Enabled Then
629: --
630: -- As the Validate_Enabled exception has been raised
677: l_rec per_pea_shd.g_rec_type;
678: l_proc varchar2(72) := g_package||'upd';
679: --
680: Begin
681: hr_utility.set_location('Entering:'||l_proc, 5);
682: --
683: -- Call conversion function to turn arguments into the
684: -- l_rec structure.
685: --
728: --
729: upd(l_rec, p_validate);
730: p_object_version_number := l_rec.object_version_number;
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 10);
733: End upd;
734: --
735: end per_pea_upd;