DBA Data[Home] [Help]

APPS.WSH_ITM_USERS_PKG dependencies on STANDARD

Line 74: -- Standard Start of API savepoint

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

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

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

Line 138: -- Standard check of p_commit.

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

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

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

Line 251: -- Standard Start of API savepoint

247: l_api_version number := 1.0;
248:
249: BEGIN
250: --dbms_output.put_line('begin');
251: -- Standard Start of API savepoint
252: SAVEPOINT WSH_ITM_USERS_PKG;
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
255: p_api_version ,

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

249: BEGIN
250: --dbms_output.put_line('begin');
251: -- Standard Start of API savepoint
252: SAVEPOINT WSH_ITM_USERS_PKG;
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
255: p_api_version ,
256: l_api_name ,
257: G_PKG_NAME )

Line 301: -- Standard check of p_commit.

297:
298: x_return_status := fnd_api.g_ret_sts_success;
299:
300: -- End of API body
301: -- Standard check of p_commit.
302:
303: IF FND_API.To_Boolean( p_commit ) THEN
304: COMMIT WORK;
305: END IF;

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

303: IF FND_API.To_Boolean( p_commit ) THEN
304: COMMIT WORK;
305: END IF;
306:
307: -- Standard call to get message count and if count is 1,
308: -- get message info.
309:
310: FND_MSG_PUB.Count_And_Get
311: ( p_count => x_msg_count,

Line 405: -- Standard Start of API savepoint

401: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row' ;
402: l_api_version number := 1.0;
403: BEGIN
404: --dbms_output.put_line('begin');
405: -- Standard Start of API savepoint
406: SAVEPOINT WSH_ITM_USERS_PKG;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
409: p_api_version ,

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

403: BEGIN
404: --dbms_output.put_line('begin');
405: -- Standard Start of API savepoint
406: SAVEPOINT WSH_ITM_USERS_PKG;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
409: p_api_version ,
410: l_api_name ,
411: G_PKG_NAME )

Line 439: -- Standard check of p_commit.

435: --dbms_output.put_line('begin-5');
436: x_return_status := fnd_api.g_ret_sts_success;
437:
438: -- End of API body
439: -- Standard check of p_commit.
440: IF FND_API.To_Boolean( p_commit ) THEN
441: COMMIT WORK;
442: END IF;
443: -- Standard call to get message count and if count is 1,

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

439: -- Standard check of p_commit.
440: IF FND_API.To_Boolean( p_commit ) THEN
441: COMMIT WORK;
442: END IF;
443: -- Standard call to get message count and if count is 1,
444: -- get message info.
445: FND_MSG_PUB.Count_And_Get
446: ( p_count => x_msg_count,
447: p_data => x_msg_data

Line 564: -- Standard Start of API savepoint

560: l_api_version number := 1.0;
561:
562: BEGIN
563:
564: -- Standard Start of API savepoint
565: SAVEPOINT WSH_ITM_USERS_PKG;
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
568: p_api_version ,

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

562: BEGIN
563:
564: -- Standard Start of API savepoint
565: SAVEPOINT WSH_ITM_USERS_PKG;
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
568: p_api_version ,
569: l_api_name ,
570: G_PKG_NAME )