APPS.BEN_SVA_SHD dependencies on BEN_SVC_AREA_F

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

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

99: sva_attribute28,
100: sva_attribute29,
101: sva_attribute30,
102: object_version_number
103: from ben_svc_area_f
104: where svc_area_id = p_svc_area_id
105: and p_effective_date
106: between effective_start_date and effective_end_date;
107: --

Line 179: p_base_table_name => 'ben_svc_area_f',

175: -- Call the corresponding datetrack api
176: --
177: dt_api.find_dt_del_modes
178: (p_effective_date => p_effective_date,
179: p_base_table_name => 'ben_svc_area_f',
180: p_base_key_column => 'svc_area_id',
181: p_base_key_value => p_base_key_value,
182: p_zap => p_zap,
183: p_delete => p_delete,

Line 210: p_base_table_name => 'ben_svc_area_f',

206: -- Call the corresponding datetrack api
207: --
208: dt_api.find_dt_upd_modes
209: (p_effective_date => p_effective_date,
210: p_base_table_name => 'ben_svc_area_f',
211: p_base_key_column => 'svc_area_id',
212: p_base_key_value => p_base_key_value,
213: p_correction => p_correction,
214: p_update => p_update,

Line 243: (p_base_table_name => 'ben_svc_area_f',

239: -- version number.
240: --
241: l_object_version_number :=
242: dt_api.get_object_version_number
243: (p_base_table_name => 'ben_svc_area_f',
244: p_base_key_column => 'svc_area_id',
245: p_base_key_value => p_base_key_value);
246: --
247: hr_utility.set_location(l_proc, 10);

Line 253: update ben_svc_area_f t

249: --
250: -- Update the specified datetrack row setting the effective
251: -- end date to the specified new effective end date.
252: --
253: update ben_svc_area_f t
254: set t.effective_end_date = p_new_effective_end_date,
255: t.object_version_number = l_object_version_number
256: where t.svc_area_id = p_base_key_value
257: and p_effective_date

Line 330: from ben_svc_area_f

326: sva_attribute28,
327: sva_attribute29,
328: sva_attribute30,
329: object_version_number
330: from ben_svc_area_f
331: where svc_area_id = p_svc_area_id
332: and p_effective_date
333: between effective_start_date and effective_end_date
334: for update nowait;

Line 389: p_base_table_name => 'ben_svc_area_f',

385: --
386: dt_api.validate_dt_mode
387: (p_effective_date => p_effective_date,
388: p_datetrack_mode => p_datetrack_mode,
389: p_base_table_name => 'ben_svc_area_f',
390: p_base_key_column => 'svc_area_id',
391: p_base_key_value => p_svc_area_id,
392: p_child_table_name1 => 'ben_elig_svc_area_prte_f',
393: p_child_key_column1 => 'elig_svc_area_prte_id',

Line 429: fnd_message.set_token('TABLE_NAME', 'ben_svc_area_f');

425: -- The object is locked therefore we need to supply a meaningful
426: -- error message.
427: --
428: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
429: fnd_message.set_token('TABLE_NAME', 'ben_svc_area_f');
430: fnd_message.raise_error;
431: When l_object_invalid then
432: --
433: -- The object doesn't exist or is invalid

Line 436: fnd_message.set_token('TABLE_NAME', 'ben_svc_area_f');

432: --
433: -- The object doesn't exist or is invalid
434: --
435: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
436: fnd_message.set_token('TABLE_NAME', 'ben_svc_area_f');
437: fnd_message.raise_error;
438: End lck;
439: --
440: -- ----------------------------------------------------------------------------