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_evt_ins.g_event_id_i := p_event_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: ota_evt_ins.g_event_id_i := p_event_id;
24: --
25: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: End set_base_key_value;
27:
28: -- ----------------------------------------------------------------------------
29: -- |------------------------------< insert_dml >------------------------------|
72: --
73: l_proc varchar2(72) := g_package||'insert_dml';
74: --
75: Begin
76: hr_utility.set_location('Entering:'||l_proc, 5);
77: p_rec.object_version_number := 1; -- Initialise the object version
78: --
79: ota_evt_shd.g_api_dml := true; -- Set the api dml status
80: --
220: );
221: --
222: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
295: ota_evt_ins.g_event_id_i;
296: --
297: l_exists varchar2(1);
298: Begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: If (ota_evt_ins.g_event_id_i is not null) Then
301: --
302: -- Verify registered primary key values not already in use
303: --
330: Close C_Sel1;
331:
332: END IF;
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 10);
335: End pre_insert;
336: --
337:
338:
373: l_proc varchar2(72) := g_package||'post_insert';
374: l_return boolean;
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: /* commented out to fix bug 3385192. The call is moved to ota_tdb_ins.post_insert */
379: /* IF p_rec.line_id is not null then
380: l_return := ota_utility.check_wf_status(p_rec.line_id,'BLOCK');
381: IF l_return = TRUE THEN
386: END IF;
387:
388: END IF;*/
389:
390: hr_utility.set_location(' Leaving:'||l_proc, 10);
391: End post_insert;
392: --
393: -- ----------------------------------------------------------------------------
394: -- |---------------------------------< ins >----------------------------------|
401: --
402: l_proc varchar2(72) := g_package||'ins';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Determine if the business process is to be validated.
408: --
409: If p_validate then
440: If p_validate then
441: Raise HR_Api.Validate_Enabled;
442: End If;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 10);
445: Exception
446: When HR_Api.Validate_Enabled Then
447: --
448: -- As the Validate_Enabled exception has been raised
529: l_rec ota_evt_shd.g_rec_type;
530: l_proc varchar2(72) := g_package||'ins';
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Call conversion function to turn arguments into the
536: -- p_rec structure.
537: --
617: --
618: p_event_id := l_rec.event_id;
619: p_object_version_number := l_rec.object_version_number;
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 10);
622: End ins;
623: --
624: end ota_evt_ins;