4 procedure INSERT_ROW (
1 package MTL_CATEGORIES_PKG AUTHID CURRENT_USER as
2 /* $Header: INVICAHS.pls 120.4 2008/06/06 22:24:50 trudave ship $ */
3
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_CATEGORY_ID in NUMBER,
7 X_DESCRIPTION in VARCHAR2,
8 X_STRUCTURE_ID in NUMBER,
9 X_DISABLE_DATE in DATE,
10 X_WEB_STATUS in VARCHAR2,
11 X_SUPPLIER_ENABLED_FLAG in VARCHAR2,
12 X_SEGMENT1 in VARCHAR2,
13 X_SEGMENT2 in VARCHAR2,
14 X_SEGMENT3 in VARCHAR2,
15 X_SEGMENT4 in VARCHAR2,
16 X_SEGMENT5 in VARCHAR2,
17 X_SEGMENT6 in VARCHAR2,
18 X_SEGMENT7 in VARCHAR2,
19 X_SEGMENT8 in VARCHAR2,
20 X_SEGMENT9 in VARCHAR2,
21 X_SEGMENT10 in VARCHAR2,
22 X_SEGMENT11 in VARCHAR2,
23 X_SEGMENT12 in VARCHAR2,
24 X_SEGMENT13 in VARCHAR2,
25 X_SEGMENT14 in VARCHAR2,
26 X_SEGMENT15 in VARCHAR2,
27 X_SEGMENT16 in VARCHAR2,
28 X_SEGMENT17 in VARCHAR2,
29 X_SEGMENT18 in VARCHAR2,
30 X_SEGMENT19 in VARCHAR2,
31 X_SEGMENT20 in VARCHAR2,
32 X_SUMMARY_FLAG in VARCHAR2,
33 X_ENABLED_FLAG in VARCHAR2,
34 X_START_DATE_ACTIVE in DATE,
35 X_END_DATE_ACTIVE in DATE,
36 X_ATTRIBUTE_CATEGORY in VARCHAR2,
37 X_ATTRIBUTE1 in VARCHAR2,
38 X_ATTRIBUTE2 in VARCHAR2,
39 X_ATTRIBUTE3 in VARCHAR2,
40 X_ATTRIBUTE4 in VARCHAR2,
41 X_ATTRIBUTE5 in VARCHAR2,
42 X_ATTRIBUTE6 in VARCHAR2,
43 X_ATTRIBUTE7 in VARCHAR2,
44 X_ATTRIBUTE8 in VARCHAR2,
45 X_ATTRIBUTE9 in VARCHAR2,
46 X_ATTRIBUTE10 in VARCHAR2,
47 X_ATTRIBUTE11 in VARCHAR2,
48 X_ATTRIBUTE12 in VARCHAR2,
49 X_ATTRIBUTE13 in VARCHAR2,
50 X_ATTRIBUTE14 in VARCHAR2,
51 X_ATTRIBUTE15 in VARCHAR2,
52 X_LAST_UPDATE_DATE in DATE,
53 X_LAST_UPDATED_BY in NUMBER,
54 X_CREATION_DATE in DATE,
55 X_CREATED_BY in NUMBER,
56 X_LAST_UPDATE_LOGIN in NUMBER
57 -- X_REQUEST_ID in NUMBER,
58 );
59
60 procedure LOCK_ROW (
61 X_CATEGORY_ID in NUMBER,
62 X_DESCRIPTION in VARCHAR2,
63 X_STRUCTURE_ID in NUMBER,
64 X_DISABLE_DATE in DATE,
65 X_WEB_STATUS in VARCHAR2,
66 X_SUPPLIER_ENABLED_FLAG in VARCHAR2,
67 X_SEGMENT1 in VARCHAR2,
68 X_SEGMENT2 in VARCHAR2,
69 X_SEGMENT3 in VARCHAR2,
70 X_SEGMENT4 in VARCHAR2,
71 X_SEGMENT5 in VARCHAR2,
72 X_SEGMENT6 in VARCHAR2,
73 X_SEGMENT7 in VARCHAR2,
74 X_SEGMENT8 in VARCHAR2,
75 X_SEGMENT9 in VARCHAR2,
76 X_SEGMENT10 in VARCHAR2,
77 X_SEGMENT11 in VARCHAR2,
78 X_SEGMENT12 in VARCHAR2,
79 X_SEGMENT13 in VARCHAR2,
80 X_SEGMENT14 in VARCHAR2,
81 X_SEGMENT15 in VARCHAR2,
82 X_SEGMENT16 in VARCHAR2,
83 X_SEGMENT17 in VARCHAR2,
84 X_SEGMENT18 in VARCHAR2,
85 X_SEGMENT19 in VARCHAR2,
86 X_SEGMENT20 in VARCHAR2,
87 X_SUMMARY_FLAG in VARCHAR2,
88 X_ENABLED_FLAG in VARCHAR2,
89 X_START_DATE_ACTIVE in DATE,
90 X_END_DATE_ACTIVE in DATE,
91 X_ATTRIBUTE_CATEGORY in VARCHAR2,
92 X_ATTRIBUTE1 in VARCHAR2,
93 X_ATTRIBUTE2 in VARCHAR2,
94 X_ATTRIBUTE3 in VARCHAR2,
95 X_ATTRIBUTE4 in VARCHAR2,
96 X_ATTRIBUTE5 in VARCHAR2,
97 X_ATTRIBUTE6 in VARCHAR2,
98 X_ATTRIBUTE7 in VARCHAR2,
99 X_ATTRIBUTE8 in VARCHAR2,
100 X_ATTRIBUTE9 in VARCHAR2,
101 X_ATTRIBUTE10 in VARCHAR2,
102 X_ATTRIBUTE11 in VARCHAR2,
103 X_ATTRIBUTE12 in VARCHAR2,
104 X_ATTRIBUTE13 in VARCHAR2,
105 X_ATTRIBUTE14 in VARCHAR2,
106 X_ATTRIBUTE15 in VARCHAR2
107 -- X_REQUEST_ID in NUMBER,
108 );
109
110 procedure UPDATE_ROW (
111 X_CATEGORY_ID in NUMBER,
112 X_DESCRIPTION in VARCHAR2,
113 X_STRUCTURE_ID in NUMBER,
114 X_DISABLE_DATE in DATE,
115 X_WEB_STATUS in VARCHAR2,
116 X_SUPPLIER_ENABLED_FLAG in VARCHAR2,
117 X_SEGMENT1 in VARCHAR2,
118 X_SEGMENT2 in VARCHAR2,
119 X_SEGMENT3 in VARCHAR2,
120 X_SEGMENT4 in VARCHAR2,
121 X_SEGMENT5 in VARCHAR2,
122 X_SEGMENT6 in VARCHAR2,
123 X_SEGMENT7 in VARCHAR2,
124 X_SEGMENT8 in VARCHAR2,
125 X_SEGMENT9 in VARCHAR2,
126 X_SEGMENT10 in VARCHAR2,
127 X_SEGMENT11 in VARCHAR2,
128 X_SEGMENT12 in VARCHAR2,
129 X_SEGMENT13 in VARCHAR2,
130 X_SEGMENT14 in VARCHAR2,
131 X_SEGMENT15 in VARCHAR2,
132 X_SEGMENT16 in VARCHAR2,
133 X_SEGMENT17 in VARCHAR2,
134 X_SEGMENT18 in VARCHAR2,
135 X_SEGMENT19 in VARCHAR2,
136 X_SEGMENT20 in VARCHAR2,
137 X_SUMMARY_FLAG in VARCHAR2,
138 X_ENABLED_FLAG in VARCHAR2,
139 X_START_DATE_ACTIVE in DATE,
140 X_END_DATE_ACTIVE in DATE,
141 X_ATTRIBUTE_CATEGORY in VARCHAR2,
142 X_ATTRIBUTE1 in VARCHAR2,
143 X_ATTRIBUTE2 in VARCHAR2,
144 X_ATTRIBUTE3 in VARCHAR2,
145 X_ATTRIBUTE4 in VARCHAR2,
146 X_ATTRIBUTE5 in VARCHAR2,
147 X_ATTRIBUTE6 in VARCHAR2,
148 X_ATTRIBUTE7 in VARCHAR2,
149 X_ATTRIBUTE8 in VARCHAR2,
150 X_ATTRIBUTE9 in VARCHAR2,
151 X_ATTRIBUTE10 in VARCHAR2,
152 X_ATTRIBUTE11 in VARCHAR2,
153 X_ATTRIBUTE12 in VARCHAR2,
154 X_ATTRIBUTE13 in VARCHAR2,
155 X_ATTRIBUTE14 in VARCHAR2,
156 X_ATTRIBUTE15 in VARCHAR2,
157 X_LAST_UPDATE_DATE in DATE,
158 X_LAST_UPDATED_BY in NUMBER,
159 X_LAST_UPDATE_LOGIN in NUMBER
160 -- X_REQUEST_ID in NUMBER,
161 );
162
163
164 -- ----------------------------------------------------------------------
165 -- Deletion of categories is not supported.
166 -- ----------------------------------------------------------------------
167
168 procedure DELETE_ROW (
169 X_CATEGORY_ID in NUMBER
170 );
171
172
173 procedure ADD_LANGUAGE;
174
175
176 -- ----------------------------------------------------------------------
177 -- PROCEDURE: Translate_Row PUBLIC
178 --
179 -- PARAMETERS:
180 -- x_<developer key>
181 -- x_<translated columns>
182 -- x_owner user owning the row (SEED or other)
183 --
184 -- COMMENT:
185 -- Called from the FNDLOAD config file in 'NLS' mode to upload
186 -- translations.
187 -- ----------------------------------------------------------------------
188
189 PROCEDURE Translate_Row
190 (
191 x_category_name IN VARCHAR2
192 , x_structure_code IN VARCHAR2 --BUg 6975120
193 , x_description IN VARCHAR2
194 , x_owner IN VARCHAR2
195 , x_upload_to_functional_area IN VARCHAR2
196 , x_application_short_name IN VARCHAR2
197 );
198
199 -- ----------------------------------------------------------------------
200 -- PROCEDURE: Load_Row PUBLIC
201 --
202 -- PARAMETERS:
203 -- x_<developer key>
204 -- x_<columns>
205 -- x_owner user owning the row (SEED or other)
206 --
207 -- COMMENT:
208 -- Called from the FNDLOAD config file to upload Categories
209 -- ----------------------------------------------------------------------
210
211 PROCEDURE Load_Row
212 (
213 X_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE
214 ,X_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE
215 ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
216 ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
217 ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
218 ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
219 ,X_SEGMENT5 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
220 ,X_SEGMENT6 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
221 ,X_SEGMENT7 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
222 ,X_SEGMENT8 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
223 ,X_SEGMENT9 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
224 ,X_SEGMENT10 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
225 ,X_SEGMENT11 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
226 ,X_SEGMENT12 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
227 ,X_SEGMENT13 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
228 ,X_SEGMENT14 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
229 ,X_SEGMENT15 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
230 ,X_SEGMENT16 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
231 ,X_SEGMENT17 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
232 ,X_SEGMENT18 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
233 ,X_SEGMENT19 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
234 ,X_SEGMENT20 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
235 ,X_SUMMARY_FLAG IN MTL_CATEGORIES_B.SUMMARY_FLAG%TYPE
236 ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
237 ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
238 ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE
239 ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE
240 ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
241 ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE
242 ,X_OWNER IN VARCHAR2
243 ,X_LAST_UPDATE_DATE IN MTL_CATEGORIES_B.LAST_UPDATE_DATE%TYPE
244 ,X_DESCRIPTION IN MTL_CATEGORIES_TL.DESCRIPTION%TYPE
245 ,X_APPLICATION_SHORT_NAME IN VARCHAR2
246 ,X_UPLOAD_TO_FUNCTIONAL_AREA IN VARCHAR2
247 );
248 end MTL_CATEGORIES_PKG;