APPS.BEN_PEI_SHD dependencies on BEN_PL_EXTRACT_IDENTIFIER_F

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

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

83: ,last_updated_by
84: ,last_update_login
85: ,object_version_number
86: ,business_group_id
87: from ben_pl_extract_identifier_f
88: where pl_extract_identifier_id = p_pl_extract_identifier_id
89: and p_effective_date
90: between effective_start_date and effective_end_date;
91: --

Line 166: p_base_table_name => 'ben_pl_extract_identifier_f',

162: -- Call the corresponding datetrack api
163: --
164: dt_api.find_dt_del_modes
165: (p_effective_date => p_effective_date,
166: p_base_table_name => 'ben_pl_extract_identifier_f',
167: p_base_key_column => 'pl_extract_identifier_id',
168: p_base_key_value => p_base_key_value,
169: p_zap => p_zap,
170: p_delete => p_delete,

Line 198: p_base_table_name => 'ben_pl_extract_identifier_f',

194: -- Call the corresponding datetrack api
195: --
196: dt_api.find_dt_upd_modes
197: (p_effective_date => p_effective_date,
198: p_base_table_name => 'ben_pl_extract_identifier_f',
199: p_base_key_column => 'pl_extract_identifier_id',
200: p_base_key_value => p_base_key_value,
201: p_correction => p_correction,
202: p_update => p_update,

Line 232: (p_base_table_name => 'ben_pl_extract_identifier_f',

228: -- version number.
229: --
230: l_object_version_number :=
231: dt_api.get_object_version_number
232: (p_base_table_name => 'ben_pl_extract_identifier_f',
233: p_base_key_column => 'pl_extract_identifier_id',
234: p_base_key_value => p_base_key_value);
235: --
236: hr_utility.set_location(l_proc, 10);

Line 242: update ben_pl_extract_identifier_f t

238: --
239: -- Update the specified datetrack row setting the effective
240: -- end date to the specified new effective end date.
241: --
242: update ben_pl_extract_identifier_f t
243: set t.effective_end_date = p_new_effective_end_date,
244: t.object_version_number = l_object_version_number
245: where t.pl_extract_identifier_id = p_base_key_value
246: and p_effective_date between t.effective_start_date and t.effective_end_date;

Line 307: from ben_pl_extract_identifier_f

303: ,last_updated_by
304: ,last_update_login
305: ,object_version_number
306: ,business_group_id
307: from ben_pl_extract_identifier_f
308: where pl_extract_identifier_id = p_pl_extract_identifier_id
309: and p_effective_date between effective_start_date and effective_end_date
310: for update nowait;
311: --

Line 364: p_base_table_name => 'ben_pl_extract_identifier_f',

360: --
361: dt_api.validate_dt_mode
362: (p_effective_date => p_effective_date,
363: p_datetrack_mode => p_datetrack_mode,
364: p_base_table_name => 'ben_pl_extract_identifier_f',
365: p_base_key_column => 'pl_extract_identifier_id',
366: p_base_key_value => p_pl_extract_identifier_id,
367: p_enforce_foreign_locking => true,
368: p_validation_start_date => l_validation_start_date,

Line 400: fnd_message.set_token('TABLE_NAME', 'ben_pl_extract_identifier_f');

396: -- The object is locked therefore we need to supply a meaningful
397: -- error message.
398: --
399: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
400: fnd_message.set_token('TABLE_NAME', 'ben_pl_extract_identifier_f');
401: fnd_message.raise_error;
402: When l_object_invalid then
403: --
404: -- The object doesn't exist or is invalid

Line 407: fnd_message.set_token('TABLE_NAME', 'ben_pl_extract_identifier_f');

403: --
404: -- The object doesn't exist or is invalid
405: --
406: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
407: fnd_message.set_token('TABLE_NAME', 'ben_pl_extract_identifier_f');
408: fnd_message.raise_error;
409: End lck;
410: -- ----------------------------------------------------------------------------
411: -- |-----------------------------< convert_args >-----------------------------|