52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_routing_categories
57: --
58: insert into pqh_routing_categories
59: ( routing_category_id,
60: transaction_category_id,
54: --
55: --
56: -- Insert the row into: pqh_routing_categories
57: --
58: insert into pqh_routing_categories
59: ( routing_category_id,
60: transaction_category_id,
61: enable_flag,
62: default_flag,
144: --
145: l_proc varchar2(72) := g_package||'pre_insert';
146: --
147: --
148: Cursor C_Sel1 is select pqh_routing_categories_s.nextval from sys.dual;
149: --
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: when hr_api.cannot_find_prog_unit then
229: --
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'pqh_routing_categories'
232: ,p_hook_type => 'AI');
233: --
234: end;
235: --