[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: per_psv_ins.g_pos_structure_version_id_i := p_pos_structure_version_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_psv_ins.g_pos_structure_version_id_i := p_pos_structure_version_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_psv_shd.g_api_dml := true; -- Set the api dml status
86: --
116: );
117: --
118: per_psv_shd.g_api_dml := false; -- Unset the api dml status
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: per_psv_shd.g_api_dml := false; -- Unset the api dml status
191: l_proc varchar2(72) := g_package||'pre_insert';
192: l_exists varchar2(1);
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: If (per_psv_ins.g_pos_structure_version_id_i is not null) Then
198: --
199: -- Verify registered primary key values not already in use
228: Close C_Sel1;
229: End If;
230: --
231:
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: End pre_insert;
234: --
235: -- ----------------------------------------------------------------------------
236: -- |-----------------------------< post_insert >------------------------------|
271: --
272: l_proc varchar2(72) := g_package||'post_insert';
273: --
274: Begin
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: begin
277: --
278: per_psv_rki.after_insert
279: (p_effective_date => p_effective_date
312: ,p_hook_type => 'AI');
313: --
314: end;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);
317: End post_insert;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |---------------------------------< ins >----------------------------------|
326: --
327: l_proc varchar2(72) := g_package||'ins';
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: -- Call the supporting insert validate operations
333: --
334: per_psv_bus.insert_validate
351: (p_effective_date
352: ,p_rec
353: );
354: --
355: hr_utility.set_location('Leaving:'||l_proc, 20);
356: end ins;
357: --
358: -- ----------------------------------------------------------------------------
359: -- |---------------------------------< ins >----------------------------------|
378: l_proc varchar2(72) := g_package||'ins';
379: l_business_group_id number;
380: --
381: Begin
382: hr_utility.set_location('Entering:'||l_proc, 5);
383: --
384: -- Call conversion function to turn arguments into the
385: -- p_rec structure.
386: --
418: --
419: p_pos_structure_version_id := l_rec.pos_structure_version_id;
420: p_object_version_number := l_rec.object_version_number;
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 10);
423: End ins;
424: --
425: end per_psv_ins;