[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_ivl_ins.g_input_value_id_i := p_input_value_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_ivl_ins.g_input_value_id_i := p_input_value_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_input_values_f.last_updated_by%TYPE;
102: l_last_update_login pay_input_values_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;
210: ,l_last_update_login
211: );
212: --
213: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
214: hr_utility.set_location(' Leaving:'||l_proc, 15);
215: --
216: Exception
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
290: --
291: l_proc varchar2(72) := g_package||'insert_dml';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: pay_ivl_ins.dt_insert_dml
297: (p_rec => p_rec
298: ,p_effective_date => p_effective_date
300: ,p_validation_start_date => p_validation_start_date
301: ,p_validation_end_date => p_validation_end_date
302: );
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: End insert_dml;
306: --
307: -- ----------------------------------------------------------------------------
308: -- |------------------------------< pre_insert >------------------------------|
362: l_proc varchar2(72) := g_package||'pre_insert';
363: l_exists varchar2(1);
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: If (pay_ivl_ins.g_input_value_id_i is not null) Then
369: --
370: -- Verify registered primary key values not already in use
399: Close C_Sel1;
400: End If;
401: --
402: --
403: hr_utility.set_location(' Leaving:'||l_proc, 10);
404: End pre_insert;
405: --
406: -- ----------------------------------------------------------------------------
407: -- |----------------------------< post_insert >-------------------------------|
445: --
446: l_proc varchar2(72) := g_package||'post_insert';
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: begin
451: --
452: -- insert ownerships if applicable
453: create_app_ownerships
515: ,p_hook_type => 'AI');
516: --
517: end;
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
520: End post_insert;
521: --
522: -- ----------------------------------------------------------------------------
523: -- |-------------------------------< ins_lck >--------------------------------|
567: l_validation_start_date date;
568: l_validation_end_date date;
569: --
570: Begin
571: hr_utility.set_location('Entering:'||l_proc, 5);
572: --
573: -- Validate the datetrack mode mode getting the validation start
574: -- and end dates for the specified datetrack operation.
575: --
591: --
592: p_validation_start_date := l_validation_start_date;
593: p_validation_end_date := l_validation_end_date;
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: --
597: End ins_lck;
598: --
599: -- ----------------------------------------------------------------------------
621: where element_type_id = p_rec.element_type_id;
622:
623: --
624: Begin
625: hr_utility.set_location('Entering:'||l_proc, 5);
626: --
627: -- Call the lock operation
628: --
629: pay_ivl_ins.ins_lck
691:
692: -- Call to raise any errors on multi-message list
693: hr_multi_message.end_validation_set;
694: --
695: hr_utility.set_location('Leaving:'||l_proc,10);
696: end ins;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------------< ins >----------------------------------|
733: l_proc varchar2(72) := g_package||'ins';
734: l_name pay_input_values_f.name%type;
735: --
736: Begin
737: hr_utility.set_location('Entering:'||l_proc, 5);
738: --
739: -- Check for Pay Value special case
740: -- whereby 'PAY VALUE' goes into base table
741: -- (instead of base language value)
804: ,l_name
805: );
806:
807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: End ins;
810: --
811: end pay_ivl_ins;