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