49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;
76: value_style_cd = p_rec.value_style_cd
77: where txn_category_attribute_id = p_rec.txn_category_attribute_id;
78: --
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
132: --
133: l_proc varchar2(72) := g_package||'pre_update';
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: End pre_update;
140: --
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: End pre_update;
140: --
141: -- ----------------------------------------------------------------------------
142: -- |-----------------------------< post_update >------------------------------|
175: --
176: l_proc varchar2(72) := g_package||'post_update';
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: --
182: -- Start of API User Hook for post_update.
183: --
225: --
226: -- End of API User Hook for post_update.
227: --
228: --
229: hr_utility.set_location(' Leaving:'||l_proc, 10);
230: End post_update;
231: --
232: -- ----------------------------------------------------------------------------
233: -- |-----------------------------< convert_defs >-----------------------------|
277: l_proc varchar2(72) := g_package||'convert_defs';
278: --
279: Begin
280: --
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- We must now examine each argument value in the
284: -- p_rec plsql record structure
285: -- to see if a system default is being used. If a system default
329: p_rec.value_style_cd :=
330: pqh_tca_shd.g_old_rec.value_style_cd;
331: End If;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: --
335: End convert_defs;
336: --
337: -- ----------------------------------------------------------------------------
346: --
347: l_proc varchar2(72) := g_package||'upd';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- We must lock the row which we need to update.
353: --
354: pqh_tca_shd.lck
406: l_rec pqh_tca_shd.g_rec_type;
407: l_proc varchar2(72) := g_package||'upd';
408: --
409: Begin
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: -- Call conversion function to turn arguments into the
413: -- l_rec structure.
414: --
437: upd(
438: p_effective_date,l_rec,p_delete_attr_ranges_flag);
439: p_object_version_number := l_rec.object_version_number;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: End upd;
443: --
444: end pqh_tca_upd;