[Home] [Help]
PACKAGE: APPS.JTF_PREFAB_FILTER_PUB
Source
1 PACKAGE JTF_PREFAB_FILTER_PUB AUTHID CURRENT_USER as
2 /* $Header: jtfprefabfls.pls 120.2 2005/10/28 00:07:04 emekala ship $ */
3
4 PROCEDURE INSERT_FILTER(
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8
9 p_filter_id OUT NOCOPY jtf_prefab_filters_b.filter_id%TYPE,
10 p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
11 p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
12 p_description IN jtf_prefab_filters_tl.description%TYPE,
13 p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
14 p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
15 p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
16
17 p_object_version_number OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
18
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE UPDATE_FILTER(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27 p_commit IN VARCHAR2 := FND_API.G_FALSE,
28
29 p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
30 p_filter_name IN jtf_prefab_filters_b.filter_name%TYPE,
31 p_application_id IN jtf_prefab_filters_b.application_id%TYPE,
32 p_description IN jtf_prefab_filters_tl.description%TYPE,
33 p_filter_string IN jtf_prefab_filters_b.filter_string%TYPE,
34 p_exclusion_flag IN jtf_prefab_filters_b.exclusion_flag%TYPE,
35 p_enabled_flag IN jtf_prefab_filters_b.enabled_flag%TYPE,
36
37 p_object_version_number IN OUT NOCOPY jtf_prefab_filters_b.object_version_number%TYPE,
38
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 procedure DELETE_FILTER(
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47 p_commit IN VARCHAR2 := FND_API.G_FALSE,
48
49 p_filter_id IN jtf_prefab_filters_b.filter_id%TYPE,
50
51 p_object_version_number IN jtf_prefab_filters_b.object_version_number%TYPE,
52
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 END JTF_PREFAB_FILTER_PUB;