APPS.BEN_BMN_SHD dependencies on BEN_REPORTING

Line 36: If (p_constraint_name = 'BEN_REPORTING_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_REPORTING_FK1') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;

Line 41: ElsIf (p_constraint_name = 'BEN_REPORTING_PK') Then

37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'BEN_REPORTING_PK') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;

Line 92: from ben_reporting

88: val ,
89: mo_num ,
90: yr_num ,
91: object_version_number
92: from ben_reporting
93: where reporting_id = p_reporting_id;
94: --
95: l_proc varchar2(72) := g_package||'api_updating';
96: l_fct_ret boolean;

Line 183: from ben_reporting

179: val ,
180: mo_num ,
181: yr_num ,
182: object_version_number
183: from ben_reporting
184: where reporting_id = p_reporting_id
185: for update nowait;
186: --
187: l_proc varchar2(72) := g_package||'lck';

Line 226: hr_utility.set_message_token('TABLE_NAME', 'ben_reporting');

222: -- The object is locked therefore we need to supply a meaningful
223: -- error message.
224: --
225: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
226: hr_utility.set_message_token('TABLE_NAME', 'ben_reporting');
227: hr_utility.raise_error;
228: End lck;
229: --
230: -- ----------------------------------------------------------------------------