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