1 PACKAGE ben_cache AUTHID CURRENT_USER AS
2 /* $Header: bencache.pkh 115.12 2002/12/24 15:44:02 bmanyam ship $ */
3 --
4 type g_cache_lookup is record
5 (id number
6 ,fk_id number
7 ,fk1_id number
8 ,fk2_id number
9 ,fk3_id number
10 ,fk4_id number
11 ,fk5_id number
12 ,v2value_1 varchar2(100)
13 ,datevalue_1 date
14 ,starttorele_num binary_integer
15 ,endtorele_num binary_integer
16 );
17 --
18 type g_cache_lookup_table is table of g_cache_lookup index by binary_integer;
19 --
20 type IdRecType is record
21 (id number
22 );
23 --
24 type IdType is table of IdRecType index by binary_integer;
25 --
26 -- Table details record type
27 --
28 Type TabDetRecType is record
29 (tab_name varchar2(100)
30 ,tab_jncolnm varchar2(100)
31 ,tab_datetype varchar2(100)
32 );
33 --
34 Type TabDetType is table of TabDetRecType index by binary_integer;
35 --
36 -- Column/cache details record type
37 --
38 Type InstColNmRecType is record
39 (col_name varchar2(100)
40 ,caccol_name varchar2(100)
41 ,asscol_name varchar2(100)
42 ,col_alias varchar2(100)
43 ,col_type varchar2(100)
44 );
45 --
46 Type InstColNmType is table of InstColNmRecType index by binary_integer;
47 --
48 -- Cursor details record type
49 --
50 Type CurParmRecType is record
51 (cur_type varchar2(100)
52 ,parm_type varchar2(100)
53 ,name varchar2(100)
54 ,datatype varchar2(100)
55 ,v2val varchar2(2000)
56 ,dateval date
57 ,numval number
58 );
59 --
60 Type CurParmType is table of CurParmRecType index by binary_integer;
61 --
62 -- Globals
63 --
64 g_tabdet_set ben_cache.TabDetType;
65 g_instcolnm_set ben_cache.InstColNmType;
66 g_curparm_set ben_cache.CurParmType;
67 g_id_set ben_cache.IdType;
68 --
69 -- ---------------------------------------------------------------------------
70 -- |--------------------------< Write_MastDet_Cache >------------------------|
71 -- ---------------------------------------------------------------------------
72 --
73 -- Write a master detail cache
74 --
75 procedure Write_MastDet_Cache
76 (p_mastercol_name in varchar2
77 ,p_detailcol_name in varchar2
78 ,p_masterfkcol_name in varchar2 default null
79 ,p_masterfk1col_name in varchar2 default null
80 ,p_masterfk2col_name in varchar2 default null
81 ,p_masterfk3col_name in varchar2 default null
82 ,p_masterfk4col_name in varchar2 default null
83 ,p_masterfk5col_name in varchar2 default null
84 ,p_lkup_name in varchar2
85 ,p_inst_name in varchar2
86 ,p_lkup_query in varchar2
87 ,p_inst_query in varchar2
88 ,p_nonmand_hv in boolean default false
89 ,p_coninst_query in varchar2 default null
90 ,p_conlkup_name in varchar2 default null
91 ,p_dtconlkup_ccolnm in varchar2 default null
92 ,p_dtconlkup_value in date default null
93 ,p_instcolnm_set in ben_cache.InstColNmType
94 default ben_cache.g_instcolnm_set
95 ,p_curparm_set in ben_cache.CurParmType
96 default ben_cache.g_curparm_set
97 );
98 --
99 -- ---------------------------------------------------------------------------
100 -- |----------------------------< Write_BGP_Cache >--------------------------|
101 -- ---------------------------------------------------------------------------
102 --
103 -- Write a cache below a business group
104 --
105 procedure Write_BGP_Cache
106 (p_mastertab_name in varchar2
107 ,p_masterpkcol_name in varchar2
108 ,p_masterfkcol_name in varchar2 default null
109 ,p_masterfk1col_name in varchar2 default null
110 ,p_masterfk2col_name in varchar2 default null
111 ,p_masterfk3col_name in varchar2 default null
112 ,p_masterfk4col_name in varchar2 default null
113 ,p_masterfk5col_name in varchar2 default null
114 ,p_masid_set in ben_cache.IdType default ben_cache.g_id_set
115 ,p_tabdet_set in ben_cache.TabDetType default ben_cache.g_tabdet_set
116 ,p_table1_name in varchar2
117 ,p_tab1jncol_name in varchar2 default null
118 ,p_table2_name in varchar2 default null
119 ,p_tab2jncol_name in varchar2 default null
120 ,p_table3_name in varchar2 default null
121 ,p_business_group_id in number
122 ,p_effective_date in date default null
123 ,p_context1_colname in varchar2 default null
124 ,p_context1_id in number default null
125 ,p_nonmand_hv in boolean default false
126 ,p_lkup_name in varchar2
127 ,p_inst_name in varchar2
128 ,p_inst_frclause in varchar2 default null
129 ,p_lkup_whclause in varchar2 default null
130 ,p_inst_whclause in varchar2 default null
131 ,p_inst_queryorby in varchar2 default null
132 ,p_lkup_subqyhint in varchar2 default null
133 ,p_lkup_query in varchar2 default null
134 ,p_instcolnm_set in ben_cache.InstColNmType
135 default ben_cache.g_instcolnm_set
136 ,p_curparm_set in ben_cache.CurParmType
137 default ben_cache.g_curparm_set
138 );
139 --
140 function check_list_duplicate
141 (p_list in out nocopy ben_cache.IdType
142 ,p_id in number
143 )
144 return boolean;
145 --
146 END ben_cache;
[Home] [Help]