1: PACKAGE JTF_PREFAB_STATISTICS_PUB AUTHID CURRENT_USER as
2: /* $Header: jtfprefabsts.pls 120.3 2005/10/28 00:23:12 emekala ship $ */
3:
4: PROCEDURE INSERT_STATISTICS(
5: p_api_version IN NUMBER,
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_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
8:
9: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
9: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
11: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
12: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
13: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
21: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
21: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
22: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
21: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
22: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
23: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
21: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
22: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
23: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
24:
17: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
21: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
22: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
23: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
24:
25: p_object_version_number OUT NOCOPY NUMBER,
18: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
21: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
22: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
23: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
24:
25: p_object_version_number OUT NOCOPY NUMBER,
26:
19: p_depth IN jtf_prefab_statistics.depth%TYPE,
20: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
21: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
22: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
23: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
24:
25: p_object_version_number OUT NOCOPY NUMBER,
26:
27: x_return_status OUT NOCOPY VARCHAR2,
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36:
37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
36:
37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
39: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
40: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
41: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
49: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
49: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
50: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
49: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
50: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
51: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
49: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
50: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
51: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
52:
45: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
49: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
50: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
51: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
52:
53: p_object_version_number IN OUT NOCOPY NUMBER,
46: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
49: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
50: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
51: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
52:
53: p_object_version_number IN OUT NOCOPY NUMBER,
54:
47: p_depth IN jtf_prefab_statistics.depth%TYPE,
48: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
49: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
50: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
51: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
52:
53: p_object_version_number IN OUT NOCOPY NUMBER,
54:
55: x_return_status OUT NOCOPY VARCHAR2,
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79:
80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79:
80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE,
79:
80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
79:
80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
93: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
93: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
94: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
93: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
94: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
95:
88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
93: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
94: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
95:
96: p_object_version_number OUT NOCOPY NUMBER,
89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
93: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
94: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
95:
96: p_object_version_number OUT NOCOPY NUMBER,
97: p_row_count OUT NOCOPY NUMBER,
90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
93: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
94: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
95:
96: p_object_version_number OUT NOCOPY NUMBER,
97: p_row_count OUT NOCOPY NUMBER,
98:
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2
102: );
103:
104: END JTF_PREFAB_STATISTICS_PUB;