1 package BNE_PARAM_DEFNS_PKG AUTHID CURRENT_USER as
2 /* $Header: bnepards.pls 120.3 2005/08/18 06:36:54 dagroves noship $ */
3
4 /* ============================================================*/
5 /* WARNING WARNING WARNING WARNING WARNING WARNING WARNING */
6 /* This is not the default package body generated by tltblgen. */
7 /* X_DEFAULT_STRING_TRANS_FLAG has been added. */
8 /* ============================================================*/
9
10 procedure INSERT_ROW (
11 X_ROWID in out NOCOPY VARCHAR2,
12 X_APPLICATION_ID in NUMBER,
13 X_PARAM_DEFN_CODE in VARCHAR2,
14 X_OBJECT_VERSION_NUMBER in NUMBER,
15 X_PARAM_NAME in VARCHAR2,
16 X_PARAM_SOURCE in VARCHAR2,
17 X_PARAM_CATEGORY in NUMBER,
18 X_DATATYPE in NUMBER,
19 X_ATTRIBUTE_APP_ID in NUMBER,
20 X_ATTRIBUTE_CODE in VARCHAR2,
21 X_PARAM_RESOLVER in VARCHAR2,
22 X_DEFAULT_REQUIRED_FLAG in VARCHAR2,
23 X_DEFAULT_VISIBLE_FLAG in VARCHAR2,
24 X_DEFAULT_USER_MODIFYABLE_FLAG in VARCHAR2,
25 X_DEFAULT_DATE in DATE,
26 X_DEFAULT_NUMBER in NUMBER,
27 X_DEFAULT_BOOLEAN_FLAG in VARCHAR2,
28 X_DEFAULT_FORMULA in VARCHAR2,
29 X_VAL_TYPE in VARCHAR2,
30 X_VAL_VALUE in VARCHAR2,
31 X_MAX_SIZE in NUMBER,
32 X_DISPLAY_TYPE in NUMBER,
33 X_DISPLAY_STYLE in NUMBER,
34 X_DISPLAY_SIZE in NUMBER,
35 X_HELP_URL in VARCHAR2,
36 X_FORMAT_MASK in VARCHAR2,
37 X_USER_NAME in VARCHAR2,
38 X_DEFAULT_STRING in VARCHAR2,
39 X_DEFAULT_STRING_TRANS_FLAG in VARCHAR2,
40 X_DEFAULT_DESC in VARCHAR2,
41 X_PROMPT_LEFT in VARCHAR2,
42 X_PROMPT_ABOVE in VARCHAR2,
43 X_USER_TIP in VARCHAR2,
44 X_ACCESS_KEY in VARCHAR2,
45 X_CREATION_DATE in DATE,
46 X_CREATED_BY in NUMBER,
47 X_LAST_UPDATE_DATE in DATE,
48 X_LAST_UPDATED_BY in NUMBER,
49 X_LAST_UPDATE_LOGIN in NUMBER,
50 X_OA_FLEX_APPLICATION_ID in NUMBER DEFAULT NULL,
51 X_OA_FLEX_CODE in VARCHAR2 DEFAULT NULL,
52 X_OA_FLEX_NUM in VARCHAR2 DEFAULT NULL
53 );
54 procedure LOCK_ROW (
55 X_APPLICATION_ID in NUMBER,
56 X_PARAM_DEFN_CODE in VARCHAR2,
57 X_OBJECT_VERSION_NUMBER in NUMBER,
58 X_PARAM_NAME in VARCHAR2,
59 X_PARAM_SOURCE in VARCHAR2,
60 X_PARAM_CATEGORY in NUMBER,
61 X_DATATYPE in NUMBER,
62 X_ATTRIBUTE_APP_ID in NUMBER,
63 X_ATTRIBUTE_CODE in VARCHAR2,
64 X_PARAM_RESOLVER in VARCHAR2,
65 X_DEFAULT_REQUIRED_FLAG in VARCHAR2,
66 X_DEFAULT_VISIBLE_FLAG in VARCHAR2,
67 X_DEFAULT_USER_MODIFYABLE_FLAG in VARCHAR2,
68 X_DEFAULT_DATE in DATE,
69 X_DEFAULT_NUMBER in NUMBER,
70 X_DEFAULT_BOOLEAN_FLAG in VARCHAR2,
71 X_DEFAULT_FORMULA in VARCHAR2,
72 X_VAL_TYPE in VARCHAR2,
73 X_VAL_VALUE in VARCHAR2,
74 X_MAX_SIZE in NUMBER,
75 X_DISPLAY_TYPE in NUMBER,
76 X_DISPLAY_STYLE in NUMBER,
77 X_DISPLAY_SIZE in NUMBER,
78 X_HELP_URL in VARCHAR2,
79 X_FORMAT_MASK in VARCHAR2,
80 X_USER_NAME in VARCHAR2,
81 X_DEFAULT_STRING in VARCHAR2,
82 X_DEFAULT_STRING_TRANS_FLAG in VARCHAR2,
83 X_DEFAULT_DESC in VARCHAR2,
84 X_PROMPT_LEFT in VARCHAR2,
85 X_PROMPT_ABOVE in VARCHAR2,
86 X_USER_TIP in VARCHAR2,
87 X_ACCESS_KEY in VARCHAR2,
88 X_OA_FLEX_APPLICATION_ID in NUMBER DEFAULT NULL,
89 X_OA_FLEX_CODE in VARCHAR2 DEFAULT NULL,
90 X_OA_FLEX_NUM in VARCHAR2 DEFAULT NULL
91 );
92 procedure UPDATE_ROW (
93 X_APPLICATION_ID in NUMBER,
94 X_PARAM_DEFN_CODE in VARCHAR2,
95 X_OBJECT_VERSION_NUMBER in NUMBER,
96 X_PARAM_NAME in VARCHAR2,
97 X_PARAM_SOURCE in VARCHAR2,
98 X_PARAM_CATEGORY in NUMBER,
99 X_DATATYPE in NUMBER,
100 X_ATTRIBUTE_APP_ID in NUMBER,
101 X_ATTRIBUTE_CODE in VARCHAR2,
102 X_PARAM_RESOLVER in VARCHAR2,
103 X_DEFAULT_REQUIRED_FLAG in VARCHAR2,
104 X_DEFAULT_VISIBLE_FLAG in VARCHAR2,
105 X_DEFAULT_USER_MODIFYABLE_FLAG in VARCHAR2,
106 X_DEFAULT_DATE in DATE,
107 X_DEFAULT_NUMBER in NUMBER,
108 X_DEFAULT_BOOLEAN_FLAG in VARCHAR2,
109 X_DEFAULT_FORMULA in VARCHAR2,
110 X_VAL_TYPE in VARCHAR2,
111 X_VAL_VALUE in VARCHAR2,
112 X_MAX_SIZE in NUMBER,
113 X_DISPLAY_TYPE in NUMBER,
114 X_DISPLAY_STYLE in NUMBER,
115 X_DISPLAY_SIZE in NUMBER,
116 X_HELP_URL in VARCHAR2,
117 X_FORMAT_MASK in VARCHAR2,
118 X_USER_NAME in VARCHAR2,
119 X_DEFAULT_STRING in VARCHAR2,
120 X_DEFAULT_STRING_TRANS_FLAG in VARCHAR2,
121 X_DEFAULT_DESC in VARCHAR2,
122 X_PROMPT_LEFT in VARCHAR2,
123 X_PROMPT_ABOVE in VARCHAR2,
124 X_USER_TIP in VARCHAR2,
125 X_ACCESS_KEY in VARCHAR2,
126 X_LAST_UPDATE_DATE in DATE,
127 X_LAST_UPDATED_BY in NUMBER,
128 X_LAST_UPDATE_LOGIN in NUMBER,
129 X_OA_FLEX_APPLICATION_ID in NUMBER DEFAULT NULL,
130 X_OA_FLEX_CODE in VARCHAR2 DEFAULT NULL,
131 X_OA_FLEX_NUM in VARCHAR2 DEFAULT NULL
132 );
133 procedure DELETE_ROW (
134 X_APPLICATION_ID in NUMBER,
135 X_PARAM_DEFN_CODE in VARCHAR2
136 );
137 procedure ADD_LANGUAGE;
138
139 procedure TRANSLATE_ROW(
140 x_param_defn_asn in VARCHAR2,
141 x_param_defn_code in VARCHAR2,
142 x_default_string_trans in VARCHAR2,
143 x_user_name in VARCHAR2,
144 x_default_desc in VARCHAR2,
145 x_prompt_left in VARCHAR2,
146 x_prompt_above in VARCHAR2,
147 x_user_tip in VARCHAR2,
148 x_access_key in VARCHAR2,
149 x_owner in VARCHAR2,
150 x_last_update_date in VARCHAR2,
151 x_custom_mode in VARCHAR2
152 );
153 procedure LOAD_ROW(
154 x_param_defn_asn in VARCHAR2,
155 x_param_defn_code in VARCHAR2,
156 x_object_version_number in VARCHAR2,
157 x_param_name in VARCHAR2,
158 x_param_source in VARCHAR2,
159 x_param_category in VARCHAR2,
160 x_datatype in VARCHAR2,
161 x_attribute_asn in VARCHAR2,
162 x_attribute_code in VARCHAR2,
163 x_param_resolver in VARCHAR2,
164 x_default_required_flag in VARCHAR2,
165 x_default_visible_flag in VARCHAR2,
166 x_default_user_modifyable_flag in VARCHAR2,
167 x_default_string in VARCHAR2,
168 x_default_string_trans_flag in VARCHAR2,
169 x_default_date in VARCHAR2,
170 x_default_number in VARCHAR2,
171 x_default_boolean_flag in VARCHAR2,
172 x_default_formula in VARCHAR2,
173 x_val_type in VARCHAR2,
174 x_val_value in VARCHAR2,
175 x_max_size in VARCHAR2,
176 x_display_type in VARCHAR2,
177 x_display_style in VARCHAR2,
178 x_display_size in VARCHAR2,
179 x_help_url in VARCHAR2,
180 x_format_mask in VARCHAR2,
181 x_user_name in VARCHAR2,
182 x_default_desc in VARCHAR2,
183 x_prompt_left in VARCHAR2,
184 x_prompt_above in VARCHAR2,
185 x_user_tip in VARCHAR2,
186 x_access_key in VARCHAR2,
187 x_owner in VARCHAR2,
188 x_last_update_date in VARCHAR2,
189 x_custom_mode in VARCHAR2,
190 x_oa_flex_asn in VARCHAR2 default null,
191 x_oa_flex_code in VARCHAR2 default null,
192 x_oa_flex_num in VARCHAR2 default null
193 );
194
195 end BNE_PARAM_DEFNS_PKG;