APPS.BEN_XRC_SHD dependencies on BEN_EXT_RCD

Line 36: ben_ext_rcd_in_file xrf

32:
33: cursor c1 is
34: select xfi.name
35: from ben_ext_file xfi,
36: ben_ext_rcd_in_file xrf
37: where xrf.ext_rcd_id = g_old_rec.ext_rcd_id
38: and xrf.ext_file_id = xfi.ext_file_id;
39:
40: l_name ben_ext_file.name%type ;

Line 45: If (p_constraint_name = 'BEN_EXT_RCD_FK1') Then

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

Line 50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then

46: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','5');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('STEP','10');
54: fnd_message.raise_error;

Line 61: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK2') Then

57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK3') Then
59: fnd_message.set_name('BEN', 'BEN_92483_XRD_EXISTS');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK2') Then
62: open c1;
63: fetch c1 into l_name;
64: close c1;
65: fnd_message.set_name('BEN', 'BEN_92481_XRF_EXISTS');

Line 136: from ben_ext_rcd

132: last_updated_by,
133: last_update_login,
134: created_by ,
135: object_version_number
136: from ben_ext_rcd
137: where ext_rcd_id = p_ext_rcd_id;
138: --
139: l_proc varchar2(72) := g_package||'api_updating';
140: l_fct_ret boolean;

Line 249: from ben_ext_rcd

245: last_updated_by,
246: last_update_login,
247: created_by ,
248: object_version_number
249: from ben_ext_rcd
250: where ext_rcd_id = p_ext_rcd_id
251: for update nowait;
252: --
253: l_proc varchar2(72) := g_package||'lck';

Line 292: fnd_message.set_token('TABLE_NAME', 'ben_ext_rcd');

288: -- The object is locked therefore we need to supply a meaningful
289: -- error message.
290: --
291: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
292: fnd_message.set_token('TABLE_NAME', 'ben_ext_rcd');
293: fnd_message.raise_error;
294: End lck;
295: --
296: -- ----------------------------------------------------------------------------