APPS.BEN_RZR_SHD dependencies on BEN_PSTL_ZIP_RNG_F

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

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

104: rzr_attribute7,
105: rzr_attribute8,
106: rzr_attribute9,
107: object_version_number
108: from ben_pstl_zip_rng_f
109: where pstl_zip_rng_id = p_pstl_zip_rng_id
110: and p_effective_date
111: between effective_start_date and effective_end_date;
112: --

Line 188: p_base_table_name => 'ben_pstl_zip_rng_f',

184: -- Call the corresponding datetrack api
185: --
186: dt_api.find_dt_del_modes
187: (p_effective_date => p_effective_date,
188: p_base_table_name => 'ben_pstl_zip_rng_f',
189: p_base_key_column => 'pstl_zip_rng_id',
190: p_base_key_value => p_base_key_value,
191: p_zap => p_zap,
192: p_delete => p_delete,

Line 219: p_base_table_name => 'ben_pstl_zip_rng_f',

215: -- Call the corresponding datetrack api
216: --
217: dt_api.find_dt_upd_modes
218: (p_effective_date => p_effective_date,
219: p_base_table_name => 'ben_pstl_zip_rng_f',
220: p_base_key_column => 'pstl_zip_rng_id',
221: p_base_key_value => p_base_key_value,
222: p_correction => p_correction,
223: p_update => p_update,

Line 252: (p_base_table_name => 'ben_pstl_zip_rng_f',

248: -- version number.
249: --
250: l_object_version_number :=
251: dt_api.get_object_version_number
252: (p_base_table_name => 'ben_pstl_zip_rng_f',
253: p_base_key_column => 'pstl_zip_rng_id',
254: p_base_key_value => p_base_key_value);
255: --
256: hr_utility.set_location(l_proc, 10);

Line 262: update ben_pstl_zip_rng_f t

258: --
259: -- Update the specified datetrack row setting the effective
260: -- end date to the specified new effective end date.
261: --
262: update ben_pstl_zip_rng_f t
263: set t.effective_end_date = p_new_effective_end_date,
264: t.object_version_number = l_object_version_number
265: where t.pstl_zip_rng_id = p_base_key_value
266: and p_effective_date

Line 339: from ben_pstl_zip_rng_f

335: rzr_attribute7,
336: rzr_attribute8,
337: rzr_attribute9,
338: object_version_number
339: from ben_pstl_zip_rng_f
340: where pstl_zip_rng_id = p_pstl_zip_rng_id
341: and p_effective_date
342: between effective_start_date and effective_end_date
343: for update nowait;

Line 398: p_base_table_name => 'ben_pstl_zip_rng_f',

394: --
395: dt_api.validate_dt_mode
396: (p_effective_date => p_effective_date,
397: p_datetrack_mode => p_datetrack_mode,
398: p_base_table_name => 'ben_pstl_zip_rng_f',
399: p_base_key_column => 'pstl_zip_rng_id',
400: p_base_key_value => p_pstl_zip_rng_id,
401: p_child_table_name1 => 'ben_elig_pstl_cd_r_rng_prte_f',
402: p_child_key_column1 => 'elig_pstl_cd_r_rng_prte_id',

Line 440: fnd_message.set_token('TABLE_NAME', 'ben_pstl_zip_rng_f');

436: -- The object is locked therefore we need to supply a meaningful
437: -- error message.
438: --
439: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
440: fnd_message.set_token('TABLE_NAME', 'ben_pstl_zip_rng_f');
441: fnd_message.raise_error;
442: When l_object_invalid then
443: --
444: -- The object doesn't exist or is invalid

Line 447: fnd_message.set_token('TABLE_NAME', 'ben_pstl_zip_rng_f');

443: --
444: -- The object doesn't exist or is invalid
445: --
446: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
447: fnd_message.set_token('TABLE_NAME', 'ben_pstl_zip_rng_f');
448: fnd_message.raise_error;
449: End lck;
450: --
451: -- ----------------------------------------------------------------------------