APPS.BEN_BLI_SHD dependencies on BEN_BATCH_LER_INFO

Line 56: ElsIf (p_constraint_name = 'BEN_BATCH_LER_INFO_FK1') Then

52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','20');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'BEN_BATCH_LER_INFO_FK1') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','25');
60: hr_utility.raise_error;

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

57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','25');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'BEN_BATCH_LER_INFO_FK2') Then
62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
63: hr_utility.set_message_token('PROCEDURE', l_proc);
64: hr_utility.set_message_token('STEP','30');
65: hr_utility.raise_error;

Line 66: ElsIf (p_constraint_name = 'BEN_BATCH_LER_INFO_PK') Then

62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
63: hr_utility.set_message_token('PROCEDURE', l_proc);
64: hr_utility.set_message_token('STEP','30');
65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'BEN_BATCH_LER_INFO_PK') Then
67: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
68: hr_utility.set_message_token('PROCEDURE', l_proc);
69: hr_utility.set_message_token('STEP','35');
70: hr_utility.raise_error;

Line 115: from ben_batch_ler_info

111: cvrge_rt_prem_flag,
112: per_in_ler_id,
113: business_group_id,
114: object_version_number
115: from ben_batch_ler_info
116: where batch_ler_id = p_batch_ler_id;
117: --
118: l_proc varchar2(72) := g_package||'api_updating';
119: l_fct_ret boolean;

Line 204: from ben_batch_ler_info

200: cvrge_rt_prem_flag,
201: per_in_ler_id,
202: business_group_id,
203: object_version_number
204: from ben_batch_ler_info
205: where batch_ler_id = p_batch_ler_id
206: for update nowait;
207: --
208: l_proc varchar2(72) := g_package||'lck';

Line 247: hr_utility.set_message_token('TABLE_NAME', 'ben_batch_ler_info');

243: -- The object is locked therefore we need to supply a meaningful
244: -- error message.
245: --
246: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
247: hr_utility.set_message_token('TABLE_NAME', 'ben_batch_ler_info');
248: hr_utility.raise_error;
249: End lck;
250: --
251: -- ----------------------------------------------------------------------------