DBA Data[Home] [Help]

APPS.WSH_CC_USERS_PKG dependencies on STANDARD

Line 72: -- Standard Start of API savepoint

68: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
69: l_api_version number := 1.0;
70: begin
71: --dbms_output.put_line('begin api');
72: -- Standard Start of API savepoint
73: SAVEPOINT WSH_CC_USERS_PKG;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
76: p_api_version ,

Line 74: -- Standard call to check for call compatibility.

70: begin
71: --dbms_output.put_line('begin api');
72: -- Standard Start of API savepoint
73: SAVEPOINT WSH_CC_USERS_PKG;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
76: p_api_version ,
77: l_api_name ,
78: G_PKG_NAME )

Line 134: -- Standard check of p_commit.

130: --dbms_output.put_line('Seq Id got it '||l_CC_USER_SEQUENCE_ID||'success');
131: x_return_status := fnd_api.g_ret_sts_success;
132: p_CC_USER_SEQUENCE_ID := l_CC_USER_SEQUENCE_ID;
133: -- End of API body
134: -- Standard check of p_commit.
135: IF FND_API.To_Boolean( p_commit ) THEN
136: COMMIT WORK;
137: END IF;
138: -- Standard call to get message count and if count is 1,

Line 138: -- Standard call to get message count and if count is 1,

134: -- Standard check of p_commit.
135: IF FND_API.To_Boolean( p_commit ) THEN
136: COMMIT WORK;
137: END IF;
138: -- Standard call to get message count and if count is 1,
139: -- get message info.
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data

Line 242: -- Standard Start of API savepoint

238: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row' ;
239: l_api_version number := 1.0;
240: BEGIN
241: --dbms_output.put_line('begin');
242: -- Standard Start of API savepoint
243: SAVEPOINT WSH_CC_USERS_PKG;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
246: p_api_version ,

Line 244: -- Standard call to check for call compatibility.

240: BEGIN
241: --dbms_output.put_line('begin');
242: -- Standard Start of API savepoint
243: SAVEPOINT WSH_CC_USERS_PKG;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
246: p_api_version ,
247: l_api_name ,
248: G_PKG_NAME )

Line 288: -- Standard check of p_commit.

284: --dbms_output.put_line('begin-5');
285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: -- End of API body
288: -- Standard check of p_commit.
289: IF FND_API.To_Boolean( p_commit ) THEN
290: COMMIT WORK;
291: END IF;
292: -- Standard call to get message count and if count is 1,

Line 292: -- Standard call to get message count and if count is 1,

288: -- Standard check of p_commit.
289: IF FND_API.To_Boolean( p_commit ) THEN
290: COMMIT WORK;
291: END IF;
292: -- Standard call to get message count and if count is 1,
293: -- get message info.
294: FND_MSG_PUB.Count_And_Get
295: ( p_count => x_msg_count,
296: p_data => x_msg_data

Line 388: -- Standard Start of API savepoint

384: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row' ;
385: l_api_version number := 1.0;
386: BEGIN
387: --dbms_output.put_line('begin');
388: -- Standard Start of API savepoint
389: SAVEPOINT WSH_CC_USERS_PKG;
390: -- Standard call to check for call compatibility.
391: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
392: p_api_version ,

Line 390: -- Standard call to check for call compatibility.

386: BEGIN
387: --dbms_output.put_line('begin');
388: -- Standard Start of API savepoint
389: SAVEPOINT WSH_CC_USERS_PKG;
390: -- Standard call to check for call compatibility.
391: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
392: p_api_version ,
393: l_api_name ,
394: G_PKG_NAME )

Line 422: -- Standard check of p_commit.

418: --dbms_output.put_line('begin-5');
419: x_return_status := fnd_api.g_ret_sts_success;
420:
421: -- End of API body
422: -- Standard check of p_commit.
423: IF FND_API.To_Boolean( p_commit ) THEN
424: COMMIT WORK;
425: END IF;
426: -- Standard call to get message count and if count is 1,

Line 426: -- Standard call to get message count and if count is 1,

422: -- Standard check of p_commit.
423: IF FND_API.To_Boolean( p_commit ) THEN
424: COMMIT WORK;
425: END IF;
426: -- Standard call to get message count and if count is 1,
427: -- get message info.
428: FND_MSG_PUB.Count_And_Get
429: ( p_count => x_msg_count,
430: p_data => x_msg_data

Line 544: -- Standard Start of API savepoint

540: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row' ;
541: l_api_version number := 1.0;
542: BEGIN
543: --dbms_output.put_line('begin');
544: -- Standard Start of API savepoint
545: SAVEPOINT WSH_CC_USERS_PKG;
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
548: p_api_version ,

Line 546: -- Standard call to check for call compatibility.

542: BEGIN
543: --dbms_output.put_line('begin');
544: -- Standard Start of API savepoint
545: SAVEPOINT WSH_CC_USERS_PKG;
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
548: p_api_version ,
549: l_api_name ,
550: G_PKG_NAME )