DBA Data[Home] [Help]

APPS.WSH_CC_REQUEST_SETUPS_PKG dependencies on STANDARD

Line 76: -- Standard Start of API savepoint

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

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

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

Line 158: -- Standard check of p_commit.

154: --dbms_output.put_line('Seq Id got it '||l_CC_REQUEST_SEQUENCE_ID||'success');
155: x_return_status := fnd_api.g_ret_sts_success;
156: p_CC_REQUEST_SEQUENCE_ID := l_CC_REQUEST_SEQUENCE_ID;
157: -- End of API body
158: -- Standard check of p_commit.
159: IF FND_API.To_Boolean( p_commit ) THEN
160: COMMIT WORK;
161: END IF;
162: -- Standard call to get message count and if count is 1,

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

158: -- Standard check of p_commit.
159: IF FND_API.To_Boolean( p_commit ) THEN
160: COMMIT WORK;
161: END IF;
162: -- Standard call to get message count and if count is 1,
163: -- get message info.
164: FND_MSG_PUB.Count_And_Get
165: ( p_count => x_msg_count,
166: p_data => x_msg_data

Line 270: -- Standard Start of API savepoint

266: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row' ;
267: l_api_version number := 1.0;
268: BEGIN
269: --dbms_output.put_line('begin');
270: -- Standard Start of API savepoint
271: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
274: p_api_version ,

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

268: BEGIN
269: --dbms_output.put_line('begin');
270: -- Standard Start of API savepoint
271: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
274: p_api_version ,
275: l_api_name ,
276: G_PKG_NAME )

Line 326: -- Standard check of p_commit.

322: --dbms_output.put_line('begin-5');
323: x_return_status := fnd_api.g_ret_sts_success;
324:
325: -- End of API body
326: -- Standard check of p_commit.
327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330: -- Standard call to get message count and if count is 1,

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

326: -- Standard check of p_commit.
327: IF FND_API.To_Boolean( p_commit ) THEN
328: COMMIT WORK;
329: END IF;
330: -- Standard call to get message count and if count is 1,
331: -- get message info.
332: FND_MSG_PUB.Count_And_Get
333: ( p_count => x_msg_count,
334: p_data => x_msg_data

Line 427: -- Standard Start of API savepoint

423: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row' ;
424: l_api_version number := 1.0;
425: BEGIN
426: --dbms_output.put_line('begin');
427: -- Standard Start of API savepoint
428: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
429: -- Standard call to check for call compatibility.
430: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
431: p_api_version ,

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

425: BEGIN
426: --dbms_output.put_line('begin');
427: -- Standard Start of API savepoint
428: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
429: -- Standard call to check for call compatibility.
430: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
431: p_api_version ,
432: l_api_name ,
433: G_PKG_NAME )

Line 461: -- Standard check of p_commit.

457: --dbms_output.put_line('begin-5');
458: x_return_status := fnd_api.g_ret_sts_success;
459:
460: -- End of API body
461: -- Standard check of p_commit.
462: IF FND_API.To_Boolean( p_commit ) THEN
463: COMMIT WORK;
464: END IF;
465: -- Standard call to get message count and if count is 1,

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

461: -- Standard check of p_commit.
462: IF FND_API.To_Boolean( p_commit ) THEN
463: COMMIT WORK;
464: END IF;
465: -- Standard call to get message count and if count is 1,
466: -- get message info.
467: FND_MSG_PUB.Count_And_Get
468: ( p_count => x_msg_count,
469: p_data => x_msg_data

Line 586: -- Standard Start of API savepoint

582: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row' ;
583: l_api_version number := 1.0;
584: BEGIN
585: --dbms_output.put_line('begin');
586: -- Standard Start of API savepoint
587: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
590: p_api_version ,

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

584: BEGIN
585: --dbms_output.put_line('begin');
586: -- Standard Start of API savepoint
587: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
590: p_api_version ,
591: l_api_name ,
592: G_PKG_NAME )