[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_frr_ins.g_formula_result_rule_id_i := p_formula_result_rule_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_frr_ins.g_formula_result_rule_id_i := p_formula_result_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_formula_result_rules_f.last_updated_by%TYPE;
102: l_last_update_login pay_formula_result_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 :=
196: ,l_last_update_login
197: );
198: --
199: pay_frr_shd.g_api_dml := false; -- Unset the api dml status
200: hr_utility.set_location(' Leaving:'||l_proc, 15);
201: --
202: Exception
203: When hr_api.check_integrity_violated Then
204: -- A check constraint has been violated
276: --
277: l_proc varchar2(72) := g_package||'insert_dml';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: pay_frr_ins.dt_insert_dml
283: (p_rec => p_rec
284: ,p_effective_date => p_effective_date
286: ,p_validation_start_date => p_validation_start_date
287: ,p_validation_end_date => p_validation_end_date
288: );
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: End insert_dml;
292: --
293: -- ----------------------------------------------------------------------------
294: -- |------------------------------< pre_insert >------------------------------|
348: l_proc varchar2(72) := g_package||'pre_insert';
349: l_exists varchar2(1);
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: If (pay_frr_ins.g_formula_result_rule_id_i is not null) Then
355: --
356: -- Verify registered primary key values not already in use
385: Close C_Sel1;
386: End If;
387: --
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: End pre_insert;
391: --
392: -- ----------------------------------------------------------------------------
393: -- |----------------------------< post_insert >-------------------------------|
431: --
432: l_proc varchar2(72) := g_package||'post_insert';
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: begin
437: --
438: -- insert ownerships if applicable
439: create_app_ownerships
485: ,p_hook_type => 'AI');
486: --
487: end;
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 10);
490: End post_insert;
491: --
492: -- ----------------------------------------------------------------------------
493: -- |-------------------------------< ins_lck >--------------------------------|
537: l_validation_start_date date;
538: l_validation_end_date date;
539: --
540: Begin
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Validate the datetrack mode mode getting the validation start
544: -- and end dates for the specified datetrack operation.
545: --
558: --
559: p_validation_start_date := l_validation_start_date;
560: p_validation_end_date := l_validation_end_date;
561: --
562: hr_utility.set_location(' Leaving:'||l_proc, 10);
563: --
564: End ins_lck;
565: --
566: -- ----------------------------------------------------------------------------
576: l_validation_start_date date;
577: l_validation_end_date date;
578: --
579: Begin
580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: -- Call the lock operation
583: --
584: pay_frr_ins.ins_lck
648: --
649: -- Call to raise any errors on multi-message list
650: hr_multi_message.end_validation_set;
651: --
652: hr_utility.set_location('Leaving:'||l_proc,10);
653: end ins;
654: --
655: -- ----------------------------------------------------------------------------
656: -- |---------------------------------< ins >----------------------------------|
675: l_rec pay_frr_shd.g_rec_type;
676: l_proc varchar2(72) := g_package||'ins';
677: --
678: Begin
679: hr_utility.set_location('Entering:'||l_proc, 5);
680: --
681: -- Call conversion function to turn arguments into the
682: -- p_rec structure.
683: --
714: p_effective_end_date := l_rec.effective_end_date;
715: p_object_version_number := l_rec.object_version_number;
716: --
717: --
718: hr_utility.set_location(' Leaving:'||l_proc, 10);
719: End ins;
720: --
721: end pay_frr_ins;