PACKAGE: APPS.BEN_RT_ASNT_CACHE

Source

1 PACKAGE ben_rt_asnt_cache AUTHID CURRENT_USER AS
2 /* $Header: bertasch.pkh 115.0 2004/02/02 11:54:27 kmahendr noship $*/
3 --
4 /*
5  * +==============================================================================+
6  * |                        Copyright (c) 1997 Oracle Corporation
7  * |
8  * |                           Redwood Shores, California, USA
9  * |
10  * |                               All rights reserved.
11  * |
12  * +==============================================================================+
13  * --
14  * History
15  *   Version    Date       Who        What?
16  *  ---------  ---------  ----------
17  *--------------------------------------------
18  *   115.0    30-Jan-04  kmahendr    Created.
19  *---------------------------------------------
20  *
21  *
22  * */
23 --
24 -- Global record type.
25 --
26 type g_rt_asnt_rec is record
27   (id               number
28   ,formula_id       number
29   ,excld_flag       varchar2(30)
30   );
31 --
32 type g_rt_asnt_inst_tbl is table of g_rt_asnt_rec index by binary_integer;
33 --
34 procedure get_rt_asnt_cache
35   (p_vrbl_rt_prfl_id     in number
36   ,p_effective_date    in date
37   ,p_lf_evt_ocrd_dt    in date
38   ,p_business_group_id in number
39   ,p_inst_set          out nocopy ben_rt_asnt_cache.g_rt_asnt_inst_tbl
40   ,p_inst_count        out nocopy number
41   );
42 --
43 procedure clear_down_cache;
44 --
45 end ben_rt_asnt_cache;