18: l_api_version CONSTANT NUMBER := 1.0;
19: l_server_id NUMBER;
20:
21: BEGIN
22: -- Standard Start of API savepoint
23:
24: -- Standard call to check for call compatibility.
25: IF NOT FND_API.Compatible_API_Call
26: (
20:
21: BEGIN
22: -- Standard Start of API savepoint
23:
24: -- Standard call to check for call compatibility.
25: IF NOT FND_API.Compatible_API_Call
26: (
27: l_api_version,
28: p_api_version,
57: x_msg_data);
58:
59: -- End of API body.
60:
61: -- Standard check of p_commit.
62: IF FND_API.To_Boolean( p_commit ) THEN
63: COMMIT WORK;
64: END IF;
65: -- Standard call to get message count and if count is 1, get message info.
61: -- Standard check of p_commit.
62: IF FND_API.To_Boolean( p_commit ) THEN
63: COMMIT WORK;
64: END IF;
65: -- Standard call to get message count and if count is 1, get message info.
66: FND_MSG_PUB.Count_And_Get
67: (
68: p_count => x_msg_count,
69: p_data => x_msg_data
115: l_result VARCHAR2(256);
116:
117: BEGIN
118:
119: -- Standard Start of API savepoint
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call
123: (
117: BEGIN
118:
119: -- Standard Start of API savepoint
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call
123: (
124: l_api_version,
125: p_api_version,
189: l_result VARCHAR2(256);
190:
191: BEGIN
192:
193: -- Standard Start of API savepoint
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call
197: (
191: BEGIN
192:
193: -- Standard Start of API savepoint
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call
197: (
198: l_api_version,
199: p_api_version,
264: l_result VARCHAR2(256);
265:
266: BEGIN
267:
268: -- Standard Start of API savepoint
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call
272: (
266: BEGIN
267:
268: -- Standard Start of API savepoint
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call
272: (
273: l_api_version,
274: p_api_version,