APPS.PER_CEO_INS dependencies on PER_COMP_ELEMENT_OUTCOMES

Line 87: -- Insert the row into: per_comp_element_outcomes

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: per_ceo_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_comp_element_outcomes
88: --
89: insert into per_comp_element_outcomes
90: (comp_element_outcome_id
91: ,competence_element_id

Line 89: insert into per_comp_element_outcomes

85: per_ceo_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_comp_element_outcomes
88: --
89: insert into per_comp_element_outcomes
90: (comp_element_outcome_id
91: ,competence_element_id
92: ,outcome_id
93: ,date_from

Line 256: select per_comp_element_outcomes_s.nextval

252: (p_rec in out nocopy per_ceo_shd.g_rec_type
253: ) is
254: --
255: Cursor C_Sel1 is
256: select per_comp_element_outcomes_s.nextval
257: from sys.dual;
258: --
259: Cursor C_Sel2 is
260: Select null

Line 261: from per_comp_element_outcomes

257: from sys.dual;
258: --
259: Cursor C_Sel2 is
260: Select null
261: from per_comp_element_outcomes
262: where comp_element_outcome_id =
263: per_ceo_ins.g_comp_element_outcome_id_i;
264: --
265: l_proc varchar2(72) := g_package||'pre_insert';

Line 283: fnd_message.set_token('TABLE_NAME','per_comp_element_outcomes');

279: --
280: -- The primary key values are already in use.
281: --
282: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
283: fnd_message.set_token('TABLE_NAME','per_comp_element_outcomes');
284: fnd_message.raise_error;
285: End If;
286: Close C_Sel2;
287: --

Line 456: (p_module_name => 'PER_COMP_ELEMENT_OUTCOMES'

452: --
453: when hr_api.cannot_find_prog_unit then
454: --
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'PER_COMP_ELEMENT_OUTCOMES'
457: ,p_hook_type => 'AI');
458: --
459: end;
460: --