52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: -- Increment the object version
59: --
60: p_rec.object_version_number := p_rec.object_version_number + 1;
70: ,exclusion_rule_id = p_rec.exclusion_rule_id
71: where balance_classification_id = p_rec.balance_classification_id;
72: --
73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
126: --
127: l_proc varchar2(72) := g_package||'pre_update';
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: End pre_update;
134: --
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: End pre_update;
134: --
135: -- ----------------------------------------------------------------------------
136: -- |-----------------------------< post_update >------------------------------|
168: --
169: l_proc varchar2(72) := g_package||'post_update';
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: End post_update;
176: --
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: End post_update;
176: --
177: -- ----------------------------------------------------------------------------
178: -- |-----------------------------< convert_defs >-----------------------------|
223: l_proc varchar2(72) := g_package||'convert_defs';
224: --
225: Begin
226: --
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: -- We must now examine each argument value in the
230: -- p_rec plsql record structure
231: -- to see if a system default is being used. If a system default
245: If (p_rec.exclusion_rule_id = hr_api.g_number) then
246: p_rec.exclusion_rule_id := pay_sbc_shd.g_old_rec.exclusion_rule_id;
247: End If;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: --
251: End convert_defs;
252: --
253: -- ----------------------------------------------------------------------------
261: --
262: l_proc varchar2(72) := g_package||'upd';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: -- We must lock the row which we need to update.
268: --
269: pay_sbc_shd.lck
310: l_rec pay_sbc_shd.g_rec_type;
311: l_proc varchar2(72) := g_package||'upd';
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: --
316: -- Call conversion function to turn arguments into the
317: -- l_rec structure.
318: --
333: --
334: upd(p_effective_date, l_rec);
335: p_object_version_number := l_rec.object_version_number;
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 10);
338: End upd;
339: --
340: end pay_sbc_upd;