[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_liv_ins.g_link_input_value_id_i := p_link_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_liv_ins.g_link_input_value_id_i := p_link_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_link_input_values_f.last_updated_by%TYPE;
102: l_last_update_login pay_link_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;
190: ,l_last_update_login
191: );
192: --
193: pay_liv_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
222: --
223: l_proc varchar2(72) := g_package||'insert_dml';
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: pay_liv_ins.dt_insert_dml
229: (p_rec => p_rec
230: ,p_effective_date => p_effective_date
232: ,p_validation_start_date => p_validation_start_date
233: ,p_validation_end_date => p_validation_end_date
234: );
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: End insert_dml;
238: --
239: -- ----------------------------------------------------------------------------
240: -- |------------------------------< pre_insert >------------------------------|
294: l_proc varchar2(72) := g_package||'pre_insert';
295: l_exists varchar2(1);
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: If (pay_liv_ins.g_link_input_value_id_i is not null) Then
301: --
302: -- Verify registered primary key values not already in use
331: Close C_Sel1;
332: End If;
333: --
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: End pre_insert;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |----------------------------< post_insert >-------------------------------|
377: --
378: l_proc varchar2(72) := g_package||'post_insert';
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: begin
383: --
384: pay_liv_rki.after_insert
385: (p_effective_date
421: ,p_hook_type => 'AI');
422: --
423: end;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: End post_insert;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |-------------------------------< ins_lck >--------------------------------|
473: l_validation_start_date date;
474: l_validation_end_date date;
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Validate the datetrack mode mode getting the validation start
480: -- and end dates for the specified datetrack operation.
481: --
500: --
501: p_validation_start_date := l_validation_start_date;
502: p_validation_end_date := l_validation_end_date;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 10);
505: --
506: End ins_lck;
507: --
508: -- ----------------------------------------------------------------------------
518: l_validation_start_date date;
519: l_validation_end_date date;
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Call the lock operation
525: --
526: pay_liv_ins.ins_lck
577: --
578: -- Call to raise any errors on multi-message list
579: hr_multi_message.end_validation_set;
580: --
581: hr_utility.set_location('Leaving:'||l_proc,10);
582: end ins;
583: --
584: -- ----------------------------------------------------------------------------
585: -- |---------------------------------< ins >----------------------------------|
602: l_rec pay_liv_shd.g_rec_type;
603: l_proc varchar2(72) := g_package||'ins';
604: --
605: Begin
606: hr_utility.set_location('Entering:'||l_proc, 5);
607: --
608: -- Call conversion function to turn arguments into the
609: -- p_rec structure.
610: --
639: p_effective_end_date := l_rec.effective_end_date;
640: p_object_version_number := l_rec.object_version_number;
641: --
642: --
643: hr_utility.set_location(' Leaving:'||l_proc, 10);
644: End ins;
645: --
646: end pay_liv_ins;