DBA Data[Home] [Help]

APPS.JTF_PREFAB_UD_KEY_PUB dependencies on STANDARD

Line 38: -- Standard Start of API savepoint

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 (

Line 41: -- Standard call to check for call compatibility.

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,

Line 116: -- Standard check of p_commit.

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:

Line 121: -- Standard call to get message count and if count is 1, get message info.

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:

Line 181: -- Standard Start of API savepoint

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 (

Line 184: -- Standard call to check for call compatibility.

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,

Line 234: -- Standard check of p_commit.

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:

Line 239: -- Standard call to get message count and if count is 1, get message info.

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:

Line 292: -- Standard Start of API savepoint

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 (

Line 295: -- Standard call to check for call compatibility.

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,

Line 326: -- Standard check of p_commit.

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:

Line 331: -- Standard call to get message count and if count is 1, get message info.

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: