[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: ff_fgl_ins.g_global_id_i := p_global_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ff_fgl_ins.g_global_id_i := p_global_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 ff_globals_f.last_updated_by%TYPE;
102: l_last_update_login ff_globals_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 :=
190: ,l_last_update_login
191: );
192: --
193: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
194: hr_utility.set_location(' Leaving:'||l_proc, 15);
195: --
196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
270: --
271: l_proc varchar2(72) := g_package||'insert_dml';
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: ff_fgl_ins.dt_insert_dml
277: (p_rec => p_rec
278: ,p_effective_date => p_effective_date
280: ,p_validation_start_date => p_validation_start_date
281: ,p_validation_end_date => p_validation_end_date
282: );
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: End insert_dml;
286: --
287: -- ----------------------------------------------------------------------------
288: -- |------------------------------< pre_insert >------------------------------|
342: l_proc varchar2(72) := g_package||'pre_insert';
343: l_exists varchar2(1);
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: If (ff_fgl_ins.g_global_id_i is not null) Then
349: --
350: -- Verify registered primary key values not already in use
379: Close C_Sel1;
380: End If;
381: --
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End pre_insert;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |----------------------------< post_insert >-------------------------------|
425: --
426: l_proc varchar2(72) := g_package||'post_insert';
427: --
428: Begin
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: begin
431: --
432: -- insert ownerships if applicable
433: create_app_ownerships
473: ,p_hook_type => 'AI');
474: --
475: end;
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 10);
478: End post_insert;
479: --
480: -- ----------------------------------------------------------------------------
481: -- |-------------------------------< ins_lck >--------------------------------|
525: l_validation_start_date date;
526: l_validation_end_date date;
527: --
528: Begin
529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: -- Validate the datetrack mode mode getting the validation start
532: -- and end dates for the specified datetrack operation.
533: --
546: --
547: p_validation_start_date := l_validation_start_date;
548: p_validation_end_date := l_validation_end_date;
549: --
550: hr_utility.set_location(' Leaving:'||l_proc, 10);
551: --
552: End ins_lck;
553: --
554: -- ----------------------------------------------------------------------------
564: l_validation_start_date date;
565: l_validation_end_date date;
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Call the lock operation
571: --
572: ff_fgl_ins.ins_lck
622: --
623: -- Call to raise any errors on multi-message list
624: hr_multi_message.end_validation_set;
625: --
626: hr_utility.set_location('Leaving:'||l_proc,10);
627: end ins;
628: --
629: -- ----------------------------------------------------------------------------
630: -- |---------------------------------< ins >----------------------------------|
646: l_rec ff_fgl_shd.g_rec_type;
647: l_proc varchar2(72) := g_package||'ins';
648: --
649: Begin
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: --
652: -- Call conversion function to turn arguments into the
653: -- p_rec structure.
654: --
682: p_effective_end_date := l_rec.effective_end_date;
683: p_object_version_number := l_rec.object_version_number;
684: --
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);
687: End ins;
688: --
689: end ff_fgl_ins;