[Home] [Help]
29: --
30: type g_cache_pgm_rec_table is table of ben_pgm_f%rowtype index
31: by binary_integer;
32: --
33: type g_cache_pl_rec_table is table of ben_pl_f%rowtype index
34: by binary_integer;
35: --
36: type g_cache_oipl_rec_table is table of ben_oipl_f%rowtype index
37: by binary_integer;
58: g_cache_opt_rec g_cache_opt_rec_table;
59: g_cache_oiplip_rec g_cache_oiplip_rec_table;
60: --
61: g_cache_last_pgm_rec ben_pgm_f%rowtype;
62: g_cache_last_pl_rec ben_pl_f%rowtype;
63: g_cache_last_oipl_rec ben_oipl_f%rowtype;
64: g_cache_last_plip_rec ben_plip_f%rowtype;
65: g_cache_last_ptip_rec ben_ptip_f%rowtype;
66: g_cache_last_opt_rec ben_opt_f%rowtype;
68: --
69: -- Set object routines
70: --
71: procedure set_object(p_rec in out NOCOPY ben_pgm_f%rowtype);
72: procedure set_object(p_rec in out NOCOPY ben_pl_f%rowtype);
73: procedure set_object(p_rec in out NOCOPY ben_oipl_f%rowtype);
74: procedure set_object(p_rec in out NOCOPY ben_ptip_f%rowtype);
75: procedure set_object(p_rec in out NOCOPY ben_plip_f%rowtype);
76: procedure set_object(p_rec in out NOCOPY ben_opt_f%rowtype);
78: --
79: procedure set_object(p_pl_id in number,
80: p_business_group_id in number,
81: p_effective_date in date,
82: p_rec in out NOCOPY ben_pl_f%rowtype);
83: procedure set_object(p_pgm_id in number,
84: p_business_group_id in number,
85: p_effective_date in date,
86: p_rec in out NOCOPY ben_pgm_f%rowtype);
109: --
110: procedure get_object(p_pgm_id in number,
111: p_rec in out NOCOPY ben_pgm_f%rowtype);
112: procedure get_object(p_pl_id in number,
113: p_rec in out NOCOPY ben_pl_f%rowtype);
114: procedure get_object(p_oipl_id in number,
115: p_rec in out NOCOPY ben_oipl_f%rowtype);
116: procedure get_object(p_plip_id in number,
117: p_rec in out NOCOPY ben_plip_f%rowtype);