APPS.BEN_CCM_SHD dependencies on BEN_CVG_AMT_CALC_MTHD_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_CVG_AMT_CALC_MTHD_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_CVG_AMT_CALC_MTHD_FK2') 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_CVG_AMT_CALC_MTHD_FK2') 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 139: from ben_cvg_amt_calc_mthd_f

135: ccm_attribute28,
136: ccm_attribute29,
137: ccm_attribute30,
138: object_version_number
139: from ben_cvg_amt_calc_mthd_f
140: where cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id
141: and p_effective_date
142: between effective_start_date and effective_end_date;
143: --

Line 216: from ben_cvg_amt_calc_mthd_f t

212: Cursor C_Sel1 Is
213: select t.oipl_id,
214: t.pl_id,
215: t.plip_id
216: from ben_cvg_amt_calc_mthd_f t
217: where t.cvg_amt_calc_mthd_id = p_base_key_value
218: and p_effective_date
219: between t.effective_start_date and t.effective_end_date;
220: --

Line 240: p_base_table_name => 'ben_cvg_amt_calc_mthd_f',

236: -- Call the corresponding datetrack api
237: --
238: dt_api.find_dt_del_modes
239: (p_effective_date => p_effective_date,
240: p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
241: p_base_key_column => 'cvg_amt_calc_mthd_id',
242: p_base_key_value => p_base_key_value,
243: p_parent_table_name1 => 'ben_oipl_f',
244: p_parent_key_column1 => 'oipl_id',

Line 280: p_base_table_name => 'ben_cvg_amt_calc_mthd_f',

276: -- Call the corresponding datetrack api
277: --
278: dt_api.find_dt_upd_modes
279: (p_effective_date => p_effective_date,
280: p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
281: p_base_key_column => 'cvg_amt_calc_mthd_id',
282: p_base_key_value => p_base_key_value,
283: p_correction => p_correction,
284: p_update => p_update,

Line 313: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',

309: -- version number.
310: --
311: l_object_version_number :=
312: dt_api.get_object_version_number
313: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
314: p_base_key_column => 'cvg_amt_calc_mthd_id',
315: p_base_key_value => p_base_key_value);
316: --
317: hr_utility.set_location(l_proc, 10);

Line 323: update ben_cvg_amt_calc_mthd_f t

319: --
320: -- Update the specified datetrack row setting the effective
321: -- end date to the specified new effective end date.
322: --
323: update ben_cvg_amt_calc_mthd_f t
324: set t.effective_end_date = p_new_effective_end_date,
325: t.object_version_number = l_object_version_number
326: where t.cvg_amt_calc_mthd_id = p_base_key_value
327: and p_effective_date

Line 426: from ben_cvg_amt_calc_mthd_f

422: ccm_attribute28,
423: ccm_attribute29,
424: ccm_attribute30,
425: object_version_number
426: from ben_cvg_amt_calc_mthd_f
427: where cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id
428: and p_effective_date
429: between effective_start_date and effective_end_date
430: for update nowait;

Line 485: p_base_table_name => 'ben_cvg_amt_calc_mthd_f',

481: --
482: dt_api.validate_dt_mode
483: (p_effective_date => p_effective_date,
484: p_datetrack_mode => p_datetrack_mode,
485: p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
486: p_base_key_column => 'cvg_amt_calc_mthd_id',
487: p_base_key_value => p_cvg_amt_calc_mthd_id,
488: p_parent_table_name1 => 'ben_oipl_f',
489: p_parent_key_column1 => 'oipl_id',

Line 536: hr_utility.set_message_token('TABLE_NAME', 'ben_cvg_amt_calc_mthd_f');

532: -- The object is locked therefore we need to supply a meaningful
533: -- error message.
534: --
535: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
536: hr_utility.set_message_token('TABLE_NAME', 'ben_cvg_amt_calc_mthd_f');
537: hr_utility.raise_error;
538: When l_object_invalid then
539: --
540: -- The object doesn't exist or is invalid

Line 543: hr_utility.set_message_token('TABLE_NAME', 'ben_cvg_amt_calc_mthd_f');

539: --
540: -- The object doesn't exist or is invalid
541: --
542: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
543: hr_utility.set_message_token('TABLE_NAME', 'ben_cvg_amt_calc_mthd_f');
544: hr_utility.raise_error;
545: End lck;
546: --
547: -- ----------------------------------------------------------------------------