APPS.BEN_PRG_SHD dependencies on BEN_PL_REGN_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PL_REGN_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 41: ElsIf (p_constraint_name = 'BEN_PL_REGN_FK2') 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;
41: ElsIf (p_constraint_name = 'BEN_PL_REGN_FK2') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 120: from ben_pl_regn_f

116: prg_attribute28,
117: prg_attribute29,
118: prg_attribute30,
119: object_version_number
120: from ben_pl_regn_f
121: where pl_regn_id = p_pl_regn_id
122: and p_effective_date
123: between effective_start_date and effective_end_date;
124: --

Line 205: from ben_pl_regn_f t

201: t.cvg_nndscrn_rl,
202: t.five_pct_ownr_rl,
203: t.regn_id,
204: t.pl_id
205: from ben_pl_regn_f t
206: where t.pl_regn_id = p_base_key_value
207: and p_effective_date
208: between t.effective_start_date and t.effective_end_date;
209: --

Line 233: p_base_table_name => 'ben_pl_regn_f',

229: -- Call the corresponding datetrack api
230: --
231: dt_api.find_dt_del_modes
232: (p_effective_date => p_effective_date,
233: p_base_table_name => 'ben_pl_regn_f',
234: p_base_key_column => 'pl_regn_id',
235: p_base_key_value => p_base_key_value,
236: p_parent_table_name1 => 'ff_formulas_f',
237: p_parent_key_column1 => 'formula_id',

Line 285: p_base_table_name => 'ben_pl_regn_f',

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

Line 318: (p_base_table_name => 'ben_pl_regn_f',

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

Line 328: update ben_pl_regn_f t

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

Line 412: from ben_pl_regn_f

408: prg_attribute28,
409: prg_attribute29,
410: prg_attribute30,
411: object_version_number
412: from ben_pl_regn_f
413: where pl_regn_id = p_pl_regn_id
414: and p_effective_date
415: between effective_start_date and effective_end_date
416: for update nowait;

Line 471: p_base_table_name => 'ben_pl_regn_f',

467: --
468: dt_api.validate_dt_mode
469: (p_effective_date => p_effective_date,
470: p_datetrack_mode => p_datetrack_mode,
471: p_base_table_name => 'ben_pl_regn_f',
472: p_base_key_column => 'pl_regn_id',
473: p_base_key_value => p_pl_regn_id,
474: p_parent_table_name1 => 'ff_formulas_f',
475: p_parent_key_column1 => 'formula_id',

Line 526: fnd_message.set_token('TABLE_NAME', 'ben_pl_regn_f');

522: -- The object is locked therefore we need to supply a meaningful
523: -- error message.
524: --
525: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
526: fnd_message.set_token('TABLE_NAME', 'ben_pl_regn_f');
527: fnd_message.raise_error;
528: When l_object_invalid then
529: --
530: -- The object doesn't exist or is invalid

Line 533: fnd_message.set_token('TABLE_NAME', 'ben_pl_regn_f');

529: --
530: -- The object doesn't exist or is invalid
531: --
532: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
533: fnd_message.set_token('TABLE_NAME', 'ben_pl_regn_f');
534: fnd_message.raise_error;
535: End lck;
536: --
537: -- ----------------------------------------------------------------------------