[Home] [Help]
26: --------------------------------------------------------------------------------
27: --
28: -- Cache all comp object stuff
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;
57: g_cache_ptip_rec g_cache_ptip_rec_table;
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;
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);
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);
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);
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);
107: --
108: -- Get object routines
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);