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.JTFB_AK_REGION_ITEMS_PKG

Source


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