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.PER_RTX_SHD dependencies on PER_RATING_LEVELS

Line 22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;

Line 27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then

23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;

Line 32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then

28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;

Line 37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then

33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;

Line 42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then

38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;

Line 47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then

43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;

Line 85: from per_rating_levels_tl

81: ,language
82: ,source_lang
83: ,name
84: ,behavioural_indicator
85: from per_rating_levels_tl
86: where rating_level_id = p_rating_level_id
87: and language = p_language;
88: --
89: l_fct_ret boolean;

Line 152: from per_rating_levels_tl

148: ,language
149: ,source_lang
150: ,name
151: ,behavioural_indicator
152: from per_rating_levels_tl
153: where rating_level_id = p_rating_level_id
154: and language = p_language
155: for update nowait;
156: --

Line 198: fnd_message.set_token('TABLE_NAME', 'per_rating_levels_tl');

194: -- The object is locked therefore we need to supply a meaningful
195: -- error message.
196: --
197: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
198: fnd_message.set_token('TABLE_NAME', 'per_rating_levels_tl');
199: fnd_message.raise_error;
200: End lck;
201: --
202: -- ----------------------------------------------------------------------------

Line 209: delete from PER_RATING_LEVELS_TL T

205: -- MB added on 16-Dec-2002
206: procedure ADD_LANGUAGE
207: is
208: begin
209: delete from PER_RATING_LEVELS_TL T
210: where not exists
211: (select NULL
212: from PER_RATING_LEVELS B
213: where B.RATING_LEVEL_ID = T.RATING_LEVEL_ID

Line 212: from PER_RATING_LEVELS B

208: begin
209: delete from PER_RATING_LEVELS_TL T
210: where not exists
211: (select NULL
212: from PER_RATING_LEVELS B
213: where B.RATING_LEVEL_ID = T.RATING_LEVEL_ID
214: );
215:
216: update PER_RATING_LEVELS_TL T set (

Line 216: update PER_RATING_LEVELS_TL T set (

212: from PER_RATING_LEVELS B
213: where B.RATING_LEVEL_ID = T.RATING_LEVEL_ID
214: );
215:
216: update PER_RATING_LEVELS_TL T set (
217: NAME,
218: BEHAVIOURAL_INDICATOR
219: ) = (select
220: B.NAME,

Line 222: from PER_RATING_LEVELS_TL B

218: BEHAVIOURAL_INDICATOR
219: ) = (select
220: B.NAME,
221: B.BEHAVIOURAL_INDICATOR
222: from PER_RATING_LEVELS_TL B
223: where B.RATING_LEVEL_ID = T.RATING_LEVEL_ID
224: and B.LANGUAGE = T.SOURCE_LANG)
225: where (
226: T.RATING_LEVEL_ID,

Line 231: from PER_RATING_LEVELS_TL SUBB, PER_RATING_LEVELS_TL SUBT

227: T.LANGUAGE
228: ) in (select
229: SUBT.RATING_LEVEL_ID,
230: SUBT.LANGUAGE
231: from PER_RATING_LEVELS_TL SUBB, PER_RATING_LEVELS_TL SUBT
232: where SUBB.RATING_LEVEL_ID = SUBT.RATING_LEVEL_ID
233: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
234: and (SUBB.NAME <> SUBT.NAME
235: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 242: insert into PER_RATING_LEVELS_TL (

238: or (SUBB.BEHAVIOURAL_INDICATOR is null and SUBT.BEHAVIOURAL_INDICATOR is not null)
239: or (SUBB.BEHAVIOURAL_INDICATOR is not null and SUBT.BEHAVIOURAL_INDICATOR is null)
240: ));
241:
242: insert into PER_RATING_LEVELS_TL (
243: RATING_LEVEL_ID,
244: NAME,
245: BEHAVIOURAL_INDICATOR,
246: CREATED_BY,

Line 264: from PER_RATING_LEVELS_TL B, FND_LANGUAGES L

260: B.LAST_UPDATE_DATE,
261: B.LAST_UPDATE_LOGIN,
262: L.LANGUAGE_CODE,
263: B.SOURCE_LANG
264: from PER_RATING_LEVELS_TL B, FND_LANGUAGES L
265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL

Line 269: from PER_RATING_LEVELS_TL T

265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL
269: from PER_RATING_LEVELS_TL T
270: where T.RATING_LEVEL_ID = B.RATING_LEVEL_ID
271: and T.LANGUAGE = L.LANGUAGE_CODE);
272: end ADD_LANGUAGE;
273: --