1 package ben_comp_object AUTHID CURRENT_USER as
2 /* $Header: bencompo.pkh 120.0 2005/05/28 03:51:53 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Comp Object Caching Routine
13 Purpose
14 This package is used to return comp object information.
15 History
16 Date Who Version What?
17 ---- --- ------- -----
18 05 May 99 G Perry 115.0 Created
19 27 May 99 G Perry 115.1 Added extra cache for cobra.
20 26 Jun 99 G Perry 115.2 Made objects cache on demand.
21 04 Aug 99 G Perry 115.3 Added last record got cache.
22 31 Mar 00 G Perry 115.4 Added extra cache for oiplip.
23 06 May 00 RChase 115.9 Performance NOCOPY changes
24 29 Dec 00 Tmathsers 115.10 Foxed check_sql errors.
25 */
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;
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;
41 --
42 type g_cache_plip_rec_table is table of ben_plip_f%rowtype index
43 by binary_integer;
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;
53 g_cache_pgm_cobra_rec g_cache_pl_rec_table;
54 g_cache_pgm_cobra_lookup ben_cache.g_cache_lookup_table;
55 g_cache_oipl_rec g_cache_oipl_rec_table;
56 g_cache_plip_rec g_cache_plip_rec_table;
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;
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);
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);
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);
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);
95 procedure set_object(p_ptip_id in number,
96 p_business_group_id in number,
97 p_effective_date in date,
98 p_rec in out NOCOPY ben_ptip_f%rowtype);
99 procedure set_object(p_opt_id in number,
100 p_business_group_id in number,
101 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,
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);
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
128 (p_pgm_id in number,
129 p_only_pls_subj_cobra_flag in varchar2,
130 p_rec in out NOCOPY g_cache_pl_rec_table);
131 --
132 procedure clear_down_cache;
133 --
134 end ben_comp_object;