[Home] [Help]
36: l_api_version_number CONSTANT NUMBER := 2.0;
37: l_return_status_full VARCHAR2(1);
38: l_access_flag VARCHAR2(1);
39: BEGIN
40: -- Standard Start of API savepoint
41: SAVEPOINT CREATE_SELATTVAL_PVT;
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
39: BEGIN
40: -- Standard Start of API savepoint
41: SAVEPOINT CREATE_SELATTVAL_PVT;
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
155: --
156: -- End of API body
157: --
158:
159: -- Standard check for p_commit
160: IF FND_API.to_Boolean( p_commit )
161: THEN
162: COMMIT WORK;
163: END IF;
169: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
170: END IF;
171:
172:
173: -- Standard call to get message count and if count is 1, get message info.
174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count,
176: p_data => x_msg_data
177: );
238: l_ref_SELATTVAL_rec PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type;
239: l_tar_SELATTVAL_rec PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type := P_SELATTVAL_Rec;
240: l_rowid ROWID;
241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT UPDATE_SELATTVAL_PVT;
244:
245: -- Standard call to check for call compatibility.
246: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT UPDATE_SELATTVAL_PVT;
244:
245: -- Standard call to check for call compatibility.
246: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
247: p_api_version_number,
248: l_api_name,
249: G_PKG_NAME)
386: --
387: -- End of API body.
388: --
389:
390: -- Standard check for p_commit
391: IF FND_API.to_Boolean( p_commit )
392: THEN
393: COMMIT WORK;
394: END IF;
400: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
401: END IF;
402:
403:
404: -- Standard call to get message count and if count is 1, get message info.
405: FND_MSG_PUB.Count_And_Get
406: ( p_count => x_msg_count,
407: p_data => x_msg_data
408: );
460: l_api_name CONSTANT VARCHAR2(30) := 'Delete_selattval';
461: l_api_version_number CONSTANT NUMBER := 2.0;
462: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
463: BEGIN
464: -- Standard Start of API savepoint
465: SAVEPOINT DELETE_SELATTVAL_PVT;
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
463: BEGIN
464: -- Standard Start of API savepoint
465: SAVEPOINT DELETE_SELATTVAL_PVT;
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
507: --
508: -- End of API body
509: --
510:
511: -- Standard check for p_commit
512: IF FND_API.to_Boolean( p_commit )
513: THEN
514: COMMIT WORK;
515: END IF;
521: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
522: END IF;
523:
524:
525: -- Standard call to get message count and if count is 1, get message info.
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,
528: p_data => x_msg_data
529: );
635: END IF;
636: END IF;
637:
638:
639: -- Standard call to get message count and if count is 1, get message info.
640: FND_MSG_PUB.Count_And_Get
641: ( p_count => x_msg_count,
642: p_data => x_msg_data
643: );
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END IF;
701: CLOSE C_select_criteria_id_Exists;
702:
703: -- Standard call to get message count and if count is 1, get message info.
704: FND_MSG_PUB.Count_And_Get
705: ( p_count => x_msg_count,
706: p_data => x_msg_data
707: );