[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_evq_ins.g_event_qualifier_id_i := p_event_qualifier_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_evq_ins.g_event_qualifier_id_i := p_event_qualifier_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_event_qualifiers_f.last_updated_by%TYPE;
102: l_last_update_login pay_event_qualifiers_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;
198: ,l_last_update_login
199: );
200: --
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 15);
203: --
204: Exception
205: When hr_api.check_integrity_violated Then
206: -- A check constraint has been violated
278: --
279: l_proc varchar2(72) := g_package||'insert_dml';
280: --
281: Begin
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: pay_evq_ins.dt_insert_dml
285: (p_rec => p_rec
286: ,p_effective_date => p_effective_date
288: ,p_validation_start_date => p_validation_start_date
289: ,p_validation_end_date => p_validation_end_date
290: );
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: End insert_dml;
294: --
295: -- ----------------------------------------------------------------------------
296: -- |------------------------------< pre_insert >------------------------------|
350: l_proc varchar2(72) := g_package||'pre_insert';
351: l_exists varchar2(1);
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: If (pay_evq_ins.g_event_qualifier_id_i is not null) Then
357: --
358: -- Verify registered primary key values not already in use
387: Close C_Sel1;
388: End If;
389: --
390: --
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: End pre_insert;
393: --
394: -- ----------------------------------------------------------------------------
395: -- |----------------------------< post_insert >-------------------------------|
433: --
434: l_proc varchar2(72) := g_package||'post_insert';
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 5);
438: begin
439: --
440: -- insert ownerships if applicable
441: create_app_ownerships
491: ,p_hook_type => 'AI');
492: --
493: end;
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: End post_insert;
497: --
498: -- ----------------------------------------------------------------------------
499: -- |-------------------------------< ins_lck >--------------------------------|
543: l_validation_start_date date;
544: l_validation_end_date date;
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Validate the datetrack mode mode getting the validation start
550: -- and end dates for the specified datetrack operation.
551: --
564: --
565: p_validation_start_date := l_validation_start_date;
566: p_validation_end_date := l_validation_end_date;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: --
570: End ins_lck;
571: --
572: -- ----------------------------------------------------------------------------
582: l_validation_start_date date;
583: l_validation_end_date date;
584: --
585: Begin
586: hr_utility.set_location('Entering:'||l_proc, 5);
587: --
588: -- Call the lock operation
589: --
590: pay_evq_ins.ins_lck
640: --
641: -- Call to raise any errors on multi-message list
642: hr_multi_message.end_validation_set;
643: --
644: hr_utility.set_location('Leaving:'||l_proc,10);
645: end ins;
646: --
647: -- ----------------------------------------------------------------------------
648: -- |---------------------------------< ins >----------------------------------|
669: l_rec pay_evq_shd.g_rec_type;
670: l_proc varchar2(72) := g_package||'ins';
671: --
672: Begin
673: hr_utility.set_location('Entering:'||l_proc, 5);
674: --
675: -- Call conversion function to turn arguments into the
676: -- p_rec structure.
677: --
710: p_effective_end_date := l_rec.effective_end_date;
711: p_object_version_number := l_rec.object_version_number;
712: --
713: --
714: hr_utility.set_location(' Leaving:'||l_proc, 10);
715: End ins;
716: --
717: end pay_evq_ins;