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.

APPS.JTF_PREFAB_STATISTICS_PUB dependencies on JTF_PREFAB_STATISTICS

Line 1: PACKAGE JTF_PREFAB_STATISTICS_PUB as

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,

Line 9: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,

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,

Line 10: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%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,

Line 11: p_start_time IN jtf_prefab_statistics.start_time%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,

Line 12: p_end_time IN jtf_prefab_statistics.end_time%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,

Line 13: p_last_update_time IN jtf_prefab_statistics.last_update_time%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,

Line 14: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%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,

Line 15: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%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,

Line 16: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%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,

Line 17: p_system_status IN jtf_prefab_statistics.system_status%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,

Line 18: p_error_status IN jtf_prefab_statistics.error_status%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,

Line 19: p_depth IN jtf_prefab_statistics.depth%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,

Line 20: p_disk_used IN jtf_prefab_statistics.disk_used%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:

Line 21: p_avg_mem IN jtf_prefab_statistics.avg_mem%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,

Line 22: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%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:

Line 23: p_hit_rate IN jtf_prefab_statistics.hit_rate%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,

Line 37: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,

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,

Line 38: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%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,

Line 39: p_start_time IN jtf_prefab_statistics.start_time%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,

Line 40: p_end_time IN jtf_prefab_statistics.end_time%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,

Line 41: p_last_update_time IN jtf_prefab_statistics.last_update_time%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,

Line 42: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%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,

Line 43: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%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,

Line 44: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%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,

Line 45: p_system_status IN jtf_prefab_statistics.system_status%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,

Line 46: p_error_status IN jtf_prefab_statistics.error_status%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,

Line 47: p_depth IN jtf_prefab_statistics.depth%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,

Line 48: p_disk_used IN jtf_prefab_statistics.disk_used%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:

Line 49: p_avg_mem IN jtf_prefab_statistics.avg_mem%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,

Line 50: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%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:

Line 51: p_hit_rate IN jtf_prefab_statistics.hit_rate%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,

Line 80: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,

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,

Line 81: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%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,

Line 82: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%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,

Line 83: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%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,

Line 84: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%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,

Line 85: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%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,

Line 86: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%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,

Line 87: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%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,

Line 88: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%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,

Line 89: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%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,

Line 90: p_depth OUT NOCOPY jtf_prefab_statistics.depth%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,

Line 91: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%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:

Line 92: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%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,

Line 93: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%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,

Line 94: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%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:

Line 104: END JTF_PREFAB_STATISTICS_PUB;

100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2
102: );
103:
104: END JTF_PREFAB_STATISTICS_PUB;