[Home] [Help]
16: --
17: l_proc varchar2(72) := g_package||'set_base_key_value';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 10);
21: --
22: ota_tav_ins.g_activity_version_id_i := p_activity_version_id;
23: --
24: hr_utility.set_location(' Leaving:'||l_proc, 20);
20: hr_utility.set_location('Entering:'||l_proc, 10);
21: --
22: ota_tav_ins.g_activity_version_id_i := p_activity_version_id;
23: --
24: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: End set_base_key_value;
26: -- ----------------------------------------------------------------------------
27: -- |------------------------------< insert_dml >------------------------------|
28: -- ----------------------------------------------------------------------------
70: --
71: l_proc varchar2(72) := g_package||'insert_dml';
72: --
73: Begin
74: hr_utility.set_location('Entering:'||l_proc, 5);
75: p_rec.object_version_number := 1; -- Initialise the object version
76: --
77: ota_tav_shd.g_api_dml := true; -- Set the api dml status
78: --
199: );
200: --
201: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: Exception
205: When hr_api.check_integrity_violated Then
206: -- A check constraint has been violated
207: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
273: ota_tav_ins.g_activity_version_id_i;
274: --
275: l_exists varchar2(1);
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: If (ota_tav_ins.g_activity_version_id_i is not null) Then
279: --
280: -- Verify registered primary key values not already in use
281: --
311: --
312:
313: END IF;
314:
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: End pre_insert;
317: --
318: -- ----------------------------------------------------------------------------
319: -- |-----------------------------< post_insert >------------------------------|
351: --
352: l_proc varchar2(72) := g_package||'post_insert';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: ota_tav_api_business_rules.set_superseding_version
357: (p_rec.activity_id
358: ,p_rec.activity_version_id
359: ,p_rec.start_date);
356: ota_tav_api_business_rules.set_superseding_version
357: (p_rec.activity_id
358: ,p_rec.activity_version_id
359: ,p_rec.start_date);
360: hr_utility.set_location(' Leaving:'||l_proc, 10);
361: End post_insert;
362: --
363: -- ----------------------------------------------------------------------------
364: -- |---------------------------------< ins >----------------------------------|
371: --
372: l_proc varchar2(72) := g_package||'ins';
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: -- Determine if the business process is to be validated.
378: --
379: If p_validate then
410: If p_validate then
411: Raise HR_Api.Validate_Enabled;
412: End If;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: Exception
416: When HR_Api.Validate_Enabled Then
417: --
418: -- As the Validate_Enabled exception has been raised
490: l_rec ota_tav_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'ins';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);
495: --
496: -- Call conversion function to turn arguments into the
497: -- p_rec structure.
498: --
569: --
570: p_activity_version_id:=l_rec.activity_version_id;
571: p_object_version_number:=l_rec.object_version_number;
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: End ins;
575: --
576: end ota_tav_ins;