APPS.BEN_CPT_SHD dependencies on BEN_CMBN_PTIP_OPT_F

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

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

101: object_version_number,
102: ptip_id,
103: pgm_id,
104: opt_id
105: from ben_cmbn_ptip_opt_f
106: where cmbn_ptip_opt_id = p_cmbn_ptip_opt_id
107: and p_effective_date
108: between effective_start_date and effective_end_date;
109: --

Line 185: p_base_table_name => 'ben_cmbn_ptip_opt_f',

181: -- Call the corresponding datetrack api
182: --
183: dt_api.find_dt_del_modes
184: (p_effective_date => p_effective_date,
185: p_base_table_name => 'ben_cmbn_ptip_opt_f',
186: p_base_key_column => 'cmbn_ptip_opt_id',
187: p_base_key_value => p_base_key_value,
188: p_zap => p_zap,
189: p_delete => p_delete,

Line 216: p_base_table_name => 'ben_cmbn_ptip_opt_f',

212: -- Call the corresponding datetrack api
213: --
214: dt_api.find_dt_upd_modes
215: (p_effective_date => p_effective_date,
216: p_base_table_name => 'ben_cmbn_ptip_opt_f',
217: p_base_key_column => 'cmbn_ptip_opt_id',
218: p_base_key_value => p_base_key_value,
219: p_correction => p_correction,
220: p_update => p_update,

Line 249: (p_base_table_name => 'ben_cmbn_ptip_opt_f',

245: -- version number.
246: --
247: l_object_version_number :=
248: dt_api.get_object_version_number
249: (p_base_table_name => 'ben_cmbn_ptip_opt_f',
250: p_base_key_column => 'cmbn_ptip_opt_id',
251: p_base_key_value => p_base_key_value);
252: --
253: hr_utility.set_location(l_proc, 10);

Line 259: update ben_cmbn_ptip_opt_f t

255: --
256: -- Update the specified datetrack row setting the effective
257: -- end date to the specified new effective end date.
258: --
259: update ben_cmbn_ptip_opt_f t
260: set t.effective_end_date = p_new_effective_end_date,
261: t.object_version_number = l_object_version_number
262: where t.cmbn_ptip_opt_id = p_base_key_value
263: and p_effective_date

Line 338: from ben_cmbn_ptip_opt_f

334: object_version_number,
335: ptip_id,
336: pgm_id,
337: opt_id
338: from ben_cmbn_ptip_opt_f
339: where cmbn_ptip_opt_id = p_cmbn_ptip_opt_id
340: and p_effective_date
341: between effective_start_date and effective_end_date
342: for update nowait;

Line 397: p_base_table_name => 'ben_cmbn_ptip_opt_f',

393: --
394: dt_api.validate_dt_mode
395: (p_effective_date => p_effective_date,
396: p_datetrack_mode => p_datetrack_mode,
397: p_base_table_name => 'ben_cmbn_ptip_opt_f',
398: p_base_key_column => 'cmbn_ptip_opt_id',
399: p_base_key_value => p_cmbn_ptip_opt_id,
400: /*
401: p_child_table_name1 => 'ben_ptip_f',

Line 445: hr_utility.set_message_token('TABLE_NAME', 'ben_cmbn_ptip_opt_f');

441: -- The object is locked therefore we need to supply a meaningful
442: -- error message.
443: --
444: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
445: hr_utility.set_message_token('TABLE_NAME', 'ben_cmbn_ptip_opt_f');
446: hr_utility.raise_error;
447: When l_object_invalid then
448: --
449: -- The object doesn't exist or is invalid

Line 452: hr_utility.set_message_token('TABLE_NAME', 'ben_cmbn_ptip_opt_f');

448: --
449: -- The object doesn't exist or is invalid
450: --
451: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
452: hr_utility.set_message_token('TABLE_NAME', 'ben_cmbn_ptip_opt_f');
453: hr_utility.raise_error;
454: End lck;
455: --
456: -- ----------------------------------------------------------------------------