[Home] [Help]
22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ff_ffp_ins.g_function_id_i := p_function_id;
29: ff_ffp_ins.g_sequence_number_i := p_sequence_number;
30: --
27: --
28: ff_ffp_ins.g_function_id_i := p_function_id;
29: ff_ffp_ins.g_sequence_number_i := p_sequence_number;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --
84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: ff_ffp_shd.g_api_dml := true; -- Set the api dml status
89: --
111: );
112: --
113: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: ff_ffp_shd.g_api_dml := false; -- Unset the api dml status
191: l_proc varchar2(72) := g_package||'pre_insert';
192: l_exists varchar2(1);
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: If (ff_ffp_ins.g_function_id_i is not null or
198: ff_ffp_ins.g_sequence_number_i is not null) Then
199: --
231: Fetch C_Sel1 Into p_rec.sequence_number;
232: Close C_Sel1;
233: End If;
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: End pre_insert;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |-----------------------------< post_insert >------------------------------|
274: --
275: l_proc varchar2(72) := g_package||'post_insert';
276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: begin
280: --
281: ff_ffp_rki.after_insert
282: (p_effective_date => p_effective_date
307: ,p_hook_type => 'AI');
308: --
309: end;
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End post_insert;
313: --
314: -- ----------------------------------------------------------------------------
315: -- |---------------------------------< ins >----------------------------------|
321: --
322: l_proc varchar2(72) := g_package||'ins';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- Call the supporting insert validate operations
328: --
329: ff_ffp_bus.insert_validate
351: --
352: -- Call to raise any errors on multi-message list
353: hr_multi_message.end_validation_set;
354: --
355: hr_utility.set_location('Leaving:'||l_proc, 20);
356: end ins;
357: --
358: -- ----------------------------------------------------------------------------
359: -- |---------------------------------< ins >----------------------------------|
373: l_rec ff_ffp_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'ins';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call conversion function to turn arguments into the
380: -- p_rec structure.
381: --
404: --
405: p_sequence_number := l_rec.sequence_number;
406: p_object_version_number := l_rec.object_version_number;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: End ins;
410: --
411: end ff_ffp_ins;