[Home] [Help]
22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ota_aci_ins.g_activity_version_id_i := p_activity_version_id;
29: ota_aci_ins.g_category_usage_id_i := p_category_usage_id;
30: --
27: --
28: ota_aci_ins.g_activity_version_id_i := p_activity_version_id;
29: ota_aci_ins.g_category_usage_id_i := p_category_usage_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --
84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: ota_aci_shd.g_api_dml := true; -- Set the api dml status
89: --
155: );
156: --
157: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
235: l_proc varchar2(72) := g_package||'pre_insert';
236: l_exists varchar2(1);
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: /*
241: --
242: If (ota_aci_ins.g_activity_version_id_i is not null or
243: ota_aci_ins.g_category_usage_id_i is not null) Then
277: Close C_Sel1;
278: End If;
279: --
280: */
281: hr_utility.set_location(' Leaving:'||l_proc, 10);
282: End pre_insert;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |-----------------------------< post_insert >------------------------------|
320: --
321: l_proc varchar2(72) := g_package||'post_insert';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: begin
326: --
327: ota_aci_rki.after_insert
328: (p_effective_date => p_effective_date
397: ,p_hook_type => 'AI');
398: --
399: end;
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 10);
402: End post_insert;
403: --
404: -- ----------------------------------------------------------------------------
405: -- |---------------------------------< ins >----------------------------------|
413: l_activity_version_id ota_act_cat_inclusions.activity_version_id%TYPE;
414: l_category_usage_id ota_act_cat_inclusions.category_usage_id%TYPE;
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);
418:
419: l_activity_version_id := p_rec.activity_version_id;
420: l_category_usage_id := p_rec.category_usage_id;
421:
455: --
456: -- Call to raise any errors on multi-message list
457: hr_multi_message.end_validation_set;
458: --
459: hr_utility.set_location('Leaving:'||l_proc, 20);
460: end ins;
461: --
462: -- ----------------------------------------------------------------------------
463: -- |---------------------------------< ins >----------------------------------|
501: l_rec ota_aci_shd.g_rec_type;
502: l_proc varchar2(72) := g_package||'ins';
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Call conversion function to turn arguments into the
508: -- p_rec structure.
509: --
557: -- p_activity_version_id := l_rec.activity_version_id;
558: -- p_category_usage_id := l_rec.category_usage_id;
559: p_object_version_number := l_rec.object_version_number;
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: End ins;
563: --
564: end ota_aci_ins;