49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: --
56: --
57: -- Update the pqh_rule_sets_tl Row
66: where rule_set_id = p_rec.rule_set_id
67: and language = p_rec.language;
68: --
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 >------------------------------|
164: --
165: l_proc varchar2(72) := g_package||'post_update';
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: --
171: -- Start of API User Hook for post_update.
172: --
197: --
198: -- End of API User Hook for post_update.
199: --
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End post_update;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------------< convert_defs >-----------------------------|
249: l_proc varchar2(72) := g_package||'convert_defs';
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: -- We must now examine each argument value in the
256: -- p_rec plsql record structure
257: -- to see if a system default is being used. If a system default
269: p_rec.source_lang :=
270: pqh_rtl_shd.g_old_rec.source_lang;
271: End If;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: --
275: End convert_defs;
276: --
277: -- ----------------------------------------------------------------------------
284: --
285: l_proc varchar2(72) := g_package||'upd';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- We must lock the row which we need to update.
291: --
292: pqh_rtl_shd.lck
332: l_rec pqh_rtl_shd.g_rec_type;
333: l_proc varchar2(72) := g_package||'upd';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: -- Call conversion function to turn arguments into the
339: -- l_rec structure.
340: --
354: --
355: upd(l_rec);
356: --
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End upd;
360: --
361: -- ----------------------------------------------------------------------------
362: -- |------------------------------< upd_tl >----------------------------------|
377: l_proc varchar2(72) := g_package||'upd_tl';
378: --
379: begin
380: --
381: hr_utility.set_location(' Entering:'||l_proc, 10);
382: --
383: for l_lang in csr_upd_langs loop
384: --
385: --
392: --
393: --
394: end loop;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 20);
397: --
398: end upd_tl;
399: --
400: -- ----------- Translate Row -------------------------------------------