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_QAT_BUS dependencies on PER_QUALIFICATIONS

Line 64: , per_qualifications_tl qat

60: --
61: cursor csr_leg_code is
62: select pbg.legislation_code
63: from per_business_groups pbg
64: , per_qualifications_tl qat
65: , per_qualifications qau
66: where qat.qualification_id = p_qualification_id
67: and pbg.business_group_id = qau.business_group_id
68: and qau.qualification_id = qat.qualification_id;

Line 65: , per_qualifications qau

61: cursor csr_leg_code is
62: select pbg.legislation_code
63: from per_business_groups pbg
64: , per_qualifications_tl qat
65: , per_qualifications qau
66: where qat.qualification_id = p_qualification_id
67: and pbg.business_group_id = qau.business_group_id
68: and qau.qualification_id = qat.qualification_id;
69: --

Line 208: from per_qualifications per

204: -- qualifications can be taken more than once is for resits or failure, etc.
205: --
206: cursor c1 is
207: select null
208: from per_qualifications per
209: ,per_qualifications_tl qat
210: where qat.language = p_language
211: and qat.title = p_title
212: and qat.qualification_id = per.qualification_id

Line 209: ,per_qualifications_tl qat

205: --
206: cursor c1 is
207: select null
208: from per_qualifications per
209: ,per_qualifications_tl qat
210: where qat.language = p_language
211: and qat.title = p_title
212: and qat.qualification_id = per.qualification_id
213: and per.qualification_type_id = p_qualification_type_id

Line 236: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'

232: --
233: hr_utility.set_location('Entering:'||l_proc,5);
234: --
235: if hr_multi_message.no_all_inclusive_error
236: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
237: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
238: ,p_check_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
239: ,p_check_column4 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
240: ,p_check_column5 => 'PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID'

Line 237: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

233: hr_utility.set_location('Entering:'||l_proc,5);
234: --
235: if hr_multi_message.no_all_inclusive_error
236: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
237: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
238: ,p_check_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
239: ,p_check_column4 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
240: ,p_check_column5 => 'PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID'
241: ) then

Line 238: ,p_check_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

234: --
235: if hr_multi_message.no_all_inclusive_error
236: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
237: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
238: ,p_check_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
239: ,p_check_column4 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
240: ,p_check_column5 => 'PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID'
241: ) then
242: --

Line 239: ,p_check_column4 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'

235: if hr_multi_message.no_all_inclusive_error
236: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
237: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
238: ,p_check_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
239: ,p_check_column4 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
240: ,p_check_column5 => 'PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID'
241: ) then
242: --
243: if hr_multi_message.no_all_inclusive_error

Line 240: ,p_check_column5 => 'PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID'

236: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
237: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
238: ,p_check_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
239: ,p_check_column4 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
240: ,p_check_column5 => 'PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID'
241: ) then
242: --
243: if hr_multi_message.no_all_inclusive_error
244: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'

Line 244: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'

240: ,p_check_column5 => 'PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID'
241: ) then
242: --
243: if hr_multi_message.no_all_inclusive_error
244: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'
245: ,p_check_column2 => 'PER_QUALIFICATIONS.END_DATE'
246: ,p_check_column3 => 'PER_QUALIFICATIONS.TITLE'
247: ) then
248: --

Line 245: ,p_check_column2 => 'PER_QUALIFICATIONS.END_DATE'

241: ) then
242: --
243: if hr_multi_message.no_all_inclusive_error
244: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'
245: ,p_check_column2 => 'PER_QUALIFICATIONS.END_DATE'
246: ,p_check_column3 => 'PER_QUALIFICATIONS.TITLE'
247: ) then
248: --
249: --

Line 246: ,p_check_column3 => 'PER_QUALIFICATIONS.TITLE'

242: --
243: if hr_multi_message.no_all_inclusive_error
244: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'
245: ,p_check_column2 => 'PER_QUALIFICATIONS.END_DATE'
246: ,p_check_column3 => 'PER_QUALIFICATIONS.TITLE'
247: ) then
248: --
249: --
250: /* This is commented out becuase the per_qua_shd.api_updating is

Line 291: -- check if record already exists in PER_QUALIFICATIONS table.

287: <> nvl(per_qua_shd.g_old_rec.end_date,hr_api.g_date))
288: or not l_b_api_updating) then
289: */ --
290: --
291: -- check if record already exists in PER_QUALIFICATIONS table.
292: --
293: open c1;
294: --
295: fetch c1 into l_dummy;

Line 340: from per_qualifications qau

336: ,qau.object_version_number
337: ,qau.start_date
338: ,qau.end_date
339: ,qau.party_id
340: from per_qualifications qau
341: where qau.qualification_id = NVL(p_rec.qualification_id, p_qualification_id);
342: --
343: l_qau_rec csr_qualification%ROWTYPE;
344: --