12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_ud_key_id OUT NOCOPY jtf_prefab_ud_keys_b.ud_key_id%TYPE,
17: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
18: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
19: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
20: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_ud_key_id OUT NOCOPY jtf_prefab_ud_keys_b.ud_key_id%TYPE,
17: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
18: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
19: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
20: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
21: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_ud_key_id OUT NOCOPY jtf_prefab_ud_keys_b.ud_key_id%TYPE,
17: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
18: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
19: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
20: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
21: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
22: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
16: p_ud_key_id OUT NOCOPY jtf_prefab_ud_keys_b.ud_key_id%TYPE,
17: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
18: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
19: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
20: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
21: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
22: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
17: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
18: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
19: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
20: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
21: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
22: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
25:
18: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
19: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
20: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
21: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
22: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
25:
26: x_return_status OUT NOCOPY VARCHAR2,
20: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
21: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
22: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
25:
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2
32: l_api_version NUMBER := p_api_version;
33: l_row_id VARCHAR2(255) := NULL;
34:
35: CURSOR sequence_cursor IS
36: SELECT jtf_prefab_ud_keys_b_s.NEXTVAL from dual;
37: BEGIN
38: -- Standard Start of API savepoint
39: SAVEPOINT INSERT_UD_KEY;
40:
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161:
162: p_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
163: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
164: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
165: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
166: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161:
162: p_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
163: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
164: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
165: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
166: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
167: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
161:
162: p_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
163: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
164: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
165: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
166: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
167: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
168: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
162: p_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
163: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
164: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
165: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
166: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
167: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
168: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
169:
170: p_object_version_number IN OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
163: p_application_id IN jtf_prefab_ud_keys_b.application_id%TYPE,
164: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
165: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
166: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
167: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
168: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
169:
170: p_object_version_number IN OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
171:
164: p_ud_key_name IN jtf_prefab_ud_keys_b.ud_key_name%TYPE,
165: p_description IN jtf_prefab_ud_keys_tl.description%TYPE,
166: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
167: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
168: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
169:
170: p_object_version_number IN OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
171:
172: x_return_status OUT NOCOPY VARCHAR2,
166: p_filename IN jtf_prefab_ud_keys_b.filename%TYPE,
167: p_user_defined_keys IN jtf_prefab_ud_keys_b.user_defined_keys%TYPE,
168: p_enabled_flag IN jtf_prefab_ud_keys_b.enabled_flag%TYPE,
169:
170: p_object_version_number IN OUT NOCOPY jtf_prefab_ud_keys_b.object_version_number%TYPE,
171:
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2
276: p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279:
280: p_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
281:
282: p_object_version_number IN jtf_prefab_ud_keys_b.object_version_number%TYPE,
283:
284: x_return_status OUT NOCOPY VARCHAR2,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279:
280: p_ud_key_id IN jtf_prefab_ud_keys_b.ud_key_id%TYPE,
281:
282: p_object_version_number IN jtf_prefab_ud_keys_b.object_version_number%TYPE,
283:
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2