1: Package Body JTF_PREFAB_STATISTICS_PUB AS
2: /* $Header: jtfprefabstb.pls 120.3 2005/10/28 00:22:56 emekala ship $ */
3:
4: -- global variables --
5: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PREFAB_STATISTICS_PUB';
1: Package Body JTF_PREFAB_STATISTICS_PUB AS
2: /* $Header: jtfprefabstb.pls 120.3 2005/10/28 00:22:56 emekala ship $ */
3:
4: -- global variables --
5: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PREFAB_STATISTICS_PUB';
6: G_FILE_NAME CONSTANT VARCHAR2(16):='jtfprefabstb.pls';
7:
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
18: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
18: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
18: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
15:
16: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
18: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
16: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
18: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
17: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
18: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
18: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
19: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
20: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
28: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
21: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
28: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
29: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
22: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
28: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
29: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
30: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
23: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
28: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
29: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
30: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
31:
24: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
28: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
29: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
30: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
31:
32: p_object_version_number OUT NOCOPY NUMBER,
25: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
28: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
29: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
30: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
31:
32: p_object_version_number OUT NOCOPY NUMBER,
33:
26: p_depth IN jtf_prefab_statistics.depth%TYPE,
27: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
28: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
29: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
30: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
31:
32: p_object_version_number OUT NOCOPY NUMBER,
33:
34: x_return_status OUT NOCOPY VARCHAR2,
39: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_STATISTICS';
40: l_api_version NUMBER := p_api_version;
41:
42: l_statistics_id NUMBER := NULL;
43: CURSOR statistics_id IS SELECT jtf_prefab_statistics_s.NEXTVAL FROM sys.dual;
44:
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT INSERT_STATISTICS;
72: CLOSE statistics_id;
73:
74: p_object_version_number := 1;
75:
76: INSERT INTO jtf_prefab_statistics (statistics_id,
77: created_by,
78: creation_date,
79: last_updated_by,
80: last_update_date,
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171:
172: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
173: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
174: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171:
172: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
173: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
174: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171:
172: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
173: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
174: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
171:
172: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
173: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
174: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
172: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
173: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
174: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
173: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
174: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
174: p_start_time IN jtf_prefab_statistics.start_time%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
175: p_end_time IN jtf_prefab_statistics.end_time%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
176: p_last_update_time IN jtf_prefab_statistics.last_update_time%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
184: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
177: p_pages_last_run IN jtf_prefab_statistics.pages_last_run%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
184: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
185: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
178: p_pages_crawled IN jtf_prefab_statistics.pages_crawled%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
184: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
185: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
186: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
179: p_refresh_rate IN jtf_prefab_statistics.refresh_rate%TYPE,
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
184: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
185: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
186: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
187:
180: p_system_status IN jtf_prefab_statistics.system_status%TYPE,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
184: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
185: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
186: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
187:
188: p_object_version_number IN OUT NOCOPY NUMBER,
181: p_error_status IN jtf_prefab_statistics.error_status%TYPE,
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
184: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
185: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
186: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
187:
188: p_object_version_number IN OUT NOCOPY NUMBER,
189:
182: p_depth IN jtf_prefab_statistics.depth%TYPE,
183: p_disk_used IN jtf_prefab_statistics.disk_used%TYPE,
184: p_avg_mem IN jtf_prefab_statistics.avg_mem%TYPE,
185: p_avg_cpu IN jtf_prefab_statistics.avg_cpu%TYPE,
186: p_hit_rate IN jtf_prefab_statistics.hit_rate%TYPE,
187:
188: p_object_version_number IN OUT NOCOPY NUMBER,
189:
190: x_return_status OUT NOCOPY VARCHAR2,
222: -- real logic --
223: ----------------
224: /*
225: SELECT object_version_number INTO l_object_version
226: FROM jtf_prefab_statistics
227: WHERE application_id = p_application_id;
228:
229: -- checking for object version number
230: if (l_object_version IS NULL OR l_object_version > p_OBJ_VER_NUMBER) THEN
233: p_obj_ver_number := p_obj_ver_number + 1;
234: END IF;
235: */
236:
237: UPDATE jtf_prefab_statistics
238: SET last_updated_by = G_USER_ID,
239: last_update_date = SYSDATE,
240: last_update_login = G_LOGIN_ID,
241: object_version_number = p_object_version_number,
341: -- real logic --
342: ----------------
343: /*
344: SELECT object_version_number INTO l_object_version
345: FROM jtf_prefab_statistics
346: WHERE application_id = p_application_id;
347:
348: -- checking for object version number
349: IF (l_object_version IS NULL OR l_object_version > p_obj_ver_number) THEN
349: IF (l_object_version IS NULL OR l_object_version > p_obj_ver_number) THEN
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352: */
353: DELETE FROM jtf_prefab_statistics
354: WHERE policy_id = p_policy_id AND wsh_po_id = p_wsh_po_id;
355:
356: -----------------------
357: -- end of real logic --
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404:
405: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
406: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
407: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404:
405: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
406: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
407: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404:
405: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
406: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
407: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
404:
405: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
406: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
407: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
405: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,
406: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
407: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
406: p_wsh_po_id IN jtf_prefab_statistics.wsh_po_id%TYPE,
407: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
407: p_start_time OUT NOCOPY jtf_prefab_statistics.start_time%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
408: p_end_time OUT NOCOPY jtf_prefab_statistics.end_time%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
409: p_last_update_time OUT NOCOPY jtf_prefab_statistics.last_update_time%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
410: p_pages_last_run OUT NOCOPY jtf_prefab_statistics.pages_last_run%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
418: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
411: p_pages_crawled OUT NOCOPY jtf_prefab_statistics.pages_crawled%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
418: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
419: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
412: p_refresh_rate OUT NOCOPY jtf_prefab_statistics.refresh_rate%TYPE,
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
418: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
419: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
420:
413: p_system_status OUT NOCOPY jtf_prefab_statistics.system_status%TYPE,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
418: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
419: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
420:
421: p_object_version_number OUT NOCOPY NUMBER,
414: p_error_status OUT NOCOPY jtf_prefab_statistics.error_status%TYPE,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
418: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
419: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
420:
421: p_object_version_number OUT NOCOPY NUMBER,
422: p_row_count OUT NOCOPY NUMBER,
415: p_depth OUT NOCOPY jtf_prefab_statistics.depth%TYPE,
416: p_disk_used OUT NOCOPY jtf_prefab_statistics.disk_used%TYPE,
417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%TYPE,
418: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%TYPE,
419: p_hit_rate OUT NOCOPY jtf_prefab_statistics.hit_rate%TYPE,
420:
421: p_object_version_number OUT NOCOPY NUMBER,
422: p_row_count OUT NOCOPY NUMBER,
423:
462: p_pages_last_run, p_pages_crawled, p_refresh_rate,
463: p_system_status, p_error_status, p_depth, p_disk_used,
464: p_avg_mem, p_avg_cpu, p_hit_rate,
465: p_object_version_number
466: FROM jtf_prefab_statistics
467: WHERE policy_id = p_policy_id AND wsh_po_id = p_wsh_po_id;
468:
469: p_row_count := SQL%ROWCOUNT;
470:
511: p_data => x_msg_data );
512:
513: END SELECT_STATISTICS;
514:
515: END JTF_PREFAB_STATISTICS_PUB;