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 Body JTF_PREFAB_STATISTICS_PUB AS

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

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

Line 16: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,

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,

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

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

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

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

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

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

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

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

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

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

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

Line 28: p_avg_mem IN jtf_prefab_statistics.avg_mem%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:
32: p_object_version_number OUT NOCOPY NUMBER,

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

Line 30: p_hit_rate IN jtf_prefab_statistics.hit_rate%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:
34: x_return_status OUT NOCOPY VARCHAR2,

Line 43: CURSOR statistics_id IS SELECT jtf_prefab_statistics_s.NEXTVAL FROM sys.dual;

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;

Line 76: INSERT INTO jtf_prefab_statistics (statistics_id,

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,

Line 172: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,

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,

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

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

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

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

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

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

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

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

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

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

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

Line 184: p_avg_mem IN jtf_prefab_statistics.avg_mem%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:
188: p_object_version_number IN OUT NOCOPY NUMBER,

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

Line 186: p_hit_rate IN jtf_prefab_statistics.hit_rate%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:
190: x_return_status OUT NOCOPY VARCHAR2,

Line 226: FROM jtf_prefab_statistics

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

Line 237: UPDATE jtf_prefab_statistics

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,

Line 345: FROM jtf_prefab_statistics

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

Line 353: DELETE FROM jtf_prefab_statistics

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

Line 405: p_policy_id IN jtf_prefab_statistics.policy_id%TYPE,

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,

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

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

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

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

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

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

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

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

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

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

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

Line 417: p_avg_mem OUT NOCOPY jtf_prefab_statistics.avg_mem%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:
421: p_object_version_number OUT NOCOPY NUMBER,

Line 418: p_avg_cpu OUT NOCOPY jtf_prefab_statistics.avg_cpu%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,
422: p_row_count OUT NOCOPY NUMBER,

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

Line 466: FROM jtf_prefab_statistics

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:

Line 515: END JTF_PREFAB_STATISTICS_PUB;

511: p_data => x_msg_data );
512:
513: END SELECT_STATISTICS;
514:
515: END JTF_PREFAB_STATISTICS_PUB;