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;
75: object_version_number = p_rec.object_version_number
76: where routing_category_id = p_rec.routing_category_id;
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
131: --
132: l_proc varchar2(72) := g_package||'pre_update';
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 10);
138: End pre_update;
139: --
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 10);
138: End pre_update;
139: --
140: -- ----------------------------------------------------------------------------
141: -- |-----------------------------< post_update >------------------------------|
173: --
174: l_proc varchar2(72) := g_package||'post_update';
175: --
176: Begin
177: hr_utility.set_location('Entering:'||l_proc, 5);
178: --
179: --
180: -- Start of API User Hook for post_update.
181: --
221: --
222: -- End of API User Hook for post_update.
223: --
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End post_update;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |-----------------------------< convert_defs >-----------------------------|
273: l_proc varchar2(72) := g_package||'convert_defs';
274: --
275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- We must now examine each argument value in the
280: -- p_rec plsql record structure
281: -- to see if a system default is being used. If a system default
322: pqh_rct_shd.g_old_rec.override_user_id;
323: End If;
324:
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: --
328: End convert_defs;
329: --
330: -- ----------------------------------------------------------------------------
338: --
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- We must lock the row which we need to update.
345: --
346: pqh_rct_shd.lck
394: l_rec pqh_rct_shd.g_rec_type;
395: l_proc varchar2(72) := g_package||'upd';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Call conversion function to turn arguments into the
401: -- l_rec structure.
402: --
423: --
424: upd(p_effective_date,l_rec);
425: p_object_version_number := l_rec.object_version_number;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: End upd;
429: --
430: end pqh_rct_upd;