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.HR_ITP_SHD dependencies on HR_ITEM_PROPERTIES_B

Line 21: If (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK1') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 26: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK11') Then

22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK11') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 31: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK12') Then

27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK12') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;

Line 36: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK13') Then

32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK13') 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','20');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK14') 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','20');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK14') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','25');
45: fnd_message.raise_error;

Line 46: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK15') Then

42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','25');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK15') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','30');
50: fnd_message.raise_error;

Line 51: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK16') Then

47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','30');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK16') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','35');
55: fnd_message.raise_error;

Line 56: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK17') Then

52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','35');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK17') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','40');
60: fnd_message.raise_error;

Line 61: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK2') Then

57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','40');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK2') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','45');
65: fnd_message.raise_error;

Line 66: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK3') Then

62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','45');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK3') Then
67: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('STEP','50');
70: fnd_message.raise_error;

Line 71: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK5') Then

67: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('STEP','50');
70: fnd_message.raise_error;
71: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK5') Then
72: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
73: fnd_message.set_token('PROCEDURE', l_proc);
74: fnd_message.set_token('STEP','55');
75: fnd_message.raise_error;

Line 76: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK6') Then

72: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
73: fnd_message.set_token('PROCEDURE', l_proc);
74: fnd_message.set_token('STEP','55');
75: fnd_message.raise_error;
76: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK6') Then
77: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('STEP','60');
80: fnd_message.raise_error;

Line 81: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK7') Then

77: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('STEP','60');
80: fnd_message.raise_error;
81: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK7') Then
82: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
83: fnd_message.set_token('PROCEDURE', l_proc);
84: fnd_message.set_token('STEP','65');
85: fnd_message.raise_error;

Line 86: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK8') Then

82: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
83: fnd_message.set_token('PROCEDURE', l_proc);
84: fnd_message.set_token('STEP','65');
85: fnd_message.raise_error;
86: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK8') Then
87: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
88: fnd_message.set_token('PROCEDURE', l_proc);
89: fnd_message.set_token('STEP','70');
90: fnd_message.raise_error;

Line 91: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK9') Then

87: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
88: fnd_message.set_token('PROCEDURE', l_proc);
89: fnd_message.set_token('STEP','70');
90: fnd_message.raise_error;
91: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_FK9') Then
92: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
93: fnd_message.set_token('PROCEDURE', l_proc);
94: fnd_message.set_token('STEP','75');
95: fnd_message.raise_error;

Line 96: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_PK') Then

92: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
93: fnd_message.set_token('PROCEDURE', l_proc);
94: fnd_message.set_token('STEP','75');
95: fnd_message.raise_error;
96: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_PK') Then
97: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
98: fnd_message.set_token('PROCEDURE', l_proc);
99: fnd_message.set_token('STEP','80');
100: fnd_message.raise_error;

Line 101: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_UK') Then

97: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
98: fnd_message.set_token('PROCEDURE', l_proc);
99: fnd_message.set_token('STEP','80');
100: fnd_message.raise_error;
101: ElsIf (p_constraint_name = 'HR_ITEM_PROPERTIES_B_UK') Then
102: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
103: fnd_message.set_token('PROCEDURE', l_proc);
104: fnd_message.set_token('STEP','85');
105: fnd_message.raise_error;

Line 199: from hr_item_properties_b

195: ,information29
196: ,information30
197: ,next_navigation_item_id
198: ,previous_navigation_item_id
199: from hr_item_properties_b
200: where item_property_id = p_item_property_id;
201: --
202: l_fct_ret boolean;
203: --

Line 335: from hr_item_properties_b

331: ,information29
332: ,information30
333: ,next_navigation_item_id
334: ,previous_navigation_item_id
335: from hr_item_properties_b
336: where item_property_id = p_item_property_id
337: for update nowait;
338: --
339: l_proc varchar2(72) := g_package||'lck';

Line 384: fnd_message.set_token('TABLE_NAME', 'hr_item_properties_b');

380: -- The object is locked therefore we need to supply a meaningful
381: -- error message.
382: --
383: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
384: fnd_message.set_token('TABLE_NAME', 'hr_item_properties_b');
385: fnd_message.raise_error;
386: End lck;
387: --
388: -- ----------------------------------------------------------------------------