[Home] [Help]
81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: per_cel_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: per_competence_elements
86: -- ngundura added object_id and object_name in the insert statement
87: insert into per_competence_elements
88: ( competence_element_id,
89: object_version_number,
83: per_cel_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: per_competence_elements
86: -- ngundura added object_id and object_name in the insert statement
87: insert into per_competence_elements
88: ( competence_element_id,
89: object_version_number,
90: type,
91: business_group_id,
320: --
321: l_proc varchar2(72) := g_package||'pre_insert';
322: l_exists varchar2(1);
323: --
324: Cursor C_Sel1 is select per_competence_elements_s.nextval from sys.dual;
325: --
326: Cursor C_Sel2 is
327: select null
328: from per_competence_elements
324: Cursor C_Sel1 is select per_competence_elements_s.nextval from sys.dual;
325: --
326: Cursor C_Sel2 is
327: select null
328: from per_competence_elements
329: where competence_element_id = per_cel_ins.g_competence_element_id_i;
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: -- The primary key values are already in use.
344: --
345: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
346: fnd_message.set_token('TABLE_NAME','per_competence_elements');
347: fnd_message.raise_error;
348: end if;
349: Close C_Sel2;
350: --
499: );
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: ( p_module_name => 'PER_COMPETENCE_ELEMENTS'
504: ,p_hook_type => 'AI'
505: );
506: end;
507: -- End of API User Hook for post_insert.