DBA Data[Home] [Help]

APPS.PER_ENT_INS dependencies on PER_CALENDAR_ENTRIES

Line 87: -- Insert the row into: per_calendar_entries

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: per_calendar_entries
88: insert into per_calendar_entries
89: (calendar_entry_id
90: ,business_group_id
91: ,name

Line 88: insert into per_calendar_entries

84: --
85: --
86: --
87: -- Insert the row into: per_calendar_entries
88: insert into per_calendar_entries
89: (calendar_entry_id
90: ,business_group_id
91: ,name
92: ,type

Line 194: Cursor C_Sel1 is select per_calendar_entries_s.nextval from sys.dual;

190: Procedure pre_insert
191: (p_rec in out NOCOPY per_ent_shd.g_rec_type
192: ) is
193: --
194: Cursor C_Sel1 is select per_calendar_entries_s.nextval from sys.dual;
195: --
196: Cursor C_Sel2 is
197: Select null
198: from per_calendar_entries

Line 198: from per_calendar_entries

194: Cursor C_Sel1 is select per_calendar_entries_s.nextval from sys.dual;
195: --
196: Cursor C_Sel2 is
197: Select null
198: from per_calendar_entries
199: where calendar_entry_id =
200: per_ent_ins.g_calendar_entry_id_i;
201: --
202: l_proc varchar2(72) := g_package||'pre_insert';

Line 220: fnd_message.set_token('TABLE_NAME','per_calendar_entries');

216: --
217: -- The primary key values are already in use.
218: --
219: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
220: fnd_message.set_token('TABLE_NAME','per_calendar_entries');
221: fnd_message.raise_error;
222: End If;
223: Close C_Sel2;
224: --

Line 330: (p_module_name => 'PER_CALENDAR_ENTRIES'

326: --
327: when hr_api.cannot_find_prog_unit then
328: --
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'PER_CALENDAR_ENTRIES'
331: ,p_hook_type => 'AI');
332: --
333: end;
334: --