APPS.BEN_DDR_SHD dependencies on BEN_DSGN_RQMT_F

Line 111: from ben_dsgn_rqmt_f

107: ddr_attribute28,
108: ddr_attribute29,
109: ddr_attribute30,
110: object_version_number
111: from ben_dsgn_rqmt_f
112: where dsgn_rqmt_id = p_dsgn_rqmt_id
113: and p_effective_date
114: between effective_start_date and effective_end_date;
115: --

Line 188: from ben_dsgn_rqmt_f t

184: Cursor C_Sel1 Is
185: select t.oipl_id,
186: t.opt_id,
187: t.pl_id
188: from ben_dsgn_rqmt_f t
189: where t.dsgn_rqmt_id = p_base_key_value
190: and p_effective_date
191: between t.effective_start_date and t.effective_end_date;
192: --

Line 212: p_base_table_name => 'ben_dsgn_rqmt_f',

208: -- Call the corresponding datetrack api
209: --
210: dt_api.find_dt_del_modes
211: (p_effective_date => p_effective_date,
212: p_base_table_name => 'ben_dsgn_rqmt_f',
213: p_base_key_column => 'dsgn_rqmt_id',
214: p_base_key_value => p_base_key_value,
215: p_parent_table_name1 => 'ben_oipl_f',
216: p_parent_key_column1 => 'oipl_id',

Line 252: p_base_table_name => 'ben_dsgn_rqmt_f',

248: -- Call the corresponding datetrack api
249: --
250: dt_api.find_dt_upd_modes
251: (p_effective_date => p_effective_date,
252: p_base_table_name => 'ben_dsgn_rqmt_f',
253: p_base_key_column => 'dsgn_rqmt_id',
254: p_base_key_value => p_base_key_value,
255: p_correction => p_correction,
256: p_update => p_update,

Line 285: (p_base_table_name => 'ben_dsgn_rqmt_f',

281: -- version number.
282: --
283: l_object_version_number :=
284: dt_api.get_object_version_number
285: (p_base_table_name => 'ben_dsgn_rqmt_f',
286: p_base_key_column => 'dsgn_rqmt_id',
287: p_base_key_value => p_base_key_value);
288: --
289: hr_utility.set_location(l_proc, 10);

Line 295: update ben_dsgn_rqmt_f t

291: --
292: -- Update the specified datetrack row setting the effective
293: -- end date to the specified new effective end date.
294: --
295: update ben_dsgn_rqmt_f t
296: set t.effective_end_date = p_new_effective_end_date,
297: t.object_version_number = l_object_version_number
298: where t.dsgn_rqmt_id = p_base_key_value
299: and p_effective_date

Line 380: from ben_dsgn_rqmt_f

376: ddr_attribute28,
377: ddr_attribute29,
378: ddr_attribute30,
379: object_version_number
380: from ben_dsgn_rqmt_f
381: where dsgn_rqmt_id = p_dsgn_rqmt_id
382: and p_effective_date
383: between effective_start_date and effective_end_date
384: for update nowait;

Line 439: p_base_table_name => 'ben_dsgn_rqmt_f',

435: --
436: dt_api.validate_dt_mode
437: (p_effective_date => p_effective_date,
438: p_datetrack_mode => p_datetrack_mode,
439: p_base_table_name => 'ben_dsgn_rqmt_f',
440: p_base_key_column => 'dsgn_rqmt_id',
441: p_base_key_value => p_dsgn_rqmt_id,
442: p_parent_table_name1 => 'ben_oipl_f',
443: p_parent_key_column1 => 'oipl_id',

Line 482: hr_utility.set_message_token('TABLE_NAME', 'ben_dsgn_rqmt_f');

478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
482: hr_utility.set_message_token('TABLE_NAME', 'ben_dsgn_rqmt_f');
483: hr_utility.raise_error;
484: When l_object_invalid then
485: --
486: -- The object doesn't exist or is invalid

Line 489: hr_utility.set_message_token('TABLE_NAME', 'ben_dsgn_rqmt_f');

485: --
486: -- The object doesn't exist or is invalid
487: --
488: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
489: hr_utility.set_message_token('TABLE_NAME', 'ben_dsgn_rqmt_f');
490: hr_utility.raise_error;
491: End lck;
492: --
493: -- ----------------------------------------------------------------------------