[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_ori_ins.g_org_information_id_i := p_org_information_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_ori_ins.g_org_information_id_i := p_org_information_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_ori_shd.g_api_dml := true; -- Set the api dml status
85: --
181: );
182: --
183: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
249: --
250: Cursor C_Sel1 is select hr_organization_information_s.nextval from sys.dual;
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: --
256: -- Select the next sequence number
257: --
258: Open C_Sel1;
259: Fetch C_Sel1 Into p_rec.org_information_id;
260: Close C_Sel1;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: End pre_insert;
264: --
265: -- ----------------------------------------------------------------------------
266: -- |-----------------------------< post_insert >------------------------------|
301: --
302: l_proc varchar2(72) := g_package||'post_insert';
303: --
304: Begin
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: begin
307: --
308: hr_ori_rki.after_insert
309: (p_effective_date => p_effective_date
408: ,p_hook_type => 'AI');
409: --
410: end;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End post_insert;
414: --
415: -- ----------------------------------------------------------------------------
416: -- |---------------------------------< ins >----------------------------------|
422: --
423: l_proc varchar2(72) := g_package||'ins';
424: --
425: Begin
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: -- Call the supporting insert validate operations
429: --
430: hr_ori_bus.insert_validate
446: (p_effective_date
447: ,p_rec
448: );
449: --
450: hr_utility.set_location('Leaving:'||l_proc, 20);
451: end ins;
452: --
453: -- ----------------------------------------------------------------------------
454: -- |---------------------------------< ins >----------------------------------|
505: l_rec hr_ori_shd.g_rec_type;
506: l_proc varchar2(72) := g_package||'ins';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call conversion function to turn arguments into the
512: -- p_rec structure.
513: --
577: --
578: p_org_information_id := l_rec.org_information_id;
579: p_object_version_number := l_rec.object_version_number;
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 10);
582: End ins;
583: --
584: end hr_ori_ins;