[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: hr_utility.set_location('tax_name :' ||p_rec.tax_name, 10);
81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: hr_loc_shd.g_api_dml := true; -- Set the api dml status
76: l_proc VARCHAR2(72) := g_package||'insert_dml';
77: --
78: BEGIN
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: hr_utility.set_location('tax_name :' ||p_rec.tax_name, 10);
81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: hr_loc_shd.g_api_dml := true; -- Set the api dml status
84: --
261: );
262: --
263: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: EXCEPTION
267: WHEN hr_api.check_integrity_violated THEN
268: -- A check constraint has been violated
269: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
334: l_package_exists boolean;
335: l_package_name varchar2(2000);
336: --
337: BEGIN
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: --
341: -- Select the next sequence number for hr_locations_all.location_id:
342: --
361: and ( p_rec.region_3 is null)
362: and (p_rec.postal_code is null)
363: and (p_rec.country is null)) then
364:
365: hr_utility.set_location('Not calling address2geometry:'||l_proc, 8);
366:
367: else
368: --
369: --
389: end if;
390:
391: hr_loc_shd.derive_locale(p_rec);
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: END pre_insert;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |-----------------------------< post_insert >------------------------------|
430: --
431: l_proc VARCHAR2(72) := g_package||'post_insert';
432: --
433: BEGIN
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: -- Start of API User Hook for the before hook of create_location
437: --
438: hr_loc_rki.after_insert
529: --
530: -- End of API User Hook for the before hook of create_location
531: --
532: --
533: hr_utility.set_location(' Leaving:'||l_proc, 10);
534: END post_insert;
535: --
536: -- ----------------------------------------------------------------------------
537: -- |---------------------------------< ins >----------------------------------|
545: --
546: l_proc VARCHAR2(72) := g_package||'ins';
547: --
548: BEGIN
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Call the supporting insert validate operations
552: --
553: hr_loc_bus.insert_validate(p_rec
664: l_rec hr_loc_shd.g_rec_type;
665: l_proc VARCHAR2(72) := g_package||'ins';
666: --
667: BEGIN
668: hr_utility.set_location('Entering:'||l_proc, 5);
669: --
670: -- Call conversion function to turn arguments into the
671: -- p_rec structure.
672: --
769: --
770: p_location_id := l_rec.location_id;
771: p_object_version_number := l_rec.object_version_number;
772: --
773: hr_utility.set_location(' Leaving:'||l_proc, 10);
774: END ins;
775: --
776: END hr_loc_ins;