1 package ben_elig_object AUTHID CURRENT_USER as
2 /* $Header: beneligo.pkh 120.0 2005/05/28 08:56:16 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 Comp Elig Object Caching Routine
13 Purpose
14 This package is used to return comp object elig information.
15 History
16 Date Who Version What?
17 ---- --- ------- -----
18 05 May 99 G Perry 115.0 Created
19 06 May 99 G Perry 115.1 Backport for Fidelity.
20 06 May 99 G Perry 115.2 Leapfrog from 115.0.
21 07 May 99 G Perry 115.3 Added cache for ben_prtn_elig_f
22 for Bala.
23 15 May 00 RChase 115.9 Altered all procedure calls to
24 utilize NOCOPY for large objects
25 22 May 00 mhoyes 115.10 - Modified set_object to pass out
26 record structure.
27 */
28 --------------------------------------------------------------------------------
29 --
30 -- Cache all comp object stuff
31 --
32 type g_cache_elig_prte_rec_table is table of ben_elig_to_prte_rsn_f%rowtype
33 index by binary_integer;
34 --
35 type g_cache_elig_rec_table is table of ben_prtn_elig_f%rowtype
36 index by binary_integer;
37 --
38 g_cache_pgm_rec g_cache_elig_prte_rec_table;
39 g_cache_pl_rec g_cache_elig_prte_rec_table;
40 g_cache_oipl_rec g_cache_elig_prte_rec_table;
41 g_cache_plip_rec g_cache_elig_prte_rec_table;
42 g_cache_ptip_rec g_cache_elig_prte_rec_table;
43 g_cache_pgm_elig_rec g_cache_elig_rec_table;
44 g_cache_pl_elig_rec g_cache_elig_rec_table;
45 g_cache_oipl_elig_rec g_cache_elig_rec_table;
46 g_cache_plip_elig_rec g_cache_elig_rec_table;
47 g_cache_ptip_elig_rec g_cache_elig_rec_table;
48 --
49 -- Set object routines
50 --
51 procedure set_object(p_pgm_id in number,
52 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
53 procedure set_object(p_pl_id in number,
54 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
55 procedure set_object(p_oipl_id in number,
56 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
57 procedure set_object(p_plip_id in number,
58 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
59 procedure set_object(p_ptip_id in number,
60 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
61 --
62 procedure set_object(p_pgm_id in number,
63 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
64 procedure set_object(p_pl_id in number,
65 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
66 procedure set_object(p_oipl_id in number,
67 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
68 procedure set_object(p_plip_id in number,
69 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
70 procedure set_object(p_ptip_id in number,
71 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
72 --
73 procedure set_object(p_pl_id in number,
74 p_ler_id in number,
75 p_business_group_id in number,
76 p_effective_date in date,
77 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
78 );
79 procedure set_object(p_pgm_id in number,
80 p_ler_id in number,
81 p_business_group_id in number,
82 p_effective_date in date,
83 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
84 );
85 procedure set_object(p_oipl_id in number,
86 p_ler_id in number,
87 p_business_group_id in number,
88 p_effective_date in date,
89 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
90 );
91 procedure set_object(p_plip_id in number,
92 p_ler_id in number,
93 p_business_group_id in number,
94 p_effective_date in date,
95 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
96 );
97 procedure set_object(p_ptip_id in number,
98 p_ler_id in number,
99 p_business_group_id in number,
100 p_effective_date in date,
101 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype
102 );
103 --
104 procedure set_object(p_pl_id in number,
105 p_business_group_id in number,
106 p_effective_date in date);
107 procedure set_object(p_pgm_id in number,
108 p_business_group_id in number,
109 p_effective_date in date);
110 procedure set_object(p_oipl_id in number,
111 p_business_group_id in number,
112 p_effective_date in date);
113 procedure set_object(p_plip_id in number,
114 p_business_group_id in number,
115 p_effective_date in date);
116 procedure set_object(p_ptip_id in number,
117 p_business_group_id in number,
118 p_effective_date in date);
119 --
120 -- Get object routines
121 --
122 procedure get_object(p_pgm_id in number,
123 p_ler_id in number default null,
124 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
125 procedure get_object(p_pl_id in number,
126 p_ler_id in number default null,
127 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
128 procedure get_object(p_oipl_id in number,
129 p_ler_id in number default null,
130 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
131 procedure get_object(p_plip_id in number,
132 p_ler_id in number default null,
133 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
134 procedure get_object(p_ptip_id in number,
135 p_ler_id in number default null,
136 p_rec in out NOCOPY ben_elig_to_prte_rsn_f%rowtype);
137 --
138 procedure get_object(p_pgm_id in number,
139 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
140 procedure get_object(p_pl_id in number,
141 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
142 procedure get_object(p_oipl_id in number,
143 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
144 procedure get_object(p_plip_id in number,
145 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
146 procedure get_object(p_ptip_id in number,
147 p_rec in out NOCOPY ben_prtn_elig_f%rowtype);
148 --
149 procedure clear_down_cache;
150 --
151 end ben_elig_object;