36: and pay_element_id = p_pay_element_id;
37:
38: BEGIN
39:
40: -- Standard Start of API savepoint
41:
42: SAVEPOINT INSERT_ROW_PVT;
43:
44: -- Standard call to check for call compatibility.
40: -- Standard Start of API savepoint
41:
42: SAVEPOINT INSERT_ROW_PVT;
43:
44: -- Standard call to check for call compatibility.
45:
46: if not FND_API.Compatible_API_Call (l_api_version,
47: p_api_version,
48: l_api_name,
97: raise no_data_found;
98: end if;
99: -- End of API body.
100:
101: -- Standard check of p_commit.
102:
103: if FND_API.to_Boolean (p_commit) then
104: commit work;
105: end if;
103: if FND_API.to_Boolean (p_commit) then
104: commit work;
105: end if;
106:
107: -- Standard call to get message count and if count is 1, get message info.
108:
109: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
110: p_data => p_msg_data);
111:
171: l_api_version CONSTANT NUMBER := 1.0;
172:
173: BEGIN
174:
175: -- Standard Start of API savepoint
176:
177: SAVEPOINT UPDATE_ROW_PVT;
178:
179: -- Standard call to check for call compatibility.
175: -- Standard Start of API savepoint
176:
177: SAVEPOINT UPDATE_ROW_PVT;
178:
179: -- Standard call to check for call compatibility.
180:
181: if not FND_API.Compatible_API_Call (l_api_version,
182: p_api_version,
183: l_api_name,
212: end if;
213:
214: -- End of API body.
215:
216: -- Standard check of p_commit.
217:
218: if FND_API.to_Boolean (p_commit) then
219: commit work;
220: end if;
218: if FND_API.to_Boolean (p_commit) then
219: commit work;
220: end if;
221:
222: -- Standard call to get message count and if count is 1, get message info.
223:
224: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
225: p_data => p_msg_data);
226:
281: l_api_version CONSTANT NUMBER := 1.0;
282:
283: BEGIN
284:
285: -- Standard Start of API savepoint
286:
287: SAVEPOINT DELETE_ROW_PVT;
288:
289: -- Standard call to check for call compatibility.
285: -- Standard Start of API savepoint
286:
287: SAVEPOINT DELETE_ROW_PVT;
288:
289: -- Standard call to check for call compatibility.
290:
291: if not FND_API.Compatible_API_Call (l_api_version,
292: p_api_version,
293: l_api_name,
319: if (SQL%NOTFOUND) then
320: RAISE NO_DATA_FOUND;
321: end if;
322:
323: -- Standard call to get message count and if count is 1, get message info.
324:
325: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
326: p_data => p_msg_data);
327:
324:
325: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
326: p_data => p_msg_data);
327:
328: -- Standard check of p_commit.
329:
330: if FND_API.to_Boolean (p_commit) then
331: commit work;
332: end if;