DBA Data[Home] [Help]

APPS.CSC_PROFILE_VARIABLE_PUB dependencies on STANDARD

Line 214: -- Standard Start of API Savepoint

210: l_prof_var_rec ProfVar_Rec_Type := p_prof_var_rec;
211: l_pvt_prof_var_rec CSC_Profile_Variable_PVT.ProfVar_Rec_Type;
212: BEGIN
213:
214: -- Standard Start of API Savepoint
215: SAVEPOINT Create_Profile_Variable_Pub ;
216:
217: -- Standard Call to check API compatibility
218: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 217: -- Standard Call to check API compatibility

213:
214: -- Standard Start of API Savepoint
215: SAVEPOINT Create_Profile_Variable_Pub ;
216:
217: -- Standard Call to check API compatibility
218: IF NOT FND_API.Compatible_API_Call( l_api_version,
219: p_api_version_number,
220: l_api_name,
221: G_PKG_NAME )

Line 261: -- Standard Check of p_commit

257: END IF;
258:
259:
260: -- End of API Body
261: -- Standard Check of p_commit
262: IF FND_API.To_Boolean( p_commit ) THEN
263: COMMIT WORK ;
264: END IF ;
265:

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

262: IF FND_API.To_Boolean( p_commit ) THEN
263: COMMIT WORK ;
264: END IF ;
265:
266: -- Standard call to get message count and if count is 1 , get message info
267: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
268: p_data => x_msg_data) ;
269:
270: -- Begin Exception Handling

Line 313: -- Standard Start of API savepoint

309: IS
310: l_api_name CONSTANT VARCHAR2(30) := 'Create_Table_Column';
311: l_api_version_number CONSTANT NUMBER := 1.0;
312: BEGIN
313: -- Standard Start of API savepoint
314: SAVEPOINT CREATE_Table_Column_PUB;
315:
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

312: BEGIN
313: -- Standard Start of API savepoint
314: SAVEPOINT CREATE_Table_Column_PUB;
315:
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
318: p_api_version_number,
319: l_api_name,
320: G_PKG_NAME)

Line 368: -- Standard check for p_commit

364: --
365: -- End of API body.
366: --
367:
368: -- Standard check for p_commit
369: IF FND_API.to_Boolean( p_commit )
370: THEN
371: COMMIT WORK;
372: END IF;

Line 375: -- Standard call to get message count and if count is 1, get message info.

371: COMMIT WORK;
372: END IF;
373:
374:
375: -- Standard call to get message count and if count is 1, get message info.
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count,
378: p_data => x_msg_data
379: );

Line 511: -- Standard Start of API Savepoint

507: l_prof_var_rec ProfVar_Rec_Type := p_prof_var_rec;
508: l_pvt_prof_var_rec CSC_Profile_Variable_PVT.ProfVar_Rec_Type;
509: BEGIN
510:
511: -- Standard Start of API Savepoint
512: SAVEPOINT Update_Profile_Variable_Pub ;
513:
514: -- Standard Call to check API compatibility
515: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 514: -- Standard Call to check API compatibility

510:
511: -- Standard Start of API Savepoint
512: SAVEPOINT Update_Profile_Variable_Pub ;
513:
514: -- Standard Call to check API compatibility
515: IF NOT FND_API.Compatible_API_Call( l_api_version,
516: p_api_version_number,
517: l_api_name,
518: G_PKG_NAME )

Line 560: -- Standard Check of p_commit

556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: -- End of API Body
560: -- Standard Check of p_commit
561: IF FND_API.To_Boolean( p_commit ) THEN
562: COMMIT WORK ;
563: END IF ;
564:

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

561: IF FND_API.To_Boolean( p_commit ) THEN
562: COMMIT WORK ;
563: END IF ;
564:
565: -- Standard call to get message count and if count is 1 , get message info
566: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
567: p_data => x_msg_data) ;
568:
569: -- Begin Exception Handling

Line 614: -- Standard Start of API savepoint

610: IS
611: l_api_name CONSTANT VARCHAR2(30) := 'Update_table_column';
612: l_api_version_number CONSTANT NUMBER := 1.0;
613: BEGIN
614: -- Standard Start of API savepoint
615: SAVEPOINT UPDATE_Table_Column_PUB;
616:
617: -- Standard call to check for call compatibility.
618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

613: BEGIN
614: -- Standard Start of API savepoint
615: SAVEPOINT UPDATE_Table_Column_PUB;
616:
617: -- Standard call to check for call compatibility.
618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
619: p_api_version_number,
620: l_api_name,
621: G_PKG_NAME)

Line 663: -- Standard check for p_commit

659: --
660: -- End of API body
661: --
662:
663: -- Standard check for p_commit
664: IF FND_API.to_Boolean( p_commit )
665: THEN
666: COMMIT WORK;
667: END IF;

Line 670: -- Standard call to get message count and if count is 1, get message info.

666: COMMIT WORK;
667: END IF;
668:
669:
670: -- Standard call to get message count and if count is 1, get message info.
671: FND_MSG_PUB.Count_And_Get
672: ( p_count => x_msg_count,
673: p_data => x_msg_data
674: );