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_PEL_SHD dependencies on PAY_ELEMENT_LINKS_F

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

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') 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_LINKS_F_FK11') 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_LINKS_F_FK11') 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_LINKS_F_FK12') 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_LINKS_F_FK12') 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 48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') 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;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;

Line 53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then

49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;

Line 58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then

54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;

Line 63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then

59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;

Line 68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then

64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;

Line 73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then

69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;

Line 78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then

74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;

Line 83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then

79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE', l_proc);
86: fnd_message.set_token('STEP','55');
87: fnd_message.raise_error;

Line 184: from pay_element_links_f

180: ,attribute18
181: ,attribute19
182: ,attribute20
183: ,object_version_number
184: from pay_element_links_f
185: where element_link_id = p_element_link_id
186: and p_effective_date
187: between effective_start_date and effective_end_date;
188: --

Line 260: ,p_base_table_name => 'pay_element_links_f'

256: -- Call the corresponding datetrack api
257: --
258: dt_api.find_dt_upd_modes
259: (p_effective_date => p_effective_date
260: ,p_base_table_name => 'pay_element_links_f'
261: ,p_base_key_column => 'element_link_id'
262: ,p_base_key_value => p_base_key_value
263: ,p_correction => p_correction
264: ,p_update => p_update

Line 286: l_parent_key_value1 pay_element_links_f.PAYROLL_ID%TYPE;

282: ) is
283: --
284: l_proc varchar2(72) := g_package||'find_dt_del_modes';
285: --
286: l_parent_key_value1 pay_element_links_f.PAYROLL_ID%TYPE;
287: l_parent_key_value2 pay_element_links_f.ELEMENT_TYPE_ID%TYPE;
288: --
289: Cursor C_Sel1 Is
290: select

Line 287: l_parent_key_value2 pay_element_links_f.ELEMENT_TYPE_ID%TYPE;

283: --
284: l_proc varchar2(72) := g_package||'find_dt_del_modes';
285: --
286: l_parent_key_value1 pay_element_links_f.PAYROLL_ID%TYPE;
287: l_parent_key_value2 pay_element_links_f.ELEMENT_TYPE_ID%TYPE;
288: --
289: Cursor C_Sel1 Is
290: select
291: t.payroll_id

Line 293: from pay_element_links_f t

289: Cursor C_Sel1 Is
290: select
291: t.payroll_id
292: ,t.element_type_id
293: from pay_element_links_f t
294: where t.element_link_id = p_base_key_value
295: and p_effective_date
296: between t.effective_start_date and t.effective_end_date;
297: --

Line 317: ,p_base_table_name => 'pay_element_links_f'

313: -- Call the corresponding datetrack api
314: --
315: dt_api.find_dt_del_modes
316: (p_effective_date => p_effective_date
317: ,p_base_table_name => 'pay_element_links_f'
318: ,p_base_key_column => 'element_link_id'
319: ,p_base_key_value => p_base_key_value
320: ,p_parent_table_name1 => 'pay_all_payrolls_f'
321: ,p_parent_key_column1 => 'payroll_id'

Line 348: l_object_version_number pay_element_links_f.OBJECT_VERSION_NUMBER%TYPE;

344: ,p_object_version_number out nocopy number
345: ) is
346: --
347: l_proc varchar2(72) := g_package||'upd_effective_end_date';
348: l_object_version_number pay_element_links_f.OBJECT_VERSION_NUMBER%TYPE;
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --

Line 358: (p_base_table_name => 'pay_element_links_f'

354: -- version number.
355: --
356: l_object_version_number :=
357: dt_api.get_object_version_number
358: (p_base_table_name => 'pay_element_links_f'
359: ,p_base_key_column => 'element_link_id'
360: ,p_base_key_value => p_base_key_value
361: );
362: --

Line 369: update pay_element_links_f t

365: --
366: -- Update the specified datetrack row setting the effective
367: -- end date to the specified new effective end date.
368: --
369: update pay_element_links_f t
370: set t.effective_end_date = p_new_effective_end_date
371: , t.object_version_number = l_object_version_number
372: where t.element_link_id = p_base_key_value
373: and p_effective_date

Line 459: from pay_element_links_f

455: ,attribute18
456: ,attribute19
457: ,attribute20
458: ,object_version_number
459: from pay_element_links_f
460: where element_link_id = p_element_link_id
461: and p_effective_date
462: between effective_start_date and effective_end_date
463: for update nowait;

Line 548: ,p_base_table_name => 'pay_element_links_f'

544: --
545: dt_api.validate_dt_mode
546: (p_effective_date => p_effective_date
547: ,p_datetrack_mode => p_datetrack_mode
548: ,p_base_table_name => 'pay_element_links_f'
549: ,p_base_key_column => 'element_link_id'
550: ,p_base_key_value => p_element_link_id
551: ,p_parent_table_name1 => 'pay_all_payrolls_f'
552: ,p_parent_key_column1 => 'payroll_id'

Line 595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');

591: -- The object is locked therefore we need to supply a meaningful
592: -- error message.
593: --
594: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');
596: fnd_message.raise_error;
597: End lck;
598: --
599: -- ----------------------------------------------------------------------------