APPS.BEN_EPA_SHD dependencies on BEN_PRTN_ELIG_F

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

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

123: epa_attribute28,
124: epa_attribute29,
125: epa_attribute30,
126: object_version_number
127: from ben_prtn_elig_f
128: where prtn_elig_id = p_prtn_elig_id
129: and p_effective_date
130: between effective_start_date and effective_end_date;
131: --

Line 210: from ben_prtn_elig_f t

206: t.pl_id,
207: t.pgm_id,
208: t.ptip_id,
209: t.plip_id
210: from ben_prtn_elig_f t
211: where t.prtn_elig_id = p_base_key_value
212: and p_effective_date
213: between t.effective_start_date and t.effective_end_date;
214: --

Line 237: p_base_table_name => 'ben_prtn_elig_f',

233: -- Call the corresponding datetrack api
234: --
235: dt_api.find_dt_del_modes
236: (p_effective_date => p_effective_date,
237: p_base_table_name => 'ben_prtn_elig_f',
238: p_base_key_column => 'prtn_elig_id',
239: p_base_key_value => p_base_key_value,
240: p_parent_table_name1 => 'ff_formulas_f',
241: p_parent_key_column1 => 'formula_id',

Line 286: p_base_table_name => 'ben_prtn_elig_f',

282: -- Call the corresponding datetrack api
283: --
284: dt_api.find_dt_upd_modes
285: (p_effective_date => p_effective_date,
286: p_base_table_name => 'ben_prtn_elig_f',
287: p_base_key_column => 'prtn_elig_id',
288: p_base_key_value => p_base_key_value,
289: p_correction => p_correction,
290: p_update => p_update,

Line 319: (p_base_table_name => 'ben_prtn_elig_f',

315: -- version number.
316: --
317: l_object_version_number :=
318: dt_api.get_object_version_number
319: (p_base_table_name => 'ben_prtn_elig_f',
320: p_base_key_column => 'prtn_elig_id',
321: p_base_key_value => p_base_key_value);
322: --
323: hr_utility.set_location(l_proc, 10);

Line 329: update ben_prtn_elig_f t

325: --
326: -- Update the specified datetrack row setting the effective
327: -- end date to the specified new effective end date.
328: --
329: update ben_prtn_elig_f t
330: set t.effective_end_date = p_new_effective_end_date,
331: t.object_version_number = l_object_version_number
332: where t.prtn_elig_id = p_base_key_value
333: and p_effective_date

Line 425: from ben_prtn_elig_f

421: epa_attribute28,
422: epa_attribute29,
423: epa_attribute30,
424: object_version_number
425: from ben_prtn_elig_f
426: where prtn_elig_id = p_prtn_elig_id
427: and p_effective_date
428: between effective_start_date and effective_end_date
429: for update nowait;

Line 484: p_base_table_name => 'ben_prtn_elig_f',

480: --
481: dt_api.validate_dt_mode
482: (p_effective_date => p_effective_date,
483: p_datetrack_mode => p_datetrack_mode,
484: p_base_table_name => 'ben_prtn_elig_f',
485: p_base_key_column => 'prtn_elig_id',
486: p_base_key_value => p_prtn_elig_id,
487: p_parent_table_name1 => 'ff_formulas_f',
488: p_parent_key_column1 => 'formula_id',

Line 540: hr_utility.set_message_token('TABLE_NAME', 'ben_prtn_elig_f');

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

Line 547: hr_utility.set_message_token('TABLE_NAME', 'ben_prtn_elig_f');

543: --
544: -- The object doesn't exist or is invalid
545: --
546: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
547: hr_utility.set_message_token('TABLE_NAME', 'ben_prtn_elig_f');
548: hr_utility.raise_error;
549: End lck;
550: --
551: -- ----------------------------------------------------------------------------