23: --
24: l_proc varchar2(72) := g_package||'set_base_key_value';
25: --
26: Begin
27: hr_utility.set_location('Entering:'||l_proc, 10);
28: --
29: pqp_ers_ins.g_database_item_suffix_i := p_database_item_suffix;
30: pqp_ers_ins.g_legislation_code_i := p_legislation_code;
31: --
28: --
29: pqp_ers_ins.g_database_item_suffix_i := p_database_item_suffix;
30: pqp_ers_ins.g_legislation_code_i := p_legislation_code;
31: --
32: hr_utility.set_location(' Leaving:'||l_proc, 20);
33: End set_base_key_value;
34: --
35: --
36: -- ----------------------------------------------------------------------------
82: --
83: l_proc varchar2(72) := g_package||'insert_dml';
84: --
85: Begin
86: hr_utility.set_location('Entering:'||l_proc, 5);
87: p_rec.object_version_number := 1; -- Initialise the object version
88: --
89: --
90: --
104: );
105: --
106: --
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
180: l_proc varchar2(72) := g_package||'pre_insert';
181: l_exists varchar2(1);
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: If (pqp_ers_ins.g_database_item_suffix_i is not null or
187: pqp_ers_ins.g_legislation_code_i is not null) Then
188: --
210: pqp_ers_ins.g_legislation_code_i;
211: pqp_ers_ins.g_legislation_code_i := null;
212: End If;
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_insert;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------------< post_insert >------------------------------|
252: --
253: l_proc varchar2(72) := g_package||'post_insert';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: begin
258: --
259: -- pqp_ers_rki.after_insert
260: -- (p_database_item_suffix
277: ,p_hook_type => 'AI');
278: --
279: end;
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 10);
282: End post_insert;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |---------------------------------< ins >----------------------------------|
290: --
291: l_proc varchar2(72) := g_package||'ins';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Call the supporting insert validate operations
297: --
298: pqp_ers_bus.insert_validate
318: --
319: -- Call to raise any errors on multi-message list
320: hr_multi_message.end_validation_set;
321: --
322: hr_utility.set_location('Leaving:'||l_proc, 20);
323: end ins;
324: --
325: -- ----------------------------------------------------------------------------
326: -- |---------------------------------< ins >----------------------------------|
335: l_rec pqp_ers_shd.g_rec_type;
336: l_proc varchar2(72) := g_package||'ins';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Call conversion function to turn arguments into the
342: -- p_rec structure.
343: --
360: -- are specified as an OUT's we must set these values.
361: --
362: p_object_version_number := l_rec.object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: End ins;
366: --
367: end pqp_ers_ins;