The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select rowid,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
RELATED_ITEM_ID,
RELATIONSHIP_TYPE_ID,
RECIPROCAL_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE
From MTL_RELATED_ITEMS
WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
AND organization_id = P_REL_ITEM_Rec.organization_id
AND related_item_id = P_REL_ITEM_Rec.related_item_id
AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;
SELECT item_owner_id
FROM ams_item_attributes
WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
AND organization_id = P_REL_ITEM_rec.organization_id;
AMS_RELATED_ITEMS_PKG.Insert_Row(
p_INVENTORY_ITEM_ID => p_REL_ITEM_rec.INVENTORY_ITEM_ID,
p_ORGANIZATION_ID => p_REL_ITEM_rec.ORGANIZATION_ID,
p_RELATED_ITEM_ID => p_REL_ITEM_rec.RELATED_ITEM_ID,
p_RELATIONSHIP_TYPE_ID => p_REL_ITEM_rec.RELATIONSHIP_TYPE_ID,
p_RECIPROCAL_FLAG => p_REL_ITEM_rec.RECIPROCAL_FLAG,
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_REQUEST_ID => p_REL_ITEM_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_REL_ITEM_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_REL_ITEM_rec.PROGRAM_UPDATE_DATE);
PROCEDURE Update_rel_item(
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,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
P_REL_ITEM_Rec IN REL_ITEM_Rec_Type
)
IS
Cursor C_Get_rel_item IS
Select rowid,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
RELATED_ITEM_ID,
RELATIONSHIP_TYPE_ID,
RECIPROCAL_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE
From MTL_RELATED_ITEMS
WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
AND organization_id = P_REL_ITEM_Rec.organization_id
AND related_item_id = P_REL_ITEM_Rec.related_item_id
AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;
l_api_name CONSTANT VARCHAR2(30) := 'Update_rel_item';
SAVEPOINT UPDATE_REL_ITEM_PVT;
AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
l_ref_REL_ITEM_rec.LAST_UPDATE_DATE,
l_ref_REL_ITEM_rec.LAST_UPDATED_BY,
l_ref_REL_ITEM_rec.CREATION_DATE,
l_ref_REL_ITEM_rec.CREATED_BY,
l_ref_REL_ITEM_rec.LAST_UPDATE_LOGIN,
l_ref_REL_ITEM_rec.REQUEST_ID,
l_ref_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
l_ref_REL_ITEM_rec.PROGRAM_ID,
l_ref_REL_ITEM_rec.PROGRAM_UPDATE_DATE;
FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
AMS_RELATED_ITEMS_PKG.Update_Row(
p_INVENTORY_ITEM_ID => p_REL_ITEM_rec.INVENTORY_ITEM_ID,
p_ORGANIZATION_ID => p_REL_ITEM_rec.ORGANIZATION_ID,
p_RELATED_ITEM_ID => p_REL_ITEM_rec.RELATED_ITEM_ID,
p_RELATIONSHIP_TYPE_ID => p_REL_ITEM_rec.RELATIONSHIP_TYPE_ID,
p_RECIPROCAL_FLAG => p_REL_ITEM_rec.RECIPROCAL_FLAG,
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_REQUEST_ID => p_REL_ITEM_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_REL_ITEM_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_REL_ITEM_rec.PROGRAM_UPDATE_DATE);
ROLLBACK TO UPDATE_REL_ITEM_PVT;
ROLLBACK TO UPDATE_REL_ITEM_PVT;
ROLLBACK TO UPDATE_REL_ITEM_PVT;
End Update_rel_item;
PROCEDURE Delete_rel_item(
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,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
P_REL_ITEM_Rec IN REL_ITEM_Rec_Type
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_rel_item';
SELECT 1
FROM mtl_related_items
WHERE organization_id = P_REL_ITEM_Rec.organization_id
AND inventory_item_id = p_REL_ITEM_Rec.inventory_item_id;
SELECT item_owner_id
FROM ams_item_attributes
WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
AND organization_id = P_REL_ITEM_rec.organization_id;
SAVEPOINT DELETE_REL_ITEM_PVT;
AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
AMS_RELATED_ITEMS_PKG.Delete_Row(
p_INVENTORY_ITEM_ID => p_REL_ITEM_rec.INVENTORY_ITEM_ID,
p_ORGANIZATION_ID => p_REL_ITEM_rec.ORGANIZATION_ID,
p_RELATED_ITEM_ID => p_REL_ITEM_rec.RELATED_ITEM_ID,
p_RELATIONSHIP_TYPE_ID => p_REL_ITEM_rec.RELATIONSHIP_TYPE_ID,
p_RECIPROCAL_FLAG => p_REL_ITEM_rec.RECIPROCAL_FLAG,
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_REQUEST_ID => p_REL_ITEM_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_REL_ITEM_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_REL_ITEM_rec.PROGRAM_UPDATE_DATE);
ROLLBACK TO DELETE_REL_ITEM_PVT;
ROLLBACK TO DELETE_REL_ITEM_PVT;
ROLLBACK TO DELETE_REL_ITEM_PVT;
End Delete_rel_item;
SELECT *
FROM mtl_related_items
WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
AND organization_id = P_REL_ITEM_Rec.organization_id
AND related_item_id = P_REL_ITEM_Rec.related_item_id
AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;
IF P_REL_ITEM_Rec.program_update_date = FND_API.g_miss_date THEN
x_complete_rec.program_update_date := l_rel_item_rec.program_update_date;
p_validation_mode => JTF_PLSQL_API.g_update,
x_return_status => x_return_status
);