DBA Data[Home] [Help]

APPS.PQH_WEL_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: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;

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

68: object_version_number = p_rec.object_version_number
69: where worksheet_bdgt_elmnt_id = p_rec.worksheet_bdgt_elmnt_id;
70: --
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: --
74: Exception
75: When hr_api.check_integrity_violated Then
76: -- A check constraint has been violated

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

124: --
125: l_proc varchar2(72) := g_package||'pre_update';
126: --
127: Begin
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: End pre_update;
132: --

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

126: --
127: Begin
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: End pre_update;
132: --
133: -- ----------------------------------------------------------------------------
134: -- |-----------------------------< post_update >------------------------------|

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

166: --
167: l_proc varchar2(72) := g_package||'post_update';
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: --
173: -- Start of API User Hook for post_update.
174: --

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

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 >-----------------------------|

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

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

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

272: pqh_wel_shd.g_old_rec.distribution_percentage;
273: End If;
274:
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: --
278: End convert_defs;
279: --
280: -- ----------------------------------------------------------------------------

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

287: --
288: l_proc varchar2(72) := g_package||'upd';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- We must lock the row which we need to update.
294: --
295: pqh_wel_shd.lck

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

335: l_rec pqh_wel_shd.g_rec_type;
336: l_proc varchar2(72) := g_package||'upd';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Call conversion function to turn arguments into the
342: -- l_rec structure.
343: --

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

357: --
358: upd(l_rec);
359: p_object_version_number := l_rec.object_version_number;
360: --
361: hr_utility.set_location(' Leaving:'||l_proc, 10);
362: End upd;
363: --
364: end pqh_wel_upd;