61: l_nullable cn_objects.nullable%TYPE := 'N';
62: l_obj_type cn_objects.object_type%TYPE := 'COL';
63:
64: BEGIN
65: -- Standard Start of API savepoint
66: SAVEPOINT Create_Mapping;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.compatible_api_call
69: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
63:
64: BEGIN
65: -- Standard Start of API savepoint
66: SAVEPOINT Create_Mapping;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.compatible_api_call
69: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
70: THEN
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: ;
218:
219: -- End of API body.
220:
221: -- Standard check of p_commit.
222: IF FND_API.To_Boolean( p_commit ) THEN
223: COMMIT WORK;
224: END IF;
225: -- Standard call to get message count and if count is 1, get message info.
221: -- Standard check of p_commit.
222: IF FND_API.To_Boolean( p_commit ) THEN
223: COMMIT WORK;
224: END IF;
225: -- Standard call to get message count and if count is 1, get message info.
226: FND_MSG_PUB.Count_And_Get(
227: p_count => x_msg_count ,
228: p_data => x_msg_data ,
229: p_encoded => FND_API.G_FALSE
357: ;
358: l_unmap_target_csr c_unmap_target_csr%ROWTYPE;
359:
360: BEGIN
361: -- Standard Start of API savepoint
362: SAVEPOINT retrieve_Fields;
363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.compatible_api_call
365: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
359:
360: BEGIN
361: -- Standard Start of API savepoint
362: SAVEPOINT retrieve_Fields;
363: -- Standard call to check for call compatibility.
364: IF NOT FND_API.compatible_api_call
365: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
366: THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END;
454: END IF;
455: -- End of API body.
456:
457: -- Standard check of p_commit.
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: -- Standard call to get message count and if count is 1, get message info.
457: -- Standard check of p_commit.
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get(
463: p_count => x_msg_count ,
464: p_data => x_msg_data ,
465: p_encoded => FND_API.G_FALSE
543: l_imp_map imp_maps_rec_type;
544: l_temp NUMBER;
545:
546: BEGIN
547: -- Standard Start of API savepoint
548: SAVEPOINT Create_Imp_map;
549: -- Standard call to check for call compatibility.
550: IF NOT FND_API.compatible_api_call
551: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
545:
546: BEGIN
547: -- Standard Start of API savepoint
548: SAVEPOINT Create_Imp_map;
549: -- Standard call to check for call compatibility.
550: IF NOT FND_API.compatible_api_call
551: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
552: THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: (p_imp_maps_rec => l_imp_map);
592:
593: -- End of API body.
594:
595: -- Standard check of p_commit.
596: IF FND_API.To_Boolean( p_commit ) THEN
597: COMMIT WORK;
598: END IF;
599: -- Standard call to get message count and if count is 1, get message info.
595: -- Standard check of p_commit.
596: IF FND_API.To_Boolean( p_commit ) THEN
597: COMMIT WORK;
598: END IF;
599: -- Standard call to get message count and if count is 1, get message info.
600: FND_MSG_PUB.Count_And_Get(
601: p_count => x_msg_count ,
602: p_data => x_msg_data ,
603: p_encoded => FND_API.G_FALSE
680: l_imp_map imp_maps_rec_type;
681: l_temp NUMBER;
682:
683: BEGIN
684: -- Standard Start of API savepoint
685: SAVEPOINT Delete_Imp_map;
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.compatible_api_call
688: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
682:
683: BEGIN
684: -- Standard Start of API savepoint
685: SAVEPOINT Delete_Imp_map;
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.compatible_api_call
688: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
689: THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: cn_imp_maps_pkg.delete_row
738: (p_imp_map_id => l_imp_map.imp_map_id);
739: -- End of API body.
740:
741: -- Standard check of p_commit.
742: IF FND_API.To_Boolean( p_commit ) THEN
743: COMMIT WORK;
744: END IF;
745: -- Standard call to get message count and if count is 1, get message info.
741: -- Standard check of p_commit.
742: IF FND_API.To_Boolean( p_commit ) THEN
743: COMMIT WORK;
744: END IF;
745: -- Standard call to get message count and if count is 1, get message info.
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE