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