[Home] [Help]
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: pay_ppr_ins.g_status_processing_rule_id_i := p_status_processing_rule_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_ppr_ins.g_status_processing_rule_id_i := p_status_processing_rule_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31:
32: -- ----------------------------------------------------------------------------
101: l_last_updated_by pay_status_processing_rules_f.last_updated_by%TYPE;
102: l_last_update_login pay_status_processing_rules_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Set the effective start and end dates to the corresponding
108: -- validation start and end dates
109: --
113: -- If the datetrack_mode is not INSERT then we must populate the WHO
114: -- columns with the 'old' creation values and 'new' updated values.
115: --
116: If (p_datetrack_mode <> hr_api.g_insert) then
117: hr_utility.set_location(l_proc, 10);
118: --
119: -- Get the object version number for the insert
120: --
121: p_rec.object_version_number :=
194: ,l_last_update_login
195: );
196: --
197: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
198: hr_utility.set_location(' Leaving:'||l_proc, 15);
199: --
200: Exception
201: When hr_api.check_integrity_violated Then
202: -- A check constraint has been violated
274: --
275: l_proc varchar2(72) := g_package||'insert_dml';
276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: --
280: pay_ppr_ins.dt_insert_dml
281: (p_rec => p_rec
282: ,p_effective_date => p_effective_date
284: ,p_validation_start_date => p_validation_start_date
285: ,p_validation_end_date => p_validation_end_date
286: );
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 10);
289: End insert_dml;
290: --
291: -- ----------------------------------------------------------------------------
292: -- |------------------------------< pre_insert >------------------------------|
347: l_exists varchar2(1);
348:
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: If (pay_ppr_ins.g_status_processing_rule_id_i is not null) Then
354: --
355: -- Verify registered primary key values not already in use
395: );
396: End If;
397:
398: --
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: End pre_insert;
401: --
402: -- ----------------------------------------------------------------------------
403: -- |----------------------------< post_insert >-------------------------------|
442: --
443: l_proc varchar2(72) := g_package||'post_insert';
444: --
445: Begin
446: hr_utility.set_location('Entering:'||l_proc, 5);
447: begin
448: --
449: -- insert ownerships if applicable
450: create_app_ownerships
480: ,p_hook_type => 'AI');
481: --
482: end;
483: --
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: End post_insert;
486: --
487: -- ----------------------------------------------------------------------------
488: -- |-------------------------------< ins_lck >--------------------------------|
532: l_validation_start_date date;
533: l_validation_end_date date;
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Validate the datetrack mode mode getting the validation start
539: -- and end dates for the specified datetrack operation.
540: --
553: --
554: p_validation_start_date := l_validation_start_date;
555: p_validation_end_date := l_validation_end_date;
556: --
557: hr_utility.set_location(' Leaving:'||l_proc, 10);
558: --
559: End ins_lck;
560: --
561: -- ----------------------------------------------------------------------------
574: l_processing_rule varchar2(1);
575: l_formula_mismatch_warning boolean;
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Call the lock operation
581: --
582: pay_ppr_ins.ins_lck
655: --
656: -- Call to raise any errors on multi-message list
657: hr_multi_message.end_validation_set;
658: --
659: hr_utility.set_location('Leaving:'||l_proc,10);
660: end ins;
661: --
662: -- ----------------------------------------------------------------------------
663: -- |---------------------------------< ins >----------------------------------|
683: l_proc varchar2(72) := g_package||'ins';
684: l_formula_mismatch_warning boolean;
685: --
686: Begin
687: hr_utility.set_location('Entering:'||l_proc, 5);
688: --
689: -- Call conversion function to turn arguments into the
690: -- p_rec structure.
691: --
724: p_object_version_number := l_rec.object_version_number;
725: p_comment_id := l_rec.comment_id;
726: p_formula_mismatch_warning := l_formula_mismatch_warning;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: End ins;
730: --
731: end pay_ppr_ins;