APPS.PER_QUA_INS dependencies on PER_QUALIFICATIONS

Line 84: -- Insert the row into: per_qualifications

80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: per_qua_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: per_qualifications
85: --
86: insert into per_qualifications
87: ( qualification_id,
88: business_group_id,

Line 86: insert into per_qualifications

82: per_qua_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: per_qualifications
85: --
86: insert into per_qualifications
87: ( qualification_id,
88: business_group_id,
89: object_version_number,
90: person_id,

Line 303: Cursor C_Sel1 is select per_qualifications_s.nextval from sys.dual;

299: --
300: l_proc varchar2(72) := g_package||'pre_insert';
301: l_exists varchar2(1);
302: --
303: Cursor C_Sel1 is select per_qualifications_s.nextval from sys.dual;
304: --
305: Cursor C_Sel2 is
306: select null
307: from per_qualifications

Line 307: from per_qualifications

303: Cursor C_Sel1 is select per_qualifications_s.nextval from sys.dual;
304: --
305: Cursor C_Sel2 is
306: select null
307: from per_qualifications
308: where qualification_id = per_qua_ins.g_qualification_id_i;
309: --
310:
311: Begin

Line 326: fnd_message.set_token('TABLE_NAME','per_qualifications');

322: --
323: -- The primary key values are already in use.
324: --
325: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
326: fnd_message.set_token('TABLE_NAME','per_qualifications');
327: fnd_message.raise_error;
328: end if;
329: Close C_Sel2;
330: --

Line 472: (p_module_name => 'PER_QUALIFICATIONS'

468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'PER_QUALIFICATIONS'
473: ,p_hook_type => 'AI'
474: );
475: end;
476: --