eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XER_SHD dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 36: ben_ext_data_elmt_in_rcd xdr

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

Line 46: ben_ext_data_elmt_in_rcd xdr

42: cursor c2 is
43: select xfi.name
44: from ben_ext_file xfi,
45: ben_ext_rcd_in_file xrf,
46: ben_ext_data_elmt_in_rcd xdr
47: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
48: and xdr.ext_rcd_id = xdr.ext_rcd_id
49: and xrf.sort2_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
50: and xrf.ext_file_id = xfi.ext_file_id;

Line 56: ben_ext_data_elmt_in_rcd xdr

52: cursor c3 is
53: select xfi.name
54: from ben_ext_file xfi,
55: ben_ext_rcd_in_file xrf,
56: ben_ext_data_elmt_in_rcd xdr
57: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
58: and xdr.ext_rcd_id = xdr.ext_rcd_id
59: and xrf.sort3_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
60: and xrf.ext_file_id = xfi.ext_file_id;

Line 66: ben_ext_data_elmt_in_rcd xdr

62: cursor c4 is
63: select xfi.name
64: from ben_ext_file xfi,
65: ben_ext_rcd_in_file xrf,
66: ben_ext_data_elmt_in_rcd xdr
67: where xdr.ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
68: and xdr.ext_rcd_id = xdr.ext_rcd_id
69: and xrf.sort4_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
70: and xrf.ext_file_id = xfi.ext_file_id;

Line 91: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then

87: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
88: fnd_message.set_token('PROCEDURE', l_proc);
89: fnd_message.set_token('STEP','5');
90: fnd_message.raise_error;
91: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then
92: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
93: fnd_message.set_token('PROCEDURE', l_proc);
94: fnd_message.set_token('STEP','10');
95: fnd_message.raise_error;

Line 96: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK3') Then

92: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
93: fnd_message.set_token('PROCEDURE', l_proc);
94: fnd_message.set_token('STEP','10');
95: fnd_message.raise_error;
96: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK3') Then
97: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
98: fnd_message.set_token('PROCEDURE', l_proc);
99: fnd_message.set_token('STEP','15');
100: fnd_message.raise_error;

Line 101: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_PK') Then

97: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
98: fnd_message.set_token('PROCEDURE', l_proc);
99: fnd_message.set_token('STEP','15');
100: fnd_message.raise_error;
101: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_PK') Then
102: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
103: fnd_message.set_token('PROCEDURE', l_proc);
104: fnd_message.set_token('STEP','20');
105: fnd_message.raise_error;

Line 194: from ben_ext_data_elmt_in_rcd

190: last_update_login,
191: created_by ,
192: object_version_number,
193: hide_flag
194: from ben_ext_data_elmt_in_rcd
195: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
196: --
197: l_proc varchar2(72) := g_package||'api_updating';
198: l_fct_ret boolean;

Line 281: from ben_ext_data_elmt_in_rcd

277: last_update_login,
278: created_by ,
279: object_version_number,
280: hide_flag
281: from ben_ext_data_elmt_in_rcd
282: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
283: for update nowait;
284: --
285: l_proc varchar2(72) := g_package||'lck';

Line 324: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt_in_rcd');

320: -- The object is locked therefore we need to supply a meaningful
321: -- error message.
322: --
323: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
324: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt_in_rcd');
325: fnd_message.raise_error;
326: End lck;
327: --
328: -- ----------------------------------------------------------------------------