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