50: where attribute_id = p_attribute_id;
51:
52: BEGIN
53:
54: -- Standard Start of API savepoint
55:
56: SAVEPOINT INSERT_ROW_PVT;
57:
58: -- Standard call to check for call compatibility.
54: -- Standard Start of API savepoint
55:
56: SAVEPOINT INSERT_ROW_PVT;
57:
58: -- Standard call to check for call compatibility.
59:
60: if not FND_API.Compatible_API_Call (l_api_version,
61: p_api_version,
62: l_api_name,
169: end if;
170:
171: -- End of API body.
172:
173: -- Standard check of p_commit.
174:
175: if FND_API.to_Boolean (p_commit) then
176: commit work;
177: end if;
175: if FND_API.to_Boolean (p_commit) then
176: commit work;
177: end if;
178:
179: -- Standard call to get message count and if count is 1, get message info.
180:
181: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
182: p_data => p_msg_data);
183:
257: l_api_version CONSTANT NUMBER := 1.0;
258:
259: BEGIN
260:
261: -- Standard Start of API savepoint
262:
263: SAVEPOINT UPDATE_ROW_PVT;
264:
265: -- Standard call to check for call compatibility.
261: -- Standard Start of API savepoint
262:
263: SAVEPOINT UPDATE_ROW_PVT;
264:
265: -- Standard call to check for call compatibility.
266:
267: if not FND_API.Compatible_API_Call (l_api_version,
268: p_api_version,
269: l_api_name,
324: end if;
325:
326: -- End of API body.
327:
328: -- Standard check of p_commit.
329:
330: if FND_API.to_Boolean (p_commit) then
331: commit work;
332: end if;
330: if FND_API.to_Boolean (p_commit) then
331: commit work;
332: end if;
333:
334: -- Standard call to get message count and if count is 1, get message info.
335:
336: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
337: p_data => p_msg_data);
338:
391: l_api_version CONSTANT NUMBER := 1.0;
392:
393: BEGIN
394:
395: -- Standard Start of API savepoint
396:
397: SAVEPOINT DELETE_ROW_PVT;
398:
399: -- Standard call to check for call compatibility.
395: -- Standard Start of API savepoint
396:
397: SAVEPOINT DELETE_ROW_PVT;
398:
399: -- Standard call to check for call compatibility.
400:
401: if not FND_API.Compatible_API_Call (l_api_version,
402: p_api_version,
403: l_api_name,
427: RAISE NO_DATA_FOUND;
428: end if;
429:
430:
431: -- Standard call to get message count and if count is 1, get message info.
432:
433: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
434: p_data => p_msg_data);
435:
432:
433: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
434: p_data => p_msg_data);
435:
436: -- Standard check of p_commit.
437:
438: if FND_API.to_Boolean (p_commit) then
439: commit work;
440: end if;