[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: --
197: );
198: --
199: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: Exception
203: When hr_api.check_integrity_violated Then
204: -- A check constraint has been violated
205: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
271: ota_tav_ins.g_activity_version_id_i;
272: --
273: l_exists varchar2(1);
274: Begin
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: If (ota_tav_ins.g_activity_version_id_i is not null) Then
277: --
278: -- Verify registered primary key values not already in use
279: --
309: --
310:
311: END IF;
312:
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End pre_insert;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |-----------------------------< post_insert >------------------------------|
349: --
350: l_proc varchar2(72) := g_package||'post_insert';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: ota_tav_api_business_rules.set_superseding_version
355: (p_rec.activity_id
356: ,p_rec.activity_version_id
357: ,p_rec.start_date);
354: ota_tav_api_business_rules.set_superseding_version
355: (p_rec.activity_id
356: ,p_rec.activity_version_id
357: ,p_rec.start_date);
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End post_insert;
360: --
361: -- ----------------------------------------------------------------------------
362: -- |---------------------------------< ins >----------------------------------|
369: --
370: l_proc varchar2(72) := g_package||'ins';
371: --
372: Begin
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: -- Determine if the business process is to be validated.
376: --
377: If p_validate then
408: If p_validate then
409: Raise HR_Api.Validate_Enabled;
410: End If;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: Exception
414: When HR_Api.Validate_Enabled Then
415: --
416: -- As the Validate_Enabled exception has been raised
487: l_rec ota_tav_shd.g_rec_type;
488: l_proc varchar2(72) := g_package||'ins';
489: --
490: Begin
491: hr_utility.set_location('Entering:'||l_proc, 5);
492: --
493: -- Call conversion function to turn arguments into the
494: -- p_rec structure.
495: --
565: --
566: p_activity_version_id:=l_rec.activity_version_id;
567: p_object_version_number:=l_rec.object_version_number;
568: --
569: hr_utility.set_location(' Leaving:'||l_proc, 10);
570: End ins;
571: --
572: end ota_tav_ins;