1 PACKAGE BNE_PARAMETER_UTILS AS
2 /* $Header: bneparams.pls 120.2 2005/06/29 03:40:32 dvayro noship $ */
3
4 ----------------------------------------------------------------------------------
5 -- PACKAGE: BNE_PARAMETERS_UTILS --
6 -- --
7 -- DESCRIPTION: Used For inserting into parameters tables: --
8 -- BNE_PARAM_DEFNS_B/_TL --
9 -- BNE_PARAM_LISTS_B/_TL --
10 -- BNE_PARAM_LIST_ITEMS --
11 -- BNE_ATTRIBUTES --
12 -- --
13 -- MODIFICATION HISTORY --
14 -- Date Username Description --
15 -- 8-5-2002 kdobinso Initial creation --
16 ----------------------------------------------------------------------------------
17
18 -- insert into BNE_PARAM_LISTS_B/_TL
19
20 FUNCTION CREATE_PARAM_LIST_ALL( P_APPLICATION_ID in BNE_PARAM_LISTS_B.APPLICATION_ID%type,
21 P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
22 P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
23 P_COMMENTS in BNE_PARAM_LISTS_B.COMMENTS%type,
24 P_ATTRIBUTE_APP_ID in BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID%type,
25 P_ATTRIBUTE_CODE in BNE_PARAM_LISTS_B.ATTRIBUTE_CODE%type,
26 P_LIST_RESOLVER in BNE_PARAM_LISTS_B.LIST_RESOLVER%type,
27 P_PROMPT_LEFT in BNE_PARAM_LISTS_TL.PROMPT_LEFT%type,
28 P_PROMPT_ABOVE in BNE_PARAM_LISTS_TL.PROMPT_ABOVE%type,
29 P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type,
30 P_USER_TIP in BNE_PARAM_LISTS_TL.USER_TIP%type )
31
32 RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
33
34
35
36 -- insert into BNE_PARAM_LISTS_B/_TL (minimal values required for insert)
37
38 FUNCTION CREATE_PARAM_LIST_MINIMAL( P_PARAM_LIST_CODE in BNE_PARAM_LISTS_B.PARAM_LIST_CODE%type,
39 P_PERSISTENT in BNE_PARAM_LISTS_B.PERSISTENT_FLAG%type,
40 P_USER_NAME in BNE_PARAM_LISTS_TL.USER_NAME%type)
41
42 RETURN BNE_PARAM_LISTS_TL.PARAM_LIST_CODE%type;
43
44
45
46 -- insert into BNE_ATTRIBUTES
47
48 FUNCTION CREATE_ATTRIBUTES (P_APPLICATION_ID in BNE_ATTRIBUTES.APPLICATION_ID%type,
49 P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
50 P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
51 P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
52 P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
53 P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
54 P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
55 P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
56 P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
57 P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
58 P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
59 P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type,
60 P_ATTRIBUTE11 in BNE_ATTRIBUTES.ATTRIBUTE11%type,
61 P_ATTRIBUTE12 in BNE_ATTRIBUTES.ATTRIBUTE12%type,
62 P_ATTRIBUTE13 in BNE_ATTRIBUTES.ATTRIBUTE13%type,
63 P_ATTRIBUTE14 in BNE_ATTRIBUTES.ATTRIBUTE14%type,
64 P_ATTRIBUTE15 in BNE_ATTRIBUTES.ATTRIBUTE15%type,
65 P_ATTRIBUTE16 in BNE_ATTRIBUTES.ATTRIBUTE16%type,
66 P_ATTRIBUTE17 in BNE_ATTRIBUTES.ATTRIBUTE17%type,
67 P_ATTRIBUTE18 in BNE_ATTRIBUTES.ATTRIBUTE18%type,
68 P_ATTRIBUTE19 in BNE_ATTRIBUTES.ATTRIBUTE19%type,
69 P_ATTRIBUTE20 in BNE_ATTRIBUTES.ATTRIBUTE20%type,
70 P_ATTRIBUTE21 in BNE_ATTRIBUTES.ATTRIBUTE21%type,
71 P_ATTRIBUTE22 in BNE_ATTRIBUTES.ATTRIBUTE22%type,
72 P_ATTRIBUTE23 in BNE_ATTRIBUTES.ATTRIBUTE23%type,
73 P_ATTRIBUTE24 in BNE_ATTRIBUTES.ATTRIBUTE24%type,
74 P_ATTRIBUTE25 in BNE_ATTRIBUTES.ATTRIBUTE25%type,
75 P_ATTRIBUTE26 in BNE_ATTRIBUTES.ATTRIBUTE26%type,
76 P_ATTRIBUTE27 in BNE_ATTRIBUTES.ATTRIBUTE27%type,
77 P_ATTRIBUTE28 in BNE_ATTRIBUTES.ATTRIBUTE28%type,
78 P_ATTRIBUTE29 in BNE_ATTRIBUTES.ATTRIBUTE29%type,
79 P_ATTRIBUTE30 in BNE_ATTRIBUTES.ATTRIBUTE30%type )
80 RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
81
82
83 -- inserts 10 attributes into BNE_ATTRIBUTES
84
85 FUNCTION CREATE_ATTRIBUTES_MINIMAL (P_ATTRIBUTE_CODE in BNE_ATTRIBUTES.ATTRIBUTE_CODE%type,
86 P_ATTRIBUTE1 in BNE_ATTRIBUTES.ATTRIBUTE1%type,
87 P_ATTRIBUTE2 in BNE_ATTRIBUTES.ATTRIBUTE2%type,
88 P_ATTRIBUTE3 in BNE_ATTRIBUTES.ATTRIBUTE3%type,
89 P_ATTRIBUTE4 in BNE_ATTRIBUTES.ATTRIBUTE4%type,
90 P_ATTRIBUTE5 in BNE_ATTRIBUTES.ATTRIBUTE5%type,
91 P_ATTRIBUTE6 in BNE_ATTRIBUTES.ATTRIBUTE6%type,
92 P_ATTRIBUTE7 in BNE_ATTRIBUTES.ATTRIBUTE7%type,
93 P_ATTRIBUTE8 in BNE_ATTRIBUTES.ATTRIBUTE8%type,
94 P_ATTRIBUTE9 in BNE_ATTRIBUTES.ATTRIBUTE9%type,
95 P_ATTRIBUTE10 in BNE_ATTRIBUTES.ATTRIBUTE10%type)
96 RETURN BNE_ATTRIBUTES.ATTRIBUTE_CODE%type;
97
98
99
100 -- insert into BNE_PARAM_LIST_ITEMS
101
102 FUNCTION CREATE_LIST_ITEMS_ALL (P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
103 P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
104 P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
105 P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
106 P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
107 P_ATTRIBUTE_APP_ID in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID%type,
108 P_ATTRIBUTE_CODE in BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE%type,
109 P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
110 P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
111 P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
112 P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
113 P_FORMULA in BNE_PARAM_LIST_ITEMS.FORMULA_VALUE%type,
114 P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
115
116 RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
117
118
119 -- insert into BNE_PARAM_LIST_ITEMS (minimum required to insert)
120
121 FUNCTION CREATE_LIST_ITEMS_MINIMAL(P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type,
122 P_PARAM_DEFN_APP_ID in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID%type,
123 P_PARAM_DEFN_CODE in BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE%type,
124 P_PARAM_NAME in BNE_PARAM_LIST_ITEMS.PARAM_NAME%type,
125 P_STRING_VAL in BNE_PARAM_LIST_ITEMS.STRING_VALUE%type,
126 P_DATE_VAL in BNE_PARAM_LIST_ITEMS.DATE_VALUE%type,
127 P_NUMBER_VAL in BNE_PARAM_LIST_ITEMS.NUMBER_VALUE%type,
128 P_BOOLEAN_VAL in BNE_PARAM_LIST_ITEMS.BOOLEAN_VALUE_FLAG%type,
129 P_DESC_VAL in BNE_PARAM_LIST_ITEMS.DESC_VALUE %type )
130
131 RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
132
133
134 -- Get the id for a parameter in BNE_PARAM_DEFN
135
136 FUNCTION GET_PARAM_DEFN_ID ( P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
137 P_PARAM_DEFN_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
138 P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type )
139
140 RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
141
142
143
144 -- insert into BNE_PARAM_DEFNS_B/TL
145
146 FUNCTION CREATE_PARAM_ALL( P_APPLICATION_ID in BNE_PARAM_DEFNS_B.APPLICATION_ID%type,
147 P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
148 P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
149 P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
150 P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
151 P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
152 P_ATTRIBUTE_APP_ID in BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID%type,
153 P_ATTRIBUTE_CODE in BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE%type,
154 P_PARAM_RESOLVER in BNE_PARAM_DEFNS_B.PARAM_RESOLVER%type,
155 P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
156 P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
157 P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
158 P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
159 P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
160 P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
161 P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
162 P_DEFAULT_FORMULA in BNE_PARAM_DEFNS_B.DEFAULT_FORMULA%type,
163 P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
164 P_VAL_VALUE in BNE_PARAM_DEFNS_B.VAL_VALUE%type,
165 P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
166 P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
167 P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
168 P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
169 P_HELP_URL in BNE_PARAM_DEFNS_B.HELP_URL%type,
170 P_FORMAT_MASK in BNE_PARAM_DEFNS_B.FORMAT_MASK%type,
171 P_DEFAULT_DESC in BNE_PARAM_DEFNS_TL.DEFAULT_DESC%type,
172 P_PROMPT_LEFT in BNE_PARAM_DEFNS_TL.PROMPT_LEFT%type,
173 P_PROMPT_ABOVE in BNE_PARAM_DEFNS_TL.PROMPT_ABOVE%type,
174 P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type,
175 P_USER_TIP in BNE_PARAM_DEFNS_TL.USER_TIP%type,
176 P_ACCESS_KEY in BNE_PARAM_DEFNS_TL.ACCESS_KEY%type)
177
178 RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
179
180
181 -- insert into BNE_PARAM_DEFN (minimal values required for insert)
182
183 FUNCTION CREATE_PARAM_MINIMAL ( P_PARAM_CODE in BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type,
184 P_PARAM_NAME in BNE_PARAM_DEFNS_B.PARAM_NAME%type,
185 P_PARAM_SOURCE in BNE_PARAM_DEFNS_B.PARAM_SOURCE%type,
186 P_CATEGORY in BNE_PARAM_DEFNS_B.PARAM_CATEGORY%type,
187 P_DATA_TYPE in BNE_PARAM_DEFNS_B.DATATYPE%type,
188 P_REQUIRED in BNE_PARAM_DEFNS_B.DEFAULT_REQUIRED_FLAG%type,
189 P_VISIBLE in BNE_PARAM_DEFNS_B.DEFAULT_VISIBLE_FLAG%type,
190 P_MODIFYABLE in BNE_PARAM_DEFNS_B.DEFAULT_USER_MODIFYABLE_FLAG%type,
191 P_DEFAULT_STRING in BNE_PARAM_DEFNS_B.DEFAULT_STRING%type,
192 P_DEFAULT_DATE in BNE_PARAM_DEFNS_B.DEFAULT_DATE%type,
193 P_DEFAULT_NUM in BNE_PARAM_DEFNS_B.DEFAULT_NUMBER%type,
194 P_DEFAULT_BOOLEAN in BNE_PARAM_DEFNS_B.DEFAULT_BOOLEAN_FLAG%type,
195 P_VAL_TYPE in BNE_PARAM_DEFNS_B.VAL_TYPE%type,
196 P_MAXIMUM_SIZE in BNE_PARAM_DEFNS_B.MAX_SIZE%type,
197 P_DISPLAY_TYPE in BNE_PARAM_DEFNS_B.DISPLAY_TYPE%type,
198 P_DISPLAY_STYLE in BNE_PARAM_DEFNS_B.DISPLAY_STYLE%type,
199 P_DISPLAY_SIZE in BNE_PARAM_DEFNS_B.DISPLAY_SIZE%type,
200 P_USER_NAME in BNE_PARAM_DEFNS_TL.USER_NAME%type)
201
202 RETURN BNE_PARAM_DEFNS_B.PARAM_DEFN_CODE%type;
203
204
205 -- Get the next sequence for BNE_PARAM_LIST_ITEMS
206
207 FUNCTION GET_NEXT_ITEM_SEQ ( P_APPLICATION_ID in BNE_PARAM_LIST_ITEMS.APPLICATION_ID%type,
208 P_PARAM_LIST_CODE in BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE%type)
209
210 RETURN BNE_PARAM_LIST_ITEMS.SEQUENCE_NUM%type;
211
212
213
214 END BNE_PARAMETER_UTILS;