The following lines contain the word 'select', 'insert', 'update' or 'delete':
PV_ENTITY_ATTR_MAPPINGS_PKG.Insert_Row(
px_MAPPING_ID => x_MAPPING_ID
,p_LAST_UPDATE_DATE => SYSDATE
,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
,p_CREATION_DATE => SYSDATE
,p_CREATED_BY => FND_GLOBAL.USER_ID
,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
,p_OBJECT_VERSION_NUMBER => p_ENTYATTMAP_rec.OBJECT_VERSION_NUMBER
,p_REQUEST_ID => p_ENTYATTMAP_rec.REQUEST_ID
,p_PROGRAM_APPLICATION_ID => p_ENTYATTMAP_rec.PROGRAM_APPLICATION_ID
,p_PROGRAM_ID => p_ENTYATTMAP_rec.PROGRAM_ID
,p_PROGRAM_UPDATE_DATE => p_ENTYATTMAP_rec.PROGRAM_UPDATE_DATE
,p_PROCESS_RULE_ID => p_ENTYATTMAP_rec.PROCESS_RULE_ID
,p_SOURCE_ATTR_TYPE => p_ENTYATTMAP_rec.SOURCE_ATTR_TYPE
,p_SOURCE_ATTR_ID => p_ENTYATTMAP_rec.SOURCE_ATTR_ID
,p_TARGET_ATTR_TYPE => p_ENTYATTMAP_rec.TARGET_ATTR_TYPE
,p_TARGET_ATTR_ID => p_ENTYATTMAP_rec.TARGET_ATTR_ID
,p_OPERATOR => p_ENTYATTMAP_rec.OPERATOR
,p_ATTRIBUTE_CATEGORY => p_ENTYATTMAP_rec.ATTRIBUTE_CATEGORY
,p_ATTRIBUTE1 => p_ENTYATTMAP_rec.ATTRIBUTE1
,p_ATTRIBUTE2 => p_ENTYATTMAP_rec.ATTRIBUTE2
,p_ATTRIBUTE3 => p_ENTYATTMAP_rec.ATTRIBUTE3
,p_ATTRIBUTE4 => p_ENTYATTMAP_rec.ATTRIBUTE4
,p_ATTRIBUTE5 => p_ENTYATTMAP_rec.ATTRIBUTE5
,p_ATTRIBUTE6 => p_ENTYATTMAP_rec.ATTRIBUTE6
,p_ATTRIBUTE7 => p_ENTYATTMAP_rec.ATTRIBUTE7
,p_ATTRIBUTE8 => p_ENTYATTMAP_rec.ATTRIBUTE8
,p_ATTRIBUTE9 => p_ENTYATTMAP_rec.ATTRIBUTE9
,p_ATTRIBUTE10 => p_ENTYATTMAP_rec.ATTRIBUTE10
,p_ATTRIBUTE11 => p_ENTYATTMAP_rec.ATTRIBUTE11
,p_ATTRIBUTE12 => p_ENTYATTMAP_rec.ATTRIBUTE12
,p_ATTRIBUTE13 => p_ENTYATTMAP_rec.ATTRIBUTE13
,p_ATTRIBUTE14 => p_ENTYATTMAP_rec.ATTRIBUTE14
,p_ATTRIBUTE15 => p_ENTYATTMAP_rec.ATTRIBUTE15
);
PROCEDURE Update_entyattmap(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_Identity_Resource_Id IN NUMBER,
P_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
Cursor C_Get_entyattmap(pc_MAPPING_ID Number) IS
Select object_version_number
From PV_ENTITY_ATTR_MAPPINGS
where mapping_id = pc_mapping_id
For Update NOWAIT;
l_api_name CONSTANT VARCHAR2(30) := 'Update_entyattmap';
SAVEPOINT UPDATE_ENTYATTMAP_PVT;
AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');
p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
P_ENTYATTMAP_Rec => P_ENTYATTMAP_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
PV_ENTITY_ATTR_MAPPINGS_PKG.Update_Row(
p_MAPPING_ID => p_ENTYATTMAP_rec.MAPPING_ID
,p_LAST_UPDATE_DATE => SYSDATE
,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
,p_CREATION_DATE => FND_API.G_MISS_DATE
,p_CREATED_BY => FND_API.G_MISS_NUM
,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
,p_OBJECT_VERSION_NUMBER => p_ENTYATTMAP_rec.OBJECT_VERSION_NUMBER
,p_REQUEST_ID => p_ENTYATTMAP_rec.REQUEST_ID
,p_PROGRAM_APPLICATION_ID => p_ENTYATTMAP_rec.PROGRAM_APPLICATION_ID
,p_PROGRAM_ID => p_ENTYATTMAP_rec.PROGRAM_ID
,p_PROGRAM_UPDATE_DATE => p_ENTYATTMAP_rec.PROGRAM_UPDATE_DATE
,p_PROCESS_RULE_ID => p_ENTYATTMAP_rec.PROCESS_RULE_ID
,p_SOURCE_ATTR_TYPE => p_ENTYATTMAP_rec.SOURCE_ATTR_TYPE
,p_SOURCE_ATTR_ID => p_ENTYATTMAP_rec.SOURCE_ATTR_ID
,p_TARGET_ATTR_TYPE => p_ENTYATTMAP_rec.TARGET_ATTR_TYPE
,p_TARGET_ATTR_ID => p_ENTYATTMAP_rec.TARGET_ATTR_ID
,p_OPERATOR => p_ENTYATTMAP_rec.OPERATOR
,p_ATTRIBUTE_CATEGORY => p_ENTYATTMAP_rec.ATTRIBUTE_CATEGORY
,p_ATTRIBUTE1 => p_ENTYATTMAP_rec.ATTRIBUTE1
,p_ATTRIBUTE2 => p_ENTYATTMAP_rec.ATTRIBUTE2
,p_ATTRIBUTE3 => p_ENTYATTMAP_rec.ATTRIBUTE3
,p_ATTRIBUTE4 => p_ENTYATTMAP_rec.ATTRIBUTE4
,p_ATTRIBUTE5 => p_ENTYATTMAP_rec.ATTRIBUTE5
,p_ATTRIBUTE6 => p_ENTYATTMAP_rec.ATTRIBUTE6
,p_ATTRIBUTE7 => p_ENTYATTMAP_rec.ATTRIBUTE7
,p_ATTRIBUTE8 => p_ENTYATTMAP_rec.ATTRIBUTE8
,p_ATTRIBUTE9 => p_ENTYATTMAP_rec.ATTRIBUTE9
,p_ATTRIBUTE10 => p_ENTYATTMAP_rec.ATTRIBUTE10
,p_ATTRIBUTE11 => p_ENTYATTMAP_rec.ATTRIBUTE11
,p_ATTRIBUTE12 => p_ENTYATTMAP_rec.ATTRIBUTE12
,p_ATTRIBUTE13 => p_ENTYATTMAP_rec.ATTRIBUTE13
,p_ATTRIBUTE14 => p_ENTYATTMAP_rec.ATTRIBUTE14
,p_ATTRIBUTE15 => p_ENTYATTMAP_rec.ATTRIBUTE15
); --
End Update_entyattmap;
PROCEDURE Delete_entyattmap(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_Identity_Resource_Id IN NUMBER,
P_ENTYATTMAP_Rec IN PV_RULE_RECTYPE_PUB.ENTYATTMAP_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_entyattmap';
SAVEPOINT DELETE_ENTYATTMAP_PVT;
AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
PV_ENTITY_ATTR_MAPPINGS_PKG.Delete_Row(
p_MAPPING_ID => p_ENTYATTMAP_rec.MAPPING_ID);
End Delete_entyattmap;
SELECT 'X'
FROM pv_entity_attr_mappings
WHERE mapping_id = pc_mapping_id;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- validate NOT NULL column
IF (p_mapping_id IS NULL) OR
(p_mapping_id = FND_API.G_MISS_NUM)
THEN
AS_UTILITY_PVT.Set_Message(
p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
p_msg_name => 'API_MISSING_LEAD_ID');