DBA Data[Home] [Help]

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

76: wf_transaction_category_id = p_rec.wf_transaction_category_id
77: where worksheet_id = p_rec.worksheet_id;
78: --
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated

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

132: --
133: l_proc varchar2(72) := g_package||'pre_update';
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: End pre_update;
140: --

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

134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: End pre_update;
140: --
141: -- ----------------------------------------------------------------------------
142: -- |-----------------------------< post_update >------------------------------|

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

175: --
176: l_proc varchar2(72) := g_package||'post_update';
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: --
182: -- Start of API User Hook for post_update.
183: --

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

225: --
226: -- End of API User Hook for post_update.
227: --
228: --
229: hr_utility.set_location(' Leaving:'||l_proc, 10);
230: End post_update;
231: --
232: -- ----------------------------------------------------------------------------
233: -- |-----------------------------< convert_defs >-----------------------------|

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

277: l_proc varchar2(72) := g_package||'convert_defs';
278: --
279: Begin
280: --
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- We must now examine each argument value in the
284: -- p_rec plsql record structure
285: -- to see if a system default is being used. If a system default

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

329: p_rec.wf_transaction_category_id :=
330: pqh_wks_shd.g_old_rec.wf_transaction_category_id;
331: End If;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: --
335: End convert_defs;
336: --
337: -- ----------------------------------------------------------------------------

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

345: --
346: l_proc varchar2(72) := g_package||'upd';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- We must lock the row which we need to update.
352: --
353: pqh_wks_shd.lck

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

404: l_rec pqh_wks_shd.g_rec_type;
405: l_proc varchar2(72) := g_package||'upd';
406: --
407: Begin
408: hr_utility.set_location('Entering:'||l_proc, 5);
409: --
410: -- Call conversion function to turn arguments into the
411: -- l_rec structure.
412: --

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

435: upd(
436: p_effective_date,l_rec);
437: p_object_version_number := l_rec.object_version_number;
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End upd;
441: --
442: end pqh_wks_upd;