DBA Data[Home] [Help]

APPS.PQH_RST_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 59: hr_utility.set_location('rule_set_name passed is'||p_rec.rule_set_name, 30);

55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;
58:
59: hr_utility.set_location('rule_set_name passed is'||p_rec.rule_set_name, 30);
60:
61: --
62: --
63: -- Update the pqh_rule_sets Row

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

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

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

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

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

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

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

179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: --
186: -- Start of API User Hook for post_update.
187: --

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

231: --
232: -- End of API User Hook for post_update.
233: --
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: End post_update;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |-----------------------------< convert_defs >-----------------------------|

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

283: l_proc varchar2(72) := g_package||'convert_defs';
284: --
285: Begin
286: --
287: hr_utility.set_location('Entering:'||l_proc, 5);
288: --
289: -- We must now examine each argument value in the
290: -- p_rec plsql record structure
291: -- to see if a system default is being used. If a system default

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

339: p_rec.status :=
340: pqh_rst_shd.g_old_rec.status;
341: End If;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: --
345: End convert_defs;
346: --
347: -- ----------------------------------------------------------------------------

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

355: --
356: l_proc varchar2(72) := g_package||'upd';
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- We must lock the row which we need to update.
362: --
363: pqh_rst_shd.lck

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

415: l_rec pqh_rst_shd.g_rec_type;
416: l_proc varchar2(72) := g_package||'upd';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Call conversion function to turn arguments into the
422: -- l_rec structure.
423: --

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

447: upd(
448: p_effective_date,l_rec);
449: p_object_version_number := l_rec.object_version_number;
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: End upd;
453: --
454: end pqh_rst_upd;