[Home] [Help]
PACKAGE: APPS.ASO_SUP_COMPONENT_PKG
Source
1 Package ASO_SUP_COMPONENT_PKG AS
2 /* $Header: asospcos.pls 120.2 2005/09/20 15:46:00 skulkarn ship $*/
3
4 -- Purpose: To Insert/Update/delete data for ASO_SUP_COMPONENT_B and ASO_SUP_COMPONENT_TL table for HTML Quoting
5 -- File name asospcos.pls
6
7
8 -- MODIFICATION HISTORY
9 -- Person Date Comments
10 -- --------- ------ ------------------------------------------
11 -- Sarala Biswal 01/17/02 Created Package
12
13 --------------------------------------------------------------------------------------
14 -- API Signatures--
15 --------------------------------------------------------------------------------------
16 -- 1.
17 -- Start of comments
18 -- API name : INSERT_ROW
19 -- Purpose : Procedure to insert into ASO_SUP_COMPONENT_B and ASO_SUP_COMPONENT_TL table
20 -- Type : Private
21 -- Pre-reqs : None
22 -- Parameters :
23 -- IN : P_COMPONENT_TYPE IN VARCHAR2 Required
24 -- P_MANDATORY_FLAG IN VARCHAR2 Required DEFAULT 'N'
25 -- P_COMPONENT_NAME IN VARCHAR2 Required
26 -- P_RESPONSE_TYPE IN VARCHAR2 Optional
27
28
29 -- IN OUT NOCOPY /* file.sql.39 change */ : COMPONENT_ID IN OUT NUMBER
30 -- Version :
31 -- Current version 1.0
32 -- Previous version 1.0
33 -- Initial version 1.0
34 -- End of comments
35 --------------------------------------------------------------------------------------
36
37
38 PROCEDURE INSERT_ROW
39 (
40 PX_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41 PX_COMPONENT_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
42 P_created_by IN NUMBER ,
43 P_creation_date IN DATE ,
44 P_last_updated_by IN NUMBER,
45 P_last_update_date IN DATE,
46 P_last_update_login IN NUMBER,
47 P_COMPONENT_TYPE IN VARCHAR2,
48 P_COMPONENT_NAME IN VARCHAR2,
49 P_MANDATORY_FLAG IN VARCHAR2 DEFAULT 'N',
50 P_RESPONSE_TYPE IN VARCHAR2 DEFAULT 'TEXT',
51 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
52 P_INSTRUCTION IN VARCHAR2 DEFAULT NULL,
53 P_CONTEXT IN VARCHAR2 DEFAULT NULL,
54 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
55 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
56 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
57 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
58 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
59 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
60 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
66 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
67 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
68 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
69 p_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
70 p_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
71 p_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
72 p_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
73 p_ATTRIBUTE20 VARCHAR2 DEFAULT NULL
74
75 );
76
77
78 --------------------------------------------------------------------------------------
79 -- API Signatures--
80 --------------------------------------------------------------------------------------
81 -- 2.
82 -- Start of comments
83 -- API name : UPDATE_ROW
84 -- Purpose : Procedure to update ASO_SUP_COMPONENT_B and ASO_SUP_COMPONENT_TL table
85 -- Type : Private
86 -- Pre-reqs : None
87 -- Parameters :
88 -- IN :
89 -- P_COPONENT_ID IN NUMBER Required
90 -- P_MANDATORY_FLAG IN VARCHAR2 Required DEFAULT 'N'
91 -- P_COMPONENT_NAME IN VARCHAR2 Required
92 -- OUT NOCOPY /* file.sql.39 change */ : None
93 -- Version :
94 -- Current version 1.0
95 -- Previous version 1.0
96 -- Initial version 1.0
97 -- End of comments
98 --------------------------------------------------------------------------------------
99
100
101
102 PROCEDURE UPDATE_ROW
103 (
104 P_COMPONENT_ID IN NUMBER,
105 P_last_updated_by IN NUMBER,
106 P_last_update_date IN DATE,
107 P_last_update_login IN NUMBER,
108 P_COMPONENT_TYPE IN VARCHAR2,
109 P_COMPONENT_NAME IN VARCHAR2,
110 P_MANDATORY_FLAG IN VARCHAR2 ,
111 P_RESPONSE_TYPE IN VARCHAR2 ,
112 P_DESCRIPTION IN VARCHAR2 ,
113 P_INSTRUCTION IN VARCHAR2 ,
114 P_CONTEXT IN VARCHAR2,
115 P_ATTRIBUTE1 IN VARCHAR2,
116 P_ATTRIBUTE2 IN VARCHAR2,
117 P_ATTRIBUTE3 IN VARCHAR2,
118 P_ATTRIBUTE4 IN VARCHAR2,
119 P_ATTRIBUTE5 IN VARCHAR2,
120 P_ATTRIBUTE6 IN VARCHAR2,
121 P_ATTRIBUTE7 IN VARCHAR2,
122 P_ATTRIBUTE8 IN VARCHAR2,
123 P_ATTRIBUTE9 IN VARCHAR2,
124 P_ATTRIBUTE10 IN VARCHAR2,
125 P_ATTRIBUTE11 IN VARCHAR2,
126 P_ATTRIBUTE12 IN VARCHAR2,
127 P_ATTRIBUTE13 IN VARCHAR2,
128 P_ATTRIBUTE14 IN VARCHAR2,
129 P_ATTRIBUTE15 IN VARCHAR2,
130 p_ATTRIBUTE16 VARCHAR2,
131 p_ATTRIBUTE17 VARCHAR2,
132 p_ATTRIBUTE18 VARCHAR2,
133 p_ATTRIBUTE19 VARCHAR2,
134 p_ATTRIBUTE20 VARCHAR2
135 );
136
137
138
139 --------------------------------------------------------------------------------------
140 -- API Signatures--
141 --------------------------------------------------------------------------------------
142 -- 3.
143 -- Start of comments
144 -- API name : DELETE_ROW
145 -- Purpose : Procedure to delete from ASO_SUP_COMPONENT_B and ASO_SUP_COMPONENT_TL table
146 -- Type : Private
147 -- Pre-reqs : None
148 -- Parameters :
149 -- IN :
150 -- P_COMPONENT_ID IN NUMBER Required
151
152 -- OUT NOCOPY /* file.sql.39 change */ : None
153 -- Version :
154 -- Current version 1.0
155 -- Previous version 1.0
156 -- Initial version 1.0
157 -- End of comments
158 --------------------------------------------------------------------------------------
159
160 procedure DELETE_ROW (
161 P_COMPONENT_ID IN NUMBER
162
163 );
164
165
166 --------------------------------------------------------------------------------------
167 -- API Signatures--
168 --------------------------------------------------------------------------------------
169 -- 4.
170 -- Start of comments
171 -- API name : LOCK_ROW
172 -- Purpose : Procedure to get publish history details.
173 -- Type : Private
174 -- Pre-reqs : None
175 -- Parameters :
176 -- IN : P_COMPONENT_ID IN NUMBER Required
177 -- P_COMPONENT_TYPE IN VARCHAR2 Required
178 -- P_MANDATORY_FLAG IN VARCHAR2 Required DEFAULT 'N'
179 -- P_COMPONENT_NAME IN VARCHAR2 Required
180 -- P_RESPONSE_TYPE IN VARCHAR2 Optional
181 --
182
183
184 -- OUT NOCOPY /* file.sql.39 change */ :
185
186 -- Version :
187 -- Current version 1.0
188 -- Previous version 1.0
189 -- Initial version 1.0
190 -- End of comments
191 --------------------------------------------------------------------------------------
192 PROCEDURE LOCK_ROW
193 (
194 P_COMPONENT_ID IN NUMBER,
195 P_created_by IN NUMBER ,
196 P_creation_date IN DATE ,
197 P_last_updated_by IN NUMBER,
198 P_last_update_date IN DATE,
199 P_last_update_login IN NUMBER,
200 P_COMPONENT_TYPE IN VARCHAR2,
201 P_COMPONENT_NAME IN VARCHAR2,
202 P_MANDATORY_FLAG IN VARCHAR2 ,
203 P_RESPONSE_TYPE IN VARCHAR2 ,
204 P_DESCRIPTION IN VARCHAR2 ,
205 P_INSTRUCTION IN VARCHAR2 ,
206 P_CONTEXT IN VARCHAR2,
207 P_ATTRIBUTE1 IN VARCHAR2,
208 P_ATTRIBUTE2 IN VARCHAR2,
209 P_ATTRIBUTE3 IN VARCHAR2,
210 P_ATTRIBUTE4 IN VARCHAR2,
211 P_ATTRIBUTE5 IN VARCHAR2,
212 P_ATTRIBUTE6 IN VARCHAR2,
213 P_ATTRIBUTE7 IN VARCHAR2,
214 P_ATTRIBUTE8 IN VARCHAR2,
215 P_ATTRIBUTE9 IN VARCHAR2,
216 P_ATTRIBUTE10 IN VARCHAR2,
217 P_ATTRIBUTE11 IN VARCHAR2,
218 P_ATTRIBUTE12 IN VARCHAR2,
219 P_ATTRIBUTE13 IN VARCHAR2,
220 P_ATTRIBUTE14 IN VARCHAR2,
221 P_ATTRIBUTE15 IN VARCHAR2
222 );
223
224
225 procedure ADD_LANGUAGE;
226
227
228 procedure TRANSLATE_ROW (
229 P_COMPONENT_ID IN NUMBER,
230 P_COMPONENT_NAME IN VARCHAR2,
231 P_DESCRIPTION in VARCHAR2,
232 P_INSTRUCTION IN VARCHAR2,
233 X_OWNER in VARCHAR2) ;
234
235 procedure LOAD_ROW (
236 P_COMPONENT_ID IN NUMBER,
237 P_created_by IN NUMBER ,
238 P_creation_date IN DATE ,
239 P_last_updated_by IN NUMBER,
240 P_last_update_date IN DATE,
241 P_last_update_login IN NUMBER,
242 P_COMPONENT_TYPE IN VARCHAR2,
243 P_COMPONENT_NAME IN VARCHAR2,
244 P_MANDATORY_FLAG IN VARCHAR2 DEFAULT 'N',
245 P_RESPONSE_TYPE IN VARCHAR2 DEFAULT NULL,
246 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
247 P_INSTRUCTION IN VARCHAR2 DEFAULT NULL,
248 P_CONTEXT IN VARCHAR2 DEFAULT NULL,
249 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
250 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
251 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
252 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
253 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
254 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
255 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
256 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
257 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
258 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
259 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
260 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
261 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
262 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
263 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
264 P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
265 P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
266 P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
267 P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
268 P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
269 X_OWNER IN VARCHAR2);
270
271 PROCEDURE LOAD_SEED_ROW (
272 P_COMPONENT_ID IN NUMBER,
273 P_COMPONENT_TYPE IN VARCHAR2,
274 P_COMPONENT_NAME IN VARCHAR2,
275 P_MANDATORY_FLAG IN VARCHAR2,
276 P_RESPONSE_TYPE IN VARCHAR2,
277 P_DESCRIPTION IN VARCHAR2,
278 P_INSTRUCTION IN VARCHAR2,
279 P_COMP_DISPLAY_SEQUENCE IN NUMBER,
280 P_COMP_SECTION_ID IN NUMBER,
281 P_PRESENTATION_STYLE IN VARCHAR2,
282 P_SECTION_COMPONENT_TYPE IN VARCHAR2,
283 P_Child_component_id IN NUMBER,
284 P_Sub_Section_id IN NUMBER,
285 P_Default_Response_id IN NUMBER,
286 p_context IN VARCHAR2,
287 P_OWNER IN VARCHAR2,
288 P_UPLOAD_MODE IN VARCHAR2,
289 P_ATTRIBUTE1 IN VARCHAR2,
290 P_ATTRIBUTE2 IN VARCHAR2,
291 P_ATTRIBUTE3 IN VARCHAR2,
292 P_ATTRIBUTE4 IN VARCHAR2,
293 P_ATTRIBUTE5 IN VARCHAR2,
294 P_ATTRIBUTE6 IN VARCHAR2,
295 P_ATTRIBUTE7 IN VARCHAR2,
296 P_ATTRIBUTE8 IN VARCHAR2,
297 P_ATTRIBUTE9 IN VARCHAR2,
298 P_ATTRIBUTE10 IN VARCHAR2,
299 P_ATTRIBUTE11 IN VARCHAR2,
300 P_ATTRIBUTE12 IN VARCHAR2,
301 P_ATTRIBUTE13 IN VARCHAR2,
302 P_ATTRIBUTE14 IN VARCHAR2,
303 P_ATTRIBUTE15 IN VARCHAR2,
304 P_ATTRIBUTE16 IN VARCHAR2,
305 P_ATTRIBUTE17 IN VARCHAR2,
306 P_ATTRIBUTE18 IN VARCHAR2,
307 P_ATTRIBUTE19 IN VARCHAR2,
308 P_ATTRIBUTE20 IN VARCHAR2
309 );
310
311 END; -- Package Specification ASO_SUP_COMPONENT_PKG