APPS.HR_DTY_SHD dependencies on HR_DOCUMENT_TYPES

Line 21: If (p_constraint_name = 'HR_DOCUMENT_TYPES_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_DOCUMENT_TYPES_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 63: from hr_document_types

59: ,program_application_id
60: ,program_id
61: ,program_update_date
62: ,object_version_number
63: from hr_document_types
64: where document_type_id = p_document_type_id;
65: --
66: l_fct_ret boolean;
67: --

Line 142: from hr_document_types

138: ,program_application_id
139: ,program_id
140: ,program_update_date
141: ,object_version_number
142: from hr_document_types
143: where document_type_id = p_document_type_id
144: for update nowait;
145: --
146: l_proc varchar2(72) := g_package||'lck';

Line 191: fnd_message.set_token('TABLE_NAME', 'hr_document_types');

187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
191: fnd_message.set_token('TABLE_NAME', 'hr_document_types');
192: fnd_message.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------