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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
255: p_end_time IN jtf_prefab_cache_stats.end_time%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,
255: p_end_time IN jtf_prefab_cache_stats.end_time%TYPE,
256:
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,
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,
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,
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,
258:
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,
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,
258:
259: x_return_status OUT NOCOPY VARCHAR2,
253: p_expiration_time IN jtf_prefab_cache_stats.expiration_time%TYPE,
254: p_start_time IN jtf_prefab_cache_stats.start_time%TYPE,
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,
258:
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2
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,
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,
274: p_num_cache_miss IN jtf_prefab_cache_stats.num_cache_miss%TYPE,
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,
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,
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,
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,
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,
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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%TYPE,
278: p_num_invalidations IN jtf_prefab_cache_stats.num_invalidations%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,
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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
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,
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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
273: p_jvm_id IN jtf_prefab_cache_stats.jvm_id%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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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:
276: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%TYPE,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
277: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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:
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,
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