DBA Data[Home] [Help]

APPS.WSH_CC_SERVICE_SETUPS_PKG dependencies on STANDARD

Line 79: -- Standard Start of API savepoint

75: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
76: l_api_version number := 1.0;
77: begin
78: --dbms_output.put_line('begin api');
79: -- Standard Start of API savepoint
80: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
83: p_api_version ,

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

77: begin
78: --dbms_output.put_line('begin api');
79: -- Standard Start of API savepoint
80: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
83: p_api_version ,
84: l_api_name ,
85: G_PKG_NAME )

Line 167: -- Standard check of p_commit.

163: --dbms_output.put_line('Seq Id got it '||l_CC_Service_SEQUENCE_ID||'success');
164: x_return_status := fnd_api.g_ret_sts_success;
165: p_CC_SERVICE_SEQUENCE_ID := l_CC_SERVICE_SEQUENCE_ID;
166: -- End of API body
167: -- Standard check of p_commit.
168: IF FND_API.To_Boolean( p_commit ) THEN
169: COMMIT WORK;
170: END IF;
171: -- Standard call to get message count and if count is 1,

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

167: -- Standard check of p_commit.
168: IF FND_API.To_Boolean( p_commit ) THEN
169: COMMIT WORK;
170: END IF;
171: -- Standard call to get message count and if count is 1,
172: -- get message info.
173: FND_MSG_PUB.Count_And_Get
174: ( p_count => x_msg_count,
175: p_data => x_msg_data

Line 282: -- Standard Start of API savepoint

278: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row' ;
279: l_api_version number := 1.0;
280: BEGIN
281: --dbms_output.put_line('begin');
282: -- Standard Start of API savepoint
283: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
286: p_api_version ,

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

280: BEGIN
281: --dbms_output.put_line('begin');
282: -- Standard Start of API savepoint
283: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
286: p_api_version ,
287: l_api_name ,
288: G_PKG_NAME )

Line 341: -- Standard check of p_commit.

337: --dbms_output.put_line('begin-5');
338: x_return_status := fnd_api.g_ret_sts_success;
339:
340: -- End of API body
341: -- Standard check of p_commit.
342: IF FND_API.To_Boolean( p_commit ) THEN
343: COMMIT WORK;
344: END IF;
345: -- Standard call to get message count and if count is 1,

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

341: -- Standard check of p_commit.
342: IF FND_API.To_Boolean( p_commit ) THEN
343: COMMIT WORK;
344: END IF;
345: -- Standard call to get message count and if count is 1,
346: -- get message info.
347: FND_MSG_PUB.Count_And_Get
348: ( p_count => x_msg_count,
349: p_data => x_msg_data

Line 442: -- Standard Start of API savepoint

438: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row' ;
439: l_api_version number := 1.0;
440: BEGIN
441: --dbms_output.put_line('begin');
442: -- Standard Start of API savepoint
443: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
444: -- Standard call to check for call compatibility.
445: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
446: p_api_version ,

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

440: BEGIN
441: --dbms_output.put_line('begin');
442: -- Standard Start of API savepoint
443: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
444: -- Standard call to check for call compatibility.
445: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
446: p_api_version ,
447: l_api_name ,
448: G_PKG_NAME )

Line 476: -- Standard check of p_commit.

472: --dbms_output.put_line('begin-5');
473: x_return_status := fnd_api.g_ret_sts_success;
474:
475: -- End of API body
476: -- Standard check of p_commit.
477: IF FND_API.To_Boolean( p_commit ) THEN
478: COMMIT WORK;
479: END IF;
480: -- Standard call to get message count and if count is 1,

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

476: -- Standard check of p_commit.
477: IF FND_API.To_Boolean( p_commit ) THEN
478: COMMIT WORK;
479: END IF;
480: -- Standard call to get message count and if count is 1,
481: -- get message info.
482: FND_MSG_PUB.Count_And_Get
483: ( p_count => x_msg_count,
484: p_data => x_msg_data

Line 604: -- Standard Start of API savepoint

600: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row' ;
601: l_api_version number := 1.0;
602: BEGIN
603: --dbms_output.put_line('begin');
604: -- Standard Start of API savepoint
605: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
608: p_api_version ,

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

602: BEGIN
603: --dbms_output.put_line('begin');
604: -- Standard Start of API savepoint
605: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
608: p_api_version ,
609: l_api_name ,
610: G_PKG_NAME )