DBA Data[Home] [Help]

APPS.PER_OBJ_INS dependencies on PER_OBJECTIVES

Line 77: -- Insert the row into: per_objectives

73: Begin
74: hr_utility.set_location('Entering:'||l_proc, 5);
75: p_rec.object_version_number := 1; -- Initialise the object version
76: --
77: -- Insert the row into: per_objectives
78: --
79: insert into per_objectives
80: ( objective_id,
81: name,

Line 79: insert into per_objectives

75: p_rec.object_version_number := 1; -- Initialise the object version
76: --
77: -- Insert the row into: per_objectives
78: --
79: insert into per_objectives
80: ( objective_id,
81: name,
82: target_date,
83: start_date,

Line 281: Cursor C_Sel1 is select per_objectives_s.nextval from sys.dual;

277: --
278: l_proc varchar2(72) := g_package||'pre_insert';
279: l_exists varchar2(1);
280: --
281: Cursor C_Sel1 is select per_objectives_s.nextval from sys.dual;
282: --
283: --
284: Cursor C_Sel2 is
285: Select null

Line 286: from per_objectives

282: --
283: --
284: Cursor C_Sel2 is
285: Select null
286: from per_objectives
287: where objective_id =
288: per_obj_ins.g_objective_id_i;
289: --
290:

Line 310: fnd_message.set_token('TABLE_NAME','PER_OBJECTIVES');

306: --
307: -- The primary key values are already in use.
308: --
309: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
310: fnd_message.set_token('TABLE_NAME','PER_OBJECTIVES');
311: fnd_message.raise_error;
312: End If;
313: Close C_Sel2;
314: --

Line 454: (p_module_name => 'PER_OBJECTIVES'

450: );
451: exception
452: when hr_api.cannot_find_prog_unit then
453: hr_api.cannot_find_prog_unit_error
454: (p_module_name => 'PER_OBJECTIVES'
455: ,p_hook_type => 'AI'
456: );
457: end;
458: -- End of API User Hook for post_insert.