1 Package ASO_SUP_RESPONSE_PKG AS
2 /* $Header: asospres.pls 120.1 2005/06/29 15:44:29 appldev ship $*/
3
4 -- Purpose: To Insert/Update/delete data for ASO_RESPONSE_B and ASO_RESPONSE_TL table for HTML Quoting
5 -- File name asospres.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_RESPONSE_B and ASO_RESPONSE_TL table
20 -- Type : Private
21 -- Pre-reqs : None
22 -- Parameters :
23 -- IN : P_RESPONSE_NAME IN VARCHAR2 Required
24
25
26 -- IN OUT NOCOPY /* file.sql.39 change */ : PX_RESPONSE_ID IN OUT NUMBER
27 -- Version :
28 -- Current version 1.0
29 -- Previous version 1.0
30 -- Initial version 1.0
31 -- End of comments
32 --------------------------------------------------------------------------------------
33
34
35 PROCEDURE INSERT_ROW
36 (
37 PX_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
38 PX_RESPONSE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
39 P_created_by IN NUMBER ,
40 P_creation_date IN DATE ,
41 P_last_updated_by IN NUMBER,
42 P_last_update_date IN DATE,
43 P_last_update_login IN NUMBER,
44 P_RESPONSE_NAME IN VARCHAR2,
45 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
46 P_CONTEXT IN VARCHAR2 DEFAULT NULL,
47 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
48 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
49 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
50 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
51 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
52 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
53 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
54 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
55 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
56 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
57 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
58 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
59 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
60 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
66 P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
67 );
68
69
70 --------------------------------------------------------------------------------------
71 -- API Signatures--
72 --------------------------------------------------------------------------------------
73 -- 2.
74 -- Start of comments
75 -- API name : UPDATE_ROW
76 -- Purpose : Procedure to update ASO_RESPONSE_B and ASO_RESPONSE_TL table
77 -- Type : Private
78 -- Pre-reqs : None
79 -- Parameters :
80 -- IN :
81 -- P_RESPONSE_ID IN NUMBER Required
82 -- P_RESPONSE_NAME IN VARCHAR2 Required
83 -- OUT NOCOPY /* file.sql.39 change */ : None
84 -- Version :
85 -- Current version 1.0
86 -- Previous version 1.0
87 -- Initial version 1.0
88 -- End of comments
89 --------------------------------------------------------------------------------------
90
91
92
93 PROCEDURE UPDATE_ROW
94 (
95 P_RESPONSE_ID IN NUMBER,
96 P_last_updated_by IN NUMBER,
97 P_last_update_date IN DATE,
98 P_last_update_login IN NUMBER,
99 P_RESPONSE_NAME IN VARCHAR2,
100 P_DESCRIPTION IN VARCHAR2,
101 P_CONTEXT IN VARCHAR2,
102 P_ATTRIBUTE1 IN VARCHAR2,
103 P_ATTRIBUTE2 IN VARCHAR2,
104 P_ATTRIBUTE3 IN VARCHAR2,
105 P_ATTRIBUTE4 IN VARCHAR2,
106 P_ATTRIBUTE5 IN VARCHAR2,
107 P_ATTRIBUTE6 IN VARCHAR2,
108 P_ATTRIBUTE7 IN VARCHAR2,
109 P_ATTRIBUTE8 IN VARCHAR2,
110 P_ATTRIBUTE9 IN VARCHAR2,
111 P_ATTRIBUTE10 IN VARCHAR2,
112 P_ATTRIBUTE11 IN VARCHAR2,
113 P_ATTRIBUTE12 IN VARCHAR2,
114 P_ATTRIBUTE13 IN VARCHAR2,
115 P_ATTRIBUTE14 IN VARCHAR2,
116 P_ATTRIBUTE15 IN VARCHAR2,
117 P_ATTRIBUTE16 IN VARCHAR2,
118 P_ATTRIBUTE17 IN VARCHAR2,
119 P_ATTRIBUTE18 IN VARCHAR2,
120 P_ATTRIBUTE19 IN VARCHAR2,
121 P_ATTRIBUTE20 IN VARCHAR2
122 );
123
124
125
126 --------------------------------------------------------------------------------------
127 -- API Signatures--
128 --------------------------------------------------------------------------------------
129 -- 3.
130 -- Start of comments
131 -- API name : DELETE_ROW
132 -- Purpose : Procedure to delete from ASO_RESPONSE_B and ASO_RESPONSE_TL table
133 -- Type : Private
134 -- Pre-reqs : None
135 -- Parameters :
136 -- IN :
137 -- P_RESPONSE_ID IN NUMBER Required
138
139 -- OUT NOCOPY /* file.sql.39 change */ : None
140 -- Version :
141 -- Current version 1.0
142 -- Previous version 1.0
143 -- Initial version 1.0
144 -- End of comments
145 --------------------------------------------------------------------------------------
146
147 procedure DELETE_ROW (
148 P_RESPONSE_ID IN NUMBER
149
150 );
151
152
153 --------------------------------------------------------------------------------------
154 -- API Signatures--
155 --------------------------------------------------------------------------------------
156 -- 4.
157 -- Start of comments
158 -- API name : LOCK_ROW
159 -- Purpose : Procedure to get publish history details.
160 -- Type : Private
161 -- Pre-reqs : None
162 -- Parameters :
163 -- IN : P_RESPONSE_ID IN NUMBER Required
164 -- P_RESPONSE_NAME IN VARCHAR2 Optional
165 --
166
167
168 -- OUT NOCOPY /* file.sql.39 change */ :
169
170 -- Version :
171 -- Current version 1.0
172 -- Previous version 1.0
173 -- Initial version 1.0
174 -- End of comments
175 --------------------------------------------------------------------------------------
176 PROCEDURE LOCK_ROW
177 (
178 P_RESPONSE_ID IN NUMBER,
179 P_created_by IN NUMBER ,
180 P_creation_date IN DATE ,
181 P_last_updated_by IN NUMBER,
182 P_last_update_date IN DATE,
183 P_last_update_login IN NUMBER,
184 P_RESPONSE_NAME IN VARCHAR2,
185 P_DESCRIPTION IN VARCHAR2,
186 P_CONTEXT IN VARCHAR2,
187 P_ATTRIBUTE1 IN VARCHAR2,
188 P_ATTRIBUTE2 IN VARCHAR2,
189 P_ATTRIBUTE3 IN VARCHAR2,
190 P_ATTRIBUTE4 IN VARCHAR2,
191 P_ATTRIBUTE5 IN VARCHAR2,
192 P_ATTRIBUTE6 IN VARCHAR2,
193 P_ATTRIBUTE7 IN VARCHAR2,
194 P_ATTRIBUTE8 IN VARCHAR2,
195 P_ATTRIBUTE9 IN VARCHAR2,
196 P_ATTRIBUTE10 IN VARCHAR2,
197 P_ATTRIBUTE11 IN VARCHAR2,
198 P_ATTRIBUTE12 IN VARCHAR2,
199 P_ATTRIBUTE13 IN VARCHAR2,
200 P_ATTRIBUTE14 IN VARCHAR2,
201 P_ATTRIBUTE15 IN VARCHAR2
202
203
204 );
205
206
207 procedure ADD_LANGUAGE;
208
209
210 procedure TRANSLATE_ROW (
211 P_RESPONSE_ID IN NUMBER,
212 P_RESPONSE_NAME IN VARCHAR2,
213 P_DESCRIPTION in VARCHAR2,
214 X_OWNER in VARCHAR2);
215
216 procedure LOAD_ROW (
217 P_RESPONSE_ID IN NUMBER,
218 P_created_by IN NUMBER ,
219 P_creation_date IN DATE ,
220 P_last_updated_by IN NUMBER,
221 P_last_update_date IN DATE,
222 P_last_update_login IN NUMBER,
223 P_RESPONSE_NAME IN VARCHAR2,
224 P_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
225 P_CONTEXT IN VARCHAR2 DEFAULT NULL,
226 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
227 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
228 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
229 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
230 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
231 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
232 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
233 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
234 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
235 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
236 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
237 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
238 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
239 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
240 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
241 P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
242 P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
243 P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
244 P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
245 P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
246 X_OWNER IN VARCHAR2);
247
248 PROCEDURE LOAD_SEED_ROW (
249 P_RESPONSE_ID IN NUMBER,
250 P_RESPONSE_NAME IN VARCHAR2,
251 P_DESCRIPTION IN VARCHAR2,
252 P_COMPONENT_ID IN NUMBER,
253 P_RESP_COMPONENT_ID IN NUMBER,
254 P_RESP_DISPLAY_SEQUENCE IN NUMBER,
255 p_context IN VARCHAR2,
256 P_OWNER IN VARCHAR2,
257 P_UPLOAD_MODE IN VARCHAR2,
258 P_ATTRIBUTE1 IN VARCHAR2,
259 P_ATTRIBUTE2 IN VARCHAR2,
260 P_ATTRIBUTE3 IN VARCHAR2,
261 P_ATTRIBUTE4 IN VARCHAR2,
262 P_ATTRIBUTE5 IN VARCHAR2,
263 P_ATTRIBUTE6 IN VARCHAR2,
264 P_ATTRIBUTE7 IN VARCHAR2,
265 P_ATTRIBUTE8 IN VARCHAR2,
266 P_ATTRIBUTE9 IN VARCHAR2,
267 P_ATTRIBUTE10 IN VARCHAR2,
268 P_ATTRIBUTE11 IN VARCHAR2,
269 P_ATTRIBUTE12 IN VARCHAR2,
270 P_ATTRIBUTE13 IN VARCHAR2,
271 P_ATTRIBUTE14 IN VARCHAR2,
272 P_ATTRIBUTE15 IN VARCHAR2,
273 P_ATTRIBUTE16 IN VARCHAR2,
274 P_ATTRIBUTE17 IN VARCHAR2,
275 P_ATTRIBUTE18 IN VARCHAR2,
276 P_ATTRIBUTE19 IN VARCHAR2,
277 P_ATTRIBUTE20 IN VARCHAR2
278 );
279
280 END; -- Package Specification ASO_SUP_RESPONSE_PKG