APPS.BEN_XFI_SHD dependencies on BEN_EXT_FILE

Line 42: If (p_constraint_name = 'BEN_EXT_FILE_FK1') Then

38: --
39: Begin
40: hr_utility.set_location('Entering:'||l_proc, 5);
41: --
42: If (p_constraint_name = 'BEN_EXT_FILE_FK1') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','5');
46: fnd_message.raise_error;

Line 47: ElsIf (p_constraint_name = 'BEN_EXT_FILE_PK') Then

43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','5');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'BEN_EXT_FILE_PK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','10');
51: fnd_message.raise_error;

Line 131: from ben_ext_file

127: last_updated_by,
128: last_update_login,
129: created_by ,
130: object_version_number
131: from ben_ext_file
132: where ext_file_id = p_ext_file_id;
133: --
134: l_proc varchar2(72) := g_package||'api_updating';
135: l_fct_ret boolean;

Line 245: from ben_ext_file

241: last_updated_by,
242: last_update_login,
243: created_by ,
244: object_version_number
245: from ben_ext_file
246: where ext_file_id = p_ext_file_id
247: for update nowait;
248: --
249: l_proc varchar2(72) := g_package||'lck';

Line 288: fnd_message.set_token('TABLE_NAME', 'ben_ext_file');

284: -- The object is locked therefore we need to supply a meaningful
285: -- error message.
286: --
287: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
288: fnd_message.set_token('TABLE_NAME', 'ben_ext_file');
289: fnd_message.raise_error;
290: End lck;
291: --
292: -- ----------------------------------------------------------------------------