[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: pay_aif_ins.g_action_information_id_i := p_action_information_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_aif_ins.g_action_information_id_i := p_action_information_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: --
85: --
175: );
176: --
177: --
178: --
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: Exception
181: When hr_api.check_integrity_violated Then
182: -- A check constraint has been violated
183: --
250: where action_information_id =
251: pay_aif_ins.g_action_information_id_i;
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: If (pay_aif_ins.g_action_information_id_i is not null) Then
257: --
258: -- Verify registered primary key values not already in use
285: Fetch C_Sel1 Into p_rec.action_information_id;
286: Close C_Sel1;
287: End If;
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290: End pre_insert;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |-----------------------------< post_insert >------------------------------|
327: --
328: l_proc varchar2(72) := g_package||'post_insert';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: begin
333: --
334: pay_aif_rki.after_insert
335: (p_action_information_id
427: ,p_hook_type => 'AI');
428: --
429: end;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: End post_insert;
433: --
434: -- ----------------------------------------------------------------------------
435: -- |---------------------------------< ins >----------------------------------|
440: --
441: l_proc varchar2(72) := g_package||'ins';
442: --
443: Begin
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: --
446: -- Call the supporting insert validate operations
447: --
448: pay_aif_bus.insert_validate
470: -- Call to raise any errors on multi-message list
471: --
472: hr_multi_message.end_validation_set;
473: --
474: hr_utility.set_location('Leaving:'||l_proc, 20);
475: end ins;
476: --
477: -- ----------------------------------------------------------------------------
478: -- |---------------------------------< ins >----------------------------------|
525: l_rec pay_aif_shd.g_rec_type;
526: l_proc varchar2(72) := g_package||'ins';
527: --
528: Begin
529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: -- Call conversion function to turn arguments into the
532: -- p_rec structure.
533: --
589: --
590: p_action_information_id := l_rec.action_information_id;
591: p_object_version_number := l_rec.object_version_number;
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: End ins;
595: --
596: end pay_aif_ins;