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