[Home] [Help]
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: -- Deleted lines for constraint_name = 'BEN_ELIG_ZIP_PSTL_CD_PRTE_UK'
52: -- The constraint has been dropped from the table 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F'
53: Else
54: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
115: epz_attribute30,
116: object_version_number,
117: criteria_score,
118: criteria_weight
119: from ben_elig_pstl_cd_r_rng_prte_f
120: where elig_pstl_cd_r_rng_prte_id = p_elig_pstl_cd_r_rng_prte_id
121: and p_effective_date
122: between effective_start_date and effective_end_date;
123: --
190: --
191: Cursor C_Sel1 Is
192: select t.eligy_prfl_id,
193: t.pstl_zip_rng_id
194: from ben_elig_pstl_cd_r_rng_prte_f t
195: where t.elig_pstl_cd_r_rng_prte_id = p_base_key_value
196: and p_effective_date
197: between t.effective_start_date and t.effective_end_date;
198: --
213: -- Call the corresponding datetrack api
214: --
215: dt_api.find_dt_del_modes
216: (p_effective_date => p_effective_date,
217: p_base_table_name => 'ben_elig_pstl_cd_r_rng_prte_f',
218: p_base_key_column => 'elig_pstl_cd_r_rng_prte_id',
219: p_base_key_value => p_base_key_value,
220: p_parent_table_name1 => 'ben_eligy_prfl_f',
221: p_parent_key_column1 => 'eligy_prfl_id',
250: -- Call the corresponding datetrack api
251: --
252: dt_api.find_dt_upd_modes
253: (p_effective_date => p_effective_date,
254: p_base_table_name => 'ben_elig_pstl_cd_r_rng_prte_f',
255: p_base_key_column => 'elig_pstl_cd_r_rng_prte_id',
256: p_base_key_value => p_base_key_value,
257: p_correction => p_correction,
258: p_update => p_update,
283: -- version number.
284: --
285: l_object_version_number :=
286: dt_api.get_object_version_number
287: (p_base_table_name => 'ben_elig_pstl_cd_r_rng_prte_f',
288: p_base_key_column => 'elig_pstl_cd_r_rng_prte_id',
289: p_base_key_value => p_base_key_value);
290: --
291: hr_utility.set_location(l_proc, 10);
293: --
294: -- Update the specified datetrack row setting the effective
295: -- end date to the specified new effective end date.
296: --
297: update ben_elig_pstl_cd_r_rng_prte_f t
298: set t.effective_end_date = p_new_effective_end_date,
299: t.object_version_number = l_object_version_number
300: where t.elig_pstl_cd_r_rng_prte_id = p_base_key_value
301: and p_effective_date
374: epz_attribute30,
375: object_version_number ,
376: criteria_score,
377: criteria_weight
378: from ben_elig_pstl_cd_r_rng_prte_f
379: where elig_pstl_cd_r_rng_prte_id = p_elig_pstl_cd_r_rng_prte_id
380: and p_effective_date
381: between effective_start_date and effective_end_date
382: for update nowait;
433: --
434: dt_api.validate_dt_mode
435: (p_effective_date => p_effective_date,
436: p_datetrack_mode => p_datetrack_mode,
437: p_base_table_name => 'ben_elig_pstl_cd_r_rng_prte_f',
438: p_base_key_column => 'elig_pstl_cd_r_rng_prte_id',
439: p_base_key_value => p_elig_pstl_cd_r_rng_prte_id,
440: p_parent_table_name1 => 'ben_eligy_prfl_f',
441: p_parent_key_column1 => 'eligy_prfl_id',
473: -- The object is locked therefore we need to supply a meaningful
474: -- error message.
475: --
476: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
477: fnd_message.set_token('TABLE_NAME', 'ben_elig_pstl_cd_r_rng_prte_f');
478: fnd_message.raise_error;
479: When l_object_invalid then
480: --
481: -- The object doesn't exist or is invalid
480: --
481: -- The object doesn't exist or is invalid
482: --
483: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
484: fnd_message.set_token('TABLE_NAME', 'ben_elig_pstl_cd_r_rng_prte_f');
485: fnd_message.raise_error;
486: End lck;
487: --
488: -- ----------------------------------------------------------------------------