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: -- --
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;
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:
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:
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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)
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:
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;
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:
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: