42: l_statistics_id NUMBER := NULL;
43: CURSOR statistics_id IS SELECT jtf_prefab_statistics_s.NEXTVAL FROM sys.dual;
44:
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT INSERT_STATISTICS;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call (
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT INSERT_STATISTICS;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call (
51: l_api_version,
52: p_api_version,
53: l_api_name,
122:
123: -----------------------
124: -- end of real logic --
125:
126: -- Standard check of p_commit.
127: IF (FND_API.To_Boolean(p_commit)) THEN
128: COMMIT WORK;
129: END IF;
130:
127: IF (FND_API.To_Boolean(p_commit)) THEN
128: COMMIT WORK;
129: END IF;
130:
131: -- Standard call to get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get(
133: p_count => x_msg_count,
134: p_data => x_msg_data );
135:
197: l_object_version NUMBER := NULL;
198:
199: -- l_um_row JTF_XML_URL_MAPPINGS_B%ROWTYPE;
200: BEGIN
201: -- Standard Start of API savepoint
202: SAVEPOINT UPDATE_STATISTICS;
203:
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call (
200: BEGIN
201: -- Standard Start of API savepoint
202: SAVEPOINT UPDATE_STATISTICS;
203:
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call (
206: l_api_version,
207: p_api_version,
208: l_api_name,
256:
257: -----------------------
258: -- end of real logic --
259:
260: -- Standard check of p_commit.
261: IF (FND_API.To_Boolean(p_commit)) THEN
262: COMMIT WORK;
263: END IF;
264:
261: IF (FND_API.To_Boolean(p_commit)) THEN
262: COMMIT WORK;
263: END IF;
264:
265: -- Standard call to get message count and if count is 1, get message info.
266: FND_MSG_PUB.Count_And_Get(
267: p_count => x_msg_count,
268: p_data => x_msg_data );
269:
316: l_api_version CONSTANT NUMBER := p_api_version;
317:
318: l_object_version NUMBER := NULL;
319: BEGIN
320: -- Standard Start of API savepoint
321: SAVEPOINT DELETE_STATISTICS;
322:
323: -- Standard call to check for call compatibility.
324: IF NOT FND_API.Compatible_API_Call (
319: BEGIN
320: -- Standard Start of API savepoint
321: SAVEPOINT DELETE_STATISTICS;
322:
323: -- Standard call to check for call compatibility.
324: IF NOT FND_API.Compatible_API_Call (
325: l_api_version,
326: p_api_version,
327: l_api_name,
355:
356: -----------------------
357: -- end of real logic --
358:
359: -- Standard check of p_commit.
360: IF (FND_API.To_Boolean(p_commit)) THEN
361: COMMIT WORK;
362: END IF;
363:
360: IF (FND_API.To_Boolean(p_commit)) THEN
361: COMMIT WORK;
362: END IF;
363:
364: -- Standard call to get message count and if count is 1, get message info.
365: FND_MSG_PUB.Count_And_Get(
366: p_count => x_msg_count,
367: p_data => x_msg_data );
368:
428: -- local variables --
429: l_api_name CONSTANT VARCHAR2(30) := 'SELECT_STATISTICS';
430: l_api_version NUMBER := p_api_version;
431: BEGIN
432: -- Standard Start of API savepoint
433: SAVEPOINT SELECT_STATISTICS;
434:
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call (
431: BEGIN
432: -- Standard Start of API savepoint
433: SAVEPOINT SELECT_STATISTICS;
434:
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call (
437: l_api_version,
438: p_api_version,
439: l_api_name,
470:
471: -----------------------
472: -- end of real logic --
473:
474: -- Standard check of p_commit.
475: IF (FND_API.To_Boolean(p_commit)) THEN
476: COMMIT WORK;
477: END IF;
478:
475: IF (FND_API.To_Boolean(p_commit)) THEN
476: COMMIT WORK;
477: END IF;
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get(
481: p_count => x_msg_count,
482: p_data => x_msg_data );
483: