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_FILTER_PUB dependencies on JTF_PREFAB_FILTERS_B

Line 16: p_filter_id OUT NOCOPY jtf_prefab_filters_b.filter_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_filter_id OUT NOCOPY jtf_prefab_filters_b.filter_id%TYPE,
17: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
18: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
19: p_description IN jtf_prefab_filters_tl.description%TYPE,
20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,

Line 17: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,

13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_filter_id OUT NOCOPY jtf_prefab_filters_b.filter_id%TYPE,
17: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
18: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
19: p_description IN jtf_prefab_filters_tl.description%TYPE,
20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
21: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,

Line 18: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,

14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_filter_id OUT NOCOPY jtf_prefab_filters_b.filter_id%TYPE,
17: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
18: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
19: p_description IN jtf_prefab_filters_tl.description%TYPE,
20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
21: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
22: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,

Line 20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,

16: p_filter_id OUT NOCOPY jtf_prefab_filters_b.filter_id%TYPE,
17: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
18: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
19: p_description IN jtf_prefab_filters_tl.description%TYPE,
20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
21: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
22: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,

Line 21: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,

17: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
18: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
19: p_description IN jtf_prefab_filters_tl.description%TYPE,
20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
21: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
22: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
25:

Line 22: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,

18: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
19: p_description IN jtf_prefab_filters_tl.description%TYPE,
20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
21: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
22: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
25:
26: x_return_status OUT NOCOPY VARCHAR2,

Line 24: p_object_version_number OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,

20: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
21: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
22: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
25:
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2

Line 36: SELECT jtf_prefab_filters_b_s.NEXTVAL from dual;

32: l_api_version NUMBER := p_api_version;
33: l_row_id VARCHAR2(255) := NULL;
34:
35: CURSOR sequence_cursor IS
36: SELECT jtf_prefab_filters_b_s.NEXTVAL from dual;
37: BEGIN
38: -- Standard Start of API savepoint
39: SAVEPOINT INSERT_FILTER;
40:

Line 164: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,

160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
165: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
166: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
167: p_description IN jtf_prefab_filters_tl.description%TYPE,
168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,

Line 165: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,

161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
165: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
166: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
167: p_description IN jtf_prefab_filters_tl.description%TYPE,
168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
169: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,

Line 166: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,

162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
165: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
166: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
167: p_description IN jtf_prefab_filters_tl.description%TYPE,
168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
169: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
170: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,

Line 168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,

164: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
165: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
166: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
167: p_description IN jtf_prefab_filters_tl.description%TYPE,
168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
169: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
170: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
171:
172: p_object_version_number IN OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,

Line 169: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,

165: p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
166: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
167: p_description IN jtf_prefab_filters_tl.description%TYPE,
168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
169: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
170: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
171:
172: p_object_version_number IN OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
173:

Line 170: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,

166: p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
167: p_description IN jtf_prefab_filters_tl.description%TYPE,
168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
169: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
170: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
171:
172: p_object_version_number IN OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
173:
174: x_return_status OUT NOCOPY VARCHAR2,

Line 172: p_object_version_number IN OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,

168: p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
169: p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
170: p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
171:
172: p_object_version_number IN OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
173:
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2

Line 285: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,

281: p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284:
285: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
286:
287: p_object_version_number IN jtf_prefab_filters_b.object_version_number%TYPE,
288:
289: x_return_status OUT NOCOPY VARCHAR2,

Line 287: p_object_version_number IN jtf_prefab_filters_b.object_version_number%TYPE,

283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284:
285: p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
286:
287: p_object_version_number IN jtf_prefab_filters_b.object_version_number%TYPE,
288:
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2