[Home] [Help]
44: --
45: type g_cache_opt_rec_table is table of ben_opt_f%rowtype index
46: by binary_integer;
47: --
48: type g_cache_oiplip_rec_table is table of ben_oiplip_f%rowtype index
49: by binary_integer;
50: --
51: g_cache_pgm_rec g_cache_pgm_rec_table;
52: g_cache_pl_rec g_cache_pl_rec_table;
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;
68: --
69: -- Set object routines
70: --
71: procedure set_object(p_rec in out NOCOPY ben_pgm_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);
78: --
79: procedure set_object(p_pl_id in number,
80: p_business_group_id in number,
81: p_effective_date in date,
102: p_rec in out NOCOPY ben_opt_f%rowtype);
103: procedure set_object(p_oiplip_id in number,
104: p_business_group_id in number,
105: p_effective_date in date,
106: p_rec in out NOCOPY ben_oiplip_f%rowtype);
107: --
108: -- Get object routines
109: --
110: procedure get_object(p_pgm_id in number,
119: p_rec in out NOCOPY ben_ptip_f%rowtype);
120: procedure get_object(p_opt_id in number,
121: p_rec in out NOCOPY ben_opt_f%rowtype);
122: procedure get_object(p_oiplip_id in number,
123: p_rec in out NOCOPY ben_oiplip_f%rowtype);
124: --
125: -- Set routines
126: --
127: procedure get_object_set_cobra