[Home] [Help]
58: exception
59: when app_exception.application_exception then
60: if hr_multi_message.exception_add
61: (p_associated_column1 => 'RULE_TYPE') then
62: hr_utility.set_location(' Leaving:'|| l_proc, 50);
63: raise;
64: end if;
65: hr_utility.set_location(' Leaving:'|| l_proc, 60);
66: return(null);
61: (p_associated_column1 => 'RULE_TYPE') then
62: hr_utility.set_location(' Leaving:'|| l_proc, 50);
63: raise;
64: end if;
65: hr_utility.set_location(' Leaving:'|| l_proc, 60);
66: return(null);
67: end getNextRuleKey;
68: --
69: -- ----------------------------------------------------------------------------
74: --
75: l_proc varchar2(72) := g_package||'set_base_key_value';
76: --
77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 10);
79: --
80: ame_rul_ins.g_rule_id_i := p_rule_id;
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 20);
78: hr_utility.set_location('Entering:'||l_proc, 10);
79: --
80: ame_rul_ins.g_rule_id_i := p_rule_id;
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 20);
83: End set_base_key_value;
84: --
85: --
86: -- ----------------------------------------------------------------------------
163: l_current_user_id integer;
164: l_temp_count integer;
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: -- Set the effective start and end dates to the corresponding
170: -- validation start and end dates
171: --
176: -- If the datetrack_mode is not INSERT then we must populate the WHO
177: -- columns with the 'old' creation values and 'new' updated values.
178: --
179: If (p_datetrack_mode <> hr_api.g_insert) then
180: hr_utility.set_location(l_proc, 10);
181: --
182: -- Get the object version number for the insert
183: --
184: p_rec.object_version_number :=
286: ,l_last_update_login
287: );
288: --
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 15);
291: --
292: Exception
293: When hr_api.check_integrity_violated Then
294: -- A check constraint has been violated
318: --
319: l_proc varchar2(72) := g_package||'insert_dml';
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: ame_rul_ins.dt_insert_dml
325: (p_rec => p_rec
326: ,p_effective_date => p_effective_date
328: ,p_validation_start_date => p_validation_start_date
329: ,p_validation_end_date => p_validation_end_date
330: );
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 10);
333: End insert_dml;
334: --
335: -- ----------------------------------------------------------------------------
336: -- |------------------------------< pre_insert >------------------------------|
395: l_proc varchar2(72) := g_package||'pre_insert';
396: l_exists varchar2(1);
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: If (ame_rul_ins.g_rule_id_i is not null) Then
402: --
403: -- Verify registered primary key values not already in use
438: if p_rec.rule_key is null then
439: p_rec.rule_key := getNextRuleKey;
440: end if;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: End pre_insert;
444: --
445: -- ----------------------------------------------------------------------------
446: -- |----------------------------< post_insert >-------------------------------|
484: --
485: l_proc varchar2(72) := g_package||'post_insert';
486: --
487: Begin
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: begin
490: --
491: ame_rul_rki.after_insert
492: (p_effective_date
526: ,p_hook_type => 'AI');
527: --
528: end;
529: --
530: hr_utility.set_location(' Leaving:'||l_proc, 10);
531: End post_insert;
532: --
533: -- ----------------------------------------------------------------------------
534: -- |-------------------------------< ins_lck >--------------------------------|
578: l_validation_start_date date;
579: l_validation_end_date date;
580: --
581: Begin
582: hr_utility.set_location('Entering:'||l_proc, 5);
583: --
584: -- Validate the datetrack mode mode getting the validation start
585: -- and end dates for the specified datetrack operation.
586: --
592: -- MURTHY_CHANGES
593: p_validation_start_date := sysdate;
594: p_validation_end_date := ame_utility_pkg.endOfTime;
595: --
596: hr_utility.set_location(' Leaving:'||l_proc, 10);
597: --
598: End ins_lck;
599: --
600: -- ----------------------------------------------------------------------------
610: l_validation_start_date date;
611: l_validation_end_date date;
612: --
613: Begin
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- Call the lock operation
617: --
618: ame_rul_ins.ins_lck
676: --
677: -- Call to raise any errors on multi-message list
678: hr_multi_message.end_validation_set;
679: --
680: hr_utility.set_location('Leaving:'||l_proc,10);
681: end ins;
682: --
683: -- ----------------------------------------------------------------------------
684: -- |---------------------------------< ins >----------------------------------|
700: l_rec ame_rul_shd.g_rec_type;
701: l_proc varchar2(72) := g_package||'ins';
702: --
703: Begin
704: hr_utility.set_location('Entering:'||l_proc, 5);
705: --
706: -- Call conversion function to turn arguments into the
707: -- p_rec structure.
708: --
736: p_end_date := l_rec.end_date;
737: p_object_version_number := l_rec.object_version_number;
738: --
739: --
740: hr_utility.set_location(' Leaving:'||l_proc, 10);
741: End ins;
742: --
743: end ame_rul_ins;