25: l_application_id NUMBER;
26: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
27: BEGIN
28:
29: -- Standard Start of API savepoint
30: SAVEPOINT CREATE_OBJECT_TABLESPACES_PUB;
31:
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
28:
29: -- Standard Start of API savepoint
30: SAVEPOINT CREATE_OBJECT_TABLESPACES_PUB;
31:
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
34: p_api_version_number,
35: l_api_name,
36: G_PKG_NAME)
79: P_LAST_UPDATE_DATE => sysdate,
80: P_LAST_UPDATED_BY => G_USER_ID,
81: P_LAST_UPDATE_LOGIN => G_LOGIN_ID );
82:
83: -- Standard check for p_commit
84: IF FND_API.to_Boolean( p_commit )
85: THEN
86: COMMIT WORK;
87: END IF;
85: THEN
86: COMMIT WORK;
87: END IF;
88:
89: -- Standard call to get message count and if count is 1, get message info.
90: FND_MSG_PUB.Count_And_Get
91: ( p_count => x_msg_count,
92: p_data => x_msg_data);
93:
140: l_application_id NUMBER;
141: l_oracle_username FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
142: BEGIN
143:
144: -- Standard Start of API savepoint
145: SAVEPOINT UPDATE_OBJECT_TABLESPACES_PUB;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
143:
144: -- Standard Start of API savepoint
145: SAVEPOINT UPDATE_OBJECT_TABLESPACES_PUB;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
149: p_api_version_number,
150: l_api_name,
151: G_PKG_NAME)
191: P_LAST_UPDATE_DATE => sysdate,
192: P_LAST_UPDATED_BY => G_USER_ID,
193: P_LAST_UPDATE_LOGIN => G_LOGIN_ID);
194:
195: -- Standard check for p_commit
196: IF FND_API.to_Boolean( p_commit )
197: THEN
198: COMMIT WORK;
199: END IF;
197: THEN
198: COMMIT WORK;
199: END IF;
200:
201: -- Standard call to get message count and if count is 1, get message info.
202: FND_MSG_PUB.Count_And_Get
203: ( p_count => x_msg_count,
204: p_data => x_msg_data);
205:
441:
442: x_application_id := l_application_id;
443: x_oracle_username := l_oracle_username;
444:
445: -- Standard call to get message count and if count is 1, get message info.
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data
449: );