[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_blt_ins.g_balance_type_id_i := p_balance_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_blt_ins.g_balance_type_id_i := p_balance_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: pay_blt_shd.g_api_dml := true; -- Set the api dml status
134: --
214: );
215: --
216: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: Exception
220: When hr_api.check_integrity_violated Then
221: -- A check constraint has been violated
222: pay_blt_shd.g_api_dml := false; -- Unset the api dml status
289: l_proc varchar2(72) := g_package||'pre_insert';
290: l_exists varchar2(1);
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: If (pay_blt_ins.g_balance_type_id_i is not null) Then
296: --
297: -- Verify registered primary key values not already in use
325: Fetch C_Sel1 Into p_rec.balance_type_id;
326: Close C_Sel1;
327: End If;
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);
330: End pre_insert;
331: --
332: -- ----------------------------------------------------------------------------
333: -- |-----------------------------< post_insert >------------------------------|
368: --
369: l_proc varchar2(72) := g_package||'post_insert';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: begin
374: --
375: -- insert ownerships if applicable
376: create_app_ownerships
465: ,p_hook_type => 'AI');
466: --
467: end;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 10);
470: End post_insert;
471: --
472: -- ----------------------------------------------------------------------------
473: -- |---------------------------------< ins >----------------------------------|
479: --
480: l_proc varchar2(72) := g_package||'ins';
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: -- Call the supporting insert validate operations
486: --
487: pay_blt_bus.insert_validate
522:
523: -- Call to raise any errors on multi-message list
524: hr_multi_message.end_validation_set;
525: --
526: hr_utility.set_location('Leaving:'||l_proc, 20);
527: end ins;
528: --
529: -- ----------------------------------------------------------------------------
530: -- |---------------------------------< ins >----------------------------------|
574: l_proc varchar2(72) := g_package||'ins';
575: l_balance_name_warning number;
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Call conversion function to turn arguments into the
581: -- p_rec structure.
582: --
634: --
635: p_balance_type_id := l_rec.balance_type_id;
636: p_object_version_number := l_rec.object_version_number;
637: --
638: hr_utility.set_location(' Leaving:'||l_proc, 10);
639: End ins;
640: --
641: end pay_blt_ins;