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_STATISTICS_PUB

Source


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,
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;