[Home] [Help]
PACKAGE: APPS.JTF_PREFAB_STATISTICS_PUB
Source
1 PACKAGE JTF_PREFAB_STATISTICS_PUB 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,
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,
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,
24
25 p_object_version_number OUT NOCOPY NUMBER,
26
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE UPDATE_STATISTICS (
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,
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,
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,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE DELETE_STATISTICS (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64
65 p_policy_id IN NUMBER,
66 p_wsh_po_id IN NUMBER,
67
68 p_object_version_number IN NUMBER,
69
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE SELECT_STATISTICS(
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,
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,
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
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104 END JTF_PREFAB_STATISTICS_PUB;