APPS.BEN_BPP_SHD dependencies on BEN_BNFT_PRVDR_POOL_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_BNFT_PRVDR_POOL_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 139: from ben_bnft_prvdr_pool_f

135: bpp_attribute28,
136: bpp_attribute29,
137: bpp_attribute30,
138: object_version_number
139: from ben_bnft_prvdr_pool_f
140: where bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
141: and p_effective_date
142: between effective_start_date and effective_end_date;
143: --

Line 224: from ben_bnft_prvdr_pool_f t

220: t.cmbn_plip_id,
221: t.cmbn_ptip_id,
222: t.cmbn_ptip_opt_id,
223: t.oiplip_id
224: from ben_bnft_prvdr_pool_f t
225: where t.bnft_prvdr_pool_id = p_base_key_value
226: and p_effective_date
227: between t.effective_start_date and t.effective_end_date;
228: --

Line 252: p_base_table_name => 'ben_bnft_prvdr_pool_f',

248: -- Call the corresponding datetrack api
249: --
250: dt_api.find_dt_del_modes
251: (p_effective_date => p_effective_date,
252: p_base_table_name => 'ben_bnft_prvdr_pool_f',
253: p_base_key_column => 'bnft_prvdr_pool_id',
254: p_base_key_value => p_base_key_value,
255: p_parent_table_name1 => 'ben_pgm_f',
256: p_parent_key_column1 => 'pgm_id',

Line 304: p_base_table_name => 'ben_bnft_prvdr_pool_f',

300: -- Call the corresponding datetrack api
301: --
302: dt_api.find_dt_upd_modes
303: (p_effective_date => p_effective_date,
304: p_base_table_name => 'ben_bnft_prvdr_pool_f',
305: p_base_key_column => 'bnft_prvdr_pool_id',
306: p_base_key_value => p_base_key_value,
307: p_correction => p_correction,
308: p_update => p_update,

Line 337: (p_base_table_name => 'ben_bnft_prvdr_pool_f',

333: -- version number.
334: --
335: l_object_version_number :=
336: dt_api.get_object_version_number
337: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
338: p_base_key_column => 'bnft_prvdr_pool_id',
339: p_base_key_value => p_base_key_value);
340: --
341: hr_utility.set_location(l_proc, 10);

Line 347: update ben_bnft_prvdr_pool_f t

343: --
344: -- Update the specified datetrack row setting the effective
345: -- end date to the specified new effective end date.
346: --
347: update ben_bnft_prvdr_pool_f t
348: set t.effective_end_date = p_new_effective_end_date,
349: t.object_version_number = l_object_version_number
350: where t.bnft_prvdr_pool_id = p_base_key_value
351: and p_effective_date

Line 455: from ben_bnft_prvdr_pool_f

451: bpp_attribute28,
452: bpp_attribute29,
453: bpp_attribute30,
454: object_version_number
455: from ben_bnft_prvdr_pool_f
456: where bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
457: and p_effective_date
458: between effective_start_date and effective_end_date
459: for update nowait;

Line 514: p_base_table_name => 'ben_bnft_prvdr_pool_f',

510: --
511: dt_api.validate_dt_mode
512: (p_effective_date => p_effective_date,
513: p_datetrack_mode => p_datetrack_mode,
514: p_base_table_name => 'ben_bnft_prvdr_pool_f',
515: p_base_key_column => 'bnft_prvdr_pool_id',
516: p_base_key_value => p_bnft_prvdr_pool_id,
517: p_parent_table_name1 => 'ben_pgm_f',
518: p_parent_key_column1 => 'pgm_id',

Line 579: fnd_message.set_token('TABLE_NAME', 'ben_bnft_prvdr_pool_f');

575: -- The object is locked therefore we need to supply a meaningful
576: -- error message.
577: --
578: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
579: fnd_message.set_token('TABLE_NAME', 'ben_bnft_prvdr_pool_f');
580: fnd_message.raise_error;
581: When l_object_invalid then
582: --
583: -- The object doesn't exist or is invalid

Line 586: fnd_message.set_token('TABLE_NAME', 'ben_bnft_prvdr_pool_f');

582: --
583: -- The object doesn't exist or is invalid
584: --
585: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
586: fnd_message.set_token('TABLE_NAME', 'ben_bnft_prvdr_pool_f');
587: fnd_message.raise_error;
588: End lck;
589: --
590: -- ----------------------------------------------------------------------------