PACKAGE: APPS.BEN_LIFE_OBJECT

Source

1 package ben_life_object as
2 /* $Header: benlerde.pkh 120.0 2005/05/28 09:06:00 appldev noship $ */
3 --
4 /*
5 +==============================================================================+
6 |                        Copyright (c) 1997 Oracle Corporation                 |
7 |                           Redwood Shores, California, USA                    |
8 |                               All rights reserved.                           |
9 +==============================================================================+
10 --
11 Name
12 	Life Event Object Caching Routine
13 Purpose
14 	This package is used to return life event object information.
15 History
16   Version    Date       Who        What?
17   ---------  ---------  ---------- --------------------------------------------
18   115.0      25-Jun-99  gperry     Created
19   115.1      13-Dec-02  kmahendr   Nocopy changes
20   -----------------------------------------------------------------------------
21 */
22 --
23 -- Global type declarations.
24 --
25 type g_cache_ler_table is table of ben_ler_f%rowtype index
26   by binary_integer;
27 --
28 type g_cache_css_table is table of ben_css_rltd_per_per_in_ler_f%rowtype index
29   by binary_integer;
30 --
31 type g_cache_css_ler_table is table of ben_cache.g_cache_lookup index
32   by binary_integer;
33 --
34 type g_cache_ler_ler_table is table of ben_cache.g_cache_lookup index
35   by binary_integer;
36 --
37 g_cache_ler_rec         g_cache_ler_table;
38 g_cache_ler_ler_rec     g_cache_ler_ler_table;
39 g_cache_css_rec         g_cache_css_table;
40 g_cache_css_ler_rec     g_cache_css_ler_table;
41 --
42 -- Set object routines
43 --
44 procedure set_object
45   (p_rec in ben_ler_f%rowtype);
46 procedure set_object
47   (p_rec in ben_css_rltd_per_per_in_ler_f%rowtype);
48 procedure set_css_ler_object
49   (p_rec in ben_cache.g_cache_lookup);
50 procedure set_ler_ler_object
51   (p_rec in ben_cache.g_cache_lookup);
52 --
53 procedure set_ler_object
54   (p_ler_id            in number,
55    p_business_group_id in number,
56    p_effective_date    in date,
57    p_rec               out nocopy ben_ler_f%rowtype);
58 --
59 procedure set_css_object
60   (p_ler_id            in  number,
61    p_business_group_id in  number,
62    p_effective_date    in  date,
63    p_rec               out nocopy g_cache_css_table);
64 --
65 -- Get object routines
66 --
67 procedure get_object
68   (p_ler_id    in  number,
69    p_rec       out nocopy ben_ler_f%rowtype);
70 procedure get_object
71   (p_ler_id    in  number,
72    p_rec       out nocopy g_cache_css_table);
73 --
74 procedure clear_down_cache;
75 --
76 end ben_life_object;