[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;
155: WHERE location_id = p_rec.location_id;
156: --
157: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: --
161: EXCEPTION
162: WHEN hr_api.check_integrity_violated THEN
163: -- A check constraint has been violated
222: l_package_name varchar2(30);
223: BEGIN
224:
225: --
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: hr_loc_shd.derive_locale(p_rec);
229:
230:
237: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
238: and (nvl(p_rec.postal_code,' ') = nvl(hr_loc_shd.g_old_rec.postal_code,' '))
239: and (nvl(p_rec.country,' ') = nvl(hr_loc_shd.g_old_rec.country,' ')) ) then
240:
241: hr_utility.set_location('Not calling address2geometry:'||l_proc, 8);
242:
243: else
244: --
245: --
262: end if;
263:
264: end if;
265:
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: --
268: END pre_update;
269: --
270: -- ----------------------------------------------------------------------------
304: --
305: l_proc VARCHAR2(72) := g_package||'post_update';
306: --
307: BEGIN
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: -- Start of API User Hook for the after update hook
311: --
312: hr_loc_rku.after_update
482: );
483: --
484: -- End of API User Hook for the after_update hook
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: END post_update;
488: --
489: -- ----------------------------------------------------------------------------
490: -- |-----------------------------< convert_defs >-----------------------------|
535: l_proc VARCHAR2(72) := g_package||'convert_defs';
536: --
537: BEGIN
538: --
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: -- We must now examine each argument value in the
542: -- p_rec plsql record structure
543: -- to see if a system default is being used. If a system default
869: hr_loc_shd.g_old_rec.timezone_code;
870: END IF;
871: -- End Fix 3286235
872: --
873: hr_utility.set_location(' Leaving:'||l_proc, 10);
874: --
875: END convert_defs;
876: --
877: -- ----------------------------------------------------------------------------
886: --
887: l_proc VARCHAR2(72) := g_package||'upd';
888: --
889: BEGIN
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: -- We must lock the row which we need to update.
893: --
894: hr_loc_shd.lck
1017: l_rec hr_loc_shd.g_rec_type;
1018: l_proc VARCHAR2(72) := g_package||'upd';
1019: --
1020: BEGIN
1021: hr_utility.set_location('Entering:'||l_proc, 5);
1022: --
1023: -- Call conversion function to turn arguments into the
1024: -- l_rec structure.
1025: --
1113: -- Having converted the arguments into the
1114: -- plsql record structure we call the corresponding record
1115: -- business process.
1116: --
1117: hr_utility.set_location(' Leaving:'||l_proc, 10);
1118: upd(l_rec
1119: ,p_effective_date
1120: ,p_operating_unit_id);
1121:
1120: ,p_operating_unit_id);
1121:
1122: p_object_version_number := l_rec.object_version_number;
1123: --
1124: hr_utility.set_location(' Leaving:'||l_proc, 15);
1125: END upd;
1126: --
1127: END hr_loc_upd;