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