[Home] [Help]
22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_cnu_ins.g_rule_id_i := p_rule_id;
29: ame_cnu_ins.g_condition_id_i := p_condition_id;
30: --
27: --
28: ame_cnu_ins.g_rule_id_i := p_rule_id;
29: ame_cnu_ins.g_condition_id_i := p_condition_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
114: l_current_user_id integer;
115: l_temp_count integer;
116: --
117: Begin
118: hr_utility.set_location('Entering:'||l_proc, 5);
119: --
120: -- Set the effective start and end dates to the corresponding
121: -- validation start and end dates
122: --
127: -- If the datetrack_mode is not INSERT then we must populate the WHO
128: -- columns with the 'old' creation values and 'new' updated values.
129: --
130: If (p_datetrack_mode <> hr_api.g_insert) then
131: hr_utility.set_location(l_proc, 10);
132: --
133: -- Get the object version number for the insert
134: --
135: p_rec.object_version_number :=
230: ,l_last_update_login
231: );
232: --
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 15);
235: --
236: Exception
237: When hr_api.check_integrity_violated Then
238: -- A check constraint has been violated
262: --
263: l_proc varchar2(72) := g_package||'insert_dml';
264: --
265: Begin
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: ame_cnu_ins.dt_insert_dml
269: (p_rec => p_rec
270: ,p_effective_date => p_effective_date
272: ,p_validation_start_date => p_validation_start_date
273: ,p_validation_end_date => p_validation_end_date
274: );
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End insert_dml;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |------------------------------< pre_insert >------------------------------|
341: l_proc varchar2(72) := g_package||'pre_insert';
342: l_exists varchar2(1);
343: --
344: Begin
345: hr_utility.set_location('Entering:'||l_proc, 5);
346: --
347: If (ame_cnu_ins.g_rule_id_i is not null or
348: ame_cnu_ins.g_condition_id_i is not null) Then
349: --
372: ame_cnu_ins.g_condition_id_i := null;
373: End If;
374: --
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: End pre_insert;
378: --
379: -- ----------------------------------------------------------------------------
380: -- |----------------------------< post_insert >-------------------------------|
418: --
419: l_proc varchar2(72) := g_package||'post_insert';
420: --
421: Begin
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: begin
424: --
425: ame_cnu_rki.after_insert
426: (p_effective_date
452: ,p_hook_type => 'AI');
453: --
454: end;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End post_insert;
458: --
459: -- ----------------------------------------------------------------------------
460: -- |-------------------------------< ins_lck >--------------------------------|
505: l_validation_start_date date;
506: l_validation_end_date date;
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Validate the datetrack mode mode getting the validation start
512: -- and end dates for the specified datetrack operation.
513: --
547: fnd_message.set_token('STEP','40');
548: fnd_message.raise_error;
549: end;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: End ins_lck;
553: --
554: -- ----------------------------------------------------------------------------
555: -- |---------------------------------< ins >----------------------------------|
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: ame_cnu_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 >----------------------------------|
642: l_rec ame_cnu_shd.g_rec_type;
643: l_proc varchar2(72) := g_package||'ins';
644: --
645: Begin
646: hr_utility.set_location('Entering:'||l_proc, 5);
647: --
648: -- Call conversion function to turn arguments into the
649: -- p_rec structure.
650: --
673: p_end_date := l_rec.end_date;
674: p_object_version_number := l_rec.object_version_number;
675: --
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: End ins;
679: --
680: end ame_cnu_ins;