eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AK_REGION_ITEMS_PKG

Source


1 package AK_REGION_ITEMS_PKG as
2 /* $Header: AKDRGITS.pls 120.2 2005/09/29 14:00:01 tshort ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_REGION_APPLICATION_ID in NUMBER,
6 X_REGION_CODE in VARCHAR2,
7 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
8 X_ATTRIBUTE_CODE in VARCHAR2,
9 X_DISPLAY_SEQUENCE in NUMBER,
10 X_NODE_DISPLAY_FLAG in VARCHAR2,
11 X_NODE_QUERY_FLAG in VARCHAR2,
12 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
13 X_BOLD in VARCHAR2,
14 X_ITALIC in VARCHAR2,
15 X_VERTICAL_ALIGNMENT in VARCHAR2,
16 X_HORIZONTAL_ALIGNMENT in VARCHAR2,
17 X_ITEM_STYLE in VARCHAR2,
18 X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
19 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
20 X_DESCRIPTION in VARCHAR2,
21 X_SECURITY_CODE in VARCHAR2,
22 X_UPDATE_FLAG in VARCHAR2,
23 X_REQUIRED_FLAG in VARCHAR2,
24 X_DISPLAY_VALUE_LENGTH in NUMBER,
25 X_LOV_REGION_APPLICATION_ID in NUMBER,
26 X_LOV_REGION_CODE in VARCHAR2,
27 X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
28 X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
29 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
30 X_LOV_DEFAULT_FLAG in VARCHAR2,
31 X_REGION_DEFAULTING_API_PKG in VARCHAR2,
32 X_REGION_DEFAULTING_API_PROC in VARCHAR2,
33 X_REGION_VALIDATION_API_PKG in VARCHAR2,
34 X_REGION_VALIDATION_API_PROC in VARCHAR2,
35 X_ORDER_SEQUENCE in NUMBER,
36 X_ORDER_DIRECTION in VARCHAR2,
37 X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
38 X_DEFAULT_VALUE_NUMBER in NUMBER,
39 X_DEFAULT_VALUE_DATE in DATE,
40 X_ITEM_NAME IN VARCHAR2,
41 X_DISPLAY_HEIGHT IN NUMBER,
42 X_SUBMIT IN VARCHAR2,
43 X_ENCRYPT IN VARCHAR2,
44 X_VIEW_USAGE_NAME IN VARCHAR2,
45 X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
46 X_CSS_CLASS_NAME IN VARCHAR2,
47 X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
48 X_URL IN VARCHAR2,
49 X_POPLIST_VIEWOBJECT IN VARCHAR2,
50 X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
51 X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
52 X_IMAGE_FILE_NAME IN VARCHAR2,
53 X_NESTED_REGION_CODE IN VARCHAR2,
54 X_NESTED_REGION_APPL_ID IN NUMBER,
55 X_MENU_NAME IN VARCHAR2,
56 X_FLEXFIELD_NAME IN VARCHAR2,
57 X_FLEXFIELD_APPLICATION_ID IN NUMBER,
58 X_TABULAR_FUNCTION_CODE IN VARCHAR2,
59 X_TIP_TYPE IN VARCHAR2,
60 X_TIP_MESSAGE_NAME IN VARCHAR2,
61 X_TIP_MESSAGE_APPLICATION_ID IN NUMBER,
62 X_FLEX_SEGMENT_LIST IN VARCHAR2,
63 X_ENTITY_ID IN VARCHAR2,
64 X_ANCHOR IN VARCHAR2,
65 X_POPLIST_VIEW_USAGE_NAME IN VARCHAR2,
66 X_USER_CUSTOMIZABLE IN VARCHAR2 := NULL,
67 X_ADMIN_CUSTOMIZABLE IN VARCHAR2 := 'Y',
68 X_INVOKE_FUNCTION_NAME IN VARCHAR2 := NULL,
69 X_ATTRIBUTE_LABEL_SHORT IN VARCHAR2 := NULL,
70 X_EXPANSION IN NUMBER := NULL,
71 X_ALS_MAX_LENGTH IN NUMBER := NULL,
72 X_SORTBY_VIEW_ATTRIBUTE_NAME IN VARCHAR2 := NULL,
73 X_ICX_CUSTOM_CALL IN VARCHAR2 := NULL,
74 X_INITIAL_SORT_SEQUENCE IN VARCHAR2 := NULL,
75 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER := NULL,
76 X_CUSTOMIZATION_CODE IN VARCHAR2 := NULL,
77 X_CREATION_DATE in DATE,
78 X_CREATED_BY in NUMBER,
79 X_LAST_UPDATE_DATE in DATE,
80 X_LAST_UPDATED_BY in NUMBER,
81 X_LAST_UPDATE_LOGIN in NUMBER,
82 X_ATTRIBUTE_CATEGORY in VARCHAR2,
83 X_ATTRIBUTE1 in VARCHAR2,
84 X_ATTRIBUTE2 in VARCHAR2,
85 X_ATTRIBUTE3 in VARCHAR2,
86 X_ATTRIBUTE4 in VARCHAR2,
87 X_ATTRIBUTE5 in VARCHAR2,
88 X_ATTRIBUTE6 in VARCHAR2,
89 X_ATTRIBUTE7 in VARCHAR2,
90 X_ATTRIBUTE8 in VARCHAR2,
91 X_ATTRIBUTE9 in VARCHAR2,
92 X_ATTRIBUTE10 in VARCHAR2,
93 X_ATTRIBUTE11 in VARCHAR2,
94 X_ATTRIBUTE12 in VARCHAR2,
95 X_ATTRIBUTE13 in VARCHAR2,
96 X_ATTRIBUTE14 in VARCHAR2,
97 X_ATTRIBUTE15 in VARCHAR2);
98 procedure LOCK_ROW (
99 X_REGION_APPLICATION_ID in NUMBER,
100 X_REGION_CODE in VARCHAR2,
101 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
102 X_ATTRIBUTE_CODE in VARCHAR2,
103 X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
104 X_ATTRIBUTE_CATEGORY in VARCHAR2,
105 X_ATTRIBUTE1 in VARCHAR2,
106 X_ATTRIBUTE2 in VARCHAR2,
107 X_ATTRIBUTE3 in VARCHAR2,
108 X_ATTRIBUTE4 in VARCHAR2,
109 X_ATTRIBUTE5 in VARCHAR2,
110 X_ATTRIBUTE6 in VARCHAR2,
111 X_ATTRIBUTE7 in VARCHAR2,
112 X_ATTRIBUTE8 in VARCHAR2,
113 X_ATTRIBUTE9 in VARCHAR2,
114 X_ATTRIBUTE10 in VARCHAR2,
115 X_ATTRIBUTE11 in VARCHAR2,
116 X_ATTRIBUTE12 in VARCHAR2,
117 X_ATTRIBUTE13 in VARCHAR2,
118 X_ATTRIBUTE14 in VARCHAR2,
119 X_ATTRIBUTE15 in VARCHAR2,
120 X_DISPLAY_SEQUENCE in NUMBER,
121 X_NODE_DISPLAY_FLAG in VARCHAR2,
122 X_NODE_QUERY_FLAG in VARCHAR2,
123 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
124 X_BOLD in VARCHAR2,
125 X_ITALIC in VARCHAR2,
126 X_VERTICAL_ALIGNMENT in VARCHAR2,
127 X_HORIZONTAL_ALIGNMENT in VARCHAR2,
128 X_ITEM_STYLE in VARCHAR2,
129 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
130 X_DESCRIPTION in VARCHAR2,
131 X_SECURITY_CODE in VARCHAR2,
132 X_UPDATE_FLAG in VARCHAR2,
133 X_REQUIRED_FLAG in VARCHAR2,
134 X_DISPLAY_VALUE_LENGTH in NUMBER,
135 X_LOV_REGION_APPLICATION_ID in NUMBER,
136 X_LOV_REGION_CODE in VARCHAR2,
137 X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
138 X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
139 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
140 X_LOV_DEFAULT_FLAG in VARCHAR2,
141 X_REGION_DEFAULTING_API_PKG in VARCHAR2,
142 X_REGION_DEFAULTING_API_PROC in VARCHAR2,
143 X_REGION_VALIDATION_API_PKG in VARCHAR2,
144 X_REGION_VALIDATION_API_PROC in VARCHAR2,
145 X_ORDER_SEQUENCE in NUMBER,
146 X_ORDER_DIRECTION in VARCHAR2,
147 X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
148 X_DEFAULT_VALUE_NUMBER in NUMBER,
149 X_DEFAULT_VALUE_DATE in DATE,
150 X_ITEM_NAME in VARCHAR2,
151 X_DISPLAY_HEIGHT IN NUMBER,
152 X_SUBMIT IN VARCHAR2,
153 X_ENCRYPT IN VARCHAR2,
154 X_VIEW_USAGE_NAME IN VARCHAR2,
155 X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
156 X_CSS_CLASS_NAME IN VARCHAR2,
157 X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
158 X_URL IN VARCHAR2,
159 X_POPLIST_VIEWOBJECT IN VARCHAR2,
160 X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
161 X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
162 X_IMAGE_FILE_NAME IN VARCHAR2,
163 X_NESTED_REGION_CODE IN VARCHAR2,
164 X_NESTED_REGION_APPL_ID IN NUMBER,
165 X_MENU_NAME IN VARCHAR2,
166 X_FLEXFIELD_NAME IN VARCHAR2,
167 X_FLEXFIELD_APPLICATION_ID IN NUMBER,
168 X_TABULAR_FUNCTION_CODE IN VARCHAR2,
169 X_TIP_TYPE IN VARCHAR2,
170 X_TIP_MESSAGE_NAME VARCHAR2,
171 X_TIP_MESSAGE_APPLICATION_ID NUMBER,
172 X_FLEX_SEGMENT_LIST VARCHAR2,
173 X_ENTITY_ID VARCHAR2,
174 X_ANCHOR VARCHAR2,
175 X_POPLIST_VIEW_USAGE_NAME VARCHAR2,
176 X_USER_CUSTOMIZABLE VARCHAR2,
177 X_ADMIN_CUSTOMIZABLE VARCHAR2,
178 X_INVOKE_FUNCTION_NAME VARCHAR2,
179 X_ATTRIBUTE_LABEL_SHORT VARCHAR2,
180 X_EXPANSION NUMBER,
181 X_ALS_MAX_LENGTH NUMBER,
182 X_SORTBY_VIEW_ATTRIBUTE_NAME VARCHAR2,
183 X_ICX_CUSTOM_CALL VARCHAR2,
184 X_INITIAL_SORT_SEQUENCE VARCHAR2
185 );
186 procedure UPDATE_ROW (
187 X_REGION_APPLICATION_ID in NUMBER,
188 X_REGION_CODE in VARCHAR2,
189 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
190 X_ATTRIBUTE_CODE in VARCHAR2,
191 X_DISPLAY_SEQUENCE in NUMBER,
192 X_NODE_DISPLAY_FLAG in VARCHAR2,
193 X_NODE_QUERY_FLAG in VARCHAR2,
194 X_ATTRIBUTE_LABEL_LENGTH in NUMBER,
195 X_BOLD in VARCHAR2,
196 X_ITALIC in VARCHAR2,
197 X_VERTICAL_ALIGNMENT in VARCHAR2,
198 X_HORIZONTAL_ALIGNMENT in VARCHAR2,
199 X_ITEM_STYLE in VARCHAR2,
200 X_OBJECT_ATTRIBUTE_FLAG in VARCHAR2,
201 X_ATTRIBUTE_LABEL_LONG in VARCHAR2,
202 X_DESCRIPTION in VARCHAR2,
203 X_SECURITY_CODE in VARCHAR2,
204 X_UPDATE_FLAG in VARCHAR2,
205 X_REQUIRED_FLAG in VARCHAR2,
206 X_DISPLAY_VALUE_LENGTH in NUMBER,
207 X_LOV_REGION_APPLICATION_ID in NUMBER,
208 X_LOV_REGION_CODE in VARCHAR2,
209 X_LOV_FOREIGN_KEY_NAME in VARCHAR2,
210 X_LOV_ATTRIBUTE_APPLICATION_ID in NUMBER,
211 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
212 X_LOV_DEFAULT_FLAG in VARCHAR2,
213 X_REGION_DEFAULTING_API_PKG in VARCHAR2,
214 X_REGION_DEFAULTING_API_PROC in VARCHAR2,
215 X_REGION_VALIDATION_API_PKG in VARCHAR2,
216 X_REGION_VALIDATION_API_PROC in VARCHAR2,
217 X_ORDER_SEQUENCE in NUMBER,
218 X_ORDER_DIRECTION in VARCHAR2,
219 X_DEFAULT_VALUE_VARCHAR2 in VARCHAR2,
220 X_DEFAULT_VALUE_NUMBER in NUMBER,
221 X_DEFAULT_VALUE_DATE in DATE,
222 X_ITEM_NAME in VARCHAR2,
223 X_DISPLAY_HEIGHT IN NUMBER,
224 X_SUBMIT IN VARCHAR2,
225 X_ENCRYPT IN VARCHAR2,
226 X_VIEW_USAGE_NAME IN VARCHAR2,
227 X_VIEW_ATTRIBUTE_NAME IN VARCHAR2,
228 X_CSS_CLASS_NAME IN VARCHAR2,
229 X_CSS_LABEL_CLASS_NAME IN VARCHAR2,
230 X_URL IN VARCHAR2,
231 X_POPLIST_VIEWOBJECT IN VARCHAR2,
232 X_POPLIST_DISPLAY_ATTRIBUTE IN VARCHAR2,
233 X_POPLIST_VALUE_ATTRIBUTE IN VARCHAR2,
234 X_IMAGE_FILE_NAME IN VARCHAR2,
235 X_NESTED_REGION_CODE IN VARCHAR2,
236 X_NESTED_REGION_APPL_ID IN NUMBER,
237 X_MENU_NAME IN VARCHAR2,
238 X_FLEXFIELD_NAME IN VARCHAR2,
239 X_FLEXFIELD_APPLICATION_ID IN NUMBER,
240 X_TABULAR_FUNCTION_CODE IN VARCHAR2,
241 X_TIP_TYPE IN VARCHAR2,
242 X_TIP_MESSAGE_NAME VARCHAR2,
243 X_TIP_MESSAGE_APPLICATION_ID NUMBER,
244 X_FLEX_SEGMENT_LIST VARCHAR2,
245 X_ENTITY_ID VARCHAR2,
246 X_ANCHOR VARCHAR2,
247 X_POPLIST_VIEW_USAGE_NAME VARCHAR2,
248 X_USER_CUSTOMIZABLE VARCHAR2 := NULL,
249 X_ADMIN_CUSTOMIZABLE VARCHAR2 := 'Y',
250 X_INVOKE_FUNCTION_NAME VARCHAR2 := NULL,
251 X_ATTRIBUTE_LABEL_SHORT VARCHAR2 := NULL,
252 X_EXPANSION NUMBER := NULL,
253 X_ALS_MAX_LENGTH NUMBER := NULL,
254 X_SORTBY_VIEW_ATTRIBUTE_NAME VARCHAR2 := NULL,
255 X_ICX_CUSTOM_CALL VARCHAR2 := NULL,
256 X_INITIAL_SORT_SEQUENCE VARCHAR2 := NULL,
257 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER := NULL,
258 X_CUSTOMIZATION_CODE IN VARCHAR2 := NULL,
259 X_LAST_UPDATE_DATE in DATE,
260 X_LAST_UPDATED_BY in NUMBER,
261 X_LAST_UPDATE_LOGIN in NUMBER,
262 X_ATTRIBUTE_CATEGORY in VARCHAR2,
263 X_ATTRIBUTE1 in VARCHAR2,
264 X_ATTRIBUTE2 in VARCHAR2,
265 X_ATTRIBUTE3 in VARCHAR2,
266 X_ATTRIBUTE4 in VARCHAR2,
267 X_ATTRIBUTE5 in VARCHAR2,
268 X_ATTRIBUTE6 in VARCHAR2,
269 X_ATTRIBUTE7 in VARCHAR2,
270 X_ATTRIBUTE8 in VARCHAR2,
271 X_ATTRIBUTE9 in VARCHAR2,
272 X_ATTRIBUTE10 in VARCHAR2,
273 X_ATTRIBUTE11 in VARCHAR2,
274 X_ATTRIBUTE12 in VARCHAR2,
275 X_ATTRIBUTE13 in VARCHAR2,
276 X_ATTRIBUTE14 in VARCHAR2,
277 X_ATTRIBUTE15 in VARCHAR2
278 );
279 procedure DELETE_ROW (
280 X_REGION_APPLICATION_ID in NUMBER,
281 X_REGION_CODE in VARCHAR2,
282 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
283 X_ATTRIBUTE_CODE in VARCHAR2
284 );
285 procedure ADD_LANGUAGE;
286 end AK_REGION_ITEMS_PKG;