[Home] [Help]
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: hr_oru_ins.g_organization_id_i := p_organization_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_oru_ins.g_organization_id_i := p_organization_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|
77: --
78: l_proc varchar2(72) := g_package||'insert_dml';
79: --
80: Begin
81: hr_utility.set_location('Entering:'||l_proc, 5);
82: p_rec.object_version_number := 1; -- Initialise the object version
83: --
84: hr_oru_shd.g_api_dml := true; -- Set the api dml status
85: --
183: );
184: --
185: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
251: --
252: Cursor C_Sel1 is select hr_organization_units_s.nextval from sys.dual;
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: --
258: -- Select the next sequence number
259: --
260: Open C_Sel1;
261: Fetch C_Sel1 Into p_rec.organization_id;
262: Close C_Sel1;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End pre_insert;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |-----------------------------< post_insert >------------------------------|
303: --
304: l_proc varchar2(72) := g_package||'post_insert';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: begin
309: --
310: hr_oru_rki.after_insert
311: (p_effective_date => p_effective_date
410: ,p_hook_type => 'AI');
411: --
412: end;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: End post_insert;
416: --
417: -- ----------------------------------------------------------------------------
418: -- |---------------------------------< ins >----------------------------------|
435: --
436: l_proc varchar2(72) := g_package||'ins';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: -- Call the supporting insert validate operations
442: --
443: hr_oru_bus.insert_validate
475: ,p_rec.organization_id);
476: end if;
477: -- End Fix 3565334
478: --
479: hr_utility.set_location('Leaving:'||l_proc, 20);
480: end ins;
481: --
482: -- ----------------------------------------------------------------------------
483: -- |---------------------------------< ins >----------------------------------|
536: l_rec hr_oru_shd.g_rec_type;
537: l_proc varchar2(72) := g_package||'ins';
538: --
539: Begin
540: hr_utility.set_location('Entering:'||l_proc, 5);
541: --
542: -- Call conversion function to turn arguments into the
543: -- p_rec structure.
544: --
610: --
611: p_organization_id := l_rec.organization_id;
612: p_object_version_number := l_rec.object_version_number;
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End ins;
616: --
617: end hr_oru_ins;