[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_ecu_ins.g_element_class_usage_id_i := p_element_class_usage_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_ecu_ins.g_element_class_usage_id_i := p_element_class_usage_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_element_class_usages_f.last_updated_by%TYPE;
102: l_last_update_login pay_element_class_usages_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 :=
193: ,l_last_update_login
194: );
195: --
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 15);
198: --
199: Exception
200: When hr_api.check_integrity_violated Then
201: -- A check constraint has been violated
273: --
274: l_proc varchar2(72) := g_package||'insert_dml';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: pay_ecu_ins.dt_insert_dml
280: (p_rec => p_rec
281: ,p_effective_date => p_effective_date
283: ,p_validation_start_date => p_validation_start_date
284: ,p_validation_end_date => p_validation_end_date
285: );
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End insert_dml;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |------------------------------< pre_insert >------------------------------|
345: l_proc varchar2(72) := g_package||'pre_insert';
346: l_exists varchar2(1);
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: If (pay_ecu_ins.g_element_class_usage_id_i is not null) Then
352: --
353: -- Verify registered primary key values not already in use
382: Close C_Sel1;
383: End If;
384: --
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 10);
387: End pre_insert;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |----------------------------< post_insert >-------------------------------|
428: --
429: l_proc varchar2(72) := g_package||'post_insert';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: begin
434: --
435: -- insert ownerships if applicable
436: create_app_ownerships
472: ,p_hook_type => 'AI');
473: --
474: end;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 10);
477: End post_insert;
478: --
479: -- ----------------------------------------------------------------------------
480: -- |-------------------------------< ins_lck >--------------------------------|
524: l_validation_start_date date;
525: l_validation_end_date date;
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: -- Validate the datetrack mode mode getting the validation start
531: -- and end dates for the specified datetrack operation.
532: --
545: --
546: p_validation_start_date := l_validation_start_date;
547: p_validation_end_date := l_validation_end_date;
548: --
549: hr_utility.set_location(' Leaving:'||l_proc, 10);
550: --
551: End ins_lck;
552: --
553: -- ----------------------------------------------------------------------------
563: l_validation_start_date date;
564: l_validation_end_date date;
565: --
566: Begin
567: hr_utility.set_location('Entering:'||l_proc, 5);
568: --
569: -- Call the lock operation
570: --
571: pay_ecu_ins.ins_lck
621: --
622: -- Call to raise any errors on multi-message list
623: hr_multi_message.end_validation_set;
624: --
625: hr_utility.set_location('Leaving:'||l_proc,10);
626: end ins;
627: --
628: -- ----------------------------------------------------------------------------
629: -- |---------------------------------< ins >----------------------------------|
643: l_rec pay_ecu_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'ins';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Call conversion function to turn arguments into the
650: -- p_rec structure.
651: --
677: p_effective_end_date := l_rec.effective_end_date;
678: p_object_version_number := l_rec.object_version_number;
679: --
680: --
681: hr_utility.set_location(' Leaving:'||l_proc, 10);
682: End ins;
683: --
684: end pay_ecu_ins;