APPS.PER_RSL_SHD dependencies on PER_RATING_SCALES

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_RATING_SCALES_TL_PK') 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 53: from per_rating_scales_tl

49: ,language
50: ,source_lang
51: ,name
52: ,description
53: from per_rating_scales_tl
54: where
55: rating_scale_id = p_rating_scale_id
56: AND language = p_language;
57: --

Line 121: from per_rating_scales_tl

117: ,language
118: ,source_lang
119: ,name
120: ,description
121: from per_rating_scales_tl
122: where
123: rating_scale_id = p_rating_scale_id
124: AND language = p_language
125: for update nowait;

Line 168: fnd_message.set_token('TABLE_NAME', 'per_rating_scales_tl');

164: -- The object is locked therefore we need to supply a meaningful
165: -- error message.
166: --
167: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
168: fnd_message.set_token('TABLE_NAME', 'per_rating_scales_tl');
169: fnd_message.raise_error;
170: End lck;
171: --
172: -- ----------------------------------------------------------------------------

Line 188: delete from PER_RATING_SCALES_TL T

184: -- Description Amended to add MLS functionality
185: -- ----------------------------------------------------------------------------
186: PROCEDURE add_language IS
187: begin
188: delete from PER_RATING_SCALES_TL T
189: where not exists
190: (select NULL
191: from PER_RATING_SCALES B
192: where B.RATING_SCALE_ID = T.RATING_SCALE_ID

Line 191: from PER_RATING_SCALES B

187: begin
188: delete from PER_RATING_SCALES_TL T
189: where not exists
190: (select NULL
191: from PER_RATING_SCALES B
192: where B.RATING_SCALE_ID = T.RATING_SCALE_ID
193: );
194:
195: update PER_RATING_SCALES_TL T set (

Line 195: update PER_RATING_SCALES_TL T set (

191: from PER_RATING_SCALES B
192: where B.RATING_SCALE_ID = T.RATING_SCALE_ID
193: );
194:
195: update PER_RATING_SCALES_TL T set (
196: NAME,
197: DESCRIPTION
198: ) = (select
199: B.NAME,

Line 201: from PER_RATING_SCALES_TL B

197: DESCRIPTION
198: ) = (select
199: B.NAME,
200: B.DESCRIPTION
201: from PER_RATING_SCALES_TL B
202: where B.RATING_SCALE_ID = T.RATING_SCALE_ID
203: and B.LANGUAGE = T.SOURCE_LANG)
204: where (
205: T.RATING_SCALE_ID,

Line 210: from PER_RATING_SCALES_TL SUBB, PER_RATING_SCALES_TL SUBT

206: T.LANGUAGE
207: ) in (select
208: SUBT.RATING_SCALE_ID,
209: SUBT.LANGUAGE
210: from PER_RATING_SCALES_TL SUBB, PER_RATING_SCALES_TL SUBT
211: where SUBB.RATING_SCALE_ID = SUBT.RATING_SCALE_ID
212: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
213: and (SUBB.NAME <> SUBT.NAME
214: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 221: insert into PER_RATING_SCALES_TL (

217: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
218: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
219: ));
220:
221: insert into PER_RATING_SCALES_TL (
222: RATING_SCALE_ID,
223: NAME,
224: DESCRIPTION,
225: CREATED_BY,

Line 243: from PER_RATING_SCALES_TL B, FND_LANGUAGES L

239: B.LAST_UPDATE_DATE,
240: B.LAST_UPDATE_LOGIN,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from PER_RATING_SCALES_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from PER_RATING_SCALES_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from PER_RATING_SCALES_TL T
249: where T.RATING_SCALE_ID = B.RATING_SCALE_ID
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;
252: --