[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_ose_ins.g_org_structure_element_id_i := p_org_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_ose_ins.g_org_structure_element_id_i := p_org_structure_element_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: per_ose_shd.g_api_dml := true; -- Set the api dml status
85: --
113: );
114: --
115: per_ose_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: per_ose_shd.g_api_dml := false; -- Unset the api dml status
181: --
182: Cursor C_Sel1 is select per_org_structure_elements_s.nextval from sys.dual;
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: --
188: -- Select the next sequence number
189: --
190: Open C_Sel1;
191: Fetch C_Sel1 Into p_rec.org_structure_element_id;
192: Close C_Sel1;
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: End pre_insert;
196: --
197: -- ----------------------------------------------------------------------------
198: -- |-----------------------------< post_insert >------------------------------|
232: --
233: l_proc varchar2(72) := g_package||'post_insert';
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: begin
238: --
239: per_ose_rki.after_insert
240: (p_org_structure_element_id
270: ,p_hook_type => 'AI');
271: --
272: end;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: End post_insert;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |---------------------------------< ins >----------------------------------|
284: --
285: l_proc varchar2(72) := g_package||'ins';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Call the supporting insert validate operations
291: --
292: per_ose_bus.insert_validate
307: per_ose_ins.post_insert
308: (p_rec
309: );
310: --
311: hr_utility.set_location('Leaving:'||l_proc, 20);
312: end ins;
313: --
314: -- ----------------------------------------------------------------------------
315: -- |---------------------------------< ins >----------------------------------|
332: l_rec per_ose_shd.g_rec_type;
333: l_proc varchar2(72) := g_package||'ins';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: -- Call conversion function to turn arguments into the
339: -- p_rec structure.
340: --
366: --
367: p_org_structure_element_id := l_rec.org_structure_element_id;
368: p_object_version_number := l_rec.object_version_number;
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: End ins;
372: --
373: end per_ose_ins;