APPS.PER_PHN_INS dependencies on PER_PHONES

Line 75: -- Insert the row into: per_phones

71: Begin
72: hr_utility.set_location('Entering:'||l_proc, 5);
73: p_rec.object_version_number := 1; -- Initialise the object version
74: --
75: -- Insert the row into: per_phones
76: --
77: insert into per_phones
78: ( phone_id,
79: date_from,

Line 77: insert into per_phones

73: p_rec.object_version_number := 1; -- Initialise the object version
74: --
75: -- Insert the row into: per_phones
76: --
77: insert into per_phones
78: ( phone_id,
79: date_from,
80: date_to,
81: phone_type,

Line 224: Cursor C_Sel1 is select per_phones_s.nextval from sys.dual;

220: --
221: l_proc varchar2(72) := g_package||'pre_insert';
222: l_exists varchar2(1);
223: --
224: Cursor C_Sel1 is select per_phones_s.nextval from sys.dual;
225: --
226: Cursor C_Sel2 is
227: select null
228: from per_phones

Line 228: from per_phones

224: Cursor C_Sel1 is select per_phones_s.nextval from sys.dual;
225: --
226: Cursor C_Sel2 is
227: select null
228: from per_phones
229: where phone_id = per_phn_ins.g_phone_id_i;
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);

Line 246: fnd_message.set_token('TABLE_NAME','per_phones');

242: --
243: -- The primary key values are already in use.
244: --
245: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
246: fnd_message.set_token('TABLE_NAME','per_phones');
247: fnd_message.raise_error;
248: end if;
249: Close C_Sel2;
250: --

Line 359: (p_module_name => 'PER_PHONES'

355: );
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'PER_PHONES'
360: ,p_hook_type => 'AI'
361: );
362: end;
363: --