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,
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,
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,
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,
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:
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,