DBA Data[Home] [Help]

APPS.JTF_PREFAB_STATISTICS_PUB dependencies on JTF_PREFAB_STATISTICS_S

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