eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JTF_PREFAB_CACHE_PUB

Source


4 PROCEDURE INSERT_HOST_APP(
1 PACKAGE JTF_PREFAB_CACHE_PUB AUTHID CURRENT_USER as
2 /* $Header: jtfprefabcas.pls 120.4 2006/09/15 13:04:34 amaddula ship $ */
3 
5   p_api_version         IN      NUMBER,
6   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
7   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
8 
9   p_host_app_id         OUT  NOCOPY   jtf_prefab_host_apps.host_app_id%TYPE,
10   p_wsh_po_id           IN      jtf_prefab_host_apps.wsh_po_id%TYPE,
11   p_application_id      IN      jtf_prefab_host_apps.application_id%TYPE,
12   p_cache_policy        IN      jtf_prefab_host_apps.cache_policy%TYPE,
13   p_cache_clear_flag    IN      jtf_prefab_host_apps.cache_clear_flag%TYPE,
14   p_cache_reload_flag   IN      jtf_prefab_host_apps.cache_reload_flag%TYPE,
15   p_cache_filter_policy IN      jtf_prefab_host_apps.cache_filter_policy%TYPE,
16 
17   p_object_version_number OUT  NOCOPY  jtf_prefab_host_apps.object_version_number%TYPE,
18 
19   x_return_status       OUT  NOCOPY   VARCHAR2,
20   x_msg_count           OUT  NOCOPY   NUMBER,
21   x_msg_data            OUT  NOCOPY   VARCHAR2
22 );
23 
24 PROCEDURE UPDATE_HOST_APP(
25   p_api_version         IN      NUMBER,
26   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
27   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
28 
29   p_host_app_id         IN      jtf_prefab_host_apps.host_app_id%TYPE,
30   p_cache_policy        IN      jtf_prefab_host_apps.cache_policy%TYPE,
31   p_cache_clear_flag    IN      jtf_prefab_host_apps.cache_clear_flag%TYPE,
32   p_cache_reload_flag   IN      jtf_prefab_host_apps.cache_reload_flag%TYPE,
33   p_cache_filter_policy IN      jtf_prefab_host_apps.cache_filter_policy%TYPE,
34 
35   p_object_version_number IN OUT  NOCOPY  jtf_prefab_host_apps.object_version_number%TYPE,
36 
37   x_return_status       OUT  NOCOPY   VARCHAR2,
38   x_msg_count           OUT  NOCOPY   NUMBER,
39   x_msg_data            OUT  NOCOPY   VARCHAR2
40 );
41 
42 procedure SELECT_HOST_APP_FOR_HOST(
43   p_api_version         IN      NUMBER,
44   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
45   p_host_app_id         IN      jtf_prefab_host_apps.host_app_id%TYPE,
46 
47   p_object_version_number OUT  NOCOPY  jtf_prefab_host_apps.object_version_number%TYPE,
48   p_wsh_po_id           OUT  NOCOPY    jtf_prefab_host_apps.wsh_po_id%TYPE,
49   p_application_id      OUT  NOCOPY    jtf_prefab_host_apps.application_id%TYPE,
53   p_cache_filter_policy OUT  NOCOPY    jtf_prefab_host_apps.cache_filter_policy%TYPE,
50   p_cache_policy        OUT  NOCOPY    jtf_prefab_host_apps.cache_policy%TYPE,
51   p_cache_clear_flag    OUT  NOCOPY    jtf_prefab_host_apps.cache_clear_flag%TYPE,
52   p_cache_reload_flag   OUT  NOCOPY    jtf_prefab_host_apps.cache_reload_flag%TYPE,
54   p_hostname            OUT  NOCOPY    jtf_prefab_wsh_poes_b.hostname%TYPE,
55   p_appname             OUT  NOCOPY    fnd_application_vl.application_name%TYPE,
56   p_app_short_name      OUT  NOCOPY    fnd_application_vl.application_short_name%TYPE,
57 
58   x_return_status       OUT  NOCOPY   VARCHAR2,
59   x_msg_count           OUT  NOCOPY   NUMBER,
60   x_msg_data            OUT  NOCOPY   VARCHAR2
61 );
62 
63 procedure DELETE_HOST_APP(
64   p_api_version         IN      NUMBER,
65   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
66   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
67 
68   p_host_app_id         IN      jtf_prefab_host_apps.host_app_id%TYPE,
69 
70   p_object_version_number IN    jtf_prefab_host_apps.object_version_number%TYPE,
71 
72   x_return_status       OUT  NOCOPY   VARCHAR2,
73   x_msg_count           OUT  NOCOPY   NUMBER,
74   x_msg_data            OUT  NOCOPY   VARCHAR2
75 );
76 
77 procedure DELETE_HOST_APPS_FOR_HOST(
78   p_api_version         IN      NUMBER,
79   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
80   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
81 
82   p_wsh_po_id           IN      jtf_prefab_host_apps.wsh_po_id%TYPE,
83 
84   p_object_version_number IN    jtf_prefab_host_apps.object_version_number%TYPE,
85 
86   x_return_status       OUT  NOCOPY   VARCHAR2,
87   x_msg_count           OUT  NOCOPY   NUMBER,
88   x_msg_data            OUT  NOCOPY   VARCHAR2
89 );
90 
91 PROCEDURE INSERT_CACHE_COMP(
92   p_api_version         IN      NUMBER,
93   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
94   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
95 
96   p_ca_comp_id          OUT  NOCOPY   jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
97   p_application_id      IN      jtf_prefab_ca_comps_b.application_id%TYPE,
98   p_comp_name           IN      jtf_prefab_ca_comps_b.comp_name%TYPE,
99   p_description         IN      jtf_prefab_ca_comps_tl.description%TYPE,
100   p_component_key       IN      jtf_prefab_ca_comps_b.component_key%TYPE,
101   p_loader_class_name   IN      jtf_prefab_ca_comps_b.loader_class_name%TYPE,
102   p_timeout_type        IN      jtf_prefab_ca_comps_b.timeout_type%TYPE,
103   p_timeout             IN      jtf_prefab_ca_comps_b.timeout%TYPE,
104   p_timeout_unit        IN      jtf_prefab_ca_comps_b.timeout_unit%TYPE,
105   p_sgid_enabled_flag   IN      jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
106   p_stat_enabled_flag   IN      jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
107   p_distributed_flag    IN      jtf_prefab_ca_comps_b.distributed_flag%TYPE,
108   p_cache_generic_flag  IN      jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
109   p_business_event_name IN      jtf_prefab_ca_comps_b.business_event_name%TYPE,
110 
111   p_object_version_number OUT  NOCOPY  jtf_prefab_ca_comps_b.object_version_number%TYPE,
112 
113   x_return_status       OUT  NOCOPY   VARCHAR2,
114   x_msg_count           OUT  NOCOPY   NUMBER,
115   x_msg_data            OUT  NOCOPY   VARCHAR2
116 );
117 
118 PROCEDURE UPDATE_CACHE_COMP(
119   p_api_version         IN      NUMBER,
120   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
121   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
122 
123   p_ca_comp_id          IN      jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
124   p_application_id      IN      jtf_prefab_ca_comps_b.application_id%TYPE,
125   p_comp_name           IN      jtf_prefab_ca_comps_b.comp_name%TYPE,
126   p_description         IN      jtf_prefab_ca_comps_tl.description%TYPE,
127   p_component_key       IN      jtf_prefab_ca_comps_b.component_key%TYPE,
128   p_loader_class_name   IN      jtf_prefab_ca_comps_b.loader_class_name%TYPE,
129   p_timeout_type        IN      jtf_prefab_ca_comps_b.timeout_type%TYPE,
130   p_timeout             IN      jtf_prefab_ca_comps_b.timeout%TYPE,
131   p_timeout_unit        IN      jtf_prefab_ca_comps_b.timeout_unit%TYPE,
132   p_sgid_enabled_flag   IN      jtf_prefab_ca_comps_b.sgid_enabled_flag%TYPE,
133   p_stat_enabled_flag   IN      jtf_prefab_ca_comps_b.stat_enabled_flag%TYPE,
139 
134   p_distributed_flag    IN      jtf_prefab_ca_comps_b.distributed_flag%TYPE,
135   p_cache_generic_flag  IN      jtf_prefab_ca_comps_b.cache_generic_flag%TYPE,
136   p_business_event_name IN      jtf_prefab_ca_comps_b.business_event_name%TYPE,
137 
138   p_object_version_number IN OUT  NOCOPY  jtf_prefab_ca_comps_b.object_version_number%TYPE,
140   x_return_status       OUT  NOCOPY   VARCHAR2,
141   x_msg_count           OUT  NOCOPY   NUMBER,
142   x_msg_data            OUT  NOCOPY   VARCHAR2
143 );
144 
145 PROCEDURE UPDATE_CACHE_COMP_1(
146   p_api_version         IN      NUMBER,
147   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
148   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
149 
150   p_ca_comp_id          IN      jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
151 
152 --  p_object_version_number IN OUT jtf_prefab_ca_comps_b.object_version_number%TYPE,
153 
154   x_return_status       OUT  NOCOPY   VARCHAR2,
155   x_msg_count           OUT  NOCOPY   NUMBER,
156   x_msg_data            OUT  NOCOPY   VARCHAR2
157 );
158 
159 procedure DELETE_CACHE_COMP(
160   p_api_version         IN      NUMBER,
161   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
162   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
163 
164   p_ca_comp_id          IN      jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
165 
166   p_object_version_number IN    jtf_prefab_ca_comps_b.object_version_number%TYPE,
167 
168   x_return_status       OUT  NOCOPY   VARCHAR2,
169   x_msg_count           OUT  NOCOPY   NUMBER,
170   x_msg_data            OUT  NOCOPY   VARCHAR2
171 );
172 
173 PROCEDURE INSERT_HA_COMP(
174   p_api_version         IN      NUMBER,
175   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
176   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
177 
178   p_ha_comp_id          OUT  NOCOPY   jtf_prefab_ha_comps.ha_comp_id%TYPE,
179   p_host_app_id         IN      jtf_prefab_ha_comps.host_app_id%TYPE,
180   p_ca_comp_id          IN      jtf_prefab_ha_comps.ca_comp_id%TYPE,
181   p_cache_policy        IN      jtf_prefab_ha_comps.cache_policy%TYPE,
182   p_cache_clear_flag    IN      jtf_prefab_ha_comps.cache_clear_flag%TYPE,
183   p_cache_reload_flag   IN      jtf_prefab_ha_comps.cache_reload_flag%TYPE,
184 
185   p_object_version_number OUT  NOCOPY jtf_prefab_ha_comps.object_version_number%TYPE,
186 
187   x_return_status       OUT  NOCOPY   VARCHAR2,
188   x_msg_count           OUT  NOCOPY   NUMBER,
189   x_msg_data            OUT  NOCOPY   VARCHAR2
190 );
191 
192 PROCEDURE UPDATE_HA_COMP(
193   p_api_version         IN      NUMBER,
194   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
195   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
196 
197   p_ha_comp_id          IN      jtf_prefab_ha_comps.ha_comp_id%TYPE,
198   p_cache_policy        IN      jtf_prefab_ha_comps.cache_policy%TYPE,
199   p_cache_clear_flag    IN      jtf_prefab_ha_comps.cache_clear_flag%TYPE,
200   p_cache_reload_flag   IN      jtf_prefab_ha_comps.cache_reload_flag%TYPE,
201 
202   p_object_version_number IN OUT  NOCOPY  jtf_prefab_ha_comps.object_version_number%TYPE,
203 
204   x_return_status       OUT  NOCOPY   VARCHAR2,
205   x_msg_count           OUT  NOCOPY   NUMBER,
206   x_msg_data            OUT  NOCOPY   VARCHAR2
207 );
208 
209 procedure DELETE_HA_COMPS_FOR_HOST_APP(
210   p_api_version         IN      NUMBER,
211   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
212   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
213 
214   p_host_app_id         IN      jtf_prefab_ha_comps.host_app_id%TYPE,
215 
216   p_object_version_number IN    jtf_prefab_ha_comps.object_version_number%TYPE,
217 
218   x_return_status       OUT  NOCOPY   VARCHAR2,
219   x_msg_count           OUT  NOCOPY   NUMBER,
220   x_msg_data            OUT  NOCOPY   VARCHAR2
221 );
222 
223 procedure DELETE_HA_COMPS_FOR_CACHE_COMP(
224   p_api_version         IN      NUMBER,
225   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
226   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
227 
228   p_ca_comp_id          IN      jtf_prefab_ha_comps.ca_comp_id%TYPE,
229 
230   p_object_version_number IN    jtf_prefab_ha_comps.object_version_number%TYPE,
231 
232   x_return_status       OUT   NOCOPY  VARCHAR2,
233   x_msg_count           OUT   NOCOPY  NUMBER,
234   x_msg_data            OUT   NOCOPY  VARCHAR2
235 );
236 
237 PROCEDURE INSERT_CACHE_STAT(
238   p_api_version         IN      NUMBER,
239   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
240   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
241 
242   p_cache_stat_id       OUT  NOCOPY   jtf_prefab_cache_stats.cache_stat_id%TYPE,
243   p_security_group_id   IN      jtf_prefab_cache_stats.security_group_id%TYPE,
244   p_wsh_po_id           IN      jtf_prefab_cache_stats.wsh_po_id%TYPE,
245   p_ca_comp_id          IN      jtf_prefab_cache_stats.ca_comp_id%TYPE,
246   p_jvm_id              IN      jtf_prefab_cache_stats.jvm_id%TYPE,
247   p_num_cache_miss      IN      jtf_prefab_cache_stats.num_cache_miss%TYPE,
248   p_num_cache_hit       IN      jtf_prefab_cache_stats.num_cache_hit%TYPE,
249   p_num_loader_miss     IN      jtf_prefab_cache_stats.num_loader_miss%TYPE,
250   p_num_invalidate_call IN      jtf_prefab_cache_stats.num_invalidate_call%TYPE,
251   p_num_invalidations   IN      jtf_prefab_cache_stats.num_invalidations%TYPE,
252   p_num_objects         IN      jtf_prefab_cache_stats.num_objects%TYPE,
253   p_expiration_time     IN      jtf_prefab_cache_stats.expiration_time%TYPE,
254   p_start_time          IN      jtf_prefab_cache_stats.start_time%TYPE,
258 
255   p_end_time            IN      jtf_prefab_cache_stats.end_time%TYPE,
256 
257   p_object_version_number OUT  NOCOPY  jtf_prefab_cache_stats.object_version_number%TYPE,
259   x_return_status       OUT  NOCOPY   VARCHAR2,
260   x_msg_count           OUT  NOCOPY   NUMBER,
261   x_msg_data            OUT  NOCOPY   VARCHAR2
262 );
263 
264 PROCEDURE UPDATE_CACHE_STAT(
265   p_api_version         IN      NUMBER,
266   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
267   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
268 
269   p_cache_stat_id       IN      jtf_prefab_cache_stats.cache_stat_id%TYPE,
270   p_security_group_id   IN      jtf_prefab_cache_stats.security_group_id%TYPE,
271   p_wsh_po_id           IN      jtf_prefab_cache_stats.wsh_po_id%TYPE,
272   p_ca_comp_id          IN      jtf_prefab_cache_stats.ca_comp_id%TYPE,
273   p_jvm_id              IN      jtf_prefab_cache_stats.jvm_id%TYPE,
277   p_num_invalidate_call IN      jtf_prefab_cache_stats.num_invalidate_call%TYPE,
274   p_num_cache_miss      IN      jtf_prefab_cache_stats.num_cache_miss%TYPE,
275   p_num_cache_hit       IN      jtf_prefab_cache_stats.num_cache_hit%TYPE,
276   p_num_loader_miss     IN      jtf_prefab_cache_stats.num_loader_miss%TYPE,
278   p_num_invalidations   IN      jtf_prefab_cache_stats.num_invalidations%TYPE,
279   p_num_objects         IN      jtf_prefab_cache_stats.num_objects%TYPE,
280   p_expiration_time     IN      jtf_prefab_cache_stats.expiration_time%TYPE,
281   p_start_time          IN      jtf_prefab_cache_stats.start_time%TYPE,
282   p_end_time            IN      jtf_prefab_cache_stats.end_time%TYPE,
283 
284   p_object_version_number IN OUT  NOCOPY  jtf_prefab_cache_stats.object_version_number%TYPE,
285 
286   x_return_status       OUT  NOCOPY   VARCHAR2,
287   x_msg_count           OUT  NOCOPY   NUMBER,
288   x_msg_data            OUT  NOCOPY   VARCHAR2
289 );
290 
291 procedure DELETE_CACHE_STAT(
292   p_api_version         IN      NUMBER,
293   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
294   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
295 
296   x_return_status       OUT  NOCOPY   VARCHAR2,
297   x_msg_count           OUT  NOCOPY   NUMBER,
298   x_msg_data            OUT  NOCOPY   VARCHAR2
299 );
300 
301 procedure RESET_CACHE_STAT(
302   p_api_version         IN      NUMBER,
303   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
304   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
305   p_wsh_po_id           IN      NUMBER,
306   p_ca_comp_id          IN      NUMBER,
307   x_return_status       OUT  NOCOPY   VARCHAR2,
308   x_msg_count           OUT  NOCOPY   NUMBER,
309   x_msg_data            OUT  NOCOPY   VARCHAR2
310 );
311 
312 PROCEDURE INSERT_CA_FILTER(
313   p_api_version         IN      NUMBER,
314   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
315   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
316 
317   p_ca_filter_id        OUT  NOCOPY   jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
318   p_application_id      IN      jtf_prefab_ca_filters_b.application_id%TYPE,
319   p_ca_filter_name      IN      jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
320   p_description         IN      jtf_prefab_ca_filters_tl.description%TYPE,
321 
322   p_object_version_number OUT  NOCOPY  jtf_prefab_ca_filters_b.object_version_number%TYPE,
323 
324   x_return_status       OUT  NOCOPY   VARCHAR2,
325   x_msg_count           OUT  NOCOPY   NUMBER,
326   x_msg_data            OUT  NOCOPY   VARCHAR2
327 );
328 
329 PROCEDURE UPDATE_CA_FILTER(
330   p_api_version         IN      NUMBER,
331   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
332   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
333 
334   p_ca_filter_id        IN      jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
335   p_application_id      IN      jtf_prefab_ca_filters_b.application_id%TYPE,
339   p_object_version_number IN OUT  NOCOPY  jtf_prefab_ca_filters_b.object_version_number%TYPE,
336   p_ca_filter_name      IN      jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
337   p_description         IN      jtf_prefab_ca_filters_tl.description%TYPE,
338 
340 
341   x_return_status       OUT  NOCOPY   VARCHAR2,
342   x_msg_count           OUT  NOCOPY   NUMBER,
343   x_msg_data            OUT  NOCOPY   VARCHAR2
344 );
345 
346 procedure DELETE_CA_FILTER(
347   p_api_version         IN      NUMBER,
348   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
349   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
350 
351   p_ca_filter_id        IN      jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
352 
353   p_object_version_number IN    jtf_prefab_ca_filters_b.object_version_number%TYPE,
354 
355   x_return_status       OUT  NOCOPY   VARCHAR2,
356   x_msg_count           OUT  NOCOPY   NUMBER,
357   x_msg_data            OUT  NOCOPY   VARCHAR2
358 );
359 
360 PROCEDURE INSERT_HA_FILTER(
361   p_api_version         IN      NUMBER,
362   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
363   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
364 
365   p_ha_filter_id        OUT  NOCOPY   jtf_prefab_ha_filters.ha_filter_id%TYPE,
366   p_host_app_id         IN      jtf_prefab_ha_filters.host_app_id%TYPE,
367   p_ca_filter_id        IN      jtf_prefab_ha_filters.ca_filter_id%TYPE,
368   p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
369 
370   p_object_version_number OUT  NOCOPY  jtf_prefab_ha_filters.object_version_number%TYPE,
371 
372   x_return_status       OUT  NOCOPY   VARCHAR2,
373   x_msg_count           OUT  NOCOPY   NUMBER,
374   x_msg_data            OUT  NOCOPY   VARCHAR2
375 );
376 
377 PROCEDURE UPDATE_HA_FILTER(
378   p_api_version         IN      NUMBER,
379   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
380   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
381 
382   p_ha_filter_id        IN      jtf_prefab_ha_filters.ha_filter_id%TYPE,
383   p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
384 
385   p_object_version_number IN OUT  NOCOPY  jtf_prefab_ha_filters.object_version_number%TYPE,
386 
387   x_return_status       OUT  NOCOPY   VARCHAR2,
388   x_msg_count           OUT  NOCOPY   NUMBER,
389   x_msg_data            OUT  NOCOPY   VARCHAR2
390 );
391 
392 procedure DELETE_HA_FILTERS_F_HOST_APP(
393   p_api_version         IN      NUMBER,
394   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
395   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
396 
397   p_host_app_id         IN      jtf_prefab_ha_filters.host_app_id%TYPE,
398 
399   p_object_version_number IN    jtf_prefab_ha_filters.object_version_number%TYPE,
400 
401   x_return_status       OUT  NOCOPY   VARCHAR2,
402   x_msg_count           OUT  NOCOPY   NUMBER,
403   x_msg_data            OUT  NOCOPY   VARCHAR2
404 );
405 
406 procedure DELETE_HA_FILTERS_F_CA_FILTER(
407   p_api_version         IN      NUMBER,
408   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
409   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
410 
411   p_ca_filter_id        IN      jtf_prefab_ha_filters.ca_filter_id%TYPE,
412 
413   p_object_version_number IN    jtf_prefab_ha_filters.object_version_number%TYPE,
414 
415   x_return_status       OUT  NOCOPY   VARCHAR2,
416   x_msg_count           OUT  NOCOPY   NUMBER,
417   x_msg_data            OUT  NOCOPY   VARCHAR2
418 );
419 
420 PROCEDURE INSERT_CA_FL_RESP(
421   p_api_version         IN      NUMBER,
425   p_ca_fl_resp_id       OUT  NOCOPY   jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,
422   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
423   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
424 
426   p_ca_filter_id        IN      jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
427   p_responsibility_id   IN      jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
428 
429   p_object_version_number OUT  NOCOPY jtf_prefab_ca_fl_resps.object_version_number%TYPE,
430 
431   x_return_status       OUT  NOCOPY   VARCHAR2,
432   x_msg_count           OUT  NOCOPY   NUMBER,
433   x_msg_data            OUT  NOCOPY   VARCHAR2
434 );
435 
436 procedure DELETE_CA_FL_RESP(
437   p_api_version         IN      NUMBER,
438   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
439   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
440 
441   p_ca_filter_id           IN      jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
442 
443   p_object_version_number IN    jtf_prefab_ca_fl_resps.object_version_number%TYPE,
444 
445   x_return_status       OUT  NOCOPY   VARCHAR2,
446   x_msg_count           OUT  NOCOPY   NUMBER,
447   x_msg_data            OUT  NOCOPY   VARCHAR2
448 );
449 
450 procedure DELETE_CA_FL_RESP(
451   p_api_version         IN      NUMBER,
452   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
453   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
454 
455   p_ca_filter_id        IN      jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
456   p_responsibility_id   IN      jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
457 
458   p_object_version_number IN    jtf_prefab_ca_fl_resps.object_version_number%TYPE,
459 
460   x_return_status       OUT  NOCOPY   VARCHAR2,
461   x_msg_count           OUT  NOCOPY   NUMBER,
462   x_msg_data            OUT  NOCOPY   VARCHAR2
463 );
464 
465 PROCEDURE INSERT_CA_FL_LANG(
466   p_api_version         IN      NUMBER,
467   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
468   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
469 
470   p_ca_fl_lang_id       OUT  NOCOPY   jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,
471   p_ca_filter_id        IN      jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
472   p_language_code       IN      jtf_prefab_ca_fl_langs.language_code%TYPE,
473 
474   p_object_version_number OUT  NOCOPY jtf_prefab_ca_fl_langs.object_version_number%TYPE,
475 
476   x_return_status       OUT  NOCOPY   VARCHAR2,
477   x_msg_count           OUT  NOCOPY   NUMBER,
478   x_msg_data            OUT  NOCOPY   VARCHAR2
479 );
480 
481 procedure DELETE_CA_FL_LANG(
482   p_api_version         IN      NUMBER,
483   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
484   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
485 
486   p_ca_filter_id           IN      jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
487 
488   p_object_version_number IN    jtf_prefab_ca_fl_langs.object_version_number%TYPE,
489 
490   x_return_status       OUT  NOCOPY   VARCHAR2,
491   x_msg_count           OUT  NOCOPY   NUMBER,
492   x_msg_data            OUT  NOCOPY   VARCHAR2
493 );
494 
495 procedure DELETE_CA_FL_LANG(
496   p_api_version         IN      NUMBER,
497   p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
498   p_commit              IN      VARCHAR2        := FND_API.G_FALSE,
499 
500   p_ca_filter_id        IN      jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
501   p_language_code       IN      jtf_prefab_ca_fl_langs.language_code%TYPE,
502 
503   p_object_version_number IN    jtf_prefab_ca_fl_langs.object_version_number%TYPE,
504 
505   x_return_status       OUT  NOCOPY   VARCHAR2,
506   x_msg_count           OUT  NOCOPY   NUMBER,
507   x_msg_data            OUT  NOCOPY   VARCHAR2
508 );
509 
510 END JTF_PREFAB_CACHE_PUB;