APPS.PER_QTT_SHD dependencies on PER_QUALIFICATION_TYPES

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

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

48: qualification_type_id
49: ,language
50: ,source_lang
51: ,name
52: from per_qualification_types_tl
53: where qualification_type_id = p_qualification_type_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from per_qualification_types_tl

114: qualification_type_id
115: ,language
116: ,source_lang
117: ,name
118: from per_qualification_types_tl
119: where qualification_type_id = p_qualification_type_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'per_qualification_types_tl');

160: -- The object is locked therefore we need to supply a meaningful
161: -- error message.
162: --
163: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
164: fnd_message.set_token('TABLE_NAME', 'per_qualification_types_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 175: delete from PER_QUALIFICATION_TYPES_TL T

171: --
172: PROCEDURE add_language IS
173: Begin
174: --
175: delete from PER_QUALIFICATION_TYPES_TL T
176: where not exists
177: (select NULL
178: from PER_QUALIFICATION_TYPES B
179: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID

Line 178: from PER_QUALIFICATION_TYPES B

174: --
175: delete from PER_QUALIFICATION_TYPES_TL T
176: where not exists
177: (select NULL
178: from PER_QUALIFICATION_TYPES B
179: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
180: );
181:
182: update PER_QUALIFICATION_TYPES_TL T set (

Line 182: update PER_QUALIFICATION_TYPES_TL T set (

178: from PER_QUALIFICATION_TYPES B
179: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
180: );
181:
182: update PER_QUALIFICATION_TYPES_TL T set (
183: NAME
184: ) = (select
185: B.NAME
186: from PER_QUALIFICATION_TYPES_TL B

Line 186: from PER_QUALIFICATION_TYPES_TL B

182: update PER_QUALIFICATION_TYPES_TL T set (
183: NAME
184: ) = (select
185: B.NAME
186: from PER_QUALIFICATION_TYPES_TL B
187: where B.QUALIFICATION_TYPE_ID = T.QUALIFICATION_TYPE_ID
188: and B.LANGUAGE = T.SOURCE_LANG)
189: where (
190: T.QUALIFICATION_TYPE_ID,

Line 195: from PER_QUALIFICATION_TYPES_TL SUBB, PER_QUALIFICATION_TYPES_TL SUBT

191: T.LANGUAGE
192: ) in (select
193: SUBT.QUALIFICATION_TYPE_ID,
194: SUBT.LANGUAGE
195: from PER_QUALIFICATION_TYPES_TL SUBB, PER_QUALIFICATION_TYPES_TL SUBT
196: where SUBB.QUALIFICATION_TYPE_ID = SUBT.QUALIFICATION_TYPE_ID
197: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
198: and (SUBB.NAME <> SUBT.NAME
199: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 203: insert into PER_QUALIFICATION_TYPES_TL (

199: or (SUBB.NAME is null and SUBT.NAME is not null)
200: or (SUBB.NAME is not null and SUBT.NAME is null)
201: ));
202:
203: insert into PER_QUALIFICATION_TYPES_TL (
204: LAST_UPDATE_LOGIN,
205: CREATED_BY,
206: CREATION_DATE,
207: LAST_UPDATED_BY,

Line 223: from PER_QUALIFICATION_TYPES_TL B, FND_LANGUAGES L

219: B.NAME,
220: B.QUALIFICATION_TYPE_ID,
221: L.LANGUAGE_CODE,
222: B.SOURCE_LANG
223: from PER_QUALIFICATION_TYPES_TL B, FND_LANGUAGES L
224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL

Line 228: from PER_QUALIFICATION_TYPES_TL T

224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL
228: from PER_QUALIFICATION_TYPES_TL T
229: where T.QUALIFICATION_TYPE_ID = B.QUALIFICATION_TYPE_ID
230: and T.LANGUAGE = L.LANGUAGE_CODE);
231: --
232: End add_language;