DBA Data[Home] [Help]

APPS.PQH_FYN_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 76: hr_utility.set_location(' Leaving:'||l_proc, 10);

72: object_version_number = p_rec.object_version_number
73: where fyi_notified_id = p_rec.fyi_notified_id;
74: --
75: --
76: hr_utility.set_location(' Leaving:'||l_proc, 10);
77: --
78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated

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

128: --
129: l_proc varchar2(72) := g_package||'pre_update';
130: --
131: Begin
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 10);
135: End pre_update;
136: --

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

130: --
131: Begin
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 10);
135: End pre_update;
136: --
137: -- ----------------------------------------------------------------------------
138: -- |-----------------------------< post_update >------------------------------|

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

171: --
172: l_proc varchar2(72) := g_package||'post_update';
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: --
178: -- Start of API User Hook for post_update.
179: --

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

213: --
214: -- End of API User Hook for post_update.
215: --
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: End post_update;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |-----------------------------< convert_defs >-----------------------------|

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

265: l_proc varchar2(72) := g_package||'convert_defs';
266: --
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: -- We must now examine each argument value in the
272: -- p_rec plsql record structure
273: -- to see if a system default is being used. If a system default

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

302: pqh_fyn_shd.g_old_rec.status;
303: End If;
304:
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: --
308: End convert_defs;
309: --
310: -- ----------------------------------------------------------------------------

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

318: --
319: l_proc varchar2(72) := g_package||'upd';
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- We must lock the row which we need to update.
325: --
326: pqh_fyn_shd.lck

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

373: l_rec pqh_fyn_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'upd';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Call conversion function to turn arguments into the
380: -- l_rec structure.
381: --

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

400: upd(
401: p_effective_date,l_rec);
402: p_object_version_number := l_rec.object_version_number;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: End upd;
406: --
407: end pqh_fyn_upd;