DBA Data[Home] [Help]

APPS.PQH_BVR_UPD dependencies on HR_UTILITY

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

52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: -- Increment the object version
59: --
60: p_rec.object_version_number := p_rec.object_version_number + 1;

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

81: budget_unit3_available = p_rec.budget_unit3_available
82: where budget_version_id = p_rec.budget_version_id;
83: --
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated

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

137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --

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

139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|

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

196: --
197:
198: --
199: Begin
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: --
203: -- Start of API User Hook for post_update.
204: --

Line 216: hr_utility.set_location('Budget Status :'||l_budgets_rec.status, 6);

212: LOOP
213: FETCH csr_budget INTO l_budgets_rec;
214: EXIT WHEN csr_budget%NOTFOUND;
215:
216: hr_utility.set_location('Budget Status :'||l_budgets_rec.status, 6);
217:
218: -- call update API of budget to update the budget status to frozen
219:
220: l_object_version_number := l_budgets_rec.object_version_number;

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

279: --
280: -- End of API User Hook for post_update.
281: --
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 10);
284: End post_update;
285: --
286: -- ----------------------------------------------------------------------------
287: -- |-----------------------------< convert_defs >-----------------------------|

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

331: l_proc varchar2(72) := g_package||'convert_defs';
332: --
333: Begin
334: --
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- We must now examine each argument value in the
338: -- p_rec plsql record structure
339: -- to see if a system default is being used. If a system default

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

391: p_rec.budget_unit3_available :=
392: pqh_bvr_shd.g_old_rec.budget_unit3_available;
393: End If;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: --
397: End convert_defs;
398: --
399: -- ----------------------------------------------------------------------------

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

407: --
408: l_proc varchar2(72) := g_package||'upd';
409: --
410: Begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: -- We must lock the row which we need to update.
414: --
415: pqh_bvr_shd.lck

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

468: l_rec pqh_bvr_shd.g_rec_type;
469: l_proc varchar2(72) := g_package||'upd';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Call conversion function to turn arguments into the
475: -- l_rec structure.
476: --

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

501: upd(
502: p_effective_date,l_rec);
503: p_object_version_number := l_rec.object_version_number;
504: --
505: hr_utility.set_location(' Leaving:'||l_proc, 10);
506: End upd;
507: --
508: end pqh_bvr_upd;