17: --
18: l_proc varchar2(72) := g_package||'set_base_key_value';
19: --
20: Begin
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: ota_tpm_ins.g_training_plan_member_id_i := p_training_plan_member_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: ota_tpm_ins.g_training_plan_member_id_i := p_training_plan_member_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: End set_base_key_value;
27:
28: -- ----------------------------------------------------------------------------
29: -- |------------------------------< insert_dml >------------------------------|
75: l_proc varchar2(72) := g_package||'insert_dml';
76: l_boolean boolean := null;
77: --
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: --Bug3507060
83: -- Set the Is_Per_Trng_Plan global variable
181: );
182: --
183: --
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
256: ota_tpm_ins.g_training_plan_member_id_i;
257: --
258: l_exists varchar2(1);
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: If (ota_tpm_ins.g_training_plan_member_id_i is not null) Then
262: --
263: -- Verify registered primary key values not already in use
264: --
291: Close C_Sel1;
292:
293: END IF;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End pre_insert;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |-----------------------------< post_insert >------------------------------|
334: --
335: l_proc varchar2(72) := g_package||'post_insert';
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: begin
340: --
341: ota_tpm_rki.after_insert
342: (p_effective_date => p_effective_date
435: ,p_hook_type => 'AI');
436: --
437: end;
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End post_insert;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |---------------------------------< ins >----------------------------------|
449: --
450: l_proc varchar2(72) := g_package||'ins';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);
454: --
455: -- Call the supporting insert validate operations
456: --
457: ota_tpm_bus.insert_validate
476: );
477: --
478: hr_multi_message.end_validation_set;
479: --
480: hr_utility.set_location('Leaving:'||l_proc, 20);
481: end ins;
482: --
483: -- ----------------------------------------------------------------------------
484: -- |---------------------------------< ins >----------------------------------|
535: l_rec ota_tpm_shd.g_rec_type;
536: l_proc varchar2(72) := g_package||'ins';
537: --
538: Begin
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: -- Call conversion function to turn arguments into the
542: -- p_rec structure.
543: --
603: --
604: p_training_plan_member_id := l_rec.training_plan_member_id;
605: p_object_version_number := l_rec.object_version_number;
606: --
607: hr_utility.set_location(' Leaving:'||l_proc, 10);
608: End ins;
609: --
610: end ota_tpm_ins;