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 HR_API

Line 81: hr_api.mandatory_arg_error

77: hr_utility.set_location('Entering:'|| l_proc, 10);
78: --
79: -- Ensure that all the mandatory parameter are not null
80: --
81: hr_api.mandatory_arg_error
82: (p_api_name => l_proc
83: ,p_argument => 'qualification_id'
84: ,p_argument_value => p_qualification_id
85: );

Line 88: if (( nvl(per_qat_bus.g_qualification_id, hr_api.g_number)

84: ,p_argument_value => p_qualification_id
85: );
86: --
87: --
88: if (( nvl(per_qat_bus.g_qualification_id, hr_api.g_number)
89: = p_qualification_id)
90: and ( nvl(per_qat_bus.g_language, hr_api.g_varchar2)
91: = p_language)) then
92: --

Line 90: and ( nvl(per_qat_bus.g_language, hr_api.g_varchar2)

86: --
87: --
88: if (( nvl(per_qat_bus.g_qualification_id, hr_api.g_number)
89: = p_qualification_id)
90: and ( nvl(per_qat_bus.g_language, hr_api.g_varchar2)
91: = p_language)) then
92: --
93: -- The legislation code has already been found with a previous
94: -- call to this function. Just return the value in the global

Line 220: and (nvl(per.start_date,hr_api.g_sot)

216: and nvl(per.attendance_id,-1) = nvl(p_attendance_id,-1)
217: and nvl(per.business_group_id,-1) = nvl(p_business_group_id,
218: nvl(per.business_group_id,-1))
219: and per.qualification_id <> NVL(p_qualification_id,-1)
220: and (nvl(per.start_date,hr_api.g_sot)
221: between nvl(p_start_date,hr_api.g_sot)
222: and nvl(p_end_date,hr_api.g_eot)
223: ---modified below condition for fixing bug#7571790
224: --or nvl(per.end_date,nvl(per.start_date,p_start_date))

Line 221: between nvl(p_start_date,hr_api.g_sot)

217: and nvl(per.business_group_id,-1) = nvl(p_business_group_id,
218: nvl(per.business_group_id,-1))
219: and per.qualification_id <> NVL(p_qualification_id,-1)
220: and (nvl(per.start_date,hr_api.g_sot)
221: between nvl(p_start_date,hr_api.g_sot)
222: and nvl(p_end_date,hr_api.g_eot)
223: ---modified below condition for fixing bug#7571790
224: --or nvl(per.end_date,nvl(per.start_date,p_start_date))
225: or nvl(per.end_date,hr_api.g_eot)

Line 222: and nvl(p_end_date,hr_api.g_eot)

218: nvl(per.business_group_id,-1))
219: and per.qualification_id <> NVL(p_qualification_id,-1)
220: and (nvl(per.start_date,hr_api.g_sot)
221: between nvl(p_start_date,hr_api.g_sot)
222: and nvl(p_end_date,hr_api.g_eot)
223: ---modified below condition for fixing bug#7571790
224: --or nvl(per.end_date,nvl(per.start_date,p_start_date))
225: or nvl(per.end_date,hr_api.g_eot)
226: between nvl(p_start_date,hr_api.g_sot)

Line 225: or nvl(per.end_date,hr_api.g_eot)

221: between nvl(p_start_date,hr_api.g_sot)
222: and nvl(p_end_date,hr_api.g_eot)
223: ---modified below condition for fixing bug#7571790
224: --or nvl(per.end_date,nvl(per.start_date,p_start_date))
225: or nvl(per.end_date,hr_api.g_eot)
226: between nvl(p_start_date,hr_api.g_sot)
227: and nvl(p_end_date,hr_api.g_eot));
228: --
229: l_dummy varchar2(1);

Line 226: between nvl(p_start_date,hr_api.g_sot)

222: and nvl(p_end_date,hr_api.g_eot)
223: ---modified below condition for fixing bug#7571790
224: --or nvl(per.end_date,nvl(per.start_date,p_start_date))
225: or nvl(per.end_date,hr_api.g_eot)
226: between nvl(p_start_date,hr_api.g_sot)
227: and nvl(p_end_date,hr_api.g_eot));
228: --
229: l_dummy varchar2(1);
230: --

Line 227: and nvl(p_end_date,hr_api.g_eot));

223: ---modified below condition for fixing bug#7571790
224: --or nvl(per.end_date,nvl(per.start_date,p_start_date))
225: or nvl(per.end_date,hr_api.g_eot)
226: between nvl(p_start_date,hr_api.g_sot)
227: and nvl(p_end_date,hr_api.g_eot));
228: --
229: l_dummy varchar2(1);
230: --
231: Begin

Line 272: and (nvl(p_qualification_type_id,hr_api.g_number)

268: end if;
269: --
270: --
271: if (l_b_api_updating
272: and (nvl(p_qualification_type_id,hr_api.g_number)
273: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
274: or nvl(p_person_id,hr_api.g_number)
275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge

Line 273: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)

269: --
270: --
271: if (l_b_api_updating
272: and (nvl(p_qualification_type_id,hr_api.g_number)
273: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
274: or nvl(p_person_id,hr_api.g_number)
275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --

Line 274: or nvl(p_person_id,hr_api.g_number)

270: --
271: if (l_b_api_updating
272: and (nvl(p_qualification_type_id,hr_api.g_number)
273: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
274: or nvl(p_person_id,hr_api.g_number)
275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)

Line 275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)

271: if (l_b_api_updating
272: and (nvl(p_qualification_type_id,hr_api.g_number)
273: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
274: or nvl(p_person_id,hr_api.g_number)
275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)

Line 276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge

272: and (nvl(p_qualification_type_id,hr_api.g_number)
273: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
274: or nvl(p_person_id,hr_api.g_number)
275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)

Line 277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --

273: <> nvl(per_qua_shd.g_old_rec.qualification_type_id,hr_api.g_number)
274: or nvl(p_person_id,hr_api.g_number)
275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)

Line 278: or nvl(p_attendance_id,hr_api.g_number)

274: or nvl(p_person_id,hr_api.g_number)
275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)

Line 279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)

275: <> nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number)
276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)

Line 280: or nvl(p_business_group_id,hr_api.g_number)

276: or nvl(p_party_id,hr_api.g_number) -- HR/TCA merge
277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)

Line 281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)

277: <> nvl(per_qua_shd.g_old_rec.party_id,hr_api.g_number) --
278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)
285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)

Line 282: or nvl(p_title,hr_api.g_varchar2)

278: or nvl(p_attendance_id,hr_api.g_number)
279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)
285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
286: or nvl(p_end_date,hr_api.g_date)

Line 283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)

279: <> nvl(per_qua_shd.g_old_rec.attendance_id,hr_api.g_number)
280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)
285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
286: or nvl(p_end_date,hr_api.g_date)
287: <> nvl(per_qua_shd.g_old_rec.end_date,hr_api.g_date))

Line 284: or nvl(p_start_date,hr_api.g_date)

280: or nvl(p_business_group_id,hr_api.g_number)
281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)
285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
286: or nvl(p_end_date,hr_api.g_date)
287: <> nvl(per_qua_shd.g_old_rec.end_date,hr_api.g_date))
288: or not l_b_api_updating) then

Line 285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)

281: <> nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number)
282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)
285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
286: or nvl(p_end_date,hr_api.g_date)
287: <> nvl(per_qua_shd.g_old_rec.end_date,hr_api.g_date))
288: or not l_b_api_updating) then
289: */ --

Line 286: or nvl(p_end_date,hr_api.g_date)

282: or nvl(p_title,hr_api.g_varchar2)
283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)
285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
286: or nvl(p_end_date,hr_api.g_date)
287: <> nvl(per_qua_shd.g_old_rec.end_date,hr_api.g_date))
288: or not l_b_api_updating) then
289: */ --
290: --

Line 287: <> nvl(per_qua_shd.g_old_rec.end_date,hr_api.g_date))

283: <> nvl(per_qat_shd.g_old_rec.title,hr_api.g_varchar2)
284: or nvl(p_start_date,hr_api.g_date)
285: <> nvl(per_qua_shd.g_old_rec.start_date,hr_api.g_date)
286: or nvl(p_end_date,hr_api.g_date)
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.