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:
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call (
37: BEGIN
38: -- Standard Start of API savepoint
39: SAVEPOINT INSERT_UD_KEY;
40:
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call (
43: l_api_version,
44: p_api_version,
45: l_api_name,
112:
113: -----------------------
114: -- end of real logic --
115:
116: -- Standard check of p_commit.
117: IF (FND_API.To_Boolean(p_commit)) THEN
118: COMMIT WORK;
119: END IF;
120:
117: IF (FND_API.To_Boolean(p_commit)) THEN
118: COMMIT WORK;
119: END IF;
120:
121: -- Standard call to get message count and if count is 1, get message info.
122: FND_MSG_PUB.Count_And_Get(
123: p_count => x_msg_count,
124: p_data => x_msg_data );
125:
177: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_UD_KEY';
178: l_api_version NUMBER := p_api_version;
179:
180: BEGIN
181: -- Standard Start of API savepoint
182: SAVEPOINT UPDATE_UD_KEY;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call (
180: BEGIN
181: -- Standard Start of API savepoint
182: SAVEPOINT UPDATE_UD_KEY;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call (
186: l_api_version,
187: p_api_version,
188: l_api_name,
230:
231: -----------------------
232: -- end of real logic --
233:
234: -- Standard check of p_commit.
235: IF (FND_API.To_Boolean(p_commit)) THEN
236: COMMIT WORK;
237: END IF;
238:
235: IF (FND_API.To_Boolean(p_commit)) THEN
236: COMMIT WORK;
237: END IF;
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: FND_MSG_PUB.Count_And_Get(
241: p_count => x_msg_count,
242: p_data => x_msg_data );
243:
288: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_UD_KEY';
289: l_api_version CONSTANT NUMBER := p_api_version;
290:
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT DELETE_UD_KEY;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call (
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT DELETE_UD_KEY;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call (
297: l_api_version,
298: p_api_version,
299: l_api_name,
322:
323: -----------------------
324: -- end of real logic --
325:
326: -- Standard check of p_commit.
327: IF (FND_API.To_Boolean(p_commit)) THEN
328: COMMIT WORK;
329: END IF;
330:
327: IF (FND_API.To_Boolean(p_commit)) THEN
328: COMMIT WORK;
329: END IF;
330:
331: -- Standard call to get message count and if count is 1, get message info.
332: FND_MSG_PUB.Count_And_Get(
333: p_count => x_msg_count,
334: p_data => x_msg_data );
335: