[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_ENTYATTMAP_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_ENTYATTMAP_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)
156: --
157: -- End of API body
158: --
159:
160: -- Standard check for p_commit
161: IF FND_API.to_Boolean( p_commit )
162: THEN
163: COMMIT WORK;
164: END IF;
170: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
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: );
239: l_ref_ENTYATTMAP_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type;
240: l_tar_ENTYATTMAP_rec PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type := P_ENTYATTMAP_Rec;
241: l_rowid ROWID;
242: BEGIN
243: -- Standard Start of API savepoint
244: SAVEPOINT UPDATE_ENTYATTMAP_PVT;
245:
246: -- Standard call to check for call compatibility.
247: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
242: BEGIN
243: -- Standard Start of API savepoint
244: SAVEPOINT UPDATE_ENTYATTMAP_PVT;
245:
246: -- Standard call to check for call compatibility.
247: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
248: p_api_version_number,
249: l_api_name,
250: G_PKG_NAME)
389: ); --
390: -- End of API body.
391: --
392:
393: -- Standard check for p_commit
394: IF FND_API.to_Boolean( p_commit )
395: THEN
396: COMMIT WORK;
397: END IF;
403: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
404: END IF;
405:
406:
407: -- Standard call to get message count and if count is 1, get message info.
408: FND_MSG_PUB.Count_And_Get
409: ( p_count => x_msg_count,
410: p_data => x_msg_data
411: );
462: IS
463: l_api_name CONSTANT VARCHAR2(30) := 'Delete_entyattmap';
464: l_api_version_number CONSTANT NUMBER := 2.0;
465: BEGIN
466: -- Standard Start of API savepoint
467: SAVEPOINT DELETE_ENTYATTMAP_PVT;
468:
469: -- Standard call to check for call compatibility.
470: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
465: BEGIN
466: -- Standard Start of API savepoint
467: SAVEPOINT DELETE_ENTYATTMAP_PVT;
468:
469: -- Standard call to check for call compatibility.
470: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
471: p_api_version_number,
472: l_api_name,
473: G_PKG_NAME)
509: --
510: -- End of API body
511: --
512:
513: -- Standard check for p_commit
514: IF FND_API.to_Boolean( p_commit )
515: THEN
516: COMMIT WORK;
517: END IF;
523: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
524: END IF;
525:
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get
529: ( p_count => x_msg_count,
530: p_data => x_msg_data
531: );
636: CLOSE C_mapping_id_exists;
637: END IF;
638: END IF;
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get
642: ( p_count => x_msg_count,
643: p_data => x_msg_data
644: );
702: END IF;
703:
704: end if;
705:
706: -- Standard call to get message count and if count is 1, get message info.
707: FND_MSG_PUB.Count_And_Get
708: ( p_count => x_msg_count,
709: p_data => x_msg_data
710: );