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
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;
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);
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);
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);
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,
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,
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);
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);
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);
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;
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;