eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ELE_SHD dependencies on PAY_ELEMENT_ENTRIES_F

Line 33: If (p_constraint_name = 'PAY_ELEMENT_ENTRIES_F_FK1') Then

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'PAY_ELEMENT_ENTRIES_F_FK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;

Line 38: ElsIf (p_constraint_name = 'PAY_ELEMENT_ENTRIES_F_FK3') Then

34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_ENTRIES_F_FK3') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;

Line 43: ElsIf (p_constraint_name = 'PAY_ELEMENT_ENTRIES_F_PK') Then

39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_ENTRIES_F_PK') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;

Line 158: from pay_element_entries_f

154: ,source_id
155: ,balance_adj_cost_flag
156: ,element_type_id
157: ,all_entry_values_null
158: from pay_element_entries_f
159: where element_entry_id = p_element_entry_id
160: and p_effective_date
161: between effective_start_date and effective_end_date;
162: --

Line 236: pay_element_entries_f pee,

232: --
233: Cursor C_chk_type Is
234: select pet.processing_type
235: from pay_element_types_f pet,
236: pay_element_entries_f pee,
237: pay_element_links_f pel
238: where pet.element_type_id = pel.element_type_id
239: and pel.element_link_id = pee.element_link_id
240: and pee.element_entry_id = p_base_key_value

Line 255: ,p_base_table_name => 'pay_element_entries_f'

251: -- Call the corresponding datetrack api
252: --
253: dt_api.find_dt_upd_modes
254: (p_effective_date => p_effective_date
255: ,p_base_table_name => 'pay_element_entries_f'
256: ,p_base_key_column => 'element_entry_id'
257: ,p_base_key_value => p_base_key_value
258: ,p_correction => p_correction
259: ,p_update => p_update

Line 311: from pay_element_entries_f t

307: Cursor C_Sel1 Is
308: select
309: t.assignment_id
310: ,t.element_link_id
311: from pay_element_entries_f t
312: where t.element_entry_id = p_base_key_value
313: and p_effective_date
314: between t.effective_start_date and t.effective_end_date;
315: --

Line 319: pay_element_entries_f pee,

315: --
316: Cursor C_chk_type Is
317: select pet.processing_type
318: from pay_element_types_f pet,
319: pay_element_entries_f pee,
320: pay_element_links_f pel
321: where pet.element_type_id = pel.element_type_id
322: and pel.element_link_id = pee.element_link_id
323: and pee.element_entry_id = p_base_key_value

Line 350: ,p_base_table_name => 'pay_element_entries_f'

346: -- Call the corresponding datetrack api
347: --
348: dt_api.find_dt_del_modes
349: (p_effective_date => p_effective_date
350: ,p_base_table_name => 'pay_element_entries_f'
351: ,p_base_key_column => 'element_entry_id'
352: ,p_base_key_value => p_base_key_value
353: ,p_parent_table_name1 => 'per_all_assignments_f'
354: ,p_parent_key_column1 => 'assignment_id'

Line 414: (p_base_table_name => 'pay_element_entries_f'

410: -- version number.
411: --
412: l_object_version_number :=
413: dt_api.get_object_version_number
414: (p_base_table_name => 'pay_element_entries_f'
415: ,p_base_key_column => 'element_entry_id'
416: ,p_base_key_value => p_base_key_value
417: );
418: --

Line 425: update pay_element_entries_f t

421: --
422: -- Update the specified datetrack row setting the effective
423: -- end date to the specified new effective end date.
424: --
425: update pay_element_entries_f t
426: set t.effective_end_date = p_new_effective_end_date
427: , t.object_version_number = l_object_version_number
428: where t.element_entry_id = p_base_key_value
429: and p_effective_date

Line 547: from pay_element_entries_f

543: ,source_id
544: ,balance_adj_cost_flag
545: ,element_type_id
546: ,all_entry_values_null
547: from pay_element_entries_f
548: where element_entry_id = p_element_entry_id
549: and p_effective_date
550: between effective_start_date and effective_end_date
551: for update nowait;

Line 668: ,p_base_table_name => 'pay_element_entries_f'

664: --
665: dt_api.validate_dt_mode
666: (p_effective_date => p_effective_date
667: ,p_datetrack_mode => p_datetrack_mode
668: ,p_base_table_name => 'pay_element_entries_f'
669: ,p_base_key_column => 'element_entry_id'
670: ,p_base_key_value => p_element_entry_id
671: ,p_parent_table_name1 => 'per_all_assignments_f'
672: ,p_parent_key_column1 => 'assignment_id'

Line 709: fnd_message.set_token('TABLE_NAME', 'pay_element_entries_f');

705: -- The object is locked therefore we need to supply a meaningful
706: -- error message.
707: --
708: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
709: fnd_message.set_token('TABLE_NAME', 'pay_element_entries_f');
710: fnd_message.raise_error;
711: End lck;
712: --
713: -- ----------------------------------------------------------------------------