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_CA_FILTERS_B

Line 2039: p_ca_filter_id OUT NOCOPY jtf_prefab_ca_filters_b.ca_filter_id%TYPE,

2035: p_api_version IN NUMBER,
2036: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2037: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2038:
2039: p_ca_filter_id OUT NOCOPY jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2040: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2041: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2042: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2043:

Line 2040: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,

2036: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2037: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2038:
2039: p_ca_filter_id OUT NOCOPY jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2040: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2041: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2042: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2043:
2044: p_object_version_number OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,

Line 2041: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,

2037: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2038:
2039: p_ca_filter_id OUT NOCOPY jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2040: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2041: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2042: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2043:
2044: p_object_version_number OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,
2045:

Line 2044: p_object_version_number OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,

2040: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2041: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2042: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2043:
2044: p_object_version_number OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,
2045:
2046: x_return_status OUT NOCOPY VARCHAR2,
2047: x_msg_count OUT NOCOPY NUMBER,
2048: x_msg_data OUT NOCOPY VARCHAR2

Line 2056: SELECT jtf_prefab_ca_filters_b_s.NEXTVAL from dual;

2052: l_api_version NUMBER := p_api_version;
2053: l_row_id VARCHAR2(255) := NULL;
2054:
2055: CURSOR sequence_cursor IS
2056: SELECT jtf_prefab_ca_filters_b_s.NEXTVAL from dual;
2057: CURSOR host_apps_cursor IS
2058: SELECT host_app_id
2059: FROM jtf_prefab_host_apps
2060: WHERE application_id = p_application_id;

Line 2177: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,

2173: p_api_version IN NUMBER,
2174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2176:
2177: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2178: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2179: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2180: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2181:

Line 2178: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,

2174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2176:
2177: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2178: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2179: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2180: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2181:
2182: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,

Line 2179: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,

2175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2176:
2177: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2178: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2179: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2180: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2181:
2182: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,
2183:

Line 2182: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,

2178: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
2179: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,
2180: p_description IN jtf_prefab_ca_filters_tl.description%TYPE,
2181:
2182: p_object_version_number IN OUT NOCOPY jtf_prefab_ca_filters_b.object_version_number%TYPE,
2183:
2184: x_return_status OUT NOCOPY VARCHAR2,
2185: x_msg_count OUT NOCOPY NUMBER,
2186: x_msg_data OUT NOCOPY VARCHAR2

Line 2276: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,

2272: p_api_version IN NUMBER,
2273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2275:
2276: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2277:
2278: p_object_version_number IN jtf_prefab_ca_filters_b.object_version_number%TYPE,
2279:
2280: x_return_status OUT NOCOPY VARCHAR2,

Line 2278: p_object_version_number IN jtf_prefab_ca_filters_b.object_version_number%TYPE,

2274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2275:
2276: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
2277:
2278: p_object_version_number IN jtf_prefab_ca_filters_b.object_version_number%TYPE,
2279:
2280: x_return_status OUT NOCOPY VARCHAR2,
2281: x_msg_count OUT NOCOPY NUMBER,
2282: x_msg_data OUT NOCOPY VARCHAR2