[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: psp_rtd_ins.g_template_detail_id_i := p_template_detail_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: psp_rtd_ins.g_template_detail_id_i := p_template_detail_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: psp_rtd_shd.g_api_dml := true; -- Set the api dml status
86: --
110: );
111: --
112: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: psp_rtd_shd.g_api_dml := false; -- Unset the api dml status
185: l_proc varchar2(72) := g_package||'pre_insert';
186: l_exists varchar2(1);
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: If (psp_rtd_ins.g_template_detail_id_i is not null) Then
192: --
193: -- Verify registered primary key values not already in use
221: Fetch C_Sel1 Into p_rec.template_detail_id;
222: Close C_Sel1;
223: End If;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End pre_insert;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |-----------------------------< post_insert >------------------------------|
263: --
264: l_proc varchar2(72) := g_package||'post_insert';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: begin
269: --
270: psp_rtd_rki.after_insert
271: (p_template_detail_id
297: ,p_hook_type => 'AI');
298: --
299: end;
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 10);
302: End post_insert;
303: --
304: -- ----------------------------------------------------------------------------
305: -- |---------------------------------< ins >----------------------------------|
310: --
311: l_proc varchar2(72) := g_package||'ins';
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: --
316: -- Call the supporting insert validate operations
317: --
318: psp_rtd_bus.insert_validate
338: --
339: -- Call to raise any errors on multi-message list
340: hr_multi_message.end_validation_set;
341: --
342: hr_utility.set_location('Leaving:'||l_proc, 20);
343: end ins;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |---------------------------------< ins >----------------------------------|
360: l_rec psp_rtd_shd.g_rec_type;
361: l_proc varchar2(72) := g_package||'ins';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: -- Call conversion function to turn arguments into the
367: -- p_rec structure.
368: --
391: --
392: -- p_template_detail_id := l_rec.template_detail_id;
393: p_object_version_number := l_rec.object_version_number;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End ins;
397: --
398: end psp_rtd_ins;