APPS.PER_RTX_SHD dependencies on PER_RATING_LEVELS_TL

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 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: --