DBA Data[Home] [Help]

APPS.CSC_PROF_COLOR_CODE_PVT dependencies on STANDARD

Line 104: -- Standard Start of API savepoint

100: l_api_name CONSTANT VARCHAR2(30) := 'Create_prof_color_code';
101: l_api_version_number CONSTANT NUMBER := 1.0;
102: l_return_status_full VARCHAR2(1);
103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT CREATE_PROF_COLOR_CODE_PVT;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT CREATE_PROF_COLOR_CODE_PVT;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
109: p_api_version_number,
110: l_api_name,
111: G_PKG_NAME)

Line 167: -- Standard check for p_commit

163: --
164: -- End of API body
165: --
166:
167: -- Standard check for p_commit
168: IF FND_API.to_Boolean( p_commit )
169: THEN
170: COMMIT WORK;
171: END IF;

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

170: COMMIT WORK;
171: END IF;
172:
173:
174: -- Standard call to get message count and if count is 1, get message info.
175: FND_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count,
177: p_data => x_msg_data
178: );

Line 282: -- Standard Start of API savepoint

278: l_api_name CONSTANT VARCHAR2(30) := 'Update_prof_color_code';
279: l_api_version_number CONSTANT NUMBER := 1.0;
280: l_rowid ROWID;
281: BEGIN
282: -- Standard Start of API savepoint
283: SAVEPOINT UPDATE_PROF_COLOR_CODE_PVT;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

281: BEGIN
282: -- Standard Start of API savepoint
283: SAVEPOINT UPDATE_PROF_COLOR_CODE_PVT;
284:
285: -- Standard call to check for call compatibility.
286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
287: p_api_version_number,
288: l_api_name,
289: G_PKG_NAME)

Line 364: -- Standard check for p_commit

360: --
361: -- End of API body.
362: --
363:
364: -- Standard check for p_commit
365: IF FND_API.to_Boolean( p_commit )
366: THEN
367: COMMIT WORK;
368: END IF;

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

366: THEN
367: COMMIT WORK;
368: END IF;
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data
374: );

Line 419: -- Standard Start of API savepoint

415: IS
416: l_api_name CONSTANT VARCHAR2(30) := 'Delete_prof_color_code';
417: l_api_version_number CONSTANT NUMBER := 1.0;
418: BEGIN
419: -- Standard Start of API savepoint
420: SAVEPOINT DELETE_PROF_COLOR_CODE_PVT;
421:
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

418: BEGIN
419: -- Standard Start of API savepoint
420: SAVEPOINT DELETE_PROF_COLOR_CODE_PVT;
421:
422: -- Standard call to check for call compatibility.
423: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
424: p_api_version_number,
425: l_api_name,
426: G_PKG_NAME)

Line 454: -- Standard check for p_commit

450: --
451: -- End of API body
452: --
453:
454: -- Standard check for p_commit
455: IF FND_API.to_Boolean( p_commit )
456: THEN
457: COMMIT WORK;
458: END IF;

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

459:
460:
461:
462:
463: -- Standard call to get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get
465: ( p_count => x_msg_count,
466: p_data => x_msg_data
467: );

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

554: end if;
555:
556: END IF;
557:
558: -- Standard call to get message count and if count is 1, get message info.
559: FND_MSG_PUB.Count_And_Get
560: ( p_count => x_msg_count,
561: p_data => x_msg_data
562: );

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

643: END IF;
644:
645: --END IF;
646:
647: -- Standard call to get message count and if count is 1, get message info.
648: FND_MSG_PUB.Count_And_Get
649: ( p_count => x_msg_count,
650: p_data => x_msg_data
651: );