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_CACHE_PUB dependencies on JTF_PREFAB_HA_FILTERS

Line 2388: p_ha_filter_id OUT NOCOPY jtf_prefab_ha_filters.ha_filter_id%TYPE,

2384: p_api_version IN NUMBER,
2385: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2387:
2388: p_ha_filter_id OUT NOCOPY jtf_prefab_ha_filters.ha_filter_id%TYPE,
2389: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
2390: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
2391: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2392:

Line 2389: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,

2385: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2387:
2388: p_ha_filter_id OUT NOCOPY jtf_prefab_ha_filters.ha_filter_id%TYPE,
2389: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
2390: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
2391: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2392:
2393: p_object_version_number OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,

Line 2390: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,

2386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2387:
2388: p_ha_filter_id OUT NOCOPY jtf_prefab_ha_filters.ha_filter_id%TYPE,
2389: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
2390: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
2391: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2392:
2393: p_object_version_number OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,
2394:

Line 2391: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,

2387:
2388: p_ha_filter_id OUT NOCOPY jtf_prefab_ha_filters.ha_filter_id%TYPE,
2389: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
2390: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
2391: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2392:
2393: p_object_version_number OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,
2394:
2395: x_return_status OUT NOCOPY VARCHAR2,

Line 2393: p_object_version_number OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,

2389: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
2390: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
2391: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2392:
2393: p_object_version_number OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,
2394:
2395: x_return_status OUT NOCOPY VARCHAR2,
2396: x_msg_count OUT NOCOPY NUMBER,
2397: x_msg_data OUT NOCOPY VARCHAR2

Line 2404: SELECT jtf_prefab_ha_filters_s.NEXTVAL from dual;

2400: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_HA_FILTER';
2401: l_api_version NUMBER := p_api_version;
2402:
2403: CURSOR sequence_cursor IS
2404: SELECT jtf_prefab_ha_filters_s.NEXTVAL from dual;
2405: BEGIN
2406: -- Standard Start of API savepoint
2407: SAVEPOINT INSERT_HA_FILTER;
2408:

Line 2435: INSERT INTO jtf_prefab_ha_filters (ha_filter_id,

2431: FETCH sequence_cursor INTO p_ha_filter_id;
2432: CLOSE sequence_cursor;
2433: p_object_version_number := 1;
2434:
2435: INSERT INTO jtf_prefab_ha_filters (ha_filter_id,
2436: object_version_number,
2437: created_by,
2438: creation_date,
2439: last_updated_by,

Line 2507: p_ha_filter_id IN jtf_prefab_ha_filters.ha_filter_id%TYPE,

2503: p_api_version IN NUMBER,
2504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2505: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2506:
2507: p_ha_filter_id IN jtf_prefab_ha_filters.ha_filter_id%TYPE,
2508: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2509:
2510: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,
2511:

Line 2508: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,

2504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2505: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2506:
2507: p_ha_filter_id IN jtf_prefab_ha_filters.ha_filter_id%TYPE,
2508: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2509:
2510: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,
2511:
2512: x_return_status OUT NOCOPY VARCHAR2,

Line 2510: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,

2506:
2507: p_ha_filter_id IN jtf_prefab_ha_filters.ha_filter_id%TYPE,
2508: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
2509:
2510: p_object_version_number IN OUT NOCOPY jtf_prefab_ha_filters.object_version_number%TYPE,
2511:
2512: x_return_status OUT NOCOPY VARCHAR2,
2513: x_msg_count OUT NOCOPY NUMBER,
2514: x_msg_data OUT NOCOPY VARCHAR2

Line 2545: UPDATE jtf_prefab_ha_filters

2541:
2542: -- real logic --
2543: ----------------
2544:
2545: UPDATE jtf_prefab_ha_filters
2546: SET object_version_number = p_object_version_number,
2547: last_updated_by = G_USER_ID,
2548: last_update_date = SYSDATE,
2549: last_update_login = G_LOGIN_ID,

Line 2602: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,

2598: p_api_version IN NUMBER,
2599: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2600: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2601:
2602: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
2603:
2604: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,
2605:
2606: x_return_status OUT NOCOPY VARCHAR2,

Line 2604: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,

2600: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2601:
2602: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
2603:
2604: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,
2605:
2606: x_return_status OUT NOCOPY VARCHAR2,
2607: x_msg_count OUT NOCOPY NUMBER,
2608: x_msg_data OUT NOCOPY VARCHAR2

Line 2638: DELETE FROM jtf_prefab_ha_filters

2634:
2635: -- real logic --
2636: ----------------
2637:
2638: DELETE FROM jtf_prefab_ha_filters
2639: WHERE host_app_id = p_host_app_id;
2640:
2641: -----------------------
2642: -- end of real logic --

Line 2690: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,

2686: p_api_version IN NUMBER,
2687: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2689:
2690: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
2691:
2692: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,
2693:
2694: x_return_status OUT NOCOPY VARCHAR2,

Line 2692: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,

2688: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2689:
2690: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
2691:
2692: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,
2693:
2694: x_return_status OUT NOCOPY VARCHAR2,
2695: x_msg_count OUT NOCOPY NUMBER,
2696: x_msg_data OUT NOCOPY VARCHAR2

Line 2726: DELETE FROM jtf_prefab_ha_filters

2722:
2723: -- real logic --
2724: ----------------
2725:
2726: DELETE FROM jtf_prefab_ha_filters
2727: WHERE ca_filter_id = p_ca_filter_id;
2728:
2729: -----------------------
2730: -- end of real logic --