DBA Data[Home] [Help]

APPS.PQH_ATL_UPD dependencies on HR_UTILITY

Line 53: hr_utility.set_location('Entering:'||l_proc, 5);

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: -- Update the pqh_attributes_tl Row
57: --

Line 68: hr_utility.set_location(' Leaving:'||l_proc, 10);

64: where attribute_id = p_rec.attribute_id
65: and language = p_rec.language;
66: --
67: --
68: hr_utility.set_location(' Leaving:'||l_proc, 10);
69: --
70: Exception
71: When hr_api.check_integrity_violated Then
72: -- A check constraint has been violated

Line 124: hr_utility.set_location('Entering:'||l_proc, 5);

120: --
121: l_proc varchar2(72) := g_package||'pre_update';
122: --
123: Begin
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: End pre_update;
128: --

Line 126: hr_utility.set_location(' Leaving:'||l_proc, 10);

122: --
123: Begin
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: End pre_update;
128: --
129: -- ----------------------------------------------------------------------------
130: -- |-----------------------------< post_update >------------------------------|

Line 166: hr_utility.set_location('Entering:'||l_proc, 5);

162: --
163: l_proc varchar2(72) := g_package||'post_update';
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: --
169: -- Start of API User Hook for post_update.
170: --

Line 197: hr_utility.set_location(' Leaving:'||l_proc, 10);

193: --
194: -- End of API User Hook for post_update.
195: --
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End post_update;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |-----------------------------< convert_defs >-----------------------------|

Line 249: hr_utility.set_location('Entering:'||l_proc, 5);

245: l_proc varchar2(72) := g_package||'convert_defs';
246: --
247: Begin
248: --
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: -- We must now examine each argument value in the
252: -- p_rec plsql record structure
253: -- to see if a system default is being used. If a system default

Line 265: hr_utility.set_location(' Leaving:'||l_proc, 10);

261: p_rec.source_lang :=
262: pqh_atl_shd.g_old_rec.source_lang;
263: End If;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: --
267: End convert_defs;
268: --
269: -- ----------------------------------------------------------------------------

Line 280: hr_utility.set_location('Entering:'||l_proc, 5);

276: --
277: l_proc varchar2(72) := g_package||'upd';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to update.
283: --
284: pqh_atl_shd.lck

Line 327: hr_utility.set_location('Entering:'||l_proc, 5);

323: l_rec pqh_atl_shd.g_rec_type;
324: l_proc varchar2(72) := g_package||'upd';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Call conversion function to turn arguments into the
330: -- l_rec structure.
331: --

Line 348: hr_utility.set_location(' Leaving:'||l_proc, 10);

344: --
345: upd(l_rec);
346: --
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 10);
349: End upd;
350: --
351: -- ----------------------------------------------------------------------------
352: -- |------------------------------< upd_tl >----------------------------------|

Line 369: hr_utility.set_location(' Entering:'||l_proc, 10);

365: l_proc varchar2(72) := g_package||'upd_tl';
366: --
367: begin
368: --
369: hr_utility.set_location(' Entering:'||l_proc, 10);
370: --
371: for l_lang in csr_upd_langs loop
372: --
373: --

Line 383: hr_utility.set_location(' Leaving:'||l_proc, 20);

379: --
380: --
381: end loop;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 20);
384: --
385: end upd_tl;
386: --
387: -- ----------- Translate Row -------------------------------------------