[Home] [Help]
20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_loc_ins.g_location_id_i := p_location_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: hr_loc_ins.g_location_id_i := p_location_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|
75: --
76: l_proc VARCHAR2(72) := g_package||'insert_dml';
77: --
78: BEGIN
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: hr_loc_shd.g_api_dml := true; -- Set the api dml status
83: --
259: );
260: --
261: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: EXCEPTION
265: WHEN hr_api.check_integrity_violated THEN
266: -- A check constraint has been violated
267: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
332: l_package_exists boolean;
333: l_package_name varchar2(2000);
334: --
335: BEGIN
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: --
339: -- Select the next sequence number for hr_locations_all.location_id:
340: --
359: and ( p_rec.region_3 is null)
360: and (p_rec.postal_code is null)
361: and (p_rec.country is null)) then
362:
363: hr_utility.set_location('Not calling address2geometry:'||l_proc, 8);
364:
365: else
366: --
367: --
387: end if;
388:
389: hr_loc_shd.derive_locale(p_rec);
390: --
391: hr_utility.set_location(' Leaving:'||l_proc, 10);
392: END pre_insert;
393: --
394: -- ----------------------------------------------------------------------------
395: -- |-----------------------------< post_insert >------------------------------|
428: --
429: l_proc VARCHAR2(72) := g_package||'post_insert';
430: --
431: BEGIN
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- Start of API User Hook for the before hook of create_location
435: --
436: hr_loc_rki.after_insert
527: --
528: -- End of API User Hook for the before hook of create_location
529: --
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 10);
532: END post_insert;
533: --
534: -- ----------------------------------------------------------------------------
535: -- |---------------------------------< ins >----------------------------------|
543: --
544: l_proc VARCHAR2(72) := g_package||'ins';
545: --
546: BEGIN
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Call the supporting insert validate operations
550: --
551: hr_loc_bus.insert_validate(p_rec
662: l_rec hr_loc_shd.g_rec_type;
663: l_proc VARCHAR2(72) := g_package||'ins';
664: --
665: BEGIN
666: hr_utility.set_location('Entering:'||l_proc, 5);
667: --
668: -- Call conversion function to turn arguments into the
669: -- p_rec structure.
670: --
767: --
768: p_location_id := l_rec.location_id;
769: p_object_version_number := l_rec.object_version_number;
770: --
771: hr_utility.set_location(' Leaving:'||l_proc, 10);
772: END ins;
773: --
774: END hr_loc_ins;