PACKAGE: APPS.BEN_LETRG_CACHE

Source

1 package ben_letrg_cache AUTHID CURRENT_USER as
2 /* $Header: beltrgch.pkh 120.0 2005/05/28 03:39:18 appldev noship $*/
3 --
4 /*
5 +==============================================================================+
6 |			 Copyright (c) 1997 Oracle Corporation		       |
7 |			    Redwood Shores, California, USA		       |
8 |				All rights reserved.			       |
9 +==============================================================================+
10 --
11 History
12   Version    Date	Who	   What?
13   ---------  ---------	---------- --------------------------------------------
14   115.0      14-Sep-00	mhoyes     Created.
15   115.1      01-May-01	mhoyes     Added PRV and PEN caches.
16   115.2      01-May-01	tjesumic   typ_cd added .
17   -----------------------------------------------------------------------------
18 */
19 --
20 type g_egdlertrg_inst_row is record
21   (ler_id         ben_ler_f.ler_id%type
22   ,typ_cd          ben_ler_f.typ_cd%type
23   ,OCRD_DT_DET_CD ben_ler_f.OCRD_DT_DET_CD%type
24   );
25 --
26 type g_egdlertrg_inst_tbl is table of g_egdlertrg_inst_row
27   index by binary_integer;
28 --
29 procedure get_egdlertrg_dets
30   (p_business_group_id in     number
31   ,p_effective_date    in     date
32   ,p_inst_set	       in out NOCOPY g_egdlertrg_inst_tbl
33   );
34 --
35 procedure get_prvlertrg_dets
36   (p_business_group_id in     number
37   ,p_effective_date    in     date
38   ,p_inst_set	       in out NOCOPY g_egdlertrg_inst_tbl
39   );
40 --
41 procedure get_penlertrg_dets
42   (p_business_group_id in     number
43   ,p_effective_date    in     date
44   ,p_inst_set	       in out NOCOPY g_egdlertrg_inst_tbl
45   );
46 --
47 ------------------------------------------------------------------------
48 -- DELETE CACHED DATA
49 ------------------------------------------------------------------------
50 procedure clear_down_cache;
51 --
52 procedure set_no_cache;
53 --
54 END ben_letrg_cache;