20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: begin
24: hr_utility.set_location('entering:'||l_proc, 10);
25: --
26: per_pyp_ins.g_pay_proposal_id_i := p_pay_proposal_id;
27: --
28: hr_utility.set_location(' leaving:'||l_proc, 20);
24: hr_utility.set_location('entering:'||l_proc, 10);
25: --
26: per_pyp_ins.g_pay_proposal_id_i := p_pay_proposal_id;
27: --
28: hr_utility.set_location(' leaving:'||l_proc, 20);
29: end set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: per_pyp_shd.g_api_dml := true; -- Set the api dml status
83: --
169: );
170: --
171: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
244: --
245: l_exists varchar2(1);
246: --
247: Begin
248: hr_utility.set_location('entering:'||l_proc, 5);
249: --
250: if (per_pyp_ins.g_pay_proposal_id_i is not null) then
251: --
252: -- verify registered primary key values not already in use
285: -- To fix last_change_date being null issue
286: --
287: per_pyp_bus.gen_last_change_date(p_rec);
288: --
289: hr_utility.set_location(' leaving:'||l_proc, 10);
290: End pre_insert;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |-----------------------------< post_insert >------------------------------|
340: l_event varchar2(20) ;
341: --
342:
343: Begin
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- Call to user hook for post_insert.
347: --
348: begin
516: p_approved_warning => p_approved_warning,
517: p_payroll_warning => p_payroll_warning
518: );
519: --
520: hr_utility.set_location('DM Mode pro ' ||hr_general.g_data_migrator_mode ,379);
521: --
522: -- OAB Bug 1863413 : Detect potential life events when salary
523: -- information changes
524: --
529: End if ;
530: --
531: -- extract change event log call
532: if hr_general.g_data_migrator_mode <> 'Y' then
533: hr_utility.set_location('Extract event logged called for pay proposal',99) ;
534: ben_ext_chlg.log_per_pay_chg
535: (p_event => l_event
536: ,p_old_rec => l_ext_old_rec
537: ,p_new_rec => l_ext_new_rec
535: (p_event => l_event
536: ,p_old_rec => l_ext_old_rec
537: ,p_new_rec => l_ext_new_rec
538: );
539: hr_utility.set_location('Extract event logged out ',99) ;
540: end if ;
541:
542:
543: exception
547: ,p_hook_type => 'AI'
548: );
549: end;
550: -- End of API User Hook for post_insert.
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: End post_insert;
553: --
554: --
555: -- ----------------------------------------------------------------------------
572: l_payroll_warning boolean;
573:
574: --
575: Begin
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: -- Determine if the business process is to be validated.
579: --
580: If p_validate then
623: p_proposed_salary_warning := l_proposed_salary_warning;
624: p_approved_warning := l_approved_warning;
625: p_payroll_warning := l_payroll_warning;
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 10);
628: Exception
629: When HR_Api.Validate_Enabled Then
630: --
631: -- As the Validate_Enabled exception has been raised
684: l_rec per_pyp_shd.g_rec_type;
685: l_proc varchar2(72) := g_package||'ins';
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Call conversion function to turn arguments into the
691: -- p_rec structure.
692: --
747: --
748: p_pay_proposal_id := l_rec.pay_proposal_id;
749: p_object_version_number := l_rec.object_version_number;
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 10);
752: End ins;
753: --
754: end per_pyp_ins;