APPS.BEN_YRP_SHD dependencies on BEN_YR_PERD

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_YR_PERDS_FK3') 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 44: hr_utility.set_message_token('TABLE_NAME','BEN_YR_PERD');

40: hr_utility.raise_error;
41:
42: ElsIf (p_constraint_name = 'BEN_ENRT_PERD_FK2') Then
43: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
44: hr_utility.set_message_token('TABLE_NAME','BEN_YR_PERD');
45: --hr_utility.set_message_token('PROCEDURE', l_proc);
46: -- hr_utility.set_message_token('STEP','5');
47: hr_utility.raise_error;
48:

Line 49: ElsIf (p_constraint_name = 'BEN_YR_PERDS_PK') Then

45: --hr_utility.set_message_token('PROCEDURE', l_proc);
46: -- hr_utility.set_message_token('STEP','5');
47: hr_utility.raise_error;
48:
49: ElsIf (p_constraint_name = 'BEN_YR_PERDS_PK') Then
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.set_message_token('PROCEDURE', l_proc);
52: hr_utility.set_message_token('STEP','10');
53: hr_utility.raise_error;

Line 120: from ben_yr_perd

116: yrp_attribute28,
117: yrp_attribute29,
118: yrp_attribute30,
119: object_version_number
120: from ben_yr_perd
121: where yr_perd_id = p_yr_perd_id;
122: --
123: l_proc varchar2(72) := g_package||'api_updating';
124: l_fct_ret boolean;

Line 230: from ben_yr_perd

226: yrp_attribute28,
227: yrp_attribute29,
228: yrp_attribute30,
229: object_version_number
230: from ben_yr_perd
231: where yr_perd_id = p_yr_perd_id
232: for update nowait;
233: --
234: l_proc varchar2(72) := g_package||'lck';

Line 273: hr_utility.set_message_token('TABLE_NAME', 'ben_yr_perd');

269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
273: hr_utility.set_message_token('TABLE_NAME', 'ben_yr_perd');
274: hr_utility.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------