APPS.PER_QAT_SHD dependencies on PER_QUALIFICATIONS

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

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

55: ,grade_attained
56: ,reimbursement_arrangements
57: ,training_completed_units
58: ,membership_category
59: from per_qualifications_tl
60: where qualification_id = p_qualification_id
61: and language = p_language;
62: --
63: l_fct_ret boolean;

Line 132: from per_qualifications_tl

128: ,grade_attained
129: ,reimbursement_arrangements
130: ,training_completed_units
131: ,membership_category
132: from per_qualifications_tl
133: where qualification_id = p_qualification_id
134: and language = p_language
135: for update nowait;
136: --

Line 178: fnd_message.set_token('TABLE_NAME', 'per_qualifications_tl');

174: -- The object is locked therefore we need to supply a meaningful
175: -- error message.
176: --
177: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
178: fnd_message.set_token('TABLE_NAME', 'per_qualifications_tl');
179: fnd_message.raise_error;
180: End lck;
181: --
182: -- ----------------------------------------------------------------------------

Line 188: delete from PER_QUALIFICATIONS_TL T

184: -- ----------------------------------------------------------------------------
185: PROCEDURE add_language IS
186: Begin
187: --
188: delete from PER_QUALIFICATIONS_TL T
189: where not exists
190: (select NULL
191: from PER_QUALIFICATIONS B
192: where B.QUALIFICATION_ID = T.QUALIFICATION_ID

Line 191: from PER_QUALIFICATIONS B

187: --
188: delete from PER_QUALIFICATIONS_TL T
189: where not exists
190: (select NULL
191: from PER_QUALIFICATIONS B
192: where B.QUALIFICATION_ID = T.QUALIFICATION_ID
193: );
194:
195: update PER_QUALIFICATIONS_TL T set (

Line 195: update PER_QUALIFICATIONS_TL T set (

191: from PER_QUALIFICATIONS B
192: where B.QUALIFICATION_ID = T.QUALIFICATION_ID
193: );
194:
195: update PER_QUALIFICATIONS_TL T set (
196: TITLE,
197: GROUP_RANKING,
198: LICENSE_RESTRICTIONS,
199: AWARDING_BODY,

Line 213: from PER_QUALIFICATIONS_TL B

209: B.GRADE_ATTAINED,
210: B.REIMBURSEMENT_ARRANGEMENTS,
211: B.TRAINING_COMPLETED_UNITS,
212: B.MEMBERSHIP_CATEGORY
213: from PER_QUALIFICATIONS_TL B
214: where B.QUALIFICATION_ID = T.QUALIFICATION_ID
215: and B.LANGUAGE = T.SOURCE_LANG)
216: where (
217: T.QUALIFICATION_ID,

Line 222: from PER_QUALIFICATIONS_TL SUBB, PER_QUALIFICATIONS_TL SUBT

218: T.LANGUAGE
219: ) in (select
220: SUBT.QUALIFICATION_ID,
221: SUBT.LANGUAGE
222: from PER_QUALIFICATIONS_TL SUBB, PER_QUALIFICATIONS_TL SUBT
223: where SUBB.QUALIFICATION_ID = SUBT.QUALIFICATION_ID
224: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
225: and (SUBB.GROUP_RANKING <> SUBT.GROUP_RANKING
226: or (SUBB.GROUP_RANKING is null and SUBT.GROUP_RANKING is not null)

Line 251: insert into PER_QUALIFICATIONS_TL (

247: or (SUBB.MEMBERSHIP_CATEGORY is null and SUBT.MEMBERSHIP_CATEGORY is not null)
248: or (SUBB.MEMBERSHIP_CATEGORY is not null and SUBT.MEMBERSHIP_CATEGORY is null)
249: ));
250:
251: insert into PER_QUALIFICATIONS_TL (
252: QUALIFICATION_ID,
253: TITLE,
254: GROUP_RANKING,
255: LICENSE_RESTRICTIONS,

Line 285: from PER_QUALIFICATIONS_TL B, FND_LANGUAGES L

281: B.LAST_UPDATE_DATE,
282: B.LAST_UPDATE_LOGIN,
283: L.LANGUAGE_CODE,
284: B.SOURCE_LANG
285: from PER_QUALIFICATIONS_TL B, FND_LANGUAGES L
286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL

Line 290: from PER_QUALIFICATIONS_TL T

286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL
290: from PER_QUALIFICATIONS_TL T
291: where T.QUALIFICATION_ID = B.QUALIFICATION_ID
292: and T.LANGUAGE = L.LANGUAGE_CODE);
293: --
294: End;