[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_pse_ins.g_pos_structure_element_id_i := p_pos_structure_element_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_pse_ins.g_pos_structure_element_id_i := p_pos_structure_element_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_pse_shd.g_api_dml := true; -- Set the api dml status
86: --
112: );
113: --
114: per_pse_shd.g_api_dml := false; -- Unset the api dml status
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: per_pse_shd.g_api_dml := false; -- Unset the api dml status
180: --
181: Cursor C_Sel1 is select per_pos_structure_elements_s.nextval from sys.dual;
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: --
187: -- Select the next sequence number
188: --
189: Open C_Sel1;
190: Fetch C_Sel1 Into p_rec.pos_structure_element_id;
191: Close C_Sel1;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End pre_insert;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------------< post_insert >------------------------------|
231: --
232: l_proc varchar2(72) := g_package||'post_insert';
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: begin
237: --
238: per_pse_rki.after_insert
239: (p_pos_structure_element_id
267: ,p_hook_type => 'AI');
268: --
269: end;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End post_insert;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |---------------------------------< ins >----------------------------------|
281: --
282: l_proc varchar2(72) := g_package||'ins';
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: -- Call the supporting insert validate operations
288: --
289: per_pse_bus.insert_validate
304: per_pse_ins.post_insert
305: (p_rec
306: );
307: --
308: hr_utility.set_location('Leaving:'||l_proc, 20);
309: end ins;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |---------------------------------< ins >----------------------------------|
328: l_rec per_pse_shd.g_rec_type;
329: l_proc varchar2(72) := g_package||'ins';
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: -- Call conversion function to turn arguments into the
335: -- p_rec structure.
336: --
361: --
362: p_pos_structure_element_id := l_rec.pos_structure_element_id;
363: p_object_version_number := l_rec.object_version_number;
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: End ins;
367: --
368: end per_pse_ins;