34:
35: CURSOR sequence_cursor IS
36: SELECT jtf_prefab_filters_b_s.NEXTVAL from dual;
37: BEGIN
38: -- Standard Start of API savepoint
39: SAVEPOINT INSERT_FILTER;
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_FILTER;
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,
114:
115: -----------------------
116: -- end of real logic --
117:
118: -- Standard check of p_commit.
119: IF (FND_API.To_Boolean(p_commit)) THEN
120: COMMIT WORK;
121: END IF;
122:
119: IF (FND_API.To_Boolean(p_commit)) THEN
120: COMMIT WORK;
121: END IF;
122:
123: -- Standard call to get message count and if count is 1, get message info.
124: FND_MSG_PUB.Count_And_Get(
125: p_count => x_msg_count,
126: p_data => x_msg_data );
127:
179: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FILTER';
180: l_api_version NUMBER := p_api_version;
181:
182: BEGIN
183: -- Standard Start of API savepoint
184: SAVEPOINT UPDATE_FILTER;
185:
186: -- Standard call to check for call compatibility.
187: IF NOT FND_API.Compatible_API_Call (
182: BEGIN
183: -- Standard Start of API savepoint
184: SAVEPOINT UPDATE_FILTER;
185:
186: -- Standard call to check for call compatibility.
187: IF NOT FND_API.Compatible_API_Call (
188: l_api_version,
189: p_api_version,
190: l_api_name,
235:
236: -----------------------
237: -- end of real logic --
238:
239: -- Standard check of p_commit.
240: IF (FND_API.To_Boolean(p_commit)) THEN
241: COMMIT WORK;
242: END IF;
243:
240: IF (FND_API.To_Boolean(p_commit)) THEN
241: COMMIT WORK;
242: END IF;
243:
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get(
246: p_count => x_msg_count,
247: p_data => x_msg_data );
248:
294: l_api_version CONSTANT NUMBER := p_api_version;
295:
296: l_object_version NUMBER := NULL;
297: BEGIN
298: -- Standard Start of API savepoint
299: SAVEPOINT DELETE_FILTER;
300:
301: -- Standard call to check for call compatibility.
302: IF NOT FND_API.Compatible_API_Call (
297: BEGIN
298: -- Standard Start of API savepoint
299: SAVEPOINT DELETE_FILTER;
300:
301: -- Standard call to check for call compatibility.
302: IF NOT FND_API.Compatible_API_Call (
303: l_api_version,
304: p_api_version,
305: l_api_name,
328:
329: -----------------------
330: -- end of real logic --
331:
332: -- Standard check of p_commit.
333: IF (FND_API.To_Boolean(p_commit)) THEN
334: COMMIT WORK;
335: END IF;
336:
333: IF (FND_API.To_Boolean(p_commit)) THEN
334: COMMIT WORK;
335: END IF;
336:
337: -- Standard call to get message count and if count is 1, get message info.
338: FND_MSG_PUB.Count_And_Get(
339: p_count => x_msg_count,
340: p_data => x_msg_data );
341: