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_jgr_ins.g_job_group_id_i := p_job_group_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_jgr_ins.g_job_group_id_i := p_job_group_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: --
86: --
108: );
109: --
110: --
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
176: --
177: Cursor C_Sel1 is select per_job_groups_s.nextval from sys.dual;
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: --
183: -- Select the next sequence number
184: --
185: Open C_Sel1;
186: Fetch C_Sel1 Into p_rec.job_group_id;
187: Close C_Sel1;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: End pre_insert;
191: --
192: -- ----------------------------------------------------------------------------
193: -- |-----------------------------< post_insert >------------------------------|
228: --
229: l_proc varchar2(72) := g_package||'post_insert';
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: begin
234: --
235: per_jgr_rki.after_insert
236: (p_effective_date => p_effective_date
261: ,p_hook_type => 'AI');
262: --
263: end;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End post_insert;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |---------------------------------< ins >----------------------------------|
275: --
276: l_proc varchar2(72) := g_package||'ins';
277: --
278: Begin
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- Call the supporting insert validate operations
282: --
283: per_jgr_bus.insert_validate
299: (p_effective_date
300: ,p_rec
301: );
302: --
303: hr_utility.set_location('Leaving:'||l_proc, 20);
304: end ins;
305: --
306: -- ----------------------------------------------------------------------------
307: -- |---------------------------------< ins >----------------------------------|
321: l_rec per_jgr_shd.g_rec_type;
322: l_proc varchar2(72) := g_package||'ins';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- Call conversion function to turn arguments into the
328: -- p_rec structure.
329: --
352: --
353: p_job_group_id := l_rec.job_group_id;
354: p_object_version_number := l_rec.object_version_number;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End ins;
358: --
359: end per_jgr_ins;