[Home] [Help]
PACKAGE: APPS.CS_TP_TEMPLATES_PVT_W
Source
1 package cs_tp_templates_pvt_w as
2 /* $Header: cstprtms.pls 120.2 2005/06/30 11:05 appldev ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_templates_pvt.template_list, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_1000
5 , a2 JTF_VARCHAR2_TABLE_200
6 , a3 JTF_VARCHAR2_TABLE_200
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_600
9 , a6 JTF_VARCHAR2_TABLE_200
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 );
13 procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_VARCHAR2_TABLE_1000
15 , a2 out nocopy JTF_VARCHAR2_TABLE_200
16 , a3 out nocopy JTF_VARCHAR2_TABLE_200
17 , a4 out nocopy JTF_VARCHAR2_TABLE_100
18 , a5 out nocopy JTF_VARCHAR2_TABLE_600
19 , a6 out nocopy JTF_VARCHAR2_TABLE_200
20 , a7 out nocopy JTF_VARCHAR2_TABLE_100
21 , a8 out nocopy JTF_VARCHAR2_TABLE_100
22 );
23
24 procedure rosetta_table_copy_in_p3(t out nocopy cs_tp_templates_pvt.template_attribute_list, a0 JTF_NUMBER_TABLE
25 , a1 JTF_VARCHAR2_TABLE_1000
26 , a2 JTF_NUMBER_TABLE
27 , a3 JTF_NUMBER_TABLE
28 , a4 JTF_VARCHAR2_TABLE_200
29 , a5 JTF_NUMBER_TABLE
30 , a6 JTF_VARCHAR2_TABLE_200
31 , a7 JTF_VARCHAR2_TABLE_200
32 );
33 procedure rosetta_table_copy_out_p3(t cs_tp_templates_pvt.template_attribute_list, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_VARCHAR2_TABLE_1000
35 , a2 out nocopy JTF_NUMBER_TABLE
36 , a3 out nocopy JTF_NUMBER_TABLE
37 , a4 out nocopy JTF_VARCHAR2_TABLE_200
38 , a5 out nocopy JTF_NUMBER_TABLE
39 , a6 out nocopy JTF_VARCHAR2_TABLE_200
40 , a7 out nocopy JTF_VARCHAR2_TABLE_200
41 );
42
43 procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE
44 , a1 JTF_VARCHAR2_TABLE_1000
45 , a2 JTF_VARCHAR2_TABLE_1000
46 , a3 JTF_VARCHAR2_TABLE_200
47 , a4 JTF_NUMBER_TABLE
48 , a5 JTF_VARCHAR2_TABLE_100
49 , a6 JTF_VARCHAR2_TABLE_100
50 , a7 JTF_VARCHAR2_TABLE_200
51 );
52 procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE
53 , a1 out nocopy JTF_VARCHAR2_TABLE_1000
54 , a2 out nocopy JTF_VARCHAR2_TABLE_1000
55 , a3 out nocopy JTF_VARCHAR2_TABLE_200
56 , a4 out nocopy JTF_NUMBER_TABLE
57 , a5 out nocopy JTF_VARCHAR2_TABLE_100
58 , a6 out nocopy JTF_VARCHAR2_TABLE_100
59 , a7 out nocopy JTF_VARCHAR2_TABLE_200
60 );
61
62 procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000
63 , a1 JTF_VARCHAR2_TABLE_1000
64 );
65 procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
66 , a1 out nocopy JTF_VARCHAR2_TABLE_1000
67 );
68
69 procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE
70 , a1 JTF_VARCHAR2_TABLE_100
71 , a2 JTF_VARCHAR2_TABLE_1000
72 );
73 procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
74 , a1 out nocopy JTF_VARCHAR2_TABLE_100
75 , a2 out nocopy JTF_VARCHAR2_TABLE_1000
76 );
77
78 procedure add_template(p_api_version_number NUMBER
79 , p_init_msg_list VARCHAR2
80 , p_commit VARCHAR
81 , x_msg_count out nocopy NUMBER
82 , x_msg_data out nocopy VARCHAR2
83 , x_return_status out nocopy VARCHAR2
84 , x_template_id out nocopy NUMBER
85 , p3_a0 NUMBER := 0-1962.0724
86 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
87 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
88 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
89 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
90 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
91 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
92 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
93 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
94 );
95 procedure update_template(p_api_version_number NUMBER
96 , p_init_msg_list VARCHAR2
97 , p_commit VARCHAR
98 , x_msg_count out nocopy NUMBER
99 , x_msg_data out nocopy VARCHAR2
100 , x_return_status out nocopy VARCHAR2
101 , p3_a0 NUMBER := 0-1962.0724
102 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
103 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
104 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
105 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
106 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
107 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
108 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
109 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
110 );
111 procedure update_template_attributes(p_api_version_number NUMBER
112 , p_init_msg_list VARCHAR2
113 , p_commit VARCHAR
114 , p_template_id NUMBER
115 , p4_a0 JTF_NUMBER_TABLE
116 , p4_a1 JTF_VARCHAR2_TABLE_1000
117 , p4_a2 JTF_NUMBER_TABLE
118 , p4_a3 JTF_NUMBER_TABLE
119 , p4_a4 JTF_VARCHAR2_TABLE_200
120 , p4_a5 JTF_NUMBER_TABLE
121 , p4_a6 JTF_VARCHAR2_TABLE_200
122 , p4_a7 JTF_VARCHAR2_TABLE_200
123 , x_msg_count out nocopy NUMBER
124 , x_msg_data out nocopy VARCHAR2
125 , x_return_status out nocopy VARCHAR2
126 );
127 procedure update_template_links(p_api_version_number NUMBER
128 , p_init_msg_list VARCHAR2
129 , p_commit VARCHAR
130 , p_template_id NUMBER
131 , p_jtf_object_code VARCHAR2
132 , p5_a0 JTF_NUMBER_TABLE
133 , p5_a1 JTF_VARCHAR2_TABLE_1000
134 , p5_a2 JTF_VARCHAR2_TABLE_1000
135 , p5_a3 JTF_VARCHAR2_TABLE_200
136 , p5_a4 JTF_NUMBER_TABLE
137 , p5_a5 JTF_VARCHAR2_TABLE_100
138 , p5_a6 JTF_VARCHAR2_TABLE_100
139 , p5_a7 JTF_VARCHAR2_TABLE_200
140 , x_msg_count out nocopy NUMBER
141 , x_msg_data out nocopy VARCHAR2
142 , x_return_status out nocopy VARCHAR2
143 );
144 procedure show_templates(p_api_version_number NUMBER
145 , p_init_msg_list VARCHAR2
146 , p_commit VARCHAR2
147 , p_template_name VARCHAR2
148 , p_start_template NUMBER
149 , p_end_template NUMBER
150 , p_display_order VARCHAR2
151 , x_msg_count out nocopy NUMBER
152 , x_msg_data out nocopy VARCHAR2
153 , x_return_status out nocopy VARCHAR2
154 , p10_a0 out nocopy JTF_NUMBER_TABLE
155 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
156 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
157 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
158 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
159 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600
160 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
161 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
162 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
163 , x_total_templates out nocopy NUMBER
164 , x_retrieved_template_num out nocopy NUMBER
165 );
166 procedure show_template(p_api_version_number NUMBER
167 , p_init_msg_list VARCHAR2
168 , p_commit VARCHAR
169 , p_template_id NUMBER
170 , x_msg_count out nocopy NUMBER
171 , x_msg_data out nocopy VARCHAR2
172 , x_return_status out nocopy VARCHAR2
173 , p7_a0 out nocopy NUMBER
174 , p7_a1 out nocopy VARCHAR2
175 , p7_a2 out nocopy VARCHAR2
176 , p7_a3 out nocopy VARCHAR2
177 , p7_a4 out nocopy VARCHAR2
178 , p7_a5 out nocopy VARCHAR2
179 , p7_a6 out nocopy VARCHAR2
180 , p7_a7 out nocopy VARCHAR2
181 , p7_a8 out nocopy VARCHAR2
182 );
183 procedure show_templates_with_link(p_api_version_number NUMBER
184 , p_init_msg_list VARCHAR2
185 , p_commit VARCHAR
186 , p3_a0 JTF_NUMBER_TABLE
187 , p3_a1 JTF_VARCHAR2_TABLE_100
188 , p3_a2 JTF_VARCHAR2_TABLE_1000
189 , x_msg_count out nocopy NUMBER
190 , x_msg_data out nocopy VARCHAR2
191 , x_return_status out nocopy VARCHAR2
192 , p7_a0 out nocopy JTF_NUMBER_TABLE
193 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
194 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
195 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
196 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
197 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600
198 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
199 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
200 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
201 );
202 procedure show_template_attributes(p_api_version_number NUMBER
203 , p_init_msg_list VARCHAR2
204 , p_commit VARCHAR
205 , p_template_id NUMBER
206 , p_jtf_object_code VARCHAR2
207 , x_msg_count out nocopy NUMBER
208 , x_msg_data out nocopy VARCHAR2
209 , x_return_status out nocopy VARCHAR2
210 , p8_a0 out nocopy JTF_NUMBER_TABLE
211 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
212 , p8_a2 out nocopy JTF_NUMBER_TABLE
213 , p8_a3 out nocopy JTF_NUMBER_TABLE
214 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_200
215 , p8_a5 out nocopy JTF_NUMBER_TABLE
216 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200
217 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
218 );
219 procedure show_template_links(p_api_version_number NUMBER
220 , p_init_msg_list VARCHAR2
221 , p_commit VARCHAR
222 , p_template_id NUMBER
223 , p_jtf_object_code VARCHAR2
224 , x_msg_count out nocopy NUMBER
225 , x_msg_data out nocopy VARCHAR2
226 , x_return_status out nocopy VARCHAR2
227 , p8_a0 out nocopy JTF_NUMBER_TABLE
228 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
229 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
230 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
231 , p8_a4 out nocopy JTF_NUMBER_TABLE
232 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
233 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
234 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
235 );
236 procedure show_non_asso_links(p_api_version_number NUMBER
237 , p_init_msg_list VARCHAR2
238 , p_commit VARCHAR
239 , p_template_id NUMBER
240 , p_jtf_object_code VARCHAR2
241 , x_msg_count out nocopy NUMBER
242 , x_msg_data out nocopy VARCHAR2
243 , x_return_status out nocopy VARCHAR2
244 , p8_a0 out nocopy JTF_NUMBER_TABLE
245 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
246 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
247 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
248 , p8_a4 out nocopy JTF_NUMBER_TABLE
249 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
250 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
251 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
252 );
253 procedure show_link_attribute_list(p_api_version_number NUMBER
254 , p_init_msg_list VARCHAR2
255 , p_commit VARCHAR2
256 , p_identify VARCHAR2
257 , x_msg_count out nocopy NUMBER
258 , x_msg_data out nocopy VARCHAR2
259 , x_return_status out nocopy VARCHAR2
260 , p7_a0 out nocopy JTF_VARCHAR2_TABLE_1000
261 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
262 );
263 procedure retrieve_constants(p_api_version_number NUMBER
264 , p_init_msg_list VARCHAR2
265 , p_commit VARCHAR2
266 , x_msg_count out nocopy NUMBER
267 , x_msg_data out nocopy VARCHAR2
268 , x_return_status out nocopy VARCHAR2
269 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
270 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000
271 );
272 procedure show_default_template(p_api_version_number NUMBER
273 , p_init_msg_list VARCHAR2
274 , p_commit VARCHAR2
275 , x_msg_count out nocopy NUMBER
276 , x_msg_data out nocopy VARCHAR2
277 , x_return_status out nocopy VARCHAR2
278 , p6_a0 out nocopy NUMBER
279 , p6_a1 out nocopy VARCHAR2
280 , p6_a2 out nocopy VARCHAR2
281 , p6_a3 out nocopy VARCHAR2
282 , p6_a4 out nocopy VARCHAR2
283 , p6_a5 out nocopy VARCHAR2
284 , p6_a6 out nocopy VARCHAR2
285 , p6_a7 out nocopy VARCHAR2
286 , p6_a8 out nocopy VARCHAR2
287 );
288 procedure show_template_links_two(p_api_version_number NUMBER
289 , p_init_msg_list VARCHAR2
290 , p_commit VARCHAR
291 , p_template_id NUMBER
292 , p_jtf_object_code VARCHAR2
293 , p_start_link NUMBER
294 , p_end_link NUMBER
295 , x_msg_count out nocopy NUMBER
296 , x_msg_data out nocopy VARCHAR2
297 , x_return_status out nocopy VARCHAR2
298 , p10_a0 out nocopy JTF_NUMBER_TABLE
299 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
300 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000
301 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
302 , p10_a4 out nocopy JTF_NUMBER_TABLE
303 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
304 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
305 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
306 , x_total_link_number out nocopy NUMBER
307 , x_retrieved_link_number out nocopy NUMBER
308 );
309 procedure show_non_asso_links_two(p_api_version_number NUMBER
310 , p_init_msg_list VARCHAR2
311 , p_commit VARCHAR
312 , p_template_id NUMBER
313 , p_jtf_object_code VARCHAR2
314 , p_start_link NUMBER
315 , p_end_link NUMBER
316 , p_link_name VARCHAR2
317 , x_msg_count out nocopy NUMBER
318 , x_msg_data out nocopy VARCHAR2
319 , x_return_status out nocopy VARCHAR2
320 , p11_a0 out nocopy JTF_NUMBER_TABLE
321 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_1000
322 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000
323 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200
324 , p11_a4 out nocopy JTF_NUMBER_TABLE
325 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
326 , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
327 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200
328 , x_total_link_number out nocopy NUMBER
329 , x_retrieved_link_number out nocopy NUMBER
330 );
331 procedure delete_template_links(p_api_version_number NUMBER
332 , p_init_msg_list VARCHAR2
333 , p_commit VARCHAR
334 , p_template_id NUMBER
335 , p_jtf_object_code VARCHAR2
336 , p5_a0 JTF_NUMBER_TABLE
337 , p5_a1 JTF_VARCHAR2_TABLE_1000
338 , p5_a2 JTF_VARCHAR2_TABLE_1000
339 , p5_a3 JTF_VARCHAR2_TABLE_200
340 , p5_a4 JTF_NUMBER_TABLE
341 , p5_a5 JTF_VARCHAR2_TABLE_100
342 , p5_a6 JTF_VARCHAR2_TABLE_100
343 , p5_a7 JTF_VARCHAR2_TABLE_200
344 , x_msg_count out nocopy NUMBER
345 , x_msg_data out nocopy VARCHAR2
346 , x_return_status out nocopy VARCHAR2
347 );
348 procedure add_template_links(p_api_version_number NUMBER
349 , p_init_msg_list VARCHAR2
350 , p_commit VARCHAR
351 , p_template_id NUMBER
352 , p_jtf_object_code VARCHAR2
353 , p5_a0 JTF_NUMBER_TABLE
354 , p5_a1 JTF_VARCHAR2_TABLE_1000
355 , p5_a2 JTF_VARCHAR2_TABLE_1000
356 , p5_a3 JTF_VARCHAR2_TABLE_200
357 , p5_a4 JTF_NUMBER_TABLE
358 , p5_a5 JTF_VARCHAR2_TABLE_100
359 , p5_a6 JTF_VARCHAR2_TABLE_100
360 , p5_a7 JTF_VARCHAR2_TABLE_200
361 , x_msg_count out nocopy NUMBER
362 , x_msg_data out nocopy VARCHAR2
363 , x_return_status out nocopy VARCHAR2
364 );
365 end cs_tp_templates_pvt_w;