1 PACKAGE ben_los_cache AUTHID CURRENT_USER AS
2 /* $Header: benlosch.pkh 115.2 2003/02/12 10:38:05 rpgupta ship $ */
3 --
4 -- length of service factor
5 --
6 type g_cache_los_object_rec is record
7 (los_fctr_id ben_los_fctr.los_fctr_id%type
8 ,mx_los_num ben_los_fctr.mx_los_num%type
9 ,mn_los_num ben_los_fctr.mn_los_num%type
10 ,no_mn_los_num_apls_flag ben_los_fctr.no_mn_los_num_apls_flag%type
11 ,no_mx_los_num_apls_flag ben_los_fctr.no_mx_los_num_apls_flag%type
12 );
13 --
14 type g_cache_los_instor is table of g_cache_los_object_rec index by binary_integer;
15 --
16 -- length of service factor
17 --
18 procedure los_writecache
19 (p_effective_date in date
20 --
21 ,p_refresh_cache in boolean default FALSE
22 );
23 --
24 procedure los_getcacdets
25 (p_effective_date in date
26 ,p_business_group_id in number
27 ,p_los_fctr_id in number
28 --
29 ,p_refresh_cache in boolean default FALSE
30 --
31 ,p_inst_set out nocopy ben_los_cache.g_cache_los_instor
32 ,p_inst_count out nocopy number
33 );
34 --
35 END ben_los_cache;
[Home] [Help]