20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_ors_ins.g_organization_structure_id_i := p_organization_structure_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_ors_ins.g_organization_structure_id_i := p_organization_structure_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: per_ors_shd.g_api_dml := true; -- Set the api dml status
86: --
156: );
157: --
158: per_ors_shd.g_api_dml := false; -- Unset the api dml status
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: per_ors_shd.g_api_dml := false; -- Unset the api dml status
231: l_proc varchar2(72) := g_package||'pre_insert';
232: l_exists varchar2(1);
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: If (per_ors_ins.g_organization_structure_id_i is not null) Then
238: --
239: -- Verify registered primary key values not already in use
267: Fetch C_Sel1 Into p_rec.organization_structure_id;
268: Close C_Sel1;
269: End If;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End pre_insert;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |-----------------------------< post_insert >------------------------------|
310: --
311: l_proc varchar2(72) := g_package||'post_insert';
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: begin
316: --
317: per_ors_rki.after_insert
318: (p_effective_date => p_effective_date
391: ,p_hook_type => 'AI');
392: --
393: end;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End post_insert;
397: --
398: -- ----------------------------------------------------------------------------
399: -- |---------------------------------< ins >----------------------------------|
405: --
406: l_proc varchar2(72) := g_package||'ins';
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Call the supporting insert validate operations
412: --
413: per_ors_bus.insert_validate
429: (p_effective_date
430: ,p_rec
431: );
432: --
433: hr_utility.set_location('Leaving:'||l_proc, 20);
434: end ins;
435: --
436: -- ----------------------------------------------------------------------------
437: -- |---------------------------------< ins >----------------------------------|
475: l_rec per_ors_shd.g_rec_type;
476: l_proc varchar2(72) := g_package||'ins';
477: --
478: Begin
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: -- Call conversion function to turn arguments into the
482: -- p_rec structure.
483: --
530: --
531: p_organization_structure_id := l_rec.organization_structure_id;
532: p_object_version_number := l_rec.object_version_number;
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 10);
535: End ins;
536: --
537: end per_ors_ins;