APPS.BEN_CEL_LER dependencies on BEN_CEL_LER

Line 1: package body ben_cel_ler as

1: package body ben_cel_ler as
2: /* $Header: beceltrg.pkb 120.1 2006/03/10 04:51:50 nhunur noship $*/
3: procedure ler_chk(p_old IN g_cel_ler_rec
4: ,p_new IN g_cel_ler_rec
5: ,p_effective_date in date ) is

Line 164: hr_utility.set_location(' Entering: ben_cel_ler', 10);

160: ,dep_appl_id =>805
161: ,status => l_status
162: ,industry => l_industry);
163:
164: hr_utility.set_location(' Entering: ben_cel_ler', 10);
165: l_changed := FALSE;
166: --
167: if p_effective_date is not null then
168: --

Line 241: hr_utility.set_location(' ben_cel_ler', 50);

237: if get_ler_col%ROWCOUNT =1 then
238: l_changed := TRUE;
239: end if;
240: l_changed := TRUE;
241: hr_utility.set_location(' ben_cel_ler', 50);
242: hr_utility.set_location('LER '||l_ler_id, 20);
243: hr_utility.set_location('COLUMN '||l_column, 20);
244: hr_utility.set_location('NEWVAL '||l_new_val, 20);
245: hr_utility.set_location('OLDVAL '||l_old_val, 20);

Line 801: hr_utility.set_location(' ben_cel_ler', 100);

797: end if;
798: --
799: -- reset the variables.
800: --
801: hr_utility.set_location(' ben_cel_ler', 100);
802: l_changed := FALSE;
803: l_trigger := TRUE;
804: l_ovn := NULL;
805: end if;

Line 808: hr_utility.set_location(' ben_cel_ler', 110);

804: l_ovn := NULL;
805: end if;
806: close get_ler_col;
807: end loop;
808: hr_utility.set_location(' ben_cel_ler', 110);
809: close get_ler;
810: hr_utility.set_location(' Leaving: ben_cel_ler', 120);
811:
812: end;

Line 810: hr_utility.set_location(' Leaving: ben_cel_ler', 120);

806: close get_ler_col;
807: end loop;
808: hr_utility.set_location(' ben_cel_ler', 110);
809: close get_ler;
810: hr_utility.set_location(' Leaving: ben_cel_ler', 120);
811:
812: end;
813: end ben_cel_ler;

Line 813: end ben_cel_ler;

809: close get_ler;
810: hr_utility.set_location(' Leaving: ben_cel_ler', 120);
811:
812: end;
813: end ben_cel_ler;