PACKAGE: APPS.JTF_PREFAB_FILTER_PUB

Source

1 PACKAGE JTF_PREFAB_FILTER_PUB 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;