[Home] [Help]
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: hr_utility.set_location(l_proc, 6);
66: per_kad_shd.g_api_dml := true; -- Set the api dml status
67: --
68: hr_utility.set_location(l_proc, 7);
69: -- Update the per_addresses Row
64: --
65: hr_utility.set_location(l_proc, 6);
66: per_kad_shd.g_api_dml := true; -- Set the api dml status
67: --
68: hr_utility.set_location(l_proc, 7);
69: -- Update the per_addresses Row
70: --
71: update per_addresses
72: set
116: addr_attribute20 = p_rec.addr_attribute20,
117: object_version_number = p_rec.object_version_number
118: where address_id = p_rec.address_id;
119: --
120: hr_utility.set_location(l_proc, 8);
121: per_kad_shd.g_api_dml := false; -- Unset the api dml status
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
119: --
120: hr_utility.set_location(l_proc, 8);
121: per_kad_shd.g_api_dml := false; -- Unset the api dml status
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
179: --
180: l_proc varchar2(72) := g_package||'pre_update';
181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: End pre_update;
187: --
181: --
182: Begin
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: End pre_update;
187: --
188: -- ----------------------------------------------------------------------------
189: -- |-----------------------------< post_update >------------------------------|
229: --
230: -- End of Fix for WWBUG 1408379
231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: --
235: -- Fix for WWBUG 1408379
236: --
237: l_old.person_id := per_kad_shd.g_old_rec.person_id;
258: p_effective_date => l_new.date_from);
259: --
260: -- End of Fix for WWBUG 1408379
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: End post_update;
264: --
265: -- ----------------------------------------------------------------------------
266: -- |-----------------------------< convert_defs >-----------------------------|
311: l_proc varchar2(72) := g_package||'convert_defs';
312: --
313: Begin
314: --
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- We must now examine each argument value in the
318: -- p_rec plsql record structure
319: -- to see if a system default is being used. If a system default
502:
503: --
504: -- Return the plsql record structure.
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: Return(p_rec);
508: --
509: End convert_defs;
510: --
521: l_proc varchar2(72) := g_package||'upd';
522: l_convert per_kad_shd.g_rec_type;
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: -- Determine if the business process is to be validated.
528: --
529: If p_validate then
570: If p_validate then
571: Raise HR_Api.Validate_Enabled;
572: End If;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: Exception
576: When HR_Api.Validate_Enabled Then
577: --
578: -- As the Validate_Enabled exception has been raised
638: l_rec per_kad_shd.g_rec_type;
639: l_proc varchar2(72) := g_package||'upd';
640: --
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: --
644: -- Call conversion function to turn arguments into the
645: -- l_rec structure.
646: --
707: ,p_effective_date
708: );
709: p_object_version_number := l_rec.object_version_number;
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 10);
712: End upd;
713: --
714: end per_kad_upd;