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_ort_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_ort_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: --
83: --
84: --
85: --
99: );
100: --
101: --
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: --
166: --
167: l_proc varchar2(72) := g_package||'pre_insert';
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: p_rec.organization_id := p_organization_id;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: p_rec.organization_id := p_organization_id;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: End pre_insert;
176: --
177: -- ----------------------------------------------------------------------------
178: -- |-----------------------------< post_insert >------------------------------|
212: --
213: l_proc varchar2(72) := g_package||'post_insert';
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: begin
218: --
219: hr_ort_rki.after_insert
220: (p_organization_id
236: ,p_hook_type => 'AI');
237: --
238: end;
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: End post_insert;
242: --
243: -- ----------------------------------------------------------------------------
244: -- |---------------------------------< ins >----------------------------------|
250: --
251: l_proc varchar2(72) := g_package||'ins';
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: -- Call the supporting insert validate operations
257: --
258: hr_ort_bus.insert_validate
275: hr_ort_ins.post_insert
276: (p_rec
277: );
278: --
279: hr_utility.set_location('Leaving:'||l_proc, 20);
280: end ins;
281: --
282: -- ----------------------------------------------------------------------------
283: -- |---------------------------------< ins >----------------------------------|
292: l_rec hr_ort_shd.g_rec_type;
293: l_proc varchar2(72) := g_package||'ins';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- Call conversion function to turn arguments into the
299: -- p_rec structure.
300: --
318: -- are specified as an OUT's we must set these values.
319: --
320: --
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: End ins;
324: --
325: -- ----------------------------------------------------------------------------
326: -- |------------------------------< ins_tl >----------------------------------|
344: --
345: l_proc varchar2(72) := g_package || 'ins_tl';
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc,10);
349: --
350: -- Insert a row for the base language and every installed language.
351: --
352: for l_lang in csr_ins_langs loop
357: ,p_name => p_name
358: );
359: end loop;
360: --
361: hr_utility.set_location('Leaving:'||l_proc,20);
362: End ins_tl;
363: --
364: end hr_ort_ins;