[Home] [Help]
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;
38: --
39: type g_cache_ptip_rec_table is table of ben_ptip_f%rowtype index
40: by binary_integer;
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;
67: g_cache_last_oiplip_rec ben_oiplip_f%rowtype;
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);
77: procedure set_object(p_rec in out NOCOPY ben_oiplip_f%rowtype);
86: p_rec in out NOCOPY ben_pgm_f%rowtype);
87: procedure set_object(p_oipl_id in number,
88: p_business_group_id in number,
89: p_effective_date in date,
90: p_rec in out NOCOPY ben_oipl_f%rowtype);
91: procedure set_object(p_plip_id in number,
92: p_business_group_id in number,
93: p_effective_date in date,
94: p_rec in out NOCOPY ben_plip_f%rowtype);
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);
118: procedure get_object(p_ptip_id in number,
119: p_rec in out NOCOPY ben_ptip_f%rowtype);