APPS.BEN_CPY_SHD dependencies on BEN_POPL_YR_PERD

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_POPL_YR_PERD_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_POPL_YR_PERD_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_POPL_YR_PERD_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 110: from ben_popl_yr_perd

106: cpy_attribute28,
107: cpy_attribute29,
108: cpy_attribute30,
109: object_version_number
110: from ben_popl_yr_perd
111: where popl_yr_perd_id = p_popl_yr_perd_id;
112: --
113: l_proc varchar2(72) := g_package||'api_updating';
114: l_fct_ret boolean;

Line 219: from ben_popl_yr_perd

215: cpy_attribute28,
216: cpy_attribute29,
217: cpy_attribute30,
218: object_version_number
219: from ben_popl_yr_perd
220: where popl_yr_perd_id = p_popl_yr_perd_id
221: for update nowait;
222: --
223: l_proc varchar2(72) := g_package||'lck';

Line 262: hr_utility.set_message_token('TABLE_NAME', 'ben_popl_yr_perd');

258: -- The object is locked therefore we need to supply a meaningful
259: -- error message.
260: --
261: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
262: hr_utility.set_message_token('TABLE_NAME', 'ben_popl_yr_perd');
263: hr_utility.raise_error;
264: End lck;
265: --
266: -- ----------------------------------------------------------------------------