APPS.HR_DEI_INS dependencies on HR_DOCUMENT_EXTRA_INFO

Line 81: -- Insert the row into: hr_document_extra_info

77: p_rec.object_version_number := 1; -- Initialise the object version
78: --
79: --
80: --
81: -- Insert the row into: hr_document_extra_info
82: --
83: insert into hr_document_extra_info
84: (document_extra_info_id
85: ,person_id

Line 83: insert into hr_document_extra_info

79: --
80: --
81: -- Insert the row into: hr_document_extra_info
82: --
83: insert into hr_document_extra_info
84: (document_extra_info_id
85: ,person_id
86: ,document_type_id
87: ,document_number

Line 317: Cursor C_Sel1 is select hr_document_extra_info_s.nextval from sys.dual;

313: Procedure pre_insert
314: (p_rec in out nocopy hr_dei_shd.g_rec_type
315: ) is
316: --
317: Cursor C_Sel1 is select hr_document_extra_info_s.nextval from sys.dual;
318: --
319: Cursor C_Sel2 is
320: Select null
321: from hr_document_extra_info

Line 321: from hr_document_extra_info

317: Cursor C_Sel1 is select hr_document_extra_info_s.nextval from sys.dual;
318: --
319: Cursor C_Sel2 is
320: Select null
321: from hr_document_extra_info
322: where document_extra_info_id =
323: hr_dei_ins.g_document_extra_info_id_i;
324: --
325: l_proc varchar2(72) := g_package||'pre_insert';

Line 343: fnd_message.set_token('TABLE_NAME','hr_document_extra_info');

339: --
340: -- The primary key values are already in use.
341: --
342: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
343: fnd_message.set_token('TABLE_NAME','hr_document_extra_info');
344: fnd_message.raise_error;
345: End If;
346: Close C_Sel2;
347: --

Line 582: (p_module_name => 'HR_DOCUMENT_EXTRA_INFO'

578: --
579: when hr_api.cannot_find_prog_unit then
580: --
581: hr_api.cannot_find_prog_unit_error
582: (p_module_name => 'HR_DOCUMENT_EXTRA_INFO'
583: ,p_hook_type => 'AI');
584: --
585: end;
586: --