[Home] [Help]
PACKAGE: APPS.JTF_PREFAB_UD_KEY_PUB
Source
1 PACKAGE JTF_PREFAB_UD_KEY_PUB AUTHID CURRENT_USER as
2 /* $Header: jtfprefabuds.pls 120.2 2005/10/28 00:24:24 emekala ship $ */
3
4 PROCEDURE INSERT_UD_KEY(
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_ud_key_id OUT NOCOPY jtf_prefab_ud_keys_b.ud_key_id%TYPE,
10 p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
11 p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
12 p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
13 p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
14 p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
15 p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
16
17 p_object_version_number OUT NOCOPY jtf_prefab_ud_keys_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_UD_KEY(
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_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
30 p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
31 p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
32 p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
33 p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
34 p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
35 p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
36
37 p_object_version_number IN OUT NOCOPY jtf_prefab_ud_keys_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_UD_KEY(
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_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
50
51 p_object_version_number IN jtf_prefab_ud_keys_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_UD_KEY_PUB;