[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := 'per_seu_ins.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following global variables are only to be used by
12: -- the set_base_key_value and pre_insert procedures.
13: --
21: --
22: l_proc varchar2(72) := g_package||'set_base_key_value';
23: --
24: Begin
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_seu_ins.g_security_user_id_i := p_security_user_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_seu_ins.g_security_user_id_i := p_security_user_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --
32: --
33: -- ----------------------------------------------------------------------------
79: --
80: l_proc varchar2(72) := g_package||'insert_dml';
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: p_rec.object_version_number := 1; -- Initialise the object version
85: --
86: --
87: --
103: );
104: --
105: --
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: --
178: l_proc varchar2(72) := g_package||'pre_insert';
179: l_exists varchar2(1);
180: --
181: Begin
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: If (per_seu_ins.g_security_user_id_i is not null) Then
185: --
186: -- Verify registered primary key values not already in use
214: Fetch C_Sel1 Into p_rec.security_user_id;
215: Close C_Sel1;
216: End If;
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: End pre_insert;
220: --
221: -- ----------------------------------------------------------------------------
222: -- |-----------------------------< post_insert >------------------------------|
257: --
258: l_proc varchar2(72) := g_package||'post_insert';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: begin
263: --
264: per_seu_rki.after_insert
265: (p_effective_date => p_effective_date
284: ,p_hook_type => 'AI');
285: --
286: end;
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 10);
289: End post_insert;
290: --
291: -- ----------------------------------------------------------------------------
292: -- |---------------------------------< ins >----------------------------------|
298: --
299: l_proc varchar2(72) := g_package||'ins';
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: -- Call the supporting insert validate operations
305: --
306: per_seu_bus.insert_validate
328: --
329: -- Call to raise any errors on multi-message list
330: hr_multi_message.end_validation_set;
331: --
332: hr_utility.set_location('Leaving:'||l_proc, 20);
333: end ins;
334: --
335: -- ----------------------------------------------------------------------------
336: -- |---------------------------------< ins >----------------------------------|
347: l_rec per_seu_shd.g_rec_type;
348: l_proc varchar2(72) := g_package||'ins';
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- Call conversion function to turn arguments into the
354: -- p_rec structure.
355: --
375: --
376: p_security_user_id := l_rec.security_user_id;
377: p_object_version_number := l_rec.object_version_number;
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: End ins;
381: --
382: end per_seu_ins;