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;
66: select_flag = p_rec.select_flag,
67: object_version_number = p_rec.object_version_number
68: where copy_entity_pref_id = p_rec.copy_entity_pref_id;
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception
73: When hr_api.check_integrity_violated Then
74: -- A check constraint has been violated
122: --
123: l_proc varchar2(72) := g_package||'pre_update';
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: End pre_update;
130: --
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: End pre_update;
130: --
131: -- ----------------------------------------------------------------------------
132: -- |-----------------------------< post_update >------------------------------|
165: --
166: l_proc varchar2(72) := g_package||'post_update';
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: --
172: -- Start of API User Hook for post_update.
173: --
199: --
200: -- End of API User Hook for post_update.
201: --
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: End post_update;
205: --
206: -- ----------------------------------------------------------------------------
207: -- |-----------------------------< convert_defs >-----------------------------|
251: l_proc varchar2(72) := g_package||'convert_defs';
252: --
253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: -- We must now examine each argument value in the
258: -- p_rec plsql record structure
259: -- to see if a system default is being used. If a system default
272: pqh_cep_shd.g_old_rec.select_flag;
273: End If;
274:
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: --
278: End convert_defs;
279: --
280: -- ----------------------------------------------------------------------------
288: --
289: l_proc varchar2(72) := g_package||'upd';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- We must lock the row which we need to update.
295: --
296: pqh_cep_shd.lck
339: l_rec pqh_cep_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: --
362: upd(
363: p_effective_date,l_rec);
364: p_object_version_number := l_rec.object_version_number;
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End upd;
368: --
369: end pqh_cep_upd;