[Home] [Help]
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_tps_ins.g_training_plan_id_i := p_training_plan_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: ota_tps_ins.g_training_plan_id_i := p_training_plan_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: End set_base_key_value;
27: -- ----------------------------------------------------------------------------
28: -- |------------------------------< insert_dml >------------------------------|
29: -- ----------------------------------------------------------------------------
73: --
74: l_proc varchar2(72) := g_package||'insert_dml';
75: --
76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);
78: p_rec.object_version_number := 1; -- Initialise the object version
79: --
80: ota_tps_shd.g_api_dml := true; -- Set the api dml status
81: --
183: );
184: --
185: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
259: --
260: l_exists varchar2(1);
261:
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: If (ota_tps_ins.g_training_plan_id_i is not null) Then
265: --
266: -- Verify registered primary key values not already in use
267: --
294: Close C_Sel1;
295:
296: END IF;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 10);
299: End pre_insert;
300: --
301: -- ----------------------------------------------------------------------------
302: -- |-----------------------------< post_insert >------------------------------|
337: --
338: l_proc varchar2(72) := g_package||'post_insert';
339: --
340: Begin
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: begin
343: --
344: ota_tps_rki.after_insert
345: (p_effective_date => p_effective_date
443: ,p_hook_type => 'AI');
444: --
445: end;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 10);
448: End post_insert;
449: --
450: -- ----------------------------------------------------------------------------
451: -- |---------------------------------< ins >----------------------------------|
457: --
458: l_proc varchar2(72) := g_package||'ins';
459: --
460: Begin
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: --
463: -- Call the supporting insert validate operations
464: --
465: ota_tps_bus.insert_validate
487: --
488: --CALL TO RAISE ANY ERRORS ON MULTI MESSAGE LIST
489: hr_multi_message.end_validation_set;
490:
491: hr_utility.set_location('Leaving:'||l_proc, 20);
492: end ins;
493: --
494: -- ----------------------------------------------------------------------------
495: -- |---------------------------------< ins >----------------------------------|
549: l_rec ota_tps_shd.g_rec_type;
550: l_proc varchar2(72) := g_package||'ins';
551: --
552: Begin
553: hr_utility.set_location('Entering:'||l_proc, 5);
554: --
555: -- Call conversion function to turn arguments into the
556: -- p_rec structure.
557: --
620: --
621: p_training_plan_id := l_rec.training_plan_id;
622: p_object_version_number := l_rec.object_version_number;
623: --
624: hr_utility.set_location(' Leaving:'||l_proc, 10);
625: End ins;
626: --
627: end ota_tps_ins;