PACKAGE BODY: APPS.BEN_CMP_USR_HOOKS

Source

1 package body ben_cmp_usr_hooks as
2 /* $Header: benusrhk.pkb 120.0 2005/05/28 09:33:59 appldev noship $*/
3 
4 procedure cmp_uncompiled is
5 --
6 cursor c1 is
7     select object_name from user_objects
8     where status='INVALID'
9         and ( object_name like 'BEN%BK1' or object_name like 'BEN%RKU'
10         or object_name like 'BEN%BK2' or object_name like 'BEN%RKI'
11         or object_name like 'BEN%BK3' or object_name like 'BEN%RKD' );
12 l_name varchar2(100);
13 --
14 begin
15     open c1;
16     loop
17         fetch c1 into l_name;
18         exit when c1%notfound;
19         hr_api_user_hooks.create_package_body(l_name);
20     end loop;
21 end cmp_uncompiled;
22 
23 end ben_cmp_usr_hooks;