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_CTK_UPD dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: Package Body per_ctk_upd as
2: /* $Header: pectkrhi.pkb 120.7 2006/09/11 20:45:03 sturlapa noship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: --
5: -- ----------------------------------------------------------------------------
6: -- | Private Global Definitions |
7: -- ----------------------------------------------------------------------------

Line 62: hr_utility.set_location('Entering:'||l_proc, 5);

58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
61: Begin
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: --
64: -- Increment the object version
65: p_rec.object_version_number := p_rec.object_version_number + 1;
66: --

Line 132: hr_utility.set_location(' Leaving:'||l_proc, 10);

128: where task_in_checklist_id = p_rec.task_in_checklist_id;
129: --
130: --
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: --
134: Exception
135: When hr_api.check_integrity_violated Then
136: -- A check constraint has been violated

Line 243: hr_utility.set_location('Entering:'||l_proc, 5);

239: l_effective_end_date date;
240: l_effective_date date;
241: Begin
242:
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- hr_utility.set_location('g_old_rec.eligibility_profile_id='||per_ctk_shd.g_old_rec.eligibility_profile_id,10);
246: -- hr_utility.set_location('p_rec.eligibility_profile_id='||p_rec.eligibility_profile_id,10);
247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND

Line 245: -- hr_utility.set_location('g_old_rec.eligibility_profile_id='||per_ctk_shd.g_old_rec.eligibility_profile_id,10);

241: Begin
242:
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- hr_utility.set_location('g_old_rec.eligibility_profile_id='||per_ctk_shd.g_old_rec.eligibility_profile_id,10);
246: -- hr_utility.set_location('p_rec.eligibility_profile_id='||p_rec.eligibility_profile_id,10);
247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
248: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
249:

Line 246: -- hr_utility.set_location('p_rec.eligibility_profile_id='||p_rec.eligibility_profile_id,10);

242:
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- hr_utility.set_location('g_old_rec.eligibility_profile_id='||per_ctk_shd.g_old_rec.eligibility_profile_id,10);
246: -- hr_utility.set_location('p_rec.eligibility_profile_id='||p_rec.eligibility_profile_id,10);
247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
248: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
249:
250: -- delete old eligy profile eligy object (child)

Line 272: --hr_utility.set_location('p_rec.l_elig_obj_elig_prfl_id='||l_elig_obj_elig_prfl_id,10);

268: raise;
269: end;
270: end if;
271: close c_elig_prfl_elig_obj;
272: --hr_utility.set_location('p_rec.l_elig_obj_elig_prfl_id='||l_elig_obj_elig_prfl_id,10);
273: --hr_utility.set_location('p_rec.l_prf_obj_ovn='||l_prf_obj_ovn,10);
274: --hr_utility.set_location('p_rec.l_effective_date='||l_effective_date,10);
275: --hr_utility.set_location('eligy_obj_elig_profile deleted',10);
276: open c_elig_obj(per_ctk_shd.g_old_rec.eligibility_object_id);

Line 273: --hr_utility.set_location('p_rec.l_prf_obj_ovn='||l_prf_obj_ovn,10);

269: end;
270: end if;
271: close c_elig_prfl_elig_obj;
272: --hr_utility.set_location('p_rec.l_elig_obj_elig_prfl_id='||l_elig_obj_elig_prfl_id,10);
273: --hr_utility.set_location('p_rec.l_prf_obj_ovn='||l_prf_obj_ovn,10);
274: --hr_utility.set_location('p_rec.l_effective_date='||l_effective_date,10);
275: --hr_utility.set_location('eligy_obj_elig_profile deleted',10);
276: open c_elig_obj(per_ctk_shd.g_old_rec.eligibility_object_id);
277:

Line 274: --hr_utility.set_location('p_rec.l_effective_date='||l_effective_date,10);

270: end if;
271: close c_elig_prfl_elig_obj;
272: --hr_utility.set_location('p_rec.l_elig_obj_elig_prfl_id='||l_elig_obj_elig_prfl_id,10);
273: --hr_utility.set_location('p_rec.l_prf_obj_ovn='||l_prf_obj_ovn,10);
274: --hr_utility.set_location('p_rec.l_effective_date='||l_effective_date,10);
275: --hr_utility.set_location('eligy_obj_elig_profile deleted',10);
276: open c_elig_obj(per_ctk_shd.g_old_rec.eligibility_object_id);
277:
278: fetch c_elig_obj into l_obj_ovn,l_effective_date;

Line 275: --hr_utility.set_location('eligy_obj_elig_profile deleted',10);

271: close c_elig_prfl_elig_obj;
272: --hr_utility.set_location('p_rec.l_elig_obj_elig_prfl_id='||l_elig_obj_elig_prfl_id,10);
273: --hr_utility.set_location('p_rec.l_prf_obj_ovn='||l_prf_obj_ovn,10);
274: --hr_utility.set_location('p_rec.l_effective_date='||l_effective_date,10);
275: --hr_utility.set_location('eligy_obj_elig_profile deleted',10);
276: open c_elig_obj(per_ctk_shd.g_old_rec.eligibility_object_id);
277:
278: fetch c_elig_obj into l_obj_ovn,l_effective_date;
279: if(c_elig_obj%found)then

Line 298: --hr_utility.set_location('p_rec.l_obj_ovn='||l_obj_ovn,20);

294: raise;
295: end;
296: end if;
297: close c_elig_obj;
298: --hr_utility.set_location('p_rec.l_obj_ovn='||l_obj_ovn,20);
299: --hr_utility.set_location('p_rec.l_effective_date='||to_char(l_effective_date),20);
300:
301: p_rec.eligibility_object_id :=null;
302: -- create eligy object (parent)

Line 299: --hr_utility.set_location('p_rec.l_effective_date='||to_char(l_effective_date),20);

295: end;
296: end if;
297: close c_elig_obj;
298: --hr_utility.set_location('p_rec.l_obj_ovn='||l_obj_ovn,20);
299: --hr_utility.set_location('p_rec.l_effective_date='||to_char(l_effective_date),20);
300:
301: p_rec.eligibility_object_id :=null;
302: -- create eligy object (parent)
303: -- create old eligy profile eligy object (child)

Line 324: hr_utility.set_location(' entering:'||l_proc, 20);

320: Fetch c_bg_id Into l_bgid;
321: Close c_bg_id;
322:
323: l_tic_id:=p_rec.checklist_id;
324: hr_utility.set_location(' entering:'||l_proc, 20);
325:
326: ben_elig_obj_api.create_ELIG_OBJ
327: (
328: p_validate => false

Line 340: hr_utility.set_location('levaving :'||l_proc, 20);

336: ,p_object_version_number => l_obj_ovn
337: ,p_effective_date => l_effective_date
338: );
339:
340: hr_utility.set_location('levaving :'||l_proc, 20);
341: p_rec.eligibility_object_id := l_elig_obj_id;
342: --
343: -- Add Create Eligibility Object logic
344: --

Line 362: hr_utility.set_location(' Leaving:'||l_proc, 10);

358: );
359:
360: end if;
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 10);
363: End pre_update;
364: --
365: -- ----------------------------------------------------------------------------
366: -- |-----------------------------< post_update >------------------------------|

Line 405: hr_utility.set_location('Entering:'||l_proc, 5);

401: --
402: l_proc varchar2(72) := g_package||'post_update';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: begin
407: --
408: per_ctk_rku.after_update
409: (p_effective_date => p_effective_date

Line 640: hr_utility.set_location(' Leaving:'||l_proc, 10);

636: ,p_hook_type => 'AU');
637: --
638: end;
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: End post_update;
642: --
643: -- ----------------------------------------------------------------------------
644: -- |-----------------------------< convert_defs >-----------------------------|

Line 923: hr_utility.set_location('Entering:'||l_proc, 5);

919: --
920: l_proc varchar2(72) := g_package||'upd';
921: --
922: Begin
923: hr_utility.set_location('Entering:'||l_proc, 5);
924: --
925: -- We must lock the row which we need to update.
926: --
927: per_ctk_shd.lck

Line 1032: hr_utility.set_location('Entering:'||l_proc, 5);

1028: l_rec per_ctk_shd.g_rec_type;
1029: l_proc varchar2(72) := g_package||'upd';
1030: --
1031: Begin
1032: hr_utility.set_location('Entering:'||l_proc, 5);
1033: --
1034: -- Call conversion function to turn arguments into the
1035: -- l_rec structure.
1036: --

Line 1106: hr_utility.set_location(' Leaving:'||l_proc, 10);

1102: ,l_rec
1103: );
1104: p_object_version_number := l_rec.object_version_number;
1105: --
1106: hr_utility.set_location(' Leaving:'||l_proc, 10);
1107: End upd;
1108: --
1109: end per_ctk_upd;