59: l_range_flag varchar2(2) := 'F';
60: l_control_total_dup1 pay_batch_control_totals.control_total%TYPE;
61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: --
65: -- Increment the object version
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --
70: -- added for bug 6013383
71: -- convert the Number format from Display format( 99,999.99 OR 99.999,99) to
72: -- database format (99999.99)
73: --
74: hr_utility.set_location('Converting Control total from display format to database format: ' ||l_proc,6) ;
75: --
76: l_control_total_dup1 := p_rec.control_total;
77:
78:
98: where batch_control_id = p_rec.batch_control_id;
99: --
100: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
160: --
161: l_proc varchar2(72) := g_package||'pre_update';
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: End pre_update;
168: --
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: End pre_update;
168: --
169: -- ----------------------------------------------------------------------------
170: -- |-----------------------------< post_update >------------------------------|
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207: --
208: Begin
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: begin
211: --
212: pay_bct_rku.after_update
213: (p_session_date
243: ,p_hook_type => 'AU');
244: --
245: end;
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End post_update;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |-----------------------------< convert_defs >-----------------------------|
330: --
331: l_proc varchar2(72) := g_package||'upd';
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- We must lock the row which we need to update.
337: --
338: pay_bct_shd.lck
383: l_rec pay_bct_shd.g_rec_type;
384: l_proc varchar2(72) := g_package||'upd';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: -- Call conversion function to turn arguments into the
390: -- l_rec structure.
391: --
408: l_rec
409: );
410: p_object_version_number := l_rec.object_version_number;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End upd;
414: --
415: end pay_bct_upd;