57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
80: where iterative_rule_id = p_rec.iterative_rule_id;
81: --
82: --
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
142: --
143: l_proc varchar2(72) := g_package||'pre_update';
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: End pre_update;
150: --
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: End pre_update;
150: --
151: -- ----------------------------------------------------------------------------
152: -- |-----------------------------< post_update >------------------------------|
187: l_proc varchar2(72) := g_package||'post_update';
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End post_update;
195: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End post_update;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------------< convert_defs >-----------------------------|
286: --
287: l_proc varchar2(72) := g_package||'upd';
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- We must lock the row which we need to update.
293: --
294: pay_sir_shd.lck
339: l_rec pay_sir_shd.g_rec_type;
340: l_proc varchar2(72) := g_package||'upd';
341: --
342: Begin
343: hr_utility.set_location('Entering:'||l_proc, 5);
344: --
345: -- Call conversion function to turn arguments into the
346: -- l_rec structure.
347: --
366: ,l_rec
367: );
368: p_object_version_number := l_rec.object_version_number;
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: End upd;
372: --
373: end pay_sir_upd;