21: l_api_version_number CONSTANT NUMBER := 1.0;
22: l_row_id VARCHAR2(4000);
23: BEGIN
24:
25: -- Standard Start of API savepoint
26: SAVEPOINT CREATE_TABLESPACES_PUB;
27:
28: -- Standard call to check for call compatibility.
29: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
24:
25: -- Standard Start of API savepoint
26: SAVEPOINT CREATE_TABLESPACES_PUB;
27:
28: -- Standard call to check for call compatibility.
29: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
30: p_api_version_number,
31: l_api_name,
32: G_PKG_NAME)
66: P_LAST_UPDATE_DATE => sysdate,
67: P_LAST_UPDATED_BY => G_USER_ID,
68: P_LAST_UPDATE_LOGIN => G_LOGIN_ID );
69:
70: -- Standard check for p_commit
71: IF FND_API.to_Boolean( p_commit )
72: THEN
73: COMMIT WORK;
74: END IF;
72: THEN
73: COMMIT WORK;
74: END IF;
75:
76: -- Standard call to get message count and if count is 1, get message info.
77: FND_MSG_PUB.Count_And_Get
78: ( p_count => x_msg_count,
79: p_data => x_msg_data);
80:
122: l_api_version_number CONSTANT NUMBER := 1.0;
123: l_row_id VARCHAR2(4000);
124: BEGIN
125:
126: -- Standard Start of API savepoint
127: SAVEPOINT UPDATE_TABLESPACES_PUB;
128:
129: -- Standard call to check for call compatibility.
130: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
125:
126: -- Standard Start of API savepoint
127: SAVEPOINT UPDATE_TABLESPACES_PUB;
128:
129: -- Standard call to check for call compatibility.
130: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
131: p_api_version_number,
132: l_api_name,
133: G_PKG_NAME)
164: P_LAST_UPDATE_DATE => sysdate,
165: P_LAST_UPDATED_BY => G_USER_ID,
166: P_LAST_UPDATE_LOGIN => G_LOGIN_ID );
167:
168: -- Standard check for p_commit
169: IF FND_API.to_Boolean( p_commit )
170: THEN
171: COMMIT WORK;
172: END IF;
170: THEN
171: COMMIT WORK;
172: END IF;
173:
174: -- Standard call to get message count and if count is 1, get message info.
175: FND_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count,
177: p_data => x_msg_data);
178:
277: CLOSE c1;
278: END IF;
279: END IF;
280:
281: -- Standard call to get message count and if count is 1, get message info.
282: FND_MSG_PUB.Count_And_Get
283: ( p_count => x_msg_count,
284: p_data => x_msg_data
285: );